Category: SQL Server
-
Azure SQL Database and Logical Server
Microsoft calls the Azure SQL Database a managed cloud database; however, it does come attached to a server. In this case, one that’s called a “logical server”. Many of us database experts have worked extensively with servers, as that’s where our databases usually exist. But if we’re promised only a database, why does it come…
-
Improving reliability and resiliency of SQL Server estates with Azure Chaos Studio
Azure Chaos Studio is a fully managed, chaos testing service from Microsoft. And one of those services, I’ve been planning to test drive for a while now. It’s currently in preview, and as such, can be used for free. It has been around since November 2021, and to my understanding, is planned for GA early…
-
Babelfish for PostgreSQL, what the heck is that?
A short answer is: Babelfish is an extension for PostgreSQL, that allows your SQL Server applications to speak to PostgreSQL in their native language. The next question you probably have is: “Why would I ever want my applications to do that?” And it’s a valid question, to which the answer would be, to modernize your…
-
Open-source vs. commercial database systems
While SQL Server has been one of the cornerstones of my 25+ years career in IT, I’ve occasionally wandered out of my commercial databases comfort zone to the open-source database space (PostgreSQL and less frequently MySQL). These forays to the open-source database systems have definitely become more common as I started working with the public…
-
Are we ready for database containers yet?
Containers are a popular way to virtualize and package applications, but when it comes to database workloads, the adoption has definitely been much slower. The technology has been around for a long while (at least in the IT-industry or dog years), and I wondered if we’re ready to use it widespread for databases. And if…
-
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…