Why did my execution plan change?

As a SQL Server DBA it is important to understand why and how the SQL engine works.  Understanding as much...

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom scripts you have to execute frequently, maybe you have...

Load and run custom T-SQL scripts in SSMS via Snippets

If you work with SQL Server on a daily basis, it is very likely you have a lot of custom...

Notes From the 2018 PASS Summit (v20)

This was the 20th PASS Summit, a decent milestone! Interesting to pause and think, what will the Summit look like...

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R?
A few months ago, I asked myself an important question – which language to learn first...

Part 1: Predictive Modeling using R and SQL Server Machine Learning Services

To R or not to R? A few months ago, I asked myself an important question – which language to learn first – R or Python? From my research,...

Random Pix from the 2018 PASS Summit

A few memories from me. First, a beautiful late arrival view.

My first session feels a little lonely

It started to fill...

Speaking At SQL Saturday DC

I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018.
I...

Speaking At SQL Saturday DC

I am so excited to announce that I was selected to speak at SQL Saturday DC on December 8, 2018. I will be presenting two sessions, What is Power...

SQLCLR vs SQL Server 2017, Part 9: Does PERMISSION_SET Still Matter, or is Everything Now UNSAFE?

(last updated: 2018-11-01 @ 00:50 EDT / 2018-11-01 @ 04:50 UTC )
SQL Server 2017 introduced a new security restriction for SQLCLR in the...