Microsoft SQL Server - Add Articles to Existing Replication Without Reinitializing Snapshot

Replication can be defined as the process via which Data and database objects are copied and distributed between databases, and then synchronized to ensure consistency. Transactional replication is typically used in scenarios requiring high server throughput, Reporting and data warehouses; improving scalability and availability; integrating data from disparate sources. Batch processing can be offloaded, heterogeneous data can be integrated, and multiple sites can be integrated.

Read More

Azure 3 Layer Network Security Design for Banking & Finance Vertical

Any Company/Organization planning to move to cloud or looking to deploy a greenfield workload, will require a well architected landing zone with the right security posture.

Read More

Configure Oracle E-Business Suite Integrated SOA Gateway for REST Services

If we are planning to use Rest Services provided by Integrated SOA Gateway (ISG), the first step is to ensure that our EBS instance is configured to use it. The prerequisite is that we should know the E-Business Suite concepts, patching and backend components.

Read More

Intro to AWS Database Migration Service (DMS)

This blog introduces the AWS database migration service, a cloud-based tool, used extensively for migrating databases to the cloud.

Read More

RDS Instance and Read replica

The blog discusses how to configure Relational Database Service (RDS) instances and their read replica. It also explains how to promote read replicas to a new standalone instance.

Read More

How to setup a heterogeneous database link using dg4odbc

Nowadays companies use different database technologies for keeping their data and often they need to access data from one data source to another data source. However, as the data is on different database products, it does not work, and this takes up lots of effort on part of the developer to intermix data between different databases.

Read More

Intro to MSSQL Server Audit Feature

It is always a challenge to configure audits and capture schema changes for a longer duration in the SQL Server. These details are captured by default traces; however, their retention is limited. Also, it is quite a task to set up SQL audits in every user database.

Read More

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