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.
Make It Routine
Solving problems can be challenging, but once you have something built, it should be easier the next time.
What is cloud database vendor lock-in? The 3 types explained (and how to audit yours)
Cloud database vendor lock-in is one of the most expensive surprises in enterprise infrastructure — not because the dependency is hidden, but because most teams never quantify it before committing to a platform.
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.
Foreign Keys and Performance in a Microsoft Fabric Warehouse
I wanted to answer a simple question: Do relationships help, hurt, or have no effect when added to tables in a Fabric warehouse?
Evaluating a DBA (or AI)
Steve has a few thoughts on hiring and the way in which you might want to evaluate a DBA candidate.
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Learn about a Type 4 Slowly Changing Dimension in this article by Dinesh Asanka.
SQL Server login failures: how to monitor, report, and alert on them
This guide walks through how to pull login failure data using sys.xp_readerrorlog, filter it by time and error type, parse it into readable columns, aggregate repeat offenders, and automatically email a summary report — turning a passive log file into an active security and troubleshooting tool.
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers