September 2004 Blog Posts
WOW....what an interesting last couple days. I was priviliged to attend a couple incredible meetings. I was unfortunate enough to attend a session that was not so great (cough, cough)!!!!! Such is life in the world of conferences. :)
SQL Server Locking Internals and Troubleshooting - **Good**
This session covered a lot of the tools and techniques used by PSS in troubleshooting issues. He went really into depth on how scheduling, threading, fibers, crabbing work. SQL Server 2005 is changing the way threads are allocated. By allocating them to tasks, we will be able to get better management of available threads. It also...
High Availability with SQL Server 2005
This was a great session. It was cut a little short by an EMERGENCY EVACUATION!!! Go figure. :) It focused on the new enhancements that SQL Server 2005 has added to provide for greater flexibility and implementation of high-availability networks. For those who are members of PASS, the slides can be downloaded from www.sqlpass.org when the conference is over. Here are my takeaways from the session:
Covered Database Mirroring.
Can be a long ways away.
i. Have to keep transactions in sync though, which can cost performance.
ii. Don’t need to be on compatability list like...
Just thought I'd give a brief rundown of what's going on at PASS. I just attended the keynote address and my first session. The session was Developer Productivity and Server Extensibility with SQL Server 2005. The session covered many of the concepts in 2005 that involve CLR integration and benefits to development from this the extensions to the XML datatype and associated tools.
Each session I attend or book I read just enforces the fact that 2005 is by far the biggest “learning curve” upgrade since the advent of SQL Server and it's migration off the Sybase framework. It will...