I would like to share the following useful resources for Data Quality Services (DQS) and Master Data Services (MDS) in SQL Server 2008 R2/2012: How to Install Master Data Services (MDS) Service Pack 1 (for SQL Server 2008 R2) Data Quality Services (DQS)

Covering the following areas: Microsoft® SQL Server Report Builder 3.0 for Microsoft® SQL Server 2008 R2 Microsoft® SQL Server® PowerPivot for Microsoft® Excel Microsoft® SQL Server® 2008 R2 Reporting Services Add-in for Microsoft® SharePoint® Technologies 2010 Microsoft® SQL Server® 2008 Reporting Services...

World record in TPC-E with SQL Server 2008 R2 and Fujitsu #1 TPC-H non-clustered 3 TB results #1 TPC-H non-clustered 10 TB results Uncontested leader in the TPC-E Benchmark

SQL Server 2008 R2 Analysis Services Operations Guide SQL Server White Paper Writers: Thomas Kejser, John Sirmon, and Denny Lee Technical Writer and Editor: Heidi Steen, Beth Inghram Published: June 2011 Applies to: SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 Summary: This white paper describes...

SQL Server 2008 R2 provides the full breadth of tools to support restrictive compliance and security requirements. This whitepaper will associate the features and options available in SQL Server 2008 R2 to meet the varying separation of duties requirements to enable the DBA to be productive and responsive...

This is the customer ready deck from the original IDC excerpt http://idcdocserv.com/224350E

This is a great document for analyzing SAP Data using Microsoft’s SQL Server PowerPivot for Excel. Writers: Scott Cameron (Hitachi Consulting), Chunhui Zhu, Denny Lee Technical Reviewers: John Hancock, Lindsey Allen, Hermann Daeubler, Juergen Thomas, Kasper de Jonge Vendors: The authors wish to thank...

SQL Server Migration Assistant (SSMA) v5.0 is now available. SSMA simplifies database migration process from Oracle/Sybase/MySQL and Microsoft Access to SQL Server and SQL Azure. SSMA automates all aspects of migration including migration assessment analysis, schema and SQL statement conversion, data...

That’s a great report from CRIMSON Consulting Group, comparing Microsoft’s SQL Server 2008 R2 vs. Oracle’s database 11g. Some nice quotes from the report: ‘What is undeniable is Microsoft’s gains in the relational database management system (RDBMS) market"’ ‘The evidence shows that Microsoft SQL...

SQL Server 2000: On April 9, 2013, Extended Support for SQL Server 2000 will come to an end, and SQL Server 2000 will no longer be supported. After this date: No more updates. Updates to this software will stop and so customers will no longer receive patches including security updates. Self-Help Online...

From MSDN: Feb 2011 Release The SQL Server 2008 R2 Business Intelligence Training Course (SQLInsights) will help you learn how to build your first Microsoft Business Intelligence solution. SQLInsights is a great resource for developers, consultants and evangelists who need to learn the basics of how...

H P and Microsoft have delivered the first ever self service business intelligence appliance, optimized for SQL Server 2008 R2 and SharePoint Server 2010. Deploy the solution in days, with minimal IT resources. Key Benefits Quickly extend usage of business intelligence to users across organization enabling...

“REDMOND, Wash., and PALO ALTO, Calif. — Jan. 18, 2011 — HP and Microsoft Corp. today announced a portfolio of four new converged application appliances that fuse applications, infrastructure and productivity tools into a single system. These solutions help organizations optimize employee productivity...

This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It contains a rich set of presentations, demos, hands-on labs and videos that are perfect for self-paced...

A 500-pages guide Upgrade Technical Reference for R2 is live in upgrade site . For more information about SQL Server upgrade, please visit http://www.microsoft.com/sqlserver/en/us/product-info/why-upgrade.aspx

The " Enterprise Applications on Microsoft SQL Server " blog provides information about running ISV (Independent Software Vendor) Applications on Microsoft SQL Server and the Microsoft Windows platform. The Blog is written by folks from Microsoft who work closely with these ISVs. Topics of...

SQL Server 2008 R2 Upgrade Technical Reference Guide :   This document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 R2 by using best practices SQL Server 2008 R2 Security Best Practice White Paper : Security is a crucial part...

SQL Server Utility Control Point (SQL Server Utility) “collects configuration and performance information from managed instances of SQL Server every 15 minutes. This information is stored in the utility management data warehouse (UMDW) on the UCP; the UMDW file name is sysutility_mdw. SQL Server performance...

From Microsoft IT Showcase Published: 11/15/2010 Metadata Driven Extract Transform and Load (METaL) was developed by Microsoft IT to enable the rapid configuration, deployment, and operation of data warehouse applications utilizing evolving Microsoft warehouse technologies such as SQL Server 2008 and...

( Copied from MS Press Release on Nov 9th, 2010 ) Today from PASS Summit 2010, Microsoft Corp. unveiled the next generation of SQL Server, Microsoft SQL Server code-named “ Denali ,” and made available SQL Server 2008 R2 Parallel Data Warehouse. The company also announced the new Microsoft Critical Advantage...

This is an interesting report on SQL Server PowerPivot (ex-Gemini) from Gartner. You can get it here .

Διαβάστε το τελευταίο whitepaper στο οποίο γίνεται αναφορά για τα προσφερόμενα (Out of the box) χαρακτηριστικά του SQL Server, τα οποία εμπεριέχονται στο προϊόν και δεν απαιτείται η εγκατάσταση κάποιου πρόσθετου add-in ή feature pack.

  Standard Enterprise Position in product lineup Unchanged . Mid-tier offering for midsize businesses and departmental usage Changed . New Datacenter edition displaces Enterprise as top-of-the-line offering Maximum accessible memory Reduced   to 64GB; SQL Server Standard 2008 supported OS maximum...

This document is designed to help you understand the features and capabilities of the new version of SQL Server 2008 R2 and take a tour of its capabilities. Organizations are looking to compete and grow by reducing costs, reducing time to market and identifying the highest value opportunities for their...

Clinic 10334: Introduction to Managed Self-Service BI with SQL Server 2008 R2 : This two-hour clinic explores the capabilities of Introduction to Managed Self-Service BI with SQL Server 2008 R2. Clinic 10336: Introduction to SQL Server 2008 R2 Application and Multi- Server Management : This two-hour...