SQLStarters

Recipes for Cloud Database Experts

Categories

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

  • 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…

    Read the full post…

    Posted by

    Mika Sutinen

Find me in social media

Search by tag

#automation #azure #azurevm #db2 #opensourcedb #oracle #sqlserver AWS Azure Azure Cloud VM Backups Cluster Validation Database Design Dynamic Management Views IaaS IPSEC Managed Instances Monitoring NETSH PerfMon Powershell Query Tuning SQL Database SQL Database SQL PASS sqlserver SQL Server SSL T-SQL Testing