Script to find out logins and the assigned Server Role
Script to add the AG logic in SQL Server Jobs
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 what is Automatic Tuning and how to enable it for your Azure SQL Database.
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 […]
The below script is useful in finding the important information about the jobs in your SQL Server like who is the owner of your job, if you have set any notification email or not if it set then to which Emailid the mail will be sent to, when it was created and when was the […]
When we have SQL Server job running for databases in Always-On there could be need of running a specific job on Primary database only. In such cases we are required to create the job on every server and add the logic that it runs only on the Primary server. The below template can be used […]