Independent Azure Data Platform Instructors
The Azure Data Platform is taking off. I’m seeing more and more interest on the forums, at conferences and in...
2016-06-01
435 reads
What has 2 Thumbs and Deleted a LUN with the Log File of a Production DB on it?
That’s right, I did it. I was deleting unused LUNs and the focus somehow jumped from the LUNs for the...
2016-06-08 (first published: 2016-06-01)
2,708 reads
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage was over. The big deal wasn’t that it didn’t...
2016-06-01
73 reads
Powershell, when were my servers rebooted?
One of my servers wasn’t rebooted when it should have been and I never realized it until after the outage...
2016-06-01
543 reads
SSMS bug #1
This happens at my instance of SSMS and at the colleagues' one it doesn't. The SQL Server Agent duplicates its...
2016-06-01
235 reads
IT People’s Technical Debt and Reputation Credit
In Canada and USA, when people apply for a credit card or a loan/mortgage, the lending institutions will always do...
2016-06-08 (first published: 2016-06-01)
2,034 reads
PowerShell – Deleting those files
Usually I prefer to use C# to delete files (as part of my retention policy for backups) as a stored...
2016-06-01
186 reads
What is the max/min size of a decimal data type?
Recently, I wrote a maintenance script to check every table in every database on our servers at work nightly and...
2016-05-31
1,188 reads
“Tuesday Morning” SQL Break – May 31, 2016
Yesterday it was Monday, which is when I usually aim to post a weekly blog and twitter round-up. But since I...
2016-05-31
851 reads
Running Multiple Threads Quickly
Recently I was looking to generate a quick workload against an instance. I wanted to add to the amount of...
2016-05-31
1,052 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