Friend of Redgate – 2017

I’m excited to announce that I have been named a Friend of Redgate for 2017. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...

I have been hacked

I’m working on securing the blog. Please stand by. Apologies for any inconvenience or confusion.
The post I have been hacked...

SQLite and the Performance Implications of Indexes

Indexes make an enormous difference in the read speed of a databases. I have previously mentioned that adding proper indexes...

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