SQLServerCentral.Com to Offer SQL Server Track at SQL Server Connections
I have spoken at many conferences over the years, including the PASS Community Summit and SQL Server Connections, and one...
2009-06-04
712 reads
Moron's Guide to SSIS : Episode 1 - Introduction to the Environment
Today Pragmatic Works release it’s first comedic training video featuring Dustin Ryan as “Dustin” and Brian Knight as “Gary” Dustin’s boss. ...
2009-06-04
627 reads
SQL Saturday 14 Pensacola
I will be speaking this Saturday at the SQL Saturday in Pensacola. The topic will be SSIS Best Practices and Performance Tuning. ...
2009-06-04
770 reads
Advanced SSIS Interview Questions
I wrote a blog about a year ago that gave some tips on basic interview questions that you may run...
2009-06-04
3,805 reads
Off to SQLSaturday #14
I leave this afternoon for Pensacola and SQLSaturday #14. My daughter is traveling with me, for a short vacation with...
2009-06-04
332 reads
A Practical Electric Sedan?
We’re getting closer. Coda is planning on selling a 4 door sedan in CA next year for $45k ($10k tax...
2009-06-04
458 reads
The SQLServerCentral Track at SQL Connections
I'm happy to announce that SQLServerCentral is sponsoring a track at this year's SQL Connections conference in Las Vegas, Nov...
2009-06-04
777 reads
Moving to Hyper-V
My primary development machine for the past 3 years was a 32 bit Toshiba Satellite notebook running XP named PROBE-DROID....
2009-06-04
869 reads
Speaking at SQLSaturday #14 in Pensacola on June 6, 2009
I'm driving over tonight to spend a long weekend in Pensacola (6-7 hour drive from Orlando) for their first SQLSaturday,...
2009-06-03
471 reads
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,331 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