Article of the Week – SQL Server 2008 T-SQL Enhancements
I have been following this series of articles since the first article was published on SQLServerCentral. The author, Arshad Ali,...
2009-09-02
751 reads
Finally Migrating from SQL 2000
I suspect I’m not alone in that I’ve had SQL 2000 running for a long time with no problems and...
2009-09-02
431 reads
How practical is a netbook?
I’ve I was having lunch with another SQL Geek and we were talking about netbooks and how practical they are....
2009-09-02
1,454 reads
SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
638 reads
Building a Pipeline
While I try to write most days, I don’t always podcast, and I only schedule things a day or two...
2009-09-01
391 reads
24 Hours of PASS Tonight
For those of you who may have missed it, the 24 Hours of PASS conference starts tonight at 8pm EDT!...
2009-09-01
435 reads
Indexing HierarchyID
The new HierarchyID datatype in SQL Server 2008 has captured my interest lately. I’ve been working on a presentation that...
2009-09-01
3,747 reads
Keeping a Low Profile
I’ve been mostly offline for the last ten days or so, cutting back on blogging and forum participation and mostly...
2009-09-01
568 reads
The Pain of Multi-Threading!
Alas, this isn’t really a SQL post, but thoughts on efforts to share work that has been previously done by...
2009-08-31
1,448 reads
Backing up to NUL vs Backup with Truncate only
Or “It’s 10pm, do you know where your log records are?”
Something that I’ve started to see recently is the idea...
2009-08-31
2,259 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