12 June 2006 08:51
simonsabin
SQL News 12 June 2006 - UnDocumented DBCC Commands- Data Dude CTP and more
TechEd is bringing some great things out of the Microsoft closet, Data Dude and Sql Everywhere being 2 see below for downloads.
Thanks to Itzik for pointing out the undocumented DBCC command FLUSHPROCINDB, which frees compiled plans for a specific database
Bugs and Suggestions
The Product Feedback Centre is no more. If you wish to post bugs/suggestions against a Microsoft product then you need to go to http://Connect.microsoft.com
Blogs
The Storage Engine Team (aka Paul Randal) has started the series on DBCC. First up is CHECKDB and consistency. Fantastic post interesting to see that something new in 2000 was re-written for 2005. Second is PAGE, yep this is a Microsoft person blogging about an undocumented (but heavily used as Paul explains) command. This blog is essential reading for anyone wanting to now the ins and outs of SQL Server.
CTP feast.
Data Dude CTP is supposed to be available today, I was hoping to provide a public link but unfortunately it isn't available and only available to MSDN scubscribers (according to ScottGu)
SQL Everywhere is also available as a CTP. It is the new mobile edition of SQL Server that is loaded in memory, so think of it like dbf files or other non-service based databases. (Thanks to Dan for pointing this out) Also check out Steve Lasker's post on SQL Everywhere
Filed under: SQL Server 2005