Set up Instant File Initialization for SQL Server

When a space growth operation is done within SQL Server (create, restore, auto-grow) the engine places zeros across the file...

10 SQL Saturdays – and a personal parting of ways

I’ve written many posts on SQL Saturdays , especially the one at Louisville. This one is a  bit different. This is...

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