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

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

Communication in Azure: using Data Factory to send messages to Azure Service Bus

(2019-Mar-10) A conversation between two or more people involves continuous efforts to listen and reflect on what other people have to...

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

Last Week Reading (2019-03-24)

OMG! My brain almost blew up. All because of MVP Summit I’ve just returned from. Obviously (due to NDA), I can’t tell you what I’ve seen and found out,...

SQL Server Availability Group Failovers in Kubernetes

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

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

SSMS Tip #3: Easily Access/Research ALL Unicode Characters (Yes, Including Emojis ??)

Learn how to get a list of all Unicode characters to copy and paste, or use in queries / web pages / programs, or search by value, etc.… Continue...

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

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