SQL COALESCE Function
The SQL Coalesce function is used when you want to combine values from a series of columns or expressions when they might contain NULL values.
SQL
Working with Batches
Working with Batches in SQL Server, What are the differences between batches and transactions?
Using the INSERT Statement
How to use an INSERT statement to add records to a table in SQL Server. We will begin with just a simple INSERT statement that will add one row into the table.
IDENTITY Columns
How to use IDENTITY columns in a table. An IDENTITY field is very similar to an auto-number field, where the number will automatically be added as each record is inserted.
Delete vs Truncate vs Drop
What is the difference between the DELETE, TRUNCATE, and DROP statements in T-SQL?
70-765 SQL Admin Exam
I finally passed the 70-765 exam. This finished up the MCSA: SQL 2016 Database Administration certification and also re-earned the MCSE: Data Management and Analytics certification for 2018. I will say that this exam was not easy. The questions themselves are not that bad, but just the sheer amount of…
MCSA: BI Reporting
Finally! You can see by the dates below, I took these two beta exams last fall. Well, today they were finally graded. I took both of these without studying and just went in cold. So I am a little surpised that I passed both of them on the first try….
In-Memory OLTP
Free ebook: SQL Server Internals – In-Memory OLTP. In this book Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications…
Free SQL Performance Scripts
This is why I love Twitter to keep up with the #SQLFamily. A question was asked by Chrissy LeMaire about scripts that Microsoft PFEs use on the job. David Peter Hansen responded with this great list of tools for Performance Troubleshooting. I’m definitley adding it to my suggested links.
Yooper PASS Session
Tonight, I will be speaking remotely for the Yooper SQL Server User Group. I am assuming that Yooper refers to Upper Michigan. You can watch my recorded session on “The PROCESS of Queries” on YouTube.