High performing teams must implement a common approach to database migrations so that the database can be included in Continuous Delivery. This ‘kernel’ of Database DevOps leads to better alignment between developers and Ops teams, and increases the throughput of high quality releases. The key for many is Flyway, and this whitepaper explores how this highly configurable migrations tool enables a bespoke migrations-based deployment strategy that is easy to adopt and scale across teams

Join the New Stars of Data

by Steve Jones

SQLServerCentral

There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.

Using Azure Synapse Link for Azure Cosmos DB

by Sucharita Das

SQLServerCentral

Learn how you can query CosmosDB data from Azure Synapse in this walkthrough.

Developing a backup plan

by Additional Articles

SimpleTalk

Without a good backup and recovery strategy in place, a DBA should make sure their resume is always up to date. In this article, Greg Larsen discusses what should be considered when developing a backup plan.

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

by Andy Leonard

SQLServerCentral.com

In this next level of the Stairway to Biml, we will examine how you can use the information stored in your RDBMS to build packages.

Your User Group Goals

by Steve Jones

SQLServerCentral

User Groups

Today Steve asks what you might want out of your local organization devoted to the data platform.

Deploy Database Objects to Multiple SQL Server Instances Using PowerShell

by Additional Articles

MSSQLTips.com

PowerShell

In this article we look at a PowerShell script that can help you deploy database objects to multiple SQL Server instances.

Effective Data Governance: Being Grown Up About Data

by Additional Articles

Redgate

Vendors/3rd-party Products

William Brewer explains how to make data governance a continuous organizational activity, based on well-established standards and practices, rather than a knee-jerk response, and which skills and tools will help you achieve compliance, including SQL Data Catalog for discovery and classification of data held in SQL Server.

Free eBook: Fundamentals of SQL Server 2012 Replication

by Press Release

Redgate

Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.

Introduction to PostgreSQL Database on Amazon RDS

by aveek22

SQLServerCentral

This article explains how to get started with PostgreSQL on AWS.

Whitepaper: Enabling fast and easy database migrations with Flyway

Join the New Stars of Data

Using Azure Synapse Link for Azure Cosmos DB

Developing a backup plan

Stairway to Biml Level 8 – Using the Relational Database Metadata to Build Packages

Your User Group Goals

Deploy Database Objects to Multiple SQL Server Instances Using PowerShell

Effective Data Governance: Being Grown Up About Data

Free eBook: Fundamentals of SQL Server 2012 Replication

Introduction to PostgreSQL Database on Amazon RDS

Blogs

Did You Really Name That Default?

Monday Monitor Tips: A New Analysis Page

Case Studies: Real-World Success Stories of FinOps Implementation

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions

Identity Defaults

Question of the Day

Identity Defaults