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

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

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

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?

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.

Stairway to SQL Server Automated Database Testing Level 1: Why You Need TDD

The first article in this Stairway Series makes the case for test-driven development.

More SQL Server GDRs

A number of patches for SQL Server were released this week.

Integrating Python with MongoDB

This article gives an overview of MongoDB and outlines steps to integrate python with MongoDB

The SQL Developer Experience: Beyond RDBMS

Microsoft has built an amazing platform with Azure SQL Database and has recently announced an offer to use this for free. Read about the capabilities and options with this cloud database platform.

You Always Have a Software Pipeline

If you build software for customers, you have a pipeline. It might not be good, but you have one. Steve recommends you work to make sure this is a repeatable, reliable pipeline.

New Microsoft Sandbox Uses Natural Language LLMs for SQL Queries