Extended events (XE): Create a simple XE

When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...

Taking the Linux plunge

I’m a Windows guy.
Kinda have had to be, given my profession as a SQL Server DBA. But recently I’ve become...

Why Availability Databases Are Not Synchronizing?

If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...

SQL Server on VMware Boot Camp at VMworld 2018

I am extremely proud to announce that I am presenting in conjunction with VMware Corp. an all-day boot camp for...

Forcing Execution Plan

Very rarely there is a need to force an execution plan and even more rarely we should be doing it....

Silly Photos at Work

Someone I stumbled across this picture of @brento on my drive.

This might be the best one:

And this was a good...

Paper Model of Hubble Telescope

Not even close to being about SQL, I ran across the plans for a paper model of the Hubble Telescope while...

The need for having both a DW and cubes

I have heard some people say if you have a data warehouse, there is no need for cubes (when I say “cubes” I am referring to tabular and multidimensional OLAP...

The need for having both a DW and cubes

I have heard some people say if you have a data warehouse, there is no need for cubes (when I...

Selecting a Random Row From a Table

A couple of times recently I’ve seen the question asked, ‘How can I select a single row at random from...