Installing and Configuring SQL Server on Linux

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...

SQL Source Control and Bitbucket–Getting Started

This is in response to someone asking about getting started with their database in SQL  Source Control and then hosting at BitBucket. I’m going to assume people can set...

Can You Force A Parallel Plan in Query Store?

I love the questions I get when presenting: Can You Force a Parallel Plan in Query Store. I haven’t a clue. The trick I think is going to be...

What version of SQL is SSMS scripting for?

Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server ... Continue reading

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

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!