Script to add the AG logic in SQL Server Jobs
To provide business continuity Azure has the option to replicate your database to multiple regions by using Geo-Replication.
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.
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.
In this blog we’ll see how to restore back an accidentally deleted database.
In this blog we’ll see what is Automatic Tuning and how to enable it for your Azure SQL Database.
Taking backup of your Azure SQL database is not possible but there is an alternative to extract data.
To find the jobs by a specific owner and changing it’s ownership to sa
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 […]
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 […]