SQL Server 2008: 2009

Sunday, November 15, 2009

Community Technology Preview of Microsoft SQL 2008 R2 is available for download

The latest Community Technology Preview (CTP) for SQL Server 2008 R2 available to the general public today. The new capabilities in the latest CTP include support for Windows Server 2008 R2 – including Hyper-V with Live Migration – as well as enhanced data compression with support for Unicode UCS-2. Also included are new visualization features and a Report Part Gallery to Report Builder 3.0.

SQL Server 2008 R2 includes enhancements designed to help administrators centrally monitor and manage multiple database applications, instances or servers. In addition, it has enabled high-scale complex event-stream processing through SQL Server StreamInsight, and expanded business intelligence capabilities with SQL Server PowerPivot for Excel.

At the PASS Summit last week in Seattle, Microsoft announced two new premium editions – SQL Server 2008 R2 Datacenter and SQL Server 2008 R2 Parallel Data Warehouse – these will be available once SQL Server 2008 R2 is released. SQL Server 2008 R2 is on track for general availability in the first half of 2010.

The Community Technology Preview of Microsoft SQL 2008 R2 is available for download here:

Saturday, May 23, 2009

SQL Server 2008 SP1 Step by Step installation process

SQL Server 2008 SP1 was released on 4 Apr 09 and it is available for download here . I have downloaded SQLServer2008SP1-KB968369-x86-ENU.exe
since I have 32 bit version of SQL Server Evaluation Edition. Download the required edition as per the SQL Server 64/32 bit or OS what you have.

If you have SQL Server RTM Edition 32 bit you will have built Number as Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86).

After installation of SP1 the build number (as on 22 May 2009) will be
Server 2008 (RTM) - 10.00.2531.00 (Intel X86).

Installation process are as follows

Step 1 : Download SP1

Step 2 : Install the SP1. Double click on the downloaded file

Screen 1