Providing Access to Azure SQL Database

This is a part of series “Stairway to being an Azure SQL DBA“, where I will be covering all the topics that an Azure SQL DBA should know about. Once you have deployed your database and know what different roles exist, the next thing you are going to do is provide access to users and […]

Reading data from Extended Event

As we all know XEvents is a very strong tool or utility from SQL Server, it provides way more information than the tried and tested Traces. Extended Events was introduced way back in SQL Server 2008, but I was never able to use it just because of all the XML involved. No matter how much […]

Azure SQL Server Admin

This is a part of a series “Stairway to being an Azure SQL DBA“, which is one stop learning for becoming an Azure SQL DBA. If you have been following along and have created your Azure SQL Server and Azure SQL Database, you might remember that when creating the SQL Server you had provided the […]

Provisioning Azure SQL Database

This is a part of a series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. Till now we have seen the differences between different SQL Server offerings in Azure and now we know that Azure SQL Database is the lightest […]

Elastic Pool: When to use it

This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. In the previous two blogs about Elastic Pool we discussed about the concept of Elastic Pool, and also the implementation. In this blog we’ll see […]

Elastic Pools: How to implement it?

This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. Once you know what it is an Elastic Pool and have decided to implement it, the first thing to create is a SQL Server resource, […]

Single Database vs Elastic Pool

This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. As we saw in the last blog DTU vs vCore there are different costing options available for PaaS SQL Servers, and the number of resources […]