Get Out The Vote
It’s actually kind of cool that SQL Rally voting for the pre-conference seminars and voting in the real(ish) world in...
2010-10-31
1,672 reads
I’m starting my own SQL Server Consulting business!
Beginning with tomorrow I’m no longer working for HP Austria, because I’m starting
my own SQL Server Consulting business. I’ve been...
2010-10-31
1,548 reads
Why do you use Sparse Columns ? (by Abi Chapagai)
What uses have you found for sparse columns in your databases?
SPARSE columns is a new feature in SQL Server...
2010-10-31
2,611 reads
Speaking at SQL Server Connections in Las Vegas Next Week
I will be giving two presentations next week at the SQL Server Connections conference in Las Vegas. There is a...
2010-10-31
1,582 reads
WorldWide Online Tech Day 2010
Hate to post this late but just wanted to let everyone know I’ll be presenting for Brazil’s Worldwide Online Tech...
2010-10-29
1,476 reads
Scary DBA Halloween Special
Not so much my special as SQL Saturday #59's Special. These guys in NYC are pulling out all the stops....
2010-10-29
1,391 reads
SQLBIGeek’s Function Friday – Convert Job Duration to Seconds
Brian K. McDonald
SQLBIGeek
Twitter: @briankmcdonald
Welcome to the second post of my “SQLBIGeek’s Function Friday” blog series. In this series, I am...
2010-10-29
3,583 reads
Live, Loud, and In Stereo
If you followed the PASS Summit activities last year, you’ll probably remember the “blogger table”. This was an area designated...
2010-10-29
1,532 reads
Warning: Two Way Traffic
I saw this at the college where we held SQLSaturday #49 on the restroom door. I’m not sure what to...
2010-10-29
1,527 reads
Why You Should Vote for My SQLRally Pre-Con
Self-marketing is not my strong suit. I don't feel very comfortable doing it, but Andy Warren (twitter | blog) suggests that we...
2010-10-29
2,498 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