.NET German

SQLMCM Training – Day 15

The whole last 3 days I’ve spent almost every minute with reviewing the material from the last 2 weeks (around 38 hours in total…). Today Bob Beauchemin joined us, and talks the whole week about SQL Server Development, Security, PowerShell, and some esoteric technologies like SQLCLR, Service Broker, and CDC/Change Tracking. Don’t expect too much …

SQLMCM Training – Day 15 + read more

Chance to win a free seat in my Performance Troubleshooting Workshop in London!

As you might know, I’m running my “Advanced SQL Server Performance Troubleshooting Workshop” from September 12 – 14 in Central London. You can find out further information about the detailed agenda here: http://csharp.at/Registration_UK.aspx Next week you have the amazing possibility to win a free seat in that workshop! It’s very easy: Just register as the …

Chance to win a free seat in my Performance Troubleshooting Workshop in London! + read more

SQLMCM Training – Day 11

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

SQLMCM Training – Day 10

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

SQL MCM Training – Day 9

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