SQL ConstantCare® Population Report: Fall 2025
In this quarter’s update of our SQL ConstantCare® population report, showing how quickly (or slowly) folks adopt new versions of SQL Server, the data is very similar to last quarter
2025-11-17
Articles
T-SQL in SQL Server 2025: Concatenating Strings
Like many of you, I have often put strings together (concatenation) with a simple arithmetical operator: +. We have a few other ways to put strings together, but in SQL Server 2025, we have a new operator that allows us to put strings together. This is the double pipe (||) operator. This article looks at […]
2025-11-14
3,881 reads
IoT Meets OLTP: How to Handle Backfilling Challenges in Real-Time Systems
This is the true story of a 64-core SQL Server brought down by poor assumptions about its data. A clustered index designed for neat, sequential IoT inserts was overwhelmed when the real readings arrived late, out of order, and in bulk. The same risk lurks in any high-write system with unpredictable insert patterns. This article shows what can go wrong and how to avoid it.
2025-11-14
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Learn how you can create a logging module in Python that can be used to insert real-time records in a PostgreSQL database and display them on a dashboard.
2025-11-12
2,228 reads
JSON_CONTAINS Function in SQL Server 2025
I have data coming into my SQL Server database as JSON. Before I start parsing it which is quite intensive, I need to check if some values are present in the JSON. Is there a function I can use to do this? Let’s see what the new JSON_CONTAINS function in SQL Server 2025 can do.
2025-11-12
MySQL’s BLACKHOLE Storage Engine: The Odd Feature I Wish SQL Server Shipped With
Learn about a MySQL feature that could be useful in some scenarios for SQL Server.
2025-11-10
4,442 reads
Unlocking the Power of FULL OUTER JOIN in SQL: Performance, Use Cases & Examples
Discover how the FULL OUTER JOIN in SQL can simplify queries, improve performance, and solve real-world data problems
2025-11-10
T-SQL in SQL Server 2025: Substring Changes
This article takes a look at the changes in SQL Server 2025 to the SUBSTRING function.
2025-11-07
9,715 reads
SQL Server CROSS APPLY and OUTER APPLY Helpful Examples
Microsoft introduced the APPLY operator in SQL Server 2005. Similar to a JOIN, it allows correlation between two table expressions. The key difference between the JOIN and APPLY operators is when you have a table-valued expression on the right side and want to evaluate it for each row from the left table expression. Since they produce similar results, when do you choose an APPLY versus a JOIN?
2025-11-07
Create and Read the Analysis Services Flight Recorder
This article explains how to customize an extended events session in SQL Server Analysis Services for auditing and monitoring
2025-11-05
1,732 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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