SQL Triggers - An Introduction
Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...
2011-11-16
12,915 reads
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,891 reads
The First Thing To Do After Creating Keys
I’ve been looking at some security code in preparation for a few talks I plan on doing next year and...
2011-11-15
1,220 reads
Last Week's DB Security Workshop @ Oracle Montreal
DB Security Workshop @ Oracle Montreal
I have
dedicated several posts on the importance of being a Data Steward, and the
consequences of not...
2011-11-15
1,748 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject: On beyond Zebra AdventureWorks or where did I go wrong?
Level: 200 (Intermediate)
Start Time: Thursday, November 17, 2011 8:00...
2011-11-15
535 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,066 reads
Un-SQL Friday: Stop SOPA!
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,060 reads
The Calendar Driven Organization
I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...
2011-11-15
747 reads
Going to PASS 2012!
As I have previously written about in this space, I have recently moved to House of Brick Technologies. Part of...
2011-11-15
389 reads
A Trio of Tools
I have talked about tools for SQL server a few times in the past. You can read some of what I wrote here and here. Since writing those last...
2011-11-15
12 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