Blog – Domain Changes Update
As I mentioned in an earlier post I have recently moved my blog to a new domain name. This is...
2010-12-07
766 reads
T-SQL Tuesday #13 - What the Business Says Is Not What the Business Wants
It’s time to wrap up T-SQL Tuesday for the year 2010 and I was invited to host his month’s blog...
2010-12-07
8,305 reads
Automating the Processing of a Measure Groups Index Using SSIS
In a recent post (Processing a Measure Groups Index Using SSMS), I showed you how to utilize SQL Server Management...
2010-12-07
1,028 reads
December PASSMN Meeting
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
363 reads
Tip: Schema Qualify Objects in SPs
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,722 reads
IT Education Part 1
Like many in IT I’m self taught, starting with DOS and batch files, then proceeding through QuickBasic, Visual Basic in...
2010-12-06
623 reads
SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
380 reads
Review: Idera SQL Doctor
Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...
2010-12-06
2,606 reads
Moving Windows in Windows 7
I had my laptop connected to a projector recently, and for some reason a few windows got moved off screen,...
2010-12-06
571 reads
My Weekend
We are now well into December and Christmas is fast approaching, I have most, but not all of my shopping...
2010-12-06
523 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