Migrate data from mdf file to ndf file in same file group

Problem: Database integrity job was failing due to IOPS issue for TestDB database which is more than 2 TB in size. Due to large file size, it is becoming difficult to manage the database.

Read More

ORDS Relation with SQL Developer

DEFINITION

Oracle REST Data Services are based on Java Enterprise Edition and provide security, RESTful Web Services, and flexibility through support for deployment in different type of configurations like standalone mode, Apache Tomcat and Oracle WebLogic Server.

Read More

Adding new articles and reinitializing the subscriber for already initialized SQL transactional replication with backup

In my earlier blog, I had discussed how to Initialize replication for a large database using the database backup. I will now be discussing how to add new articles and reinitialize the existing SQL Server transactional replication configured through backup.

Read More