Poor Software Testing

• by Steve Jones

• SQLServerCentral

• DevOps and Continuous Delivery (CI/CD)

A major flaw in testing the software for an election machine.

Restoring Master on a Windows 2019 / SQL Server 2019 Cluster

• by Johan Bijnens

• SQLServerCentral

Howto restore master database on a Clustered SQL Server 2019 Instance

Five facts about the SQL Server Model Database

• by Additional Articles

• MSSQLTips.com

• SQL System Database
• system database
• System databases

In this article we cover interesting facts about the SQL Server model database and how new databases inherit properties from the model database.

Moving from application automation to true DevOps by including the database

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

This article explains the challenges of DevOps automation for databases, starting with how to manage the database, as a set of SQL scripts, in the version control system, and then how to start building an integrated and automated script pipeline for continuously testing and deploying database schema changes, alongside the application code.

Growing Outside of the English World

• by Steve Jones

• SQLServerCentral

• Misc

The world is bigger than one country, and Steve is trying to remember that.

Stairway to SQL Server Virtualization Level 2 - The Ideal SQL Server Virtual Machine Architecture

• by David Klee

• SQLServerCentral.com

In Level 2 of the Stairway to SQL Server Virtualization, we examine the ideal VM configuration from a standpoint of the various resources involved.

PowerShell editors and environments part 2

• by Additional Articles

• SimpleTalk

• PowerShell

In this article, Greg Moore demonstrates two additional PowerShell editors: Azure Data Studio Notebooks and Visual Studio Code.

Reading Stored Procedure Output Parameters in Azure Data Factory

• by diponkar.paul

• SQLServerCentral

• Azure Data Factory
• Azure SQL database

This article will help you to work with Store Procedure with output parameters in Azure data factory.

Removing SA from Azure SQL Database

• by Steve Jones

• SQLServerCentral

• Authentication
• Azure SQL database
• Security

Azure SQL Database is getting the ability to turn off SQL authentication.

3 steps to get started with Database DevOps

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

Once you’ve committed to changing your culture in order to automate your database deployments, what’s next? You’ve already done the hard part, making the decision to shift the culture. In this blogpost, Grant Fritchey explores three steps you can take next to begin your Database DevOps journey.