Dates and Times in SQL Server: DATE

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

How to Move Master Database to Another Location – SQL Server On Linux

With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file...

Learning Goals 2018–February Review

Better than month 1. Only XE this month.
My first week I got a reminder to spend some time on XE,...

Live Query Statistics – SQL Server 2016

SQL Server Management Studio (SSMS) 2016 has a handy new feature to View Live Query Statistics. This feature also works...

Overheard: “I just think there’s not that many women who enjoy coding. And I say that based on my daughter, too.”

Update: Instead of reading this blog post, I suggest you read the article, “The Secret History of Women in Computing: Computer programming once had much better gender balance than...

SQL 2017 Administration Inside Out - link dump

Hello all-

More than a year's work went into the newest Inside Out book by Microsoft Press, I was happy to...

SQL Server logins, users, SIDs, and orphaned users – a quick primer

Here’s a good starter article on SQL Server logins, users, and SIDs: SQL Server Logins, Users and Security Identifiers (SIDs) Some...

The best overlooked addition to SQL 2016

Many of the widely advertised and talked about features of SQL Server or other software products focus exclusively on the...

UNDERCOVER TOOLBOX: sp_WhatsMyAG

Here’s a quick one for you.  If you happen to be managing SQL Servers with a large number of databases...

Which Blogs Do I Recommend?

One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...