Blog: DB Management tips & Insights

ENHANCEMENTS OF ALWAYSON AVAILABILITY GROUP IN SQL SERVER (2012–2017)

The evolution of Always On availability feature starting from SQL Server 2012 to SQL Server 2017 along with the minute details are outlined in this article.

April

2021

What is ADS ( Azure Data Studio)?

Azure Data Studio is a free Microsoft tool, initially called as SQL Operations Studio

April

2021

How to connect to the contained database without creating the login and user on secondary instance

The contained database are different from regular uncontained databases. Contained database don’t depend on SQL server instance. it’s configuration, database setting, meta data all contained within the database which includes user information.

April

2021

How to enable Dedicated Admin Connection (DAC) in SQL server

Dedicated Admin Connection (DAC) feature tells SQL Server to reserve a thread specifically for processing your queries in an emergency. Here's a complete step by step guide to enable, connect and use SQL Server Dedicated Admin Connection (DAC) during performance issues.

April

2021

QUERY STORE

Query store is a new feature introduced in SQL Server 2016. This article explains how query store can simplify troubleshooting.

April

2021

How to enable SQL encryption in MS SQL server

In order to secure our data from these threats, we have lots of methods and important among them is encryption. Encryption will make our data or information to unreadable format until, we have right key to decrypt or read the data. In this blog, you will learn SQL encryption process

April

2021

Ways of Dynamic Data Masking SQL Server Fields

Dynamic data masking feature in SQL Server provides the possibilities of hiding sensitive information in the database.

April

2021

Configure Domain Independent Availability Group

How to configure Domain Independent Availability Group

April

2021

SQL Server instance(s) migrating to Azure SQL database(s) using Data Migration Assistant

Data Migration Assistant (DMA) helps you upgrade to a modern data platform by detecting compatibility issues that can impact database functionality in your new version of SQL Server or Azure SQL Database. Follow the steps for migrating SQL Server instance to Azure SQL database using Data Migration Assistant DMA.

April

2021