Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post. To get that setup, you can follow the instructions in this blog post. I found that…
Category: dba
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I was logged in with Azure Active Directory – Univeral with MFA. When I Googled, I didn’t…
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. As a DBA, the first six weeks on the job can be challenging and exciting. During this period, you are expected to learn about the company’s processes. You…
This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I started pushing out the sp_Blitz scripts that work on Azure. In the world of SQL Server…
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…
This is part of a series of new job blog posts. You can find them all here. The main goal for week 4: set up auditing for all Azure SQL Databases. This week is again about learning more Terraform. I’m using Terraform because my company…
This is part of a series of new job blog posts. You can find them all here. UPDATED: I needed to change out resources that will be deprecated, such as azurerm_mssql_database, azurerm_mssql_firewall_rule, and azurerm_mssql_server. Code snippets in this post and GitHub are updated accordingly. The…
This is part of a series of new job blog posts. You can find them all here. Last week was the first week of the rest of my life. But really it was the first week of my new job and I installed a lot…
This is part of a series of new job blog posts. You can find them all here. I changed to a new job and started it this week. Before I started, I thought of all the things I thought I would want to do when…