Esoteric

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...

Troubleshooting performance issues in SQL Server involves studying the wait types and wait times associated with the queries executing. However, the relevance of each of the various wait types in the output can be a mystery. For SQL Server 2000, the cumulative Read More...

A new feature of SQL Server 2005 Transactional Replication is the ability to use "Tracer Tokens" to measure true latency between publisher-distributor and also distributor-subscriber. More details at Measuring Latency and Validating Connections for Transactional Read More...

One of the most exciting new features in SQL Server 2005 is DB Mirroring. Now that Service Pack 1 is released, we officially support this feature. A really useful resource to understand the options available in using this feature and their pros / cons 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...