The Desktop Rebuild–Part 3
This is the last part of this series, at least for now. If you haven’t seen Part 1 and Part...
2016-06-29
931 reads
Is Today Your Last Day Working With SQL?
Please entertain this thought for a moment – If today was your last day working with SQL how would you spend...
2016-07-08 (first published: 2016-06-29)
3,337 reads
Better Explorer on High dpi Displays
I’ve got a high dpi display on my laptop. The recommended resolution is 2560×1704. That’s small. I have had all...
2016-06-29
907 reads
Hearing Responsibility
A while ago I was watching Shark Tank on TV and at one point Robert Herjavich (T|B) made the great...
2016-06-29
705 reads
Finding, disabling and enabling foreign keys
Foreign keys are a classic method of enforcing RI (Referential Integrity). Unfortunately though, they can get in the way if...
2016-07-11 (first published: 2016-06-29)
1,968 reads
Uninstalling SQL Server from the Command Line to Remove Unwanted Background Instances
I had a note (or ‘action item’) to make sure that people were informed regarding the ‘uninstall’ of SQL Server,...
2016-07-11 (first published: 2016-06-29)
88,642 reads
If You Need to Think, You’re Doing It Wrong
A month ago, my wife and I were in Barcelona for a short vacation.
In one of the days, we entered...
2016-06-29
657 reads
Introducing SQL Server Reporting Services
In an earlier post I introduced the SQL Server umbrella and briefly discussed a number of products that make up...
2016-07-12 (first published: 2016-06-29)
3,148 reads
Automatic Seeding Very Large Databases in SQL Server 2016
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new...
2016-07-12 (first published: 2016-06-29)
3,696 reads
Speaking at PASS Summit 2016
I’m very honored to be speaking at the PASS Global Summit again this year in Seattle during the week of...
2016-06-29
409 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