New SQL Blogging Challenge
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
414 reads
The SQL Professor
Reflections and Looking Forward
Time is slowly ticking toward 0:00 on the clock. As I look around I couldn’t help but reflect back on...
2015-12-22
505 reads
Why Should Data Professionals Automate?
Take a minute and look around you. Automation is all around you; whether you see it or not processes are...
2015-11-30 (first published: 2015-11-24)
1,514 reads
HADR Virtual Chapter Involvement
I am always looking for ways to get involved within the PASS community. One such way that has become available...
2015-11-17
488 reads
Community Involvement–Why Wait?
Everyone has a story; some stories are similar while some stories are vastly different. People always make the statement that...
2015-11-12
628 reads
T-SQL Tuesday #72 Invitation – Data Modeling Gone Wrong
T-SQL Tuesday is here again. I’ve had good intentions the past few times this event has come around and even...
2015-11-13 (first published: 2015-11-10)
1,981 reads
PASS Summit Recap and Experience
The day finally came and I was fortunate, no I was blessed to be a part of the PASS Summit...
2015-11-04
550 reads
PASS Summit Key Note Day 2 – Recap
As I sit here in an offshoot of the convention center, I started reflecting back to this morning’s keynote for...
2015-10-29
863 reads
Live Blog – Pass Summit Key Note – Day 1
Security as been invested more in SQL Server 2016 than any other.
Protecting your data at rest and in motion with...
2015-10-28
428 reads
Live Blog – Pass Summit Key Note – Day 1
Security as been invested more in SQL Server 2016 than any other.
Protecting your data at rest and in motion with...
2015-10-28
327 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