Video unavailable

SQLBits 2022

Automating Database Deployments Using Github Actions

Github Actions combines the power of Git with DevOps in the cloud. Learn how to implement databases inside this powerful tool.

Implementing DevOps or DevOps-style automation can be difficult, but when you start to deal with data, that difficulty increases rapidly. This session shows how to implement various techniques that allow you to safely automate database deployments using Github Actions. You'll learn how to successfully deploy to both on-premises and cloud-based databases in support of a complete DevOps approach.

Speaker

Grant Fritchey, SQL Server MVP, works for Redgate Software as a Product Advocate. He is the author of the books SQL Server Execution Plans (Simple-Talk) and SQL Server Query Performance Tuning (Apress).

Grant Fritchey's Sessions

Learning PostgreSQL as a SQL Server User

Maximize your Productivity: 10 Ways Redgate Makes Database Management Easier

The (Data) Future's So Bright, I Gotta Wear Shades

Understanding Extended Events

Managing the Challenge of Monitoring Growing, Multi-platform Database Estates

The New Database Landscape - Revealing Shifts and Charting the Next Horizon

Fundamentals of Git

Efficiency up, failed releases down; compliant production data for your test and dev environments

Automating Database Deployments Using Github Actions

Benefits of Using Version Control In Database Development

SQL Server Query Performance: Common Problems, Possible Solutions

Flyway: An Evolution in Database Deployments

What I’m telling your developers about DevOps

SQL Injection: How it Works, How to Stop It

Yes, You Should Monitor Azure SQL Database

SQL Injection: How it Works, How to Stop It

Learn to Read Execution Plans

Environment Provisioning: The Third Age

DevOps and Data

Exploring Execution Plans

Data protection & privacy in the world of database DevOps

Statistics, Row Counts, Execution Plans, and Query Tuning

Introducing the Query Store

Faster Provisioning with SQL Clone

The Query Store and Query Tuning in SQL Server vNext

Execution Plans: What Can You Do With Them?

Top Tips for Better T-SQL

Automating Your Database Deployments

Getting Started Reading Execution Plans

Monitoring Windows Azure SQL Server VMs and SQL Databases

Query Tuning in the Clouds