Automatically Enable CDC In RDS SQL Server

Automatically Enable CDC In RDS SQL Server

AWS recently announced a new feature which will help to enable CDC in RDS SQL server on user databases. Here this the detailed blog post that explains how to enable this CDC for DMS service. CDC is an enterprise edition feature. But RDS SQL Server Standard editions are supporting CDC. The most important thing is we can use this feature to achieve the below things.

Read More

Don’t Use AWS AMI To Backup Your EC2 Database Server

Don't Use AWS AMI To Backup Your EC2 Database Server

I have started my career to handle the databases which all are in the Cloud. Most of the database servers are in AWS EC2. AMI is one the simplest and great feature to take a VM level backup and restore it when a disaster happens. But DBAs never depend on the VM or SAN backups, so I have configured native backups for all of my database servers. But I used to choose to restore the AMI whenever we need a Dev/Test server. Because restoring a huge database will take more time and its pretty expensive operation. So I just drop the existing Dev DB server and launch it from the AMI.

Read More

SSMS Hidden Feature: SHOWPLANTEXT_ALL with Results

SHOWPLANTEXT_ALL with Results

First of all, I’m seeing this feature on SSMS 17, but later I found this feature came with SSMS 2016. So if you found this already then just ignore this.
In earlier versions of SSMS, If we want to get the SHOWPLAN in TEXT or Table format then we can use the SHOWPLAN_ALL query. But it would return only the plan of the query not for the result. But in SSMS 2016 or later we can see this show plan without add any additional query and also it’ll return the result of that query.

Read More