Protecting Against Delete without Where
If I’m doing any manual work with T-SQL, I always begin every set of data change operations with BEGIN TRAN...
2016-06-13 (first published: 2016-06-09)
3,644 reads
SQL Prompt Prevents Stupidity
I upgraded my SQL Prompt recently, mostly as a habit. The team led by David and Aaron are always adding...
2016-06-17 (first published: 2016-06-09)
2,508 reads
A Different Type of Currency
Recently, a member of the community lamented that folks weren’t willing to provide an email address for free training. This...
2016-06-09
452 reads
Presenting for Edmonton SQL Server Users Group June 16th
It’s a wonderfully busy speaking month! I’m going to be remotely speaking for the Edmonton SQL Server User Group at 5:00pm...
2016-06-09
412 reads
My first SQL Server 2016 POC
Very, very recently I did my first Proof Of Concept (POC) with SQL Server 2016. At an actual client of...
2016-06-14 (first published: 2016-06-09)
4,751 reads
OBJECT_ID()–#SQLNewBlogger
One of the things that is needed in quite a few functions is the object_id of a particular table/view/procedure/function in...
2016-06-08
1,159 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s list of books everyone should read. And since then,...
2016-06-08
16 reads
Book Review: Sapiens: A Brief History of Humankind
Sapiens: A Brief History of Humankind, by Yuval Harari, made it on my reading list after hearing about Mark Zuckerberg’s...
2016-06-08
839 reads
Comparing the contents of two tables Redux
I did a post the other day on comparing two tables. It was meant as a general overview but I...
2016-06-08
489 reads
Share custom solutions in the MinionWare Community Zone
Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and...
2016-06-07
633 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