PASS Update #45 (Agenda for SQLSaturday Roundtable)
If you’re attending the 2010 Summit and are interested in helping improve SQLSaturday, I hope you’ll register and attend our...
2010-11-03
343 reads
Kilt Day
A week from now will be Kilt Day at the PASS Summit. It’s probably way too late to order a...
2010-11-03
675 reads
Service Broker – SQL Server Connections
These are some notes and thoughts from sessions and my time at SQL Server Connections/DevConnections in Nov 2010.
Denny Cherry gives...
2010-11-03
1,603 reads
PARTITION BY clause works incorrectly when in nested select over large volumes of data
I have been witnessing a very strange behaviour of ROW_NUMBER() PARTITION BY clause in complex join and nested select or...
2010-11-03
2,778 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
671 reads
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
SQLSaturday #59 – Speaker Interview #16 with DW Expert, Chuck Kelley
Working on a large DW project, I had the pleasure of...
2010-11-03
820 reads
SQL Saturday 58 – It’s A Wrap! #sqlsat58
It’s Tuesday after PASSMN’s first SQL Saturday event in Minnesota. After a restful weekend, I’m finally starting to completely wind...
2010-11-03
458 reads
DB Maintenance
About a month ago I read a post by Brad McGehee (Blog | Twitter) concerning a checklist for SQL Server. It...
2010-11-02
582 reads
Tips For PASS Summit First Timers
In less than one week the 2010 PASS Summit begins in Seattle and with each day the excitement and anticipation...
2010-11-02
684 reads
TSQL2SDAY #12 - Why are DBA Skills Necessary?
WOW this is the 12th TSQL2Sday albeit this month’s is week early because of the PASS summit next week, so...
2010-11-02
632 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