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 […]
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 […]
As we all know XEvents is a very strong tool or utility from SQL Server, it provides way more information than the tried and tested Traces. Extended Events was introduced way back in SQL Server 2008, but I was never able to use it just because of all the XML involved. No matter how much […]
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 […]
This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. Once you know what it is an Elastic Pool and have decided to implement it, the first thing to create is a SQL Server resource, […]
This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. When creating an Azure SQL Database, which as you might already know is a PaaS service, (if you don’t know what it is I’ll suggest […]
Below Script will read through the logs and as an output gives the logins which are failing repeatedly since last 5 days, you change it to as many days maximum being the number of days for which you are maintaining your logs. GitHub Link.
This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. We saw in the previous blog there are multiple options of having a SQL Server in cloud. And also touched if any of the Azure […]
This is a part of a Series “Stairway to being an Azure SQL DBA“, in which I am planning to cover everything related to working as an Azure SQL DBA. Starting with a diagram that you must have seen multiple times before. When talking about above picture and considering we are specifically concentrating on SQL […]
being a dba 