SQL Server Transparent Data Encryption

SQL Server 2008 Transparent Data Encryption (TDE) A secure Environment can be built by designing a secure system, encrypting confidential assets, and building a firewall around the database servers. However, in a scenario where the physical media (such as drives or backup tapes) are stolen, a malicious party can just restore or attach the database…

Administration of Transactional Replication

Administration of Transactional Replication There are 3 types of Replication Types in SQL Server: 1. Snapshot Replication 2. Transactional Replication 3. Merge Replication Replication of data can be configured between same server or can be different servers connected by Network. SQL Server replication uses a publisher, distributor and subscriber for replication to work . Publisher…

SQL Server Architecture