Cellular Automation – SQL Server CPU, IO and Hekaton Stress Testing
This article shows how you can use SQL Server spatial methods, mathematical rules and oscillating patterns to benchmark CPU, IO and Hekaton performance.
Five Minute Refactoring
The debate over how to change code or solve a problem can create arguments that last for years. Steve Jones notes the idea of limiting debates to five minutes is interesting.
The Challenges of Space
CSS Engineers at Microsoft are reporting more space issues with database systems. Steve Jones has a few comments.
Powershell day-to-day Admin tasks: WMI, CIM and PSWA
WMI (Windows Management Instrumentation) is the basic way of querying and changing basic information about any windows server, including SQL Server or Exchange Server. It provides a logical structure and representation of systems and services that are hosted on the server and is essential for anyone who is keen to automate routine monitoring and administration work via PowerShell, especially where many servers are involved in the task.
Stored Procedures and SQL Injection
Why do stored procedures help with security? In this piece, MVP Brian Kelley explains why SQL Injection and information gathering are hampered with stored procedures.
Managing Test Data as a Database CI Component - Part 2
Tim Hidalgo goes through some practical demos to show you how you can automatically keep your testing environments up to date, and ship more robust databases.
Add Styles to Your Reporting Services Reports
Reporting Services provides a robust reporting platform that rivals many other products. New author Adam Aspin stars a series on how you can dress up your reports and maintain good development practices.
Checking Table Metadata with tSQLt
In this article on tSQLt, learn how you can use the AssertResultSetsHaveSameMetaData method from the framework to enforce your API.
Practical Hekaton
Steve Jones is searching for anyone that is using In-Memory OLTP tables in production.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers