SQL

Looks like the one of the new features mentioned in the SP1 release notes is located here:

"A registry switch has been added that you can use to control encryption between a master server and a target server (MSX-TSX)."

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0\GeneralFlags\Flag1

It looks like it is a DWORD toggle of 0 or 1 with the setting of 'Value' determining whether or not to use encryption between the SQL server agent and SQL server.

It looks like not a lot has changed since the March CTP of SP1. A big noteworthy detail is that Vista and Longhorn are officially supported now.

New additions:
http://support.microsoft.com/kb/916940

Fixes:
http://support.microsoft.com/?kbid=913090

Download link:
http://www.microsoft.com/downloads/details.aspx?familyid=cb6c71ea-d649-47ff-9176-e7cac58fd4bc&displaylang=en

Tiny URL version of the download link:
http://tinyurl.com/efgun

I'm sure there are a lot more out there but these seem to be the most common you might see in the wild, and this is what I've gathered from various sources around the Internet.

All start with 9.00.xxx and the number we care about is at the xxx. Typically SQL will spam the event log with the build number on startup but I don't think that is always the best way to determine the build number. When all else fails, you can always execute SELECT @@version from the Query editor.

Beta 1: 608
Beta 2: 852
12/04 CTP: 981
04/05 CTP: 1116
06/05 CTP: 1187
09/05 CTP: 1314
RTM: 1399.06
SP1 03/06 CTP: 2040

Any production server should most likely be running 1399.06 and any test box might be running one of the CTPs or Betas, but those should be retired ASAP.

I have been running the SP1 CTP without any issues so far, but my laptop isn't exactly a SQL transaction powerhouse.