Fundamentals of Storage Systems, Understanding Reliability and Performance
Solid state storage has come on strong in the last year. With that explosion of new products it can be...
2010-10-28
841 reads
Writing Opportunities
Are you looking for opportunities to show off your elite writing skills and consumate SQL Server knowledge? Want a chance...
2010-10-28
631 reads
Last Call for PASSMN Board of Directors
As I mentioned a couple weeks ago, we are looking for nominations for the 2011 PASSMN Board of Directors. PASSMN...
2010-10-28
502 reads
SQLSaturday#59 Speaker Interview #13 – with Mark Kromer
SQLSaturday #59 Speaker Interview #13 – with Mark Kromer
Today, coming in from Philadelphia, PA, we are talking with Mark Kromer, who...
2010-10-28
796 reads
SQL Rally: Performance Tuning Abstract
I get the call, you get the call, everyone gets the call. “Hey, my app/procedure/query/report is running slow.” Now what...
2010-10-28
715 reads
Vote for the Pre-Con’s You’d Pay to Attend
If you read this blog you probably already know about the PASS SQLRally and that we are doing things a little...
2010-10-28
381 reads
Bulk Insert Permissions
In order to be able to execute bulk operations you need to certain level of privilege both on the database...
2010-10-28
33,049 reads
Overwhelmed, Stress, and Planning
It’s been a bit hectic this year. In fact, it feels crazy most weeks as I try to manage work,...
2010-10-28
790 reads
When is that Restore Going to Finish?
I spent a good portion of last weekend restoring databases from backup due to a large release. Nothing went wrong,...
2010-10-27
864 reads
Notes from MySQL Enterprise Lunch and Learn With Representatives from Sun & Oracle (MySQL 5.5 Now Downloadable)
Today we sat through a pizza ‘n pop lunch while listening to a MySQL Offering and Licensing for the company...
2010-10-27
2,053 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