Too many Foreign Keys

I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some...

New developer build of SQL Code Guard released

Issues fixed since last developer build
[*] fixed incorrect binding of MI008 to MI007
[*] fixed xtra EI028 in case with named...

Update Your Scripts!

I had an incident today where a colleague was running a Wait Stats Report and the output looked like this:

As...

Quick PS script to get SQL Server Configuration Aliases - Syndication – WaterOx Consulting

Aliases! They can be quite helpful, but they can also be a major pain when setting up new servers or...

Notes from SQLSaturday Tampa 2016

Quick notes:
Speaker dinner at Spaghetti Warehouse. Good location, but just a little confined and a little noisy. Perfect location is...

Tuga IT 2016 – Registrations are open

The registrations for Tuga IT 2016 are finally open: http://tugait2016.eventbrite.com, hurry up cause we are starting to promote it very...

Notes From the February 2016 OPASS Meeting

I gave my presentation on automating restores. Part philosophy (why you need it) and part tech (one way to do...

SSC Editorial: Lessons From Little Green Army Men

This one is about spending time with my daughter – she bought some army men as a toy after a visit...

SSC Editorial: Spousal Surcharges

I had to laugh as I write this, the “Spousal Surcharges” title is awfully close to clickbait. The topic is...

SQL server on Linux

Microsoft accounted yesterday that SQL server will plan run in Linux, with early private preview available today along with full...