Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
206 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-11
177 reads
Regex With SQL Server - SQLSharp
In the context of my developer machine, I had log files I wanted to parse through. I setup a log...
2016-08-17 (first published: 2016-08-11)
3,377 reads
Azure SQL Database vs SQL Data Warehouse
I am sometimes asked to compare Azure SQL Database (SQL DB) to Azure SQL Data Warehouse (SQL DW). The most important...
2016-08-17 (first published: 2016-08-10)
1,947 reads
What’s a Database Pipeline?
One of the things I ran into a few years ago was the idea of a software pipeline. A set...
2016-08-19 (first published: 2016-08-10)
2,821 reads
Inside the mind of a c# developer
I’ve been working with SQL Server for 18 years and over that long span I’ve seen a lot of different...
2016-08-10
631 reads
SQL Server Newsletter @LearningTree
As many of you know I have been delivering Learning Tree training courses since way back in 2010. Combing training...
2016-08-10
437 reads
Power BI Custom Visuals Class (Module 11 – Calendar Visualization)
In this module you will learn how to use the Calendar Visualization Power BI Custom Visual. The Calendar Visualization is...
2016-08-16 (first published: 2016-08-10)
2,589 reads
TSQL Tuesday #081 – Sharpening something
This TSQL tuesday is hosted by my good friend Jason Brimhall – Jason has put forth a creative challenge – plan to...
2016-08-10
308 reads
T-SQL Tuesday #81 – Migrating Databases with Dell LiteSpeed
It’s time for T-SQL Tuesday again, and this month’s host is fellow Certified Master and Data Platform MVP Jason Brimhall...
2016-08-09
680 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