Script: Logins with Server Roles
Script to find out logins and the assigned Server Role
Category: SQL Server
Running the SQL Server Job on the desired node of Availability Group
Script to add the AG logic in SQL Server Jobs
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.
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.
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 […]
Script for SQL Server Agent jobs
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 […]
SQL Agent Job for databases in availability group
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 […]
being a dba 