Devops-Automation

Category: devops-automation

Installing Redgate SQL Toolbelt with Chocolatey (Video with Transcript)

Installing Redgate SQL Toolbelt with Chocolatey (Video with Transcript)

By Kendra Little on December 2, 2019

Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line.

Spoilers:

  • The command I show in the video is simply: choco install sqltoolbelt
  • Fun fact, you can also upgrade: choco upgrade sqltoolbelt
  • And uninstall: choco uninstall sqltoolbelt

Continue reading

My Git CLI Cheat Sheet

My Git CLI Cheat Sheet

By Kendra Little on November 27, 2019

I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video.

I find the Git CLI to be very friendly and easier to learn than a GUI interface.

Continue reading

Links and Resources from How to Architect Successful Database Changes

Links and Resources from How to Architect Successful Database Changes

Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day.

Continue reading

Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (Video with Transcript)

Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (Video with Transcript)

In this video, Freyja the puppy and I talk about a recent workshop which I facilitated at the IDC DevOps conference in London.

Continue reading

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem.

Continue reading

Git Command Line Tutorial with SQL Change Automation for SSMS (Video)

Git Command Line Tutorial with SQL Change Automation for SSMS (Video)

I’m excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS).

SQL Change Automation lets DBAs and developers use a migrations-first approach to create precise scripts to apply changes to your database. If you’re curious about what I mean by “migrations-first”, read more about this approach, and how it compares to a state-first approach here.

Continue reading

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

The Accelerate: State of DevOps Report 2019 has just been published. This report is the latest in six years of research. With more than 31,000 survey responses, Accelerate is the longest running study of DevOps in academia or industry.

In the 2019 edition, research continues to show that DevOps drives business value: high performers at DevOps are “twice as likely to meet or exceed their organizational goals.” While this isn’t a new finding, it’s very important that this continues to be true: why invest in improving at DevOps if it doesn’t drive business value?

Continue reading