SQL Server CTE – Back to Basics

Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.
Related Posts:

T-SQL Tuesday...

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve sent out five copies of the book based on comments from...

SQL Server Indexing Book Giveaway – Week 6 (Index Myths)

And now for something not so different with week 6 of the Expert Performance Indexing for SQL Server book giveaway.  So far, I’ve...

Using the new SQLServer Powershell module to get SQL Agent Job Information

So with the July Release of SSMS everything changed for using PowerShell with SQL. You can read the details here...

Azure SQL Data Warehouse is now GA

The Azure SQL Data Warehouse (SQL DW), that I blogged about here, is now generally available.  Here is the official...

Database Mail Breaks with TLS 1.0 Disabled

Discovery I ran across an issue where I had just configured database mail on a new server, went to send...

Does my database have data type drift?

Over the years I have come to see that every database has what I call data type drift. Simply put,...

Getting Started with Database DevOps, DLM, and New Tools

Next Tuesday is the next installment of our DLM series from Redgate. I’m off the hook, with Grant and Arneh...

Live from @LearningTree London - Security Day - Day 2

This week I’m teaching Learning Tree’s course 2108 SQL Server Database Administration in the LEC in London. Following on from last weeks...

Source Control for the Reluctant DBA

This is the 2nd post in the series named SQL Server and Continuous Integration. The previous post explained the problems I...