“Introducing Windows Server 2008 R2" from Microsoft Press is available as a free download. Authors are Charlie Russel and Craig Zucker. 

Download from here (PDF 11MB, 182 pages)

http://download.microsoft.com/download/5/C/0/5C0BD0AB-040D-4C56-A60B-661001012DDA/Windows_Server_2008_R2_e-book.pdf

SQL Server 2008 R2 will be a BI-refresh (“Madison Overview”/”Gemini Overview”) and comes out as a Minor-Release (SQL Server Version 10.50). But there are several interesting features and topics which are interesting for DBAs. In this post I’ll list some options you can already test out in the actual August CTP. Additional enhancements will ship with the next CTP which will be available somewhere around middle of November 2009.

SQL Server Stand-Alone “SysPrep”

The „SysPrep“-feature will also be available for standalone installations, where you can pre deploy your binaries and finish the configuration after the rollout. The „Advanced” Tab on the Setup Landing Page gives you the opportunity to prepare an Image of a SQL Server instance. Instance-ID, Root-Directory, and Features can be selected and pre deployed, but it is also possible to add or remove features by completing the setup. The services and their configuration settings (Security Settings, Paths) will be also configured within the completing procedure. You’ll find additional information on

How To Install SQL Server 2008 R2 Using SysPrep

SQL Server SysPrep is supported for Database Engine and Reporting Services in a Stand-Alone installation for all editions. Management Tools and Shared Services like Browser Service or SQL Server Writer will be automatically deployed during the initial setup. Failover Cluster can be prepared and configured with “Advanced Cluster Preparation/Completion” as it was with SQL Server 2008.

Unicode Compression

SQL Server 2008 R2 has the ability to compress Unicode datatypes like NCHAR and NVARCHAR and brings you huge space savings for a large number of application databases which work with Unicode datatypes. The Simple Compression Scheme for Unicode Data (SCSU, Standard Compression Scheme http://unicode.org/reports/tr6/ ) has a compression ratio of 50% for English and the most European Languages! Unicode Compression will be enabled as part of ROW or PAGE compression. If you already use the data-compression-feature, it is necessary to rebuild the indexes of the compressed table. But if you add new datasets or change an existing the Unicode compression will be enabled automatically.

There are some interesting information regarding Unicode compression and SAP in the blog post of Juergen Thomas: http://blogs.msdn.com/saponsqlserver/archive/2009/09/16/sql-server-2008-r2-ucs2-compression-what-is-it-impact-on-sap-systems.aspx

In Books online you’ll also find additional information on Unicode Compression Implementation.

SQL Server Utility – Application- and Multiservermanagement

SQL Server 2008 R2 introduces new management tools to help improve IT efficiency and productivity. Investments in application and multi-server management will help organizations proactively manage database environments efficiently at scale through centralized visibility into resource utilization. Such investments can help streamline consolidation and upgrade initiatives across the application lifecycle—all with tools that make it fast and easy. The Application- and Multiservermanagement Whitepaper explains the new terms and the configuration. The basic idea is to give DBAs the opportunity to deploy databases (data-tier applications) in a standardized way. The next CTP will bring more advantages in this topic. This blog keeps you updated.

There are no advantages or changes planned in the area of High-Availability and Datatypes.

Before you test SQL Server 2008 R2, please be prepared that the physical database version number will be updated (SQL Server 2008 RTM/SP1 655). This means, that it’s not possible to restore a SQL Server 2008 R2 database back to a SQL Server 2008 RTM/SP1 instance (backup/restore or detach/attach). Compatibility level remains “100”, whereas “90” for SQL 2005 and “80” for SQL 2000 are still supported.

You can get your database version number with following query:

SELECT
DATABASEPROPERTY ('YourDBName','Version')
GO

Get the SQL Server 2008 R2 CTP from http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx.

Microsoft Security Essentials provides real-time protection for your home PC that guards against viruses, spyware, and other malicious software.

Microsoft Security Essentials is a free* download from Microsoft that is simple to install, easy to use, and always kept up to date so you can be assured your PC is protected by the latest technology. It’s easy to tell if your PC is secure — when you’re green, you’re good. It’s that simple.

Microsoft Security Essentials runs quietly and efficiently in the background so that you are free to use your Windows-based PC the way you want—without interruptions or long computer wait times.

(*Your PC must run genuine Windows to install Microsoft Security Essentials. Learn more about genuine )

Microsoft announced yesterday the availability of 2 new betas for System Center products

System Center Essentials 2010

SCE 2010 is designed specifically for mid-sized organizations and delivers a unified physical and virtual IT management experience.

It enables you to better secure, update, monitor, and troubleshoot from a single console, so you can efficiently and proactively manage your IT environment:

• A unified solution with a single console for managing your physical and virtual servers, client computers, hardware, software, and IT services
• Smart alert notifications of IT issues, providing expert diagnostic information to accelerate problem diagnosis and quickly resolve issues before they cause downtime
• Simplify complex management tasks, like creation of virtual servers, software deployment, update management, and inventory collection
• And designed to be easy to deploy and maintain, exclusively for mid-sized organizations

System Center Data Protection Manager 2010

There are lots of reasons to be excited about DPM 2010.  Here are a few:

• Virtualization administrators get item-level restore from within VM backups, as well as support for LiveMigration (CSV) scenarios for Hyper-V R2
• SharePoint administrators lose the need for a Recovery Farm and gain auto-protection of new content databases
• SQL Server administrators get auto-protection at a SQL instance level, huge scalability increases and a self-service restore utility for DBAs
• Exchange managers get support for Exchange 2010, including DAG configurations, as well as CCR/SCR
• Windows client users get protection and recovery for remote laptops, with protection online and offline
• Disaster Recovery planners get lots of new options around multi-site chaining and protection between sites
• And everyone gets new enterprise scalability, reliability and manageability enhancements