2014 Event Kickoff
I know that this coming year, 2014, is going to be my best year yet! I’m starting 2014 off with...
2013-12-17
717 reads
Transactions: Rolling back a nested transaction
Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....
2013-12-17
1,535 reads
I’m Board
No, really, I’m board. It will be officially announced today, but as of December 11th, I’m the new Director of...
2013-12-17
570 reads
Collecting Historical IO File Statistics
In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using...
2013-12-17
1,483 reads
Database Recovery: Day 7
Recently we were talking about Backups and how you need to test them often. The most complete way to test...
2013-12-17
642 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in SQL Server 2012 is C561 whereas the result of...
2013-12-17
22 reads
Changed SoundEx Disables Index While Upgrading to SQL 2012
Implementation of SoundEx function is changed in SQL Server 2012, described here. For an example, the result of SOUNDEX(‘Csomorova’) in...
2013-12-17
998 reads
SQL Saturday in Ancona and Verona – English slide decks available for download
You can download the english version of my sessions at SQL Saturdays (on SlideShare):
SQL Saturday 257 in Verona: “Put databases...
2013-12-16
308 reads
Symmetric Keys
One of the encryption options in SQL Server is symmetric key encryption. This is the type of encryption most people...
2013-12-23 (first published: 2013-12-16)
2,944 reads
Last Weeks Top “Reading” Links #62
Monday afternoon and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout most days I tweet...
2013-12-16
1,386 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