Do You Teach Azure Data Platform?
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out....
2016-03-29
823 reads
SQL Server Service Broker – Service Architecture
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-03-29
1,108 reads
Talking about the Query Store at SQLBits!
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will...
2016-03-29
775 reads
Nothing To See Here
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to...
2016-03-29
906 reads
SQL Server News–29th March 2016
This past weekend is one of my favourite holiday weekends - the 4 day Easter weekend 🙂 Although I have had to...
2016-03-29
611 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing log files in my post Database Log VLFs. However,...
2016-03-29
44 reads
File Growths
I hinted at file growths in my previous posts about shrinking data and log files. Then I talked about growing...
2016-04-11 (first published: 2016-03-29)
1,963 reads
SQL Server Failover Cluster Configuration & its Hardware Compatibility
Introduction
Failover cluster in SQL Server is a type of cluster in which two or more independent servers are interconnected with...
2016-03-29
890 reads
2016-03-29
507 reads
Notes from the March 2016 oPASS Meeting
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
598 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...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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