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)
444 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
28 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
12 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)
424 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
21 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
138 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)
560 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
20 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
28 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
20 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers