Category: SQL Server Administration
-
The Managed Instance that couldn’t be deleted
I’ve written quite a few posts previously about creating Azure infrastructure, and it’s something that I do rather frequently. Typically, it’s to test the templates that I’ve created, after I’ve changed them somehow. While I fully expect my code to sometimes (often) fail, I usually don’t expect the removal of the Azure resources to fail. […]
-
IaC Database Deployments
Copy-pasting code snippets from StackOverflow isn’t (always) the best way to do infrastructure as a code (IaC) database deployments. In fact, if you’re ever planning to deploy more than two database services, you should probably consider building your own infrastructure as a code templates and repositories. Having IaC repositories and templates gives you the ability […]
-
Why I know DBA role survives the public cloud.
For the past 10 years or so, I’ve seen it occasionally come up in the discussions that DBA won’t be needed in the future. Originally, it started with the vendors claiming that their database systems are becoming self-tuning. Then the final nail in the coffin was to be the public cloud, which was also to […]
-
Database Migration, Modernization, and R-strategies.
Public cloud is a really great place to put your application and database workloads. However, it’s not always clear how, exactly, that should happen. Some people talk about migrating, others about modernizing, a few mix everything together, and then there is a bunch of words that all start with the letter R. In this post, […]
-
Mitigating concerns for COTS application database migrations.
I spend a lot of my working time and effort to move on-premises databases to the cloud. When I am not doing that, I am most often spending it planning on how to do it more efficiently. While I think today almost everyone agrees with the benefits of going to the cloud, there are a […]
-
Quick way to do security check for SQL Server database(s)
I previously wrote about Azure Defender for SQL that brings some remarkable security capabilities to your cloud-based SQL Server estates. And while you can also get some of that goodness to your on-premises servers, sometimes you just don’t need all that comprehensive solution. Well, I have good news for you. There’s also a quick and […]
-
SQL Assessment API
Every so often, Microsoft puts some extra into their SQL Server product, which doesn’t get as much time in the spotlight as it should. Nope, not talking about any of the great, new things that we got coming in with SQL Server 2022. Today’s post will be used to look at something called. SQL Assessment […]