SQLServerPedia

Initialize a Transactional Replication from a Database Backup

During the last days I’m working on Replication – especially with Transactional Replication. The main idea of Transactional Replication is that you have a so-called Log Reader Agent on your Publisher SQL Server database running, that is analyzing the Transaction Log File and synchronize changes on so-called Articles through a Distribution database down to your …

Initialize a Transactional Replication from a Database Backup + read more

SQL Server Quickies – a new way to learn about SQL Server

We are all living in a fast moving world, especially in the IT industry. We have to learn new technologies every few months and must keep our knowledge up-2-date to be competitive. A lot of us are learning through reading, and a lot of us are also learning through watching web casts and training videos. …

SQL Server Quickies – a new way to learn about SQL Server + read more