SQLSaturday Pensacola Up Next For Me, Baton Rouge on the Horizon
Looking forward to the triumphant return of SQLSaturday Pensacola on June 4, thrilled that this start-of-summer tradition is back! This has been...
2016-05-20
370 reads
Bad Data Can Kill
Bad data can kill. Literally. I’m not talking about the impact of bad data on the bottom line of business,...
2016-05-31 (first published: 2016-05-20)
1,968 reads
Objects dependency check up in SSMS
It’s a very good practice that you check the dependencies of the other objects when you change an object. Many...
2016-05-20
205 reads
SSRS 2005 Bug - Percentage calculated column when Exporting to Excel
Nature of the Issue Faced :- Say you have 3 columns in a tablix/table on the report. There are 3 textboxes...
2016-05-30 (first published: 2016-05-20)
1,136 reads
Speaking about Power BI @ ITPROceed 2016
I’m delighted to announce that I’ll be giving a session at this year’s ITPROceed. For those who don’t know this...
2016-05-19
494 reads
StorSimple Appliance – Part 1 Overview
Last time, I talked about cloud backup and the two different ways of doing it – directly and using StorSimple appliance...
2016-05-27 (first published: 2016-05-19)
1,548 reads
Changing a Computed Column–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-05-27 (first published: 2016-05-19)
2,222 reads
Broken Update With Join
Last month I wrote a post titled Broken Left Join which covered an easy to make mistake that I see...
2016-05-26 (first published: 2016-05-18)
1,805 reads
Migrate from on-prem SQL server to Azure VM IaaS
Hopefully you went through my presentations Should I move my database to the cloud?, Introducing Azure SQL Database and Implement SQL Server on an...
2016-05-26 (first published: 2016-05-18)
3,213 reads
Minion CheckDB Beta
Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...
2016-05-18
679 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