An Experiment with Deadlocks

There seems to be a myth out there that when deadlocks come a-knocking, then just throw this little directive (ROWLOCK) at it and all will be well. This is...

Weekly reading #8

Good day! Good week! Let’s start it with some news form the Data Platform world!

SQL Internals – Physical Table Structure under...

Improving Performance of the Distributed Replay Utility on SQL Server 2012

Setup the DRU What is it? The Distributed Replay Utility (DRU) on SQL Server allows you to capture Profiler trace information on one or more client servers and then...

ASF 020 video invitation

New podcast’s episode is coming (next Friday) and in the meantime, take a look you can watch that episode’s trailer....

Hello world!

Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

Thinking about Setup and Installation

I’m working the first section of a basic administration course, and the first part of this is installing SQL Server...

Toolbox - Exporting SSMS Results to Excel

I was working on another post when I found myself needing to dump out query results to a grid format...

SQL Server Data Pages on Linux

One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...

Webinar: Change Detection in SQL Server

Change detection is a critical component of any system that moves data from one structure to another. Most data movement mechanisms are designed to move a subset of the...

Webinar: Change Detection in SQL Server

Change detection is a critical component of any system that moves data from one structure to another. Most data movement...