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

Weekly reading #6

Coding Family is late this week with the blog post! It is due to heavy storms and wind! It started...

WIT Panel for Women’s History Month

I cannot write this without stating some history. I have been part of PASS community since 1999. That is 21...

Favorite community scripts and their parameters

Here’s some of my favorite community scripts and how I like to run them. If you haven’t tried the optional...

Speaking

A place to collect abstracts & links to presentations I’ve given. Please be sure to check out my Sessionize profile as well.
Backup Basics with PowerShell and dbatools Abstract As...

Adding Objects to our SCA Project

In my last post, I started out with a new SCA project, getting a connection to my database up and...

I’ve added data classifications. Now what?

About a year ago I wrote about a new feature in SSMS that allows you to add a data classification...