Point-in-time restoring a database
By default an Azure SQL Database has a PITR of 7 days, in this blog we’ll see how to actually restore the database to some specific point in time.
Tag: StwayAzSQLDBA
Bringing back the dead, restoring the deleted database in Azure SQL Server
In this blog we’ll see how to restore back an accidentally deleted database.
Automatic Tuning your Azure SQL Database
In this blog we’ll see what is Automatic Tuning and how to enable it for your Azure SQL Database.
Backup your Azure SQL Database
Taking backup of your Azure SQL database is not possible but there is an alternative to extract data.
Backup Storage for PaaS databases
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 configured your backups as per your company standards, you should also know about the storage consumption and it’s charges. PITR Backups As you […]
Automatic Backups in 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 databases and have been able to access and create logins/users for your applications or for anyone using it, the next thing […]
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 […]
Server and Database Roles in Azure SQL Databse
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. In the previous blogs we learned about Server Admin and AD Admin and how to connect using SQL Authentication and AD authentication. In this blog we’ll […]
SQL Authentication and AAD authentication
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. In the previous blog we saw the difference between Server Admin and AD admin and also how to create them. This blog is going to be a smaller but important […]
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 […]
being a dba 