Conferences

SQL MCM Training – Day 5

Today I’ve not taken too much notes, because the whole afternoon was about the Management Data Warehouse and Multi-Instance Management. But before that Paul and Jonathan have spoken a lot about troubleshooting with DMVs. Module 12: DMVs – Part 2 sys.dm_io_virtual_file_stats Spikes can’t be seen from this DMV, only through perfmon.exe I/O Backup activity is …

SQL MCM Training – Day 5 + read more

SQL MCM Training – Day 4

Today Jonathan has presented on analyzing trace data, and Kimberly has spoken on troubleshooting Plan Cache Issues and Index Consolidation. It’s really awesome when you listen to Kimberly, because she is speaking so fast, and delivers such a great quality of content – really awesome!!! Module 10: Analyzing Trace Data Default Trace Logs everytime when …

SQL MCM Training – Day 4 + read more

SQL MCM Training – Day 2

Today’s day was Jonathan Kehayias days, and it was pretty impressive. Jonathan covered the following 3 modules, and he can speak really continuously and forever J IO – Storage Area Networks IO – Installation and Testing SQLOS I’ve already read few whitepapers in the past about SANs and also watched the MCM Readiness videos about …

SQL MCM Training – Day 2 + read more