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

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

How To Restore Corrupted System Databases

How To Restore Corrupted System Databases

Today Dec 31, Sunday. Everybody waiting for the New Year. I’m also waiting for that and enjoying the last holiday of this year. But my SQL server doesn’t like the 2018 I guess 🙁 We have migrated our SQL Datawarehouse from Datacenter to AWS. We followed block level copying method which means sent entire Disks data to AWS then create volumes from that data. We kept data and logs on different disks.

Read More

SQL Server Availability Group without Cluster And AD In Windows

SQL Server Availability Group without Cluster And AD In Windows
SQL Server Availability Group without Cluster – Dear DBAs, Do you think is this possible? Luckily yes, its possible to create an availability group without a Windows Failover Cluster on Windows. But unfortunately, there are few restrictions. Also, we don’t need to restore the Database on secondary. The availability group has a feature called Automatic Seeding to restore the database automatically from the Primary server.

Read More

How To Handling DBA Tasks In SQL Server On Linux

Handling DBA Tasks In SQL Server On Linux

Handling DBA Tasks In SQL Server On Linux

Hello SQL DBAs, the time has been already arrived to move to the Open Source Community. After a very long time, Microsoft Released the stable version of SQL Server for Linux. Also, Microsoft provides perfect documentation to configure everything.  So we(DBAs) needs to work on SQL server in Linux. So this blog post is nothing but will provide some useful information to handling DBA tasks in SQL Server on Linux.

Read More