Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today we get to talk about chapter 7 in...
2010-11-03
15 reads
Defensive Db Programming Chapter 07
We are here again after another …um long lapse in time … and ready for another episode in this series. Today...
2010-11-03
748 reads
SQLServerPedia Award Votes
This is just another reminder to please vote for my blog post on using PowerShell Remoting with SQL Server. It’s...
2010-11-03
576 reads
How To Participate In The PASS Summit When You Can't Be There
Bummed that you can't go to the PASS Summit in Seattle this year? Turn that frown upside down because there...
2010-11-03
692 reads
MERGE Statement Corrected, or, How to Eat Crow in Public
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
850 reads
Powershell and Policy Based Management
If you haven’t looked at Policy Based Management (PBM), and you manage multiple instances, you ought to really look at...
2010-11-03
977 reads
PASS Update #46 (What Should PASS Be?)
I’ve been wanting to write this for a while, and I haven’t because I felt that I just didn’t quite...
2010-11-03
411 reads
More PASS Summit Tips For First Timers
Yesterday I posted my tips for PASS Summit First Timers, and of course as soon as I did I remembered...
2010-11-03
1,794 reads
VLDB Issues at SQL Server Connections
Kim Tripp is a great speaker, with a wealth of knowledge. This session was talking about some of the issues...
2010-11-03
731 reads
A Couple of SQL Lunches this Week
I want to apologize for posting this so late, but there is a SQL Lunch today and one tomorrow. Hope...
2010-11-03
638 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