Kris Wenzel
@sqlkris
Followers
3K
Following
692
Media
182
Statuses
8K
Your search for SQL training is over, I'm here to help. Stick around, I'll tweet to you great introductory tips to search databases using SQL.
New Hudson, MI
Joined December 2013
Is taking the 70-461 freaking you out? Check out my study guide and be sure to signup for more!
1
1
10
Learn three ways to concatenate text in SQL. And why CONCAT_WS is superior over + and CONCAT for handling NULL.
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
Use SQL HAVING to filter summary results from a GROUP BY. It specifies the search condition for the group or aggregate.
0
0
0