SQLpassion BLOG

Today Jonathan presented on Replication and Paul about Database Snapshots, and his baby called “CHECKDB” – he has been married with CHECKDB for almost 5 years at Microsoft. Module 8: Replication Distributes data to different locations Offloading reporting to another database Transactional Replication Used in server-to-server scenarios that require high throughput Different Agents Snapshot Agent …

SQLMCM Training – Day 11 + read more

Today Paul was speaking about Database Mirroring and Jonathan was talking about Failover Clustering – all in all a very intensive day J Module 6: Database Mirroring Split Brain is possible When you loose the witness, Database Mirroring goes into the asynchronous mode No automatic failover possible Witness should be also put in the same …

SQLMCM Training – Day 10 + read more

Today Jonathan was talking the whole day about Consolidation and Virtualization. There were again a lot of new concepts, and new things to learn. Module 4: Consolidation Event Notifications for Monitoring Deadlocks, Locking/Blocking Scenarios Multiple Instances for TempDb bottleneck Soft-NUMA should be used to bound multiple instances to dedicated CPUs CPU Affinity Maks should not …

SQL MCM Training – Day 9 + read more

Today Paul talked the whole day about HA DR Strategies and Backup/Restore operations. I’ve already known a lot about Backup/Restores, but Paul showed some cool things that were even new to me J. Here are my study notes for the 3 modules of today: Module 1: HA DR Strategies Zero downtime is not possible Even …

SQL MCM Training – Day 8 + read more