SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows for parts (or all) of a table, presumably older,...
2016-04-19
24 reads
SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows...
2016-04-19
214 reads
SQL 2016 features: Stretch Database
Stretch database allows for a table to span an ‘earthed’ SQL Server instance and an Azure SQL Database. It allows...
2016-04-29 (first published: 2016-04-19)
2,686 reads
SQL Server Service Broker – Error Handling
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-04-19
76 reads
SQL Server Service Broker – Error Handling
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-28 (first published: 2016-04-19)
1,861 reads
Overview of Published Articles – 2016Q1
Here is an overview of the articles I published in the first quarter of 2016.
R Services series:
SQL Server 2016 R Services:...
2016-04-19
441 reads
Automating SSMS 2016 Updates & Install
Figured I'd share a way to automate the SSMS 2016 updates until it gets it's own fancy self updater. I...
2016-04-26 (first published: 2016-04-19)
2,707 reads
KDiff3
As I write more code, especially database code, and I collaborate with others (or myself), I find that I have...
2016-04-29 (first published: 2016-04-18)
2,357 reads
Easy SQL mistakes: Accidental Correlated Subquery
Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup...
2016-04-25 (first published: 2016-04-18)
2,965 reads
How to Trim Characters in C#
The removing of leading and trailing characters in c# is made possible by the System namespace.
My demo is uses a windows...
2016-04-18
507 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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