It's Just Another 9002...another error like all the rest...

11:30pm on a Saturday night, and the pager went off…
Error: 5901, Severity: 16, State: 1.One or more recovery units belonging...

My SQL Server Development Team Maturity Levels

A teams maturity shows in its choice of tools.
I have seen quite a few different development teams in wildly different...

Power BI Announcements Summary

It was a crazy week for Power BI. There were quite a lot of announcements, so I’ll try to wrap...

Redgate Alexa Contest Winners!

A couple of weeks ago we had a small contest here to pick a skill for Alexa. The entries were...

SQL Nexus Wrap Up

This past week, I presented a preconference session and regular session at this year’s SQL Nexus conference in Copenhagen, Denmark. I...

Trace Flag 1117 Growth and Contention

In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth...

Why Log Shipping is Better than Database Mirroring for Migrations

This topic has come up several times recently, so I feel the need to blog on it. As the person...

24 Hours of PASS: Security: Session Files

Thanks to everyone who attended my presentation for the 24 Hours of PASS event on May 3rd. This iteration of...

Comparing Plans via Query Store

A small but nice little feature I have been using recently can be found within Query Store. Let’s say you...

Data Channel Interview - 07 - Steve Knutson on Managing Sharepoint Databases

7th Interview of #DataChannel is out 🙂

Very happy to have Mr.Steve Knutson, office servers and SharePoint MVP, share his knowledge...