2026-10-07
4 reads
T-SQL
2026-10-05
840 reads
2026-09-30
1,350 reads
2026-09-25
1,465 reads
2026-09-23
1,298 reads
Finding Gaps in Sequential Data Using SQL Server
Many systems expect a sequential range of numbers for invoices, ticket numbers, and more. Learn how you can identify where you have gaps in your sequences.
2026-09-21
3,641 reads
2026-09-21
924 reads
Practical Reporting Queries with CROSS APPLY (Part 3)
This article continues the series on APPLY, showcasing how some practical reports can be implemented using this operator.
2026-09-18
3,003 reads
2026-09-11
1,492 reads
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Learn how the bitwise functions SET_BIT() and GET_BIT() can be used to manage data stored inside a single column.
2026-09-11
2,323 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