Initiliazing 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

Unified data platform and data virtualization through PolyBase: Part Two

In Part One of this UDP data virtualization through PolyBase series, I introduced PolyBase and provided the prerequisites for this demo. In this final installment, you can dive into the demo.

Read More

Unified data platform and data virtualization through PolyBase: Part One

I am excited to finally build on my earlier blog post Unified Data Platform - SQL 2019.

In this series, I dig deep into how to achieve data virtualization through PolyBase®. This post covers the introduction and demo prerequisites, and Part Two gets to the demo itself.

Read More

Unified data platform: SQL Server 2019

In 2006, British mathematician Clive Robert Humby marked the words: “Data is the new Oil.” Since then, IT leaders have repeatedly heard this, resonated with the idea, and augmented it at every step.

Read More

Azure SQL virtual machine resource provider

Most release pipelines have some automation to do after configuration to a virtual machine (VM) to prepare it for use. Looking at SQL Server®, you can configure a lot of options to make it production-ready. What most people do not know is that a resource provider within Microsoft® Azure® configures basic SQL Server settings without the need for any post-configuration scripts.

Read More

Migrate a SQL Server database to an AWS RDS instance

This blog explains how to move a Microsoft® SQL Server® database hosted on-premises (or on Amazon® EC2 or Azure®) to Amazon Relational Database Service (RDS). This move requires backing up your SQL database to an AWS S3 bucket and restoring the database on your AWS RDS instance from that S3 bucket.

Read More