Our new SharePoint BI Book Project
Hey folks, Just a quick preview that we’re hard at work again on a new book with Wiley publishing focused...
2010-11-22
429 reads
Have you ever wanted to train yourself?
Hey folks, we all know that there are some great training organizations out there (AHEM Pragmatic Works, AHEM). I hate...
2010-11-22
416 reads
Turn Rows into Columns in Excel
Have you ever had to take a long column of data in Excel and turn it into a column? There...
2010-11-22
374 reads
More great free resources from Microsoft
Hey folks – A quick one today since I’m travelling, but I am sharing something I often share with my clients...
2010-11-22
541 reads
SQLPASS Virtual Chapters
Today is a topic that is close to my heart. Many of you probably don’t know that the SQL pass...
2010-11-22
548 reads
Cry, Baby, Cry! Failing the MCM Test
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
764 reads
XQuery for the Non-Expert – Value
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-22
2,036 reads
Do Foreign Key Constraints Help Performance?
Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...
2010-11-22
1,707 reads
SQL PASS 2010 Summit – Recap
The sessions are over, and the post-cons are done; the vendor parties are but a memory, and the #sqlkaraoke music...
2010-11-22
1,153 reads
Un-SQL Friday 001: Branding
Since it’s Sunday (almost Monday), I thought I would chip into Un-SQL Friday. Before I get down to brass tacks,...
2010-11-22
1,046 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