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

Overcoming Imposter Syndrome: A Plan

Advice I Like: Celebrate Success

Programmatically Retrieving MLV Lineage and Refresh Times

Forums

BCA KCP GAMA Tlpn/wa:085373737551

BCA KCU KEBAYORAN BARU Tlpn/Wa:6285188120691

BCA KCP A. Yani Telpon/WA:08218168291

Question of the Day

Increase Deadlock Detection