Getting Your Feet Wet in SQL Server 2008

In June 2007, Microsoft released the first public Community Technology Preview (CTP) of SQL Server 2008—code-named Katmai. This version is called June CTP, or CTP 3. In late July, Microsoft released a second public CTP called July CTP, or CTP 4. Until SQL Server 2008 is shipped (probably around mid to late 2008), you should expect to see a new CTP released every few months. Probably later this year, Microsoft will release a feature-complete CTP version, and most of 2008 will be dedicated to polishing work. In my T-SQL Black Belt columns, I’ll naturally focus on T-SQL–related enhancements.

For information about future versions of SQL Server, downloads of CTP versions, and links to forums where you can ask questions and report bugs, begin navigating at the Microsoft SQL Server home page ( You can download the latest CTP version of SQL Server 2008 at, and you can participate in the MSDN SQL Server forums at ( I encourage you to install the latest CTP version on a virtual machine (e.g., Microsoft Virtual PC) and not directly on your machine. That’s what I do with prerelease versions: I create a base virtual machine (VM) with everything I need (e.g., OS, latest updates) but the CTP version of SQL Server, and back it up. Whenever a new CTP version of SQL Server is released, I simply copy the base VM's files to create a new VM, and install the new CTP version on it.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.