DevOps and Continuous Delivery (CI/CD)

Stairway to Database DevOps

Stairway to Database DevOps Level 4: Creating a new Azure Pipeline (with Azure SQL DB Deployment)

  • Stairway Step

The first three levels of this series have been the lead-up to this level, automating the database deployment with Azure Pipelines. First, we started with an introduction to Azure DevOps and the Git client. Next, SQL Source Control was introduced to manage a database’s schema and manually deploy changes from the database to source control […]

5 (4)

You rated this post out of 5. Change rating

2023-12-06

1,504 reads

Stairway to Database DevOps

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

  • Stairway Step

In this level of the Stairway to Database DevOps, you'll get an introduction to branching and merging. Learn how to create a branch for making your changes to the codebase, submitting these in a code review, and then merging the changes into those made by other developers.

5 (2)

You rated this post out of 5. Change rating

2023-12-01

1,662 reads

External Article

Five database DevOps practices for boosting team productivity

  • Article

Speed of delivery and protecting data can often feel incompatible, but there are industry-proven database DevOps practices that bring them together in harmony.

Across each of these five key practices, there’s a theme of removing barriers and cognitive load for teams; but crucially, they are also putting safeguards in place to reduce the risks to production environments.

2023-11-06

Blogs

Migrate datetime data to datetimeoffset with AT TIME ZONE

By

I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...

The Comprehensive Guide to Mastering Your SQL DBA Skills

By

Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...

Friday Basics: Authentication vs. Authorization

By

Another security fundamentals topic is authentication versus authorization. For those who have a clear...

Read the latest Blogs

Forums

The Backup File Extension

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Backup File Extension

Ingest and Retrieve data from an ADX Cluster Using Python

By Sucharita Das

Comments posted to this topic are about the item Ingest and Retrieve data from...

The DBAccountant

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The DBAccountant

Visit the forum

Question of the Day

The Backup File Extension

I run this command in SQL Server 2022. What is the extension of the backup file?

BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'

See possible answers