Backup SQL database to blob container and restore it to another Server

This blog demonstrates the detailed steps needed to create an SQL Database backup in a blob container. To begin, with you need to list down the available backups, and restore them from a blob container to a Prem SQL Database.

Read More

Introduction to Change Data Capture (CDC)

What is Change Data Capture (CDC)?

Change data capture (CDC) uses SQL Server agent to capture DML activities like deleting, updating, and inserting on a table.

Read More

Shrinking of SQL Databases using Notruncate Command

This blog discusses the process of shrinking the data file of a SQL server database by using the option DBCC shrink file using the Notruncate option.

Read More

Backup Compression for TDE enabled DBs

The SQL Server 2008 and later versions provide many powerful features, and among those, Backup Compression and Transparent Data Encryption (TDE) are very useful to compress your backups and Enable the encryption at database level. However, if we use both these options on the same database then we have the limitation of leveraging both these features up to SQL 2016 version.

Read More

Procedure of taking backup of MS SQL Database

In this blog, I have discussed the process of taking backup of MS SQL Database, the types of backups, and steps to take up the backup.

Read More

Initializing replication for a large database

This blog demonstrates the detailed steps needed to set up transactional replication using a backup to initialize the subscriptions without taking the snapshot for all the articles, as we know the snapshot option is time-consuming for large databases.

Read More

MSSQL SERVER – MIGRATE DATABASE WITH CLE (Cell Level Encryption)

In this blog, I have discussed the necessary steps for restoring database and retrieving encrypted data when CLE (Cell Level Encryption) is implemented .

Read More

Configuring TDE with AlwaysOn Availability Group

“This blog demonstrates the detailed steps needed to set up Transparent Data Encryption with AlwaysOn Availability Group.”

Read More

Handle memory pressure alerts from memory-optimized tables in SQL Server

The Microsoft SQL Server is very smart in terms of memory management, but sometimes memory pressure alerts and database engines demand more memory, leading to errors.

Read More

SQL PolyBase setup issues

In my most recent blog post, Unified data platform and data virtualization through PolyBase: Part Two, I provided a demo of data virtualization through PolyBase.

Read More