Sparse Columns – ConvertSVtoXML & XMLToResv
Not very often I run across something with zero matches in a search engine, but had it happen recently. I...
2009-10-07
361 reads
SQL Saturday #21 Orlando
It’s that time again! SQL Saturday has returned to Orlando with an all star group of speakers http://www.sqlsaturday.com/schedule.aspx. The event...
2009-10-07
746 reads
Updated SQL Server 2008 Diagnostic Information Queries
Here is the October 2009 version of my SQL Server 2008 Diagnostic Information Queries. They are very useful for gathering...
2009-10-07
1,808 reads
Work on a Strength or Weakness?
When deciding what to learn, there's a binary decision. Will you focus on a strength or a weakness?
I think...
2009-10-07
1,625 reads
Weak Passwords Discovered in the 10,000 Disclosed Hotmail/Live.com/MSN leaked accounts
By now, hopefully everyone has heard of the security breach where accounts and passwords were found on a public site...
2009-10-07
2,896 reads
Deprecating Objects - Feedback
I posted a note awhile back that it might be nice to be able to mark an object as deprecated....
2009-10-07
326 reads
Do You Blog? The FTC May Be Watching
If you are a blogger and you post product reviews on your blog, you may have to answer to the...
2009-10-07
562 reads
PASS Editorial for Oct 7, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-10-06
342 reads
Buenos Aires Code Camp
No, I didn’t attend this one!
My friend Jonas Stawski is the organizer and we’ve been pleased to be a...
2009-10-06
379 reads
More SQL Server Benchmarks From AnandTech
AnandTech has another I.T. oriented post up comparing the performance and value of two-socket servers to four-socket servers. The gist...
2009-10-06
812 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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