Steve has had to change his security, which is good, but annoying.

Stairway to Database DevOps Level 2: Manage Code with Red Gate SQL Source Control

by Erin Dempster

SQLServerCentral

In this second level of the Stairway to Database DevOps, we learn to use Redgate's SQL Source Control to save and updates changes to objects, as well as tracking data in certain tables.

Designing Databases for Distributed Systems

by Additional Articles

DZone

Database Design

Several data management patterns have emerged for microservices and cloud-native solutions. Learn important patterns to manage data in a distributed environment.

What I Wish Everyone Knew About ETL Processes - Traditional to Modern Cloud Solutions

by Additional Articles

MSSQLTips.com

Learn about the evolutionary journey of ETL (Extract, Transform, Load) from traditional processes to modern cloud solutions.

Stairway to Database DevOps Level 1: Setup a Local Git Repo with Azure DevOps

by Erin Dempster

SQLServerCentral

In this first level of the Stairway to DevOps, you will learn how to get version control set up on your local machine and connect to an Azure DevOps repository.

The Code Review Checklist

by Steve Jones

SQLServerCentral

Code reviews are a part of many software development processes, but not used that often with database work. Today Steve has a few thoughts and asks if you have any formal code review process.

Explore Natively Compiled SQL Server Stored Procedure Execution Plans

by Additional Articles

SQLServerCentral

In this article, we look at execution plans and performance of a natively compiled stored procedure versus a traditional stored procedure.

What Is Good Database Design?

by Additional Articles

SQLServerCentral

Database Design

Find out how good database design is essential to ensure data accuracy, consistency, and integrity and that databases are efficient, reliable, and easy to use.