Blink – Year is gone
As the door begins to knock I start to wonder who it can be. As I begin to open it...
2014-12-22
514 reads
The SQL Professor
SQL Sentry Plan Explorer – Don’t Leave Home Without It
If you’ve been around me long enough then you realize that I am a Red Gate fanatic. With that said...
2014-12-09
1,162 reads
T-SQL Tuesday #61 – Giving Back
It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when...
2014-12-12 (first published: 2014-12-09)
4,595 reads
PASS Summit 2014 ~ My GameTime Experience
“How did you like your convention?”
“How was your trip?”
“What did you learn?”
“Where did you go for a week?”
“Who did you...
2014-11-25
1,551 reads
What Are You Thankful For
Bob Pusateri (B | T) wrote a blog post yesterday for anyone who was interested on sharing what they were thankful...
2014-11-18
527 reads
T-SQL Tuesday #60 Roundup – Step Right Up
We had a great turnout for this months T-SQL Tuesday Block Party. Coming into this month and knowing that I...
2014-11-16
627 reads
T-SQL Tuesday #60 Something New Learned
So, here it is. I put the challenge out to discuss something new learned last week. I was fortunate enough...
2014-11-11
611 reads
T-SQL Tuesday #60 – Something New Learned
Lights go on, it’s another game day, grabbed my bat and headed for the plate only this time we are...
2014-11-05
580 reads
Im At Summit Now What?
Pass Summit 2011 – Photo Provided by Pat Wright
We are a week out from PASS Summit 2014 and there will be...
2014-10-28
603 reads
T-SQL Tuesday #59 – My Hero!
It always amazes me how fast these T-SQL Tuesday block parties come about; it seems like we just finished one...
2014-10-14
606 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