Category: Databases
-
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…
-
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…
-
Well-Architected Framework (for Databases)
If you work mainly with on-premises and focus on databases, there’s a good chance that you are not familiar with the concept of a Well-Architected Framework (WAF). However, while you might not be familiar with the term, you probably are already doing things related to it. How do I know that, you ask? Because, ultimately,…