My Application is Getting SQL Timeout Errors, But What Query is the Problem?
This is something that comes up time and time again. A developer or member of the service desk comes up to me and says “SQL’s timing out, you see...
2021-07-27
96 reads
Daily Coping 27 Jul 2021
I 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...
2021-07-27
27 reads
Speaking: In person vs webinars vs recordings
I don’t speak all that often. A few times a year for the most part. Because of that I don’t ... Continue reading
2021-07-27
36 reads
Passing Variables Values into Power Automate Desktop Flows
In this video Devin continues building on a previously created Power Automate Desktop Flow design and shows how to pass values into your Desktop Flow
2021-07-27
163 reads
SQL Server Agent failed to update history
Recently I have faced a very interesting issue. A good friend of mine and my batchmate Rakesh called me this morning. He told me that one of his customers...
2021-07-27
39 reads
The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It
Join us online August 17 (Americas) or August 18 (Asia-Pacific). Register today!
2021-07-26
33 reads
The Post Pandemic Office Experience
I traveled to Pasadena, CA this week to work with a few other Redgaters in an office. There was a get together planned this week for the entire staff,...
2021-07-26
26 reads
Connecting to Azure Blobs in Power BI
The step-by-step process below walks through connecting to data housed in Azure Blob Storage from Power BI using a SAS token. There are many ways to grab your data...
2021-07-26
26 reads
Connecting to Azure Blobs in Power BI
The step-by-step process below walks through connecting to data housed in Azure Blob Storage from Power BI using a SAS token. There are many ways to grab your data...
2021-08-11 (first published: 2021-07-26)
3,325 reads
Daily Coping 26 Jul 2021
I 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...
2021-07-26
16 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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