Restoring a SQL Server Database in Docker
Last month I blogged about using Docker to run SQL Server as a quick and easy way to get SQL Server up and running. While it continues to be...
2020-07-01 (first published: 2020-06-19)
641 reads
Social: Growing Up with the Dukes of Hazzard
I grew up in the South. The capital of the Confederacy was a short drive from my house. We studied the Civil War. I watched the Dukes on TV,...
2020-06-19
23 reads
Podcast recording with Dallas DBAs
I’m thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an...
2020-06-18
19 reads
Daily Coping 18 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-18
22 reads
Combining DMVs, Query Store and Extended Events Is Challenging
I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance. Moreover, they were frustrated...
2020-06-18
15 reads
Adding people’s names to a blog post can be rather tedious.
I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading
2020-06-18
31 reads
My Experience Switching To A Macbook Pro From Windows
My background
My background has been very strongly focused on the .NET world, with a focused start on SQL Server, later branching into learning PowerShell.
This world was heavily focused on...
2020-06-18
23 reads
Secure Your Data Prep Area
I’ve been building ETL processes for many years, and I’ve learned two universal truths: data preparation is messy, and you must always secure your data prep area. A data...
2020-06-18
22 reads
Power BI Data Viz Makeover: From Drab to Fab
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
17 reads
Where are Sequences?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I created a few sequence objects lately to...
2020-06-17
20 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers