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 […]

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 […]

Providing Access to 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 database and know what different roles exist, the next thing you are going to do is provide access to users and […]

User Flows in Azure AD B2C

In the previous blogs we saw how to provision Azure AD B2C and then how to register a new application in it. A User flow is the most important part of B2C, it enables you to modify and control what happens in the authentication, starting from what sign page your customer will be using, it’s […]

Configuring Azure Active Directory B2C

Azure Active Directory is an Active Directory and much much more, one thing that I came to know and loved is B2C (Business to Consumer) identity as a service. What it provides is authentication to your application by using either Azure Active Directory or any social provider like Facebook, Google. Twitter and more. To help […]

Reading data from Extended Event

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 […]