A Solution for the Bin Packing Problem
A detailed description of a technique for the the solution of the Bin Packing Problem, that involves a recursive CTE and Window functions
Remote Sharing and Learning
Steve notes we all need to learn to communicate and share information better, especially while we are remote.
A Hybrid Approach to Database DevOps
A flexible approach to Database DevOps where the team maintain the current state of the database in version control, during development, and then at key stages generate and test the migrations script that will deploy the changes to the target database, safely.
How to ACTUALLY save money in the cloud with SQL Server
We have all heard migrating to the cloud can save you money and there are several ways moving your SQL Server workloads to the cloud can save your organization money. But, there are also missteps that can eat away at the savings, performance and even your availability creating instead an expensive, ineffective, difficult to manage cloud infrastructure.
Smarter Design
Many of us have used PowerPoint, which has grown smarter through the use of Machine Learning.
Introduction to Azure SQL Database Instance Pools
In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described. Its biggest selling points include nearly full compatibility with on-premises SQL Server deployments, support for SQL Server Agent, and additional security associated with its Azure virtual network integration.
The Underground Map of SQL Monitor
The "metro map" of SQL Monitor, with sightseeing tips and essential stops along every line....
Concurrency Control in SQL Server
Learn a bit about concurrency problems in SQL Server, the issues they create, and the different isolation levels that help you solve them.
Defending Against Ransomware
Many more companies that you have heard about have been attacked by ransomware. Steve suggests you get prepared before this happens to you.
Translating a SQL Server Schema into a Cassandra Table: Part III Many-to-Many, Attribute Closure and Solution Space
In the third and final article of the series, Shel Burkow demonstrates several designs that cover many-to-many relationships, attribute closure, and solution space with Cassandra tables.
Blogs
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...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
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