A reference implementation of a continuous integration pipeline for legacy SQL Server databases

What am I doing?
Creating a publically available version of the adventureworks 2012 oltp database but by putting it under source...

A reference implementation of a continuous integration pipeline for legacy SQL Server databases

What am I doing? Creating a publically available version of the adventureworks 2012 oltp database but by putting it under...

A Short Hiatus - WaterOx Consulting

Reading Time: 1 minutesGoing to get Digby access to a little more water to rest...
The post A Short Hiatus appeared...

Azure SQL Database – Version and Compatibility Level

In the on-premises world, when we install a SQL Server on our own servers, we decide on SQL Version (2012, 2014….), Edition (Standard, Enterprise,...

Behavior of ORDER BY + UNION Can Be Confusing

This is an interesting example and it exposes a quirk with the concept of a UNION, which is, that the...

Extended Events, Birkenstocks and SQL Server

I bring you yet another installment in the monthly meme called T-SQL Tuesday.  This is the 67th edition, and this time we have been given the opportunity to talk...

Monday Morning SQL Break – June 8, 2015

It’s time for this week’s weekly blog and twitter round-up for last week, it would be better timed if I...

NJ SQL UG Event: 13 Advanced SSAS Tips - Kevin S. Goff returns!

He's baack!  If you missed the first presentation in March, due to inclement weather, and you are local, or in...

Unexpected Windows 10

This was strange. I noticed a new icon in the taskbar today. When I hovered over it, I saw this:

I...

When was your last database backup?

Its pretty often that you have to sit down at a SQL Server and need sort out what the backup situation is. One of the first things that I...