Running the SQL Server Job on the desired node of Availability Group
Script to add the AG logic in SQL Server Jobs
Author: Shwetank Singh
Geo-Replication for Azure SQL Database
To provide business continuity Azure has the option to replicate your database to multiple regions by using Geo-Replication.
Disks configuration for Azure SQL VM
When using SQL VM it is important to consider and know what are the best practices for choosing the disk and caching for the SQL Server data, log and tempdb files.
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.
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.
Script to change SQL Agent job owners
To find the jobs by a specific owner and changing it’s ownership to sa
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 […]
being a dba 