Tom's blog

Thoughts about SQL and related stuff…

Entries for November, 2010

Detailed Step-by-Step guide to create an HA/DR configuration in Denali CTP1

In this guide, I will instruct step-by-step on how to create an HADR configuration between Denali SQL servers. For more information about this new high availability type see my post: CTP1 for SQL ‘Denali’ available for download First a little overview of my test environment, I’m running Windows 2008 R2 Hyper-V on a laptop. The [...]

New cumulative Update Packs for SQL 2008 SP1: CU11 and SQL 2008 SP2: CU1

Microsoft has recently released CU11 for SQL 2008 SP1 and CU1 for SQL 2008 SP2 The cumulative update table for R2 doesn’t change Version Service Pack (SP) / Cumulative Update (CU) 10.50.1734.0 R2 CU3 10.50.1720.0 R2 CU2 10.50.1702.0 R2 CU1 10.50.1600.1 SQL 2008 R2 RTM For SQL 2008 the cumulative update table becomes: 10.0.4266.0 SP2 [...]

CTP1 for SQL ‘Denali’ available for download

Microsoft has recently released its first CTP (Community Technical Preview) of the next version of SQL Server, code-named ‘Denali’. In this first CTP, changes have been made to the Database Engine and Integration Services. Other components remain unchanged. The Database Engine now includes a new high availability model, named HADR. HADR makes use of Availability [...]