Pinned Tweet
Is taking the 70-461 freaking you out? Check out my study guide and be sure to signup for more! bit.ly/1Slxuo9
1
1
9
Learn three ways to concatenate text in SQL. And why CONCAT_WS is superior over + and CONCAT for handling NULL.
0
0
0
What is a Relational Database Conceptual Model? youtu.be/vsak_iYU-V4 via @YouTube
0
0
0
There are several alternatives to bulk insert to use when inserting multiple rows into SQL Server. Let's review there here.
0
0
0
Rounding up to the nearest integer is easier that you think in SQL. Learn how to use a common built-in function to do so.
0
0
1
Learn to calculate a moving median in SQL. We'll use window functions and derived tables to make this happen.
0
1
1
Surprisingly there isn't a SQL MEDIAN() function. In this article I'll show you how you can calculate a Median using SQL Server.
1
0
0
Avoid SQL divide by zero errors using CASE WHEN or NULLIF functions to substitute zero for another value in our expression.
0
1
1
If you would like to subtract 30 days for a date in SQL you can easily do so using either SQL Server, PostgreSQL, or MySQL.
0
0
1
There are several way to find the week number in SQL. Let's though the standard ways to do so using PostgreSQL, MySQL, and SQL Server.
0
0
1
Use the REPLACE function to replace all occurrences of a substring with another. Use REPLACE with MySQL, PostgreSQL, and SQL Server.
0
0
0
Design a database is four steps. Follow along as I build the PizzaDB sample database. Learn my practical approach to designing databases.
0
0
0
The SQL CREATE TABLE statement is used to create a database table in SQLServer. Use it to add columns, datatypes and constraints.
2
1
1
Use GETDATE() to in conjunction with CAST to return today's date. GETDATE() returns data and time, so cast is necessary just get the date.
0
0
0
How to calculate 30 days into the Future using SQL SERVER. Also learn how to use it to calculate a date in the past.
0
0
0
An impossible join uses STRING_SPLIT() to break up column values into individual words which you can then join to another table.
0
0
0
Learn five ways to know when a column contains in SQL another value. We'll explore STRING_SPLIT, CHARINDEX, and other popular methods.
0
0
0
There is more to being a Junior DBA than knowing SQL. The DBA works at the intersection of the database, server, operations group, and developers.
0
0
2
A SQL trigger ensure actions, such as updating an audit file, are completed regardless of which program update a database table.
0
0
1