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

How to resolve ‘Login failed for user’ and sa password lost (Error 18456)

This blog post explains how to get into SQL Server if you have lost your sa password or you have...

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

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

My latest presentations

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

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

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

Optimize for ad hoc VS sp_executesql?

Happy Friday! We made it. Here’s something I came across while testing optimize for ad hoc for this week’s blog...

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let's look into the performance gains this offers.
The post Scalar UDF Inlining in...

Scalar UDF Inlining in SQL Server 2019 – Simpler functions

Scalar UDF Inlining, introduced in SQL Server 2019, promises to improve the performance of Scalar UDFs. Let's look into the performance gains this offers.
The post Scalar UDF Inlining in...