Daily Coping 23 Jul 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-07-23
12 reads
Tonight is the PASS Marathon on SQL Server Performance
The event is tonight, and it’s my first time helping out as a moderator. I got a call for volunteers, and I added my name. The event starts at...
2020-07-23
25 reads
The What, Why, When, and How of Incremental Loads
When moving data in an extraction, transformation, and loading (ETL) process, the most efficient design pattern is to touch only the data you must, copying just the data that...
2020-08-05 (first published: 2020-07-23)
568 reads
Color Coding a Database on All Servers with SQL Prompt
SQL Prompt has some nice color coding features, but sometimes I want a database to keep the same color, regardless of instance. I don’t know that I’d recommend this,...
2020-08-04 (first published: 2020-07-22)
370 reads
These are the extensions I have installed on Azure Data Studio
At last week’s presentation to the Edmonton SQL Server user group, I spoke at length about the many extensions that are available for Azure Data Studio, and was asked...
2020-07-22
66 reads
Daily Coping 22 Jul 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-07-22
24 reads
Moving 1/3 of a heap
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
26 reads
Moving 1/3 of a heap
Watch this week's video on YouTube
A Giant Heap
Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don't ask me why this 3.5 billion...
2020-07-22
23 reads
Moving 1/3 of a heap
Watch this week’s video on YouTube. A Giant Heap Recently I had to filter out 1.2 billion records from a 3.5 billion row heap. Don’t ask me why this...
2020-08-03 (first published: 2020-07-22)
298 reads
Assume a role with AWS PowerShell Tools
Assume A Role
I’ve had some issues in the past working with AWS.Tools PowerShell SDK and correctly assuming credentials.
By default, most of the time it was easier to use a...
2020-07-30 (first published: 2020-07-22)
290 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