DPM 2010

DPM 2010 Qucic Start Guide: http://technet.microsoft.com/en-us/library/ff399378.aspx
DPM requires a supported 64-bit or 32-bit version of SQL Server 2008 SP1, Enterprise or Standard Edition, for the DPM database. This guide assumes that you will install a dedicated instance of SQL Server from DPM Setup



http://www.microsoft.com/systemcenter/en/us/data-protection-manager/dpm-2010-overview.aspx

Continuous data protection of Windows application and file servers to seamlessly integrated disk, tape, and cloud — with support for a growing list of Microsoft technologies, such as:

Windows Server from 2003 through 2008 R2

SQL Server 2000 through 2008 R2

Exchange Server 2003 through 2010

SharePoint Server 2003 through 2010

Dynamics AX 2009

Cool Stuff

RAMdisk: http://memory.dataram.com/products-and-services/software/ramdisk#download-ramdisk

Updated SQL 2008 MCM Pre-reading list

http://blogs.technet.com/b/themasterblog/archive/2009/12/07/updated-sql-2008-mcm-pre-reading-list.aspx

https://dynamicevents.emeetingsonline.com/emeetings/dynamicevents/290/MCM_SQL2008_Pre-reading_v3.pdf

Clone user Table with collation in SQL Server 2005

Checking collation of Cloumns

SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN ( SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name = 'reg2003AU')

Clone table structure from existing one with collation.

select reg2003AU.*
into reg2003AUabccd
from reg2003AU
where 1=2

checking SQL Server file pages' status

select *
from msdb..suspect_pages

upgrade existing SQL server 2005 standard edition

SQL Server 2008 R2 suppports backup compression, resource governor, restriction of user accessing.

What's New in SQL Server 2008 R2 EditionsWith SQL Server 2008 R2,

Microsoft continues to be the value leader, offering rich functionality to support OLTP and BI workloads out of the box at a low cost of ownership relative to competitors. With increasing hardware innovations, SQL Server continues to be the only major database vendor who does not price per core for multi-core processors.



What’s New in SQL Server 2008 R2 Editions
Built on SQL Server 2008, SQL Server 2008 R2 delivers higher mission-critical scale, more efficient IT, and expanded reporting and analytics through self-service business intelligence. SQL Server 2008 R2 introduces two new premium editions to meet the needs of large scale datacenters and data warehouses.

SQL Server 2008 R2 Datacenter

SQL Server 2008 R2 Parallel Data Warehouse




New Premium Editions
Datacenter


Built on SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter is designed to deliver a high-performing data platform that provides the highest levels of scalability for large application workloads, virtualization and consolidation, and management for an organization’s database infrastructure. Datacenter helps enable organizations to cost effectively scale their mission-critical environment.


Key features new to Datacenter:

Application and Multi-Server Management for enrolling, gaining insights and managing over 25 instances

Highest virtualization support for maximum ROI on consolidation and virtualization

High-scale complex event processing with SQL Server StreamInsight™

Supports more than 8 physical processors for highest levels of scale

Supports memory limits up to OS maximum


Parallel Data Warehouse

SQL Server 2008 R2 Parallel Data Warehouse is a highly scalable data warehouse appliance-based solution. Parallel Data Warehouse delivers performance at low cost through a massively parallel processing (MPP) architecture and compatibility with hardware partners – scale your data warehouse to tens and hundreds of terabytes.

Key features new to Parallel Data Warehouse:

10s to 100s TBs enabled by MPP architecture

Advanced data warehousing capabilities like Star Join Queries and Change Data Capture

Integration with SSIS, SSRS, and SSAS

Supports industry standard data warehousing hub and spoke architecture and parallel database copy




Investments in Core Editions
SQL Server 2008 R2 Enterprise


SQL Server 2008 R2 Enterprise delivers a comprehensive data platform that provides built-in security, availability, and scale coupled with robust business intelligence offerings—helping enable the highest service levels for mission-critical workloads.


The following capabilities are new to Enterprise:

PowerPivot for SharePoint to support the hosting and management of PowerPivot applications in SharePoint

Application and Multi-Server Management for enrolling, gaining insights and managing up to 25 instances

Master Data Services for data consistency across heterogeneous systems

Data Compression now enabled with UCS-2 Unicode support

High-scale complex event processing with SQL Server StreamInsight™


SQL Server 2008 R2 Standard

SQL Server 2008 R2 Standard delivers a complete data management and business intelligence platform for departments and small organizations to run their applications—helping enable effective database management with minimal IT resources.

The following capabilities are new to Standard:

Backup Compression to reduce data backups by up to 60% and help reduce time spent on backups *

Can be managed instance for Application and Multi-Server Management capabilities

High-scale complex event processing with SQL Server StreamInsight™