Last night I delivered the presentation Engineering 101 for the SQL DBA (the one with the ‘legendary’ USB key RAID demo) at the Perth SQL Server User Group. This presentation focuses on how the I/O subsystem can affect the performance of SQL Server. This presentation is also the same presentation that I will be delivering in Denmark next month at SQL Server Open World.
The PowerPoint deck and demo code from this presentation can be downloaded from https://www.wardyit.com/presentations/PSSUGEngineering101fortheSQLDBA.zip.
The presentation was also recorded using Camtasia and I have made a screencast and mp3 available for download.
The screencast can be downloaded from https://www.wardyit.com/presentations/PSSUGEngineering101fortheSQLDBA.wmv (~62MB).
The mp3 can be downloaded from https://www.wardyit.com/presentations/PSSUGEngineering101fortheSQLDBA.mp3 (~35MB).