Scalar UDF Inlining in SQL Server 2019 – Simpler functions

I recently published a post detailing the new Scalar UDF Inlining feature in SQL 2019 here. That post introduced the...

Enter our Database #DevOps Contest

Share your story and you could win. Enter as often as you like before Mar 20.
https://www.red-gate.com/hub/entrypage/competition

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly so there is...

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We...

Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...

Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing...

Data Warehouse Design and Power BI at SQL Saturday Tampa 2019

Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...

One week blogging hiatus

I’m taking a brief break from daily blogging, even though it has been a ton of fun.

No excuses
I hope...

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

Last Week Reading (2019-03-10)

Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...