Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are...
2015-07-21
49 reads
Keep your environments in-sync and your upgrade scripts fresh
Whether we use a tool to generate upgrade scripts or we write manual test scripts for database changes there are a few things that we should bear in mind...
2015-07-21
7 reads
Speaking about Columnstore Indexes at PASS Performance Palooza
The PASS Performance Virtual Chapter has a tradition of yearly “Palooza events”, in which there are a few back-to-back online performance...
2015-07-21
494 reads
Azure SQL Database – Link User to Login
I’m writing this post as a way to help motivate the #SQLNewBloggers out there. Read the bottom for a few...
2015-07-20
918 reads
The SQL Saturday Crazy Train hooks up a caboose!
You know, these 1 hour sessions that are at most SQL Saturdays are just too short sometimes – you just get...
2015-07-20
762 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
1,564 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
225 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
90 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the...
2015-07-20
124 reads
Pre-Compare & Pre-Deployment Scripts to SSDT
When you use SSDT to deploy database changes you can include a pre/post deploy script which is run after the dacpac and database has been deployed. The process looks...
2015-07-20
11 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