Webinar on Change Tracking for Data Warehouse Loads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
426 reads
Open Data is like a soup
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
619 reads
Always Encrypted Column Encryption
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
731 reads
Folders to Check for errors in SQL Patching or Installation
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
6,906 reads
Launching Columnstore.NET
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
396 reads
PASS Summit Announcements: Power BI reports on-prem in SSRS
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-03
641 reads
Reinforcing the Importance of Statistics on Row Estimate
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,231 reads
Ponderings of PASS Summit 2016
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
433 reads
Ponderings of PASS Summit 2016
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
217 reads
SQL Server Backup Compression
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
483 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