This editorial was originally published on Jun 17, 2020. It is being republished as Steve is out of town. Let us know if you've changed your SQL IDEs since then. Most of us use SSMS (SQL Server Management Studio) to manage our SQL Server instances or to write database code. However, Microsoft does give us […]
SQL Server 2025 shipped without SSRS. If you're managing paginated reports, your options just narrowed; but they're not what most people think. I evaluated all 10 realistic migration paths. Here's an honest comparison, including the one I built.
Explore the mechanics of the SOFTMAX function in SQL Server. Transform scores into probabilities with this essential tool.
New AI tools are discovering older vulnerabilities in software, as well as new ones. Get ready for a bunch of patches to come out.
Learn a quick way to calculate distances without resorting to spatial calculations.
Steve has thoughts about those of us struggling to keep up with technology changes.
Learn how to split strings efficiently in T-SQL using STRING_SPLIT and the REGEXP_SPLIT_TO_TABLE function in SQL Server 2025.
Single points of failure are bad, but what if an employee's action is the single point of failure for access to services? That would be a bad day for any organization.
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
By Steve Jones
I’m sure many of you are using AI regularly, perhaps chatting, perhaps using some...
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Comments posted to this topic are about the item Another Model, More Data Loss
Comments posted to this topic are about the item Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers