Just some notes for my Atlanta SQL Server 2005 Class. We just finished covering Snapshot Isolation, and here are some “known good” resources on that:
- SQL Server 2005 Beta 2 Snapshot Isolation by Kimberly Tripp on TechNet.
- Fellow MVP Vinod Kumar has an article up on SSWUG that shows a good example of what happens when you use this isolation mode.
- Dan Sullivan and I chatted during a break about Snapshot Isolation on the Model DB. Turns out that if you enable Snapshot isolation on that, any databases created ex post facto will also have it enabled (at least on the same machine...)
We also talked about DDL triggers, reminding me of Greg Low's Blog post on the topic.