sql for everyone
I’ve covered how to create Elastic Jobs in the portal (this one is important to read if you aren’t familiar with elastic jobs already), with Terraform, and with Bicep. Now, I’ll cover how to create them and their associated objects with PowerShell. Don’t do this…
I did a couple of other posts on Elastic Jobs. But now I want to set them up with Terraform. This aligns with how we create infrastructure where I work. TL;DR check out my Github Repo. Creating Prerequisites If you aren’t familiar with Terraform and…
I posted on Terraform and Azure SQL last year but wanted to see what Bicep could do this year. I’m going to test Bicep out with Elastic Jobs. TL;DR—My bicep code is on GitHub. Please read this post before you do the Bicep code. Here…
I know if you are a SQL Server DBA using Azure SQL DB, you’ve been sorely missing the agent. Enter Elastic Jobs to help you schedule jobs more easily against Azure SQL DB. I will cover setting up and scheduling Elastic Jobs to execute Ola…
Update: My favorite way is with Elastic Agent now. You can find my posts on that here. Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to…
This is part of a series of new job blog posts. You can find them all here. Week 5 goal: set up Ola index maintenance for all Azure SQL Databases. This week is about learning Flyway. I’m using Flyway because my company requires this for…
Don’t use runbooks as Elastic Agent is much better for this. You can find out how with different automation and manual techniques with my posts here. Yes, you still need to do some work to maintain indexes in Azure SQL Database. This post will walk…