Microsoft has released documentation on protocols used in SQL 2008. This will be really helpful for those enterprises that have strict network security. http://www.microsoft.com/downloads/details.aspx?FamilyID=91ef5106-944a-41e1-b3a0-5bd3f2356f32&DisplayLang=en
I want to create a compendium of cheat sheet sites that I think are good for SQL Server. And if I can't find anything good, I was going to create my own.
SQL Server DBA focused
A simplified BOL site includes more than DBA info - http://www.ss64.com/sql
Pinal Dave has attempted to create a one page version for SQL 2008.
Grant has done a great job on the basics that you can use to understand even complicated query plans: http://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/
Microsoft and Solid Quality Mentors have produced a free Technical Reference Guide on SQL 2008 upgrade best practices.
The PSS Team blog (Bob Dorr wrote article) has a great discussion on a couple of common myths for SQL Server performance:
- SQL Server Uses One Thread Per Data File
- A Disk Queue Length greater than 2 indicates an I/O bottleneck
Summary notes from article:
Grant wrote an excellent introductory article on execution plan basics and has a more detailed ebook for sale on lulu.com. http://www.simple-talk.com/sql/performance/execution-plan-basics. Code listing link.
Trying to install any post SP2 hotfix, I kept getting this error message in the Summary.log file (C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix)
MSP Error: 29537 Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction
Microsoft has provided 2 links for SQL Express Edition -:
Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2
Microsoft SQL Server 2005 Express Edition with Advanced Services