Category: Databases
-
Breaking (storage) speed limits in Azure SQL MI.
In this post, I’ll share some results when combining Azure Managed Kubernetes Service (AKS) with Azure NetApp Files (ANF) to break built-in speed limits in Azure SQL Managed Instance (MI) storage. Storage performance in the cloud is often deeply coupled with compute, the bigger the VM or a higher the…
-
Automating the database maintenance with container app jobs
In this post, I’ll share with you how to automate the running of the previously created database maintenance container. Once you’ve created a container that has your database maintenance routines in it, you’ll need to figure out a way to automate executing it against the database(s). Luckily, Azure (and probably…
-
Database maintenance with containers
In this post, I’ll show you an example of how to build your own database maintenance container. I have been tinkering with database automation and containers lately, and it had me thinking about all the various ways we can make use of containerization with databases. Public cloud platforms do an…
-
Zero Trust Security from the Database Perspective
I bet that by now, pretty much everyone has heard about Zero Trust Security. And for a good reason too, as security is undoubtedly the one topic that should be everyone’s concern. While the topic is already quite thoroughly discussed in many sources, I wanted to take a look at…
-
Azure SQL Databases 101: Moving databases between servers
I wrote previously about moving databases in and out of Elastic Pools, one of the common DBA tasks, when working with Azure SQL Databases. To continue with a similar topic, I decided to write a short post about moving Azure SQL Databases between different logical servers. While this isn’t any…
-
Azure SQL Databases 101: Moving databases in and out of Elastic Pools
In one of my previous posts about Azure SQL Databases, I wrote about the differences between Single Database and Elastic Pool deployment options. In that post, I mentioned that it is possible to move databases between different Elastic Pools. The one thing I overlooked to say is, that you can…
-
Azure SQL Database: DTU Service Tiers
I’ll continue with the Azure SQL Database, and the topic of my previous post. This time we’ll look at the Service Tiers for Azure SQL Database when going with the DTU purchasing model. Compared to vCore model, the DTU pricing model provides much simpler configuration, both in good and bad.
-
Azure SQL Database: vCore Service Tiers
Continuing with the Azure SQL Database topic, this post focuses on different service tiers available for the Azure SQL Databases with vCore purchasing model. The vCore purchasing model is one of the two purchasing models available for the Azure SQL Database, the other one being DTU. There are three service…
-
Azure SQL Database: Single database and Elastic Pools
Azure SQL databases can be deployed either as a single database, sometimes called “singletons” or into an Elastic Pool. The question I sometimes get is, how do you pick which one you should use? In this post, which will be the first in a series to introduce you to the…
-
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…