The Desktop Rebuild–Part 1
I’ve had an aging desktop for some time. I originally bought it from Glenn Berry (b | t), who I think...
2016-06-24
541 reads
PASS Summit 2016 – My Session Evaluations
No Sessions For You! The announcements of the speakers and sessions selected for the PASS Summit 2016 were recently announced,...
2016-06-24
427 reads
My PASS Summit 2016 Session Submissions Feedback
I’m excited to say that I will be delivering a session in this year’s PASS Summit in Seattle later this...
2016-06-24
451 reads
Problems When Running DBCC SHRINKFILE On SQL Server Database
Overview of the Situation
While accessing data files in SQL Server, many issues may occur that may lead to frustrating situation...
2016-06-30 (first published: 2016-06-24)
2,292 reads
What do you want to learn about SSRS 2016 at PASS Global Summit?
I’m thrilled to have been selected to deliver a session at the 2016 PASS Global Summit titled “Reporting Services 2016:...
2016-06-29 (first published: 2016-06-24)
1,148 reads
Are my SQL logins weak?
Security is a vital component of data security. In today’s day and age it is imperative to think about security....
2016-07-04 (first published: 2016-06-24)
1,622 reads
Is Resource Monitor (resmon) all I need to troubleshoot storage?
I was recently doing some work on my Windows 10 desktop and placed a drive on one of the slower...
2016-06-30 (first published: 2016-06-23)
1,652 reads
Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
547 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
19 reads
Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
551 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