While I was at the Denver SQL Server Users Group meeting last Thursday, I asked for a show of hands from the approximately 35 attendees, of people who were using SQL Server 2008 in a Production environment. I was a little surprised to only see two people who were using SQL Server 2008 in Production among a group of SQL Server DBAs who were active enough in the community to attend a users group meeting.
SQL Server 2008 has been commercially available since August 2008. There have been four Cumulative Updates for SQL Server 2008 released, and Service Pack 1 (which only includes the fixes up through CU3) is pretty likely to be released in April. The latest Cumulative Update is available here. Kevin Cox wrote a nice post today with lots of useful resources for upgrading to SQL Server 2008.
If you are running on SQL Server 2000 or 2005, you should seriously take a look at SQL Server 2008. There are so many useful new features in SQL Server 2008 that really make your life easier as DBA. NewsGator Online is running completely on SQL Server 2008 on Windows Server 2008, with very good results. We are using database mirroring, backup compression, data compression, table-valued parameters, and MERGE. Our upgrade experience (from SQL Server 2005) was very smooth.