PASS Board of Directors - Call for Nominations
Well I feel a little strange making an announcement about this since I'm not running. A number of people have...
2009-08-25
1,619 reads
Examing database shared locks using sys.dm_tran_locks
If you’ve worked with Microsoft SQL Server for any length of time, you’re probably already aware that SQL Server uses...
2009-08-25
695 reads
Kalen Delaney Joins The SQLSaturday Advisory Council
Last but certainly not least we’ve just announced Kalen Delaney as a member of the Advisory Council. Now that we...
2009-08-25
578 reads
New Book
Well, three chapters. The latest book I worked on is up at Apress. I only have three chapters in this...
2009-08-25
569 reads
The Need for a College Degree
I'm reading through Brad McGehee'sHow to Be an Exceptional DBAand in chapter 4 he talks about having the right skill...
2009-08-24
2,430 reads
PASS Board of Directors Call for Nominations
This is just a reminder that the call for nominations for the PASS Boards of Directors is open. The final...
2009-08-24
932 reads
SQLSaturday #23 - Session Submitted
I'm committed to SQLSaturday #23 in Louisville on October 24, 2009. I got a note the other day from the...
2009-08-24
736 reads
Spare Yourself Installation Issues by Downloading the Latest SQL 2008 ISO Image
Recently, we began the install of a new instance on a VMware Host and ran into an issue with a problematic outdated...
2009-08-24
971 reads
Stats blob corruptions
There have been a couple odd types of corruption that I’ve been seeing on the forums. I want to take...
2009-08-24
374 reads
Types Matter!
Louis Davidson (@DrSql) had an excellent series on his blog on the Pillars of Database Design and the one of...
2009-08-24
440 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