Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset...
2025-06-13 (first published: 2025-06-11)
177 reads
If your SQL Server has both SQL and Windows logins and you’re not sure why, you’re not alone. Many IT teams without a dedicated DBA bump into this sooner...
2025-06-11 (first published: 2025-05-21)
448 reads
Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk drawer – everyone uses it, nobody monitors it, and eventually it becomes a bottleneck you...
2025-06-06 (first published: 2025-06-04)
78 reads
The Two-Layer Model Explained “We added them to the database, but they still can’t connect.” Sound familiar? That’s the kind of confusion SQL Server’s two-layer security model creates when...
2025-05-28
91 reads
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index. No questions asked. Here’s the truth: if you’re doing this daily on indexes smaller than...
2025-05-26 (first published: 2025-05-14)
638 reads
Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...
2025-05-12 (first published: 2025-04-23)
247 reads
Early Warnings of a Meltdown (and How to Catch Them) Most SQL Server crashes don’t come out of nowhere. They leave breadcrumbs – red flags that something’s not right....
2025-05-07
82 reads
Ever tried to request SQL Server funding from the CFO? Your systems, your data, your customer experience – they all rely on that “invisible” database engine humming along behind...
2025-05-01
36 reads
Everything in SQL Server is waiting for something…this is by design. And most people never think about it… Until your application is waiting to complete its request, sell the...
2025-04-30 (first published: 2025-04-16)
367 reads
Does skipping a DBA save money? Wait until your system grinds to a halt, your backups fail, or your cloud bill skyrockets. The “DBA? We Don’t Need No Stinkin’...
2025-04-14 (first published: 2025-04-02)
574 reads
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
I'm trying to figure out a how to do average costing over time in...
Comments posted to this topic are about the item What is Between?
Comments posted to this topic are about the item Inside the Walls of Azure...
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers