T-SQL Tuesday #73: Never Made That Mistake Again
T-SQL Tuesday is a monthly community-wide blogging event created by Adam Machanic (blog|@AdamMachanic), and everyone is invited to particpate. This...
2015-12-08
1,901 reads
T-SQL Tuesday 73 - Naught or Nice - Change Control Process
You better watch out, you better not cry, gonna find out who's naught and nice - TSQL Tuesday #73 is coming...
2015-12-08
2,378 reads
Data Compression
Data compression is often misunderstood to cost CPU in exchange for smaller size on disk. Somewhat true, but that simple...
2015-12-08
1,150 reads
Apathy – A quick path to the naughty list.
It’s the Christmas season! And it’s T-SQL Tuesday! And Bradley Ball (b/t), SQL’s very own superhero (one of many really...
2015-12-08
531 reads
T-SQL Tuesday #73 - Not Running CHECKDB is Naughty!
This month T-SQL Tuesday is hosted by Bradley Balls (blog/@SQLBalls) and his topic of choice is “Naughty or Nice.”
(If you...
2015-12-14 (first published: 2015-12-08)
2,875 reads
SQL SERVER – Random function in Dynamic Data Masking in SQL Server 2016 CTP 3
Hi friends, With new CTP version of SQL Server 2016 many new functionality are added and modified. As with introduction...
2015-12-08
589 reads
SQL Cruise Caribbean 2016 is almost here!
Want to get out of the winter blues and into some warmer weather for some deep SQL Server training? Join...
2015-12-07
691 reads
Monday Morning SQL Break – December 7, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-07
449 reads
#SQLFamily Feud
I’ve started a new project. Actually, I started this well over a year ago, but I lost track of it...
2015-12-11 (first published: 2015-12-07)
1,885 reads
New Vacancy on the PASS Board
Last week James Rowland-Jones announced that he would be resigning from the PASS Board to accept a position with Microsoft....
2015-12-11 (first published: 2015-12-07)
1,549 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