So Long, Farewell, I Hate to Say Goodbye
The Sound of Music is one of my all time favorite movies. It reminds me of some great times with...
2016-10-12
523 reads
An Update on My 2012 Mac Air
Typically I want to get 3 years out of a laptop to amortize spending on a premium grade machine. I’m...
2016-10-12
436 reads
Diff All Files - Reviewing Changesets Quickly
If you need to do code comparison on a lot of files in Visual Studio, I ran across an extension...
2016-10-12
819 reads
SQL Live Health Check - part 3 - permission requirements and the rest
This is the last part of the series, where I discuss about the monitoring application that I build. If you...
2016-10-12
1,339 reads
T-SQL Tuesday #83: Resource Governor CAP_CPU_PERCENT: It just runs faster?
Welcome to T-SQL Tuesday #83 being hosted this month by Andy Mallon (blog|@AMTwo). This month’s topic is “We’re still dealing...
2016-10-11
722 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
7 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have to own an Azure account. In the account you...
2016-10-11
19 reads
T-SQL Tuesday #83: How are we still dealing with the same problems?
#TSQL2SDAY is a monthly blog party hosted by a different blogger each month. This blog party was started by Adam...
2016-10-11
401 reads
Connect to SQL Azure database from SSMS
In this article I’ll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-10-11
293 reads
T-SQL Tuesday #83: We’re still dealing with the same problems
It’s about time I got back into participating in the T-SQL Tuesday block parties that are hosted by community members...
2016-10-11
385 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