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...

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,...

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...

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. ...

Simply Debugging

Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...

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...

Finding Top Offenders with Extended Events

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing workloads and doing analysis on them. T-SQL or other...

Finding Top Offenders with Extended Events

This week at MVP Summit I got to talk with a friend who loves profiler. We were talking about capturing...

Azure SQL Database Managed Instance is now private preview

Today is the day that Azure SQL Database Managed Instance is available for the world to explore. Private preview means...