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

SQL Server PowerShell module installation failed with “Unable to download..” error

Today when installing SQLServer module on one system I got the below error. This happens because the TLS setting for PowerShell is not compatible with PSGallery. Use the below script to set the session TLS version to 1.2 for the session Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 Once doing this you will be able to install any module […]