Automation

Tag: automation

Automated Deployments and the Art of the Database with Database Michael J Swart

Automated Deployments and the Art of the Database with Database Michael J Swart

In this episode, Michael J Swart joins the Dear SQL DBA Podcast to talk about databases, automation, and how he’s come to illustrate some of the coolest blog posts ever to be written about data.

Continue reading

Why Not Call Database DevOps Simply DevOps?

Why Not Call Database DevOps Simply DevOps?

Sometimes people are annoyed by the term ‘Database DevOps’. Why not call it simply ‘DevOps’? After all, Database DevOps follows the same core principles.

The answer is simple: implementing DevOps is tricky by itself, but most teams are set up to fail when it comes to implementing DevOps for databases. This makes it worth defining as a specialization.

Continue reading

The HBO Max Integration Test Email Means You Should Make Automation Safer: For Everyone

The HBO Max Integration Test Email Means You Should Make Automation Safer: For Everyone

When I woke up today in the UK, Twitter was alive with jokes, hot takes, and sympathy about an email sent out to millions of folks on a contact list for HBO Max featuring the subject line, “Integration Test Email #1”.

Continue reading

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing

I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication.

Continue reading

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

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

DBAs: Stop Denying Sysadmin to Developers

DBAs: Stop Denying Sysadmin to Developers

I recently chatted with some folks who have a permissions problem in SQL Server. The permissions problem isn’t technical: it’s a process problem.

Continue reading