Learn how to use SQL Clone together with Git hooks and SQL Change Automation to branch your database in Git as quickly and simply as your code.

Why Ordering Isn’t Guaranteed Without an ORDER BY

by Additional Articles

Brent Ozar Blog

If your query doesn’t have an ORDER BY clause, you can’t reliably predict the order of your results over time. Sure, it’s going to look predictable at first, but down the road, as things change – the indexes, the table, the server’s configuration, the size of your data – you can end up with some ugly surprises.

A Solution for the Bin Packing Problem

by Alessandro Mortola

SQLServerCentral

T-SQL

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

by Steve Jones

SQLServerCentral

Communication

Steve notes we all need to learn to communicate and share information better, especially while we are remote.

A Hybrid Approach to Database DevOps

by Additional Articles

Redgate

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

by Additional Articles

MSSQLTips.com

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

by Steve Jones

SQLServerCentral

Many of us have used PowerPoint, which has grown smarter through the use of Machine Learning.

Introduction to Azure SQL Database Instance Pools

by Additional Articles

Database Journal

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.