Lots of useful info appearing here http://sqlcat.com/Default.aspx. This is a great article on database mirroring log compression in Katmai http://sqlcat.com/technicalnotes/archive/2007/09/17/database-mirroring-log-compression-in-sql-server-2008-improves-throughput.aspx
This is a nice touch, the pre-canned VHD’s are now available for pre-release versions of SQL Server 2008 CTP4 http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-82e4-4efd6705f4a6&DisplayLang=en and Windows Server 2008 Beta 3 http://www.microsoft.com/downloads/details.aspx?familyid=9AA65956-4A13-46A3-9711-82939A041792&displaylang=en. Note: the VHD download is split into approximately four compressed .rar files.
I thought the SQL Server 2005 Large Values out of Row would be a sp_tableoption config value similar to text in row – apparently not! It took a while to find out that this is hidden in sys.tables. The following query returns the value I was looking for: SELECT [name] AS tablename, large_value_types_out_of_row FROM sys.tables
The PPS UK launch is happening on 16th October in London. Sign up here: http://www.microsoft.com/uk/office/ppslaunch/default.mspx
It’s nice to see a new CTP of Katmai on the Microsoft Connect site – I’ve been waiting to look at the new database mirroring enhancement which performs automatic page repair. There are many other features in this CTP which are listed here https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5470 which will be covered in the webcasts over August https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=6082.
I like this whitepaper particularly because it talks about tuning, validating and benchmarking the storage system before laying down SQL Server on the disk. It is nice to see a mention of the disk sector alignment benefits in a SQL document as this has been mentioned before but primarily for Exchange, of course these problems go…
I almost missed this one.. SQL Server 2005 has received another update (May 2007) which can be downloaded here: http://www.microsoft.com/downloads/details.aspx?familyid=be6a2c5d-00df-4220-b133-29c1e0b6585f&displaylang=en – watch out, its 135mb! The updated BOL is also on MSDN 🙂
Katmai information is slowly making its way into the public domain. There is a good webcast scheduled today. Further info here: http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032341071&EventCategory=2&culture=en-US&CountryCode=US
A new cumulative hotfix has been released and contains quite a few important fixes. Read more about this build here http://support.microsoft.com/kb/935356.
Read more about the new certification here http://www.microsoft.com/learning/mcp/architect/database/default.mspx