Monitoring SLAs with SQL Monitor Reporting

Proactive Reporting for SQL Server If you’re a return reader of this blog you know I write often about monitoring and performance of Availability Groups. I’m a very big...

SQL Server on Linux

Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it...

Friday Reading 2017-02-03

2017 is trundling along now, this week I’ve been reading…
The GitLab incident report

We’ve all had that moment of “what did...

Get Your SQL Server Product Key with Powershell #dbatools

There are lots of tasks that are easily accomplished with bot h PowerShell and T-SQL.
Get-SqlServerKey is a command that...

How the SQL Agent Job schedule_uid broke my heart, and my jobs!

This is something that has caused me some grief in my life as a DBA. I hesitate to call it...

Setting Up a Productive Work Environment – #TAPtips

Having a productive work environment for you and your team is important to facilitate tasks being accomplished as well as...

SQL Server vNext

I have been pretty busy recently working with Joe Sack from Microsoft and  getting my hands dirty with SQL Server...

The High Availability Conversation Part 1: Introduction

Hello Dear Reader!  Twitter is a fantastic tool if you use SQL Server.  It is a great way to network, find presentations, interact with experts, and #SQLHelp offers some...

What’s a Database Encryption Key (DEK) in TDE

The encryption mechanisms in SQL Server are interesting, and they work well, but they are somewhat poorly named. I ran...

Backup/Restore–What’s My Status?

The day begins and you find yourself going through a list in your mind of things that need to be...