Removing ad hoc plans from Query Store
This is not a post about the “optimize for ad hoc workloads” setting on your favorite SQL Server instance, but that is a good place to start. Lots of...
2020-02-27 (first published: 2020-02-20)
441 reads
Blog Posts
DBA, a job, a vital job
DBA, a job, a vital job. T-SQL a language that is fun. Select, a query to get some data. From, ... Continue reading
2020-02-26
27 reads
Join me at SQLBits 2020
The SQLBits conference is taking place in London again this year, between March 31st and April 4th, and I’ll be there. I will not be presenting this year, but...
2020-02-26
11 reads
Power BI Monthly Digest – February 2020
In this month’s Power BI Digest Manuel I will again guide you through some of the latest and greatest Power BI updates this month. In
2020-02-26 (first published: 2020-02-18)
422 reads
Quickly Create Github Release via Cli
TEST Intro
I've been trying to improve modularization with Terraform.
Using Terraform Cloud, you get a private module repository.
The modules are linked to tags in git.
I've wanted additionally to specifically create...
2020-02-26
19 reads
SOS_SCHEDULER_YIELD – What is it really telling us?
I decided to write this off the back of a conversation I was having the other day around the SOS_SCHEDULER_YIELD wait type. The conversation went something along the lines...
2020-02-26
136 reads
#PowershellBasics: Run a file and pass it a parameter.
I realized in my last #PowershellBasics post that I was talking about running a file and passing in an optional ... Continue reading
2020-02-25 (first published: 2020-02-17)
557 reads
Does dbatools Have a Function for That?
dbatools has a lot of functions. A lot. Over 550. There is a great command index on the website, and the documentation gets updated every time a new version...
2020-02-25
18 reads
Level Up!
Great news! I was accepted this weekend to speak at SQLSaturday Los Angeles! This officially counts as a level up for me for my deadlock resolution quest. The event...
2020-02-25
21 reads
Renewed as a Friend of Red Gate
I recently received the news that I’ve been renewed as a Friend of Red Gate. I’ve been a big fan of Red Gate since the days when SQL Compare...
2020-02-25
19 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Escaping Strings
Comments posted to this topic are about the item Escaping Strings
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers