#MDXMonday: Finding the Current Day
This week I’m teaching the Pragmatic Works Intro to MDX virtual training class. A student in the class asked how...
2015-09-16
469 reads
PASS Election Questions Answered
As we continue through the campaign period for this year’s PASS Board of Directors Election (Voting opens tomorrow morning), I...
2015-09-16
519 reads
PASS Summit Precon – The Complete Primer to SQL Server Virtualization – UPDATE
I am very pleased to announce that Argenis Fernandez, (now including)Jimmy May, and I will be presenting a new precon...
2015-09-16
573 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
298 reads
SQL Prompt 7 by RedGate
RedGate unleashed their newest version of SQL Prompt recently. It is no secret to those of you who know me...
2015-09-16
2,177 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data.
Related Posts:
How to: File Target use in Extended Events December 27, 2018
Dynamics...
2015-09-16
7 reads
Storing Event Data
Among the several core concepts of Extended Events is the concept of storing event payloads / data. When an event fires, it...
2015-09-16
788 reads
Ryan Adams For PASS 2016-2018 Board
Ladies and Gentlemen, I would love to announce my support for Ryan Adams running for the PASS Board in 2016-2018....
2015-09-16
493 reads
Using @@ROWCOUNT can be a bit tricky
@@ROWCOUNT is a very useful system variable that returns the number of rows read/affected by the previous statement. It’s frequently...
2015-09-16
724 reads
The Trouble with Rules
I love running. I wake up at 5am three times a week, run for an hour, and by 6:30am I’m...
2015-09-16
595 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