Wait Statistics in Azure SQL Database
You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it...
2016-03-07 (first published: 2016-02-29)
1,944 reads
SQL Saturday Chicago Precon – SQL Server Infrastructure – This Friday
This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure...
2016-02-29
841 reads
Blogger questions: How often should I blog?
What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again)...
2016-03-04 (first published: 2016-02-29)
1,255 reads
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was almost a blog I didn't write because I...
2016-02-29
13 reads
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was...
2016-02-29
986 reads
I/O Baseline Comparison – Idera Diagnostic Manager
What servers need the most attention when it comes to I/O? When I increase the memory on a server what effect does it have on I/O? What was it...
2016-02-29
25 reads
I/O Baseline Comparison – Idera Diagnostic Manager
What servers need the most attention when it comes to I/O? When I increase the memory on a server what...
2016-02-29
940 reads
Dynamic Data Masking
Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses,...
2016-03-04 (first published: 2016-02-29)
2,180 reads
Article Series: Power BI Solutions for the Enterprise
I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published...
2016-02-28
887 reads
My favourite wait state– ASYNC_NETWORK_IO
Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have...
2016-03-03 (first published: 2016-02-28)
2,848 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