SSMS Tools Pack - A Handy Tool for generating CRUD
So I've had this tool around for a while, but never found much usage out of it to be honest....
2016-06-17
2,938 reads
Selective Logging with the UPDATE() Function
Triggers can be very useful when you want to log changes to your data, but what if you’re only interested...
2016-06-22 (first published: 2016-06-16)
2,385 reads
When were statistics updated?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-16
658 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-23 (first published: 2016-06-16)
3,524 reads
Help! My backup file has doubled in size.
Help! I backed up my database yesterday and the backup file was about 200MB but today it’s closer to 400!...
2016-06-16
605 reads
A Better (Free) Search in SSMS
A few years back, Redgate Software released SQL Search. This was an internal project that became a free product we...
2016-06-21 (first published: 2016-06-15)
4,074 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at the upcoming Louisville #531, Saturday, Aug. 6th, 2016. My...
2016-06-14
20 reads
I am speaking at SQL Saturday Louisville 2016!
That’s right. My way of giving back to the SQL Server community, I am presenting my first SQLSaturday session at...
2016-06-14
142 reads
What’s New in Reporting Services 2016
Today I had the pleasure of presenting to the Higher Ed Data Warehousing and BI Group. We discussed the long...
2016-06-21 (first published: 2016-06-14)
5,423 reads
Power BI Custom Visuals Class (Module 03 – Hexbin Scatterplot)
In this module you will learn how to use the Hexbin Scatterplot Power BI Custom Visual. The Hexbin Scatterplot is...
2016-06-23 (first published: 2016-06-14)
2,908 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