Category: SQL Server Administration
-
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 how Zero Trust Security implementation…
-
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 more difficult than moving databases…
-
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 also move Azure SQL Databases…
-
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. The DTU pricing model includes…
-
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 tiers available for vCore purchasing…
-
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 various deployment options of Azure…
-
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…