Esoteric

Overview I recently conducted some tests to double check the exact behavior of database snapshots when: Snapshots are created on volumes which are much smaller than the actual database size Metadata-only operations such as DROP TABLE are executed DDL Read More...

Several attendees have asked for the resources section from our presentations at TechEd India. Enjoy! Blogs SQLCAT: http://blogs.msdn.com/sqlcat WINCAT: http://blogs.msdn.com/wincat Slava Oks’ blog: http://blogs.msdn.com/slavao Product Feedback http://lab.msdn.microsoft.com/productfeedback/ Read More...

DB Snapshots are a very useful new feature in SQL Server 2005 Enterprise Edition. They provide us the ability to preserve a consistent picture of the database as it was at a point in time. Both metadata and data are captured in the snapshot. The main Read More...