Are You Ready to Move to SharePoint for Microsoft BI?
I’m interested in hearing your response to this question. Microsoft is investing
aggressively in delivering Business Intelligence as a holistic platform...
2010-11-24
538 reads
Notes from SQLSaturday#59 - Waits & Queues Presentation
SQLSaturday#59 – Waits & Queues Presentation
At SQLSaturday#59 in NYC, my session was about Waits & Queues. I presented a topic I thought was...
2010-11-24
948 reads
I'm a Midnight DBA
Well, not really. However when I was recently up in Seattle, Jen and Sean McCown contacted me about being on...
2010-11-24
833 reads
Column Based Indexing in Denali
Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had...
2010-11-24
932 reads
XQuery for the Non-Expert – Exist
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-23
2,151 reads
What’s New In Denali for SSRS
I was so excited when I found out that Denali was released last week. Like it was Christmas time, I...
2010-11-23
602 reads
2010 PASS Summit Recap
The 2010 PASS Summit has been over for a week and a half now and I've finally recovered & processed everything...
2010-11-23
691 reads
INDEX DEFRAGMENTATION SCRIPT
Advertisements
INDEX DEFRAGMENTATION SCRIPT for 2008 / 2005
I dedicate this article to my senior DBA “Roshan Joe Joseph” who has helped me...
2010-11-23
1,512 reads
Roundup: Un-SQL #001 – Branding
Hi-ho all, and a wonderful Un-SQL event it’s been! We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...
2010-11-23
803 reads
Dynamic PowerShell
I learned something new while giving my PowerShell session at the PASS Community Summit a couple of weeks ago.
One astute...
2010-11-23
1,442 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