SQL Server DQS and MDS

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)

0

Microsoft® SQL Server® 2008 R2 Feature Pack

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 Add-in for Microsoft® SharePoint® Technologies 2007 Microsoft® SQL Server® 2008 R2 Policies Microsoft®…

1

SQL Server 2008 R2 benchmarks

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

0

SQL Server 2008 R2 Analysis Services Operations Guide

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 how operations engineers can test, monitor,…

0

Separation of Duties for DBA customer ready white paper

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 while protecting applications and sensitive data. http://download.microsoft.com/download/D/2/D/D2D931E9-B6B5-4E3B-B0AF-22C749F9BB7E/SQL_Server_Separation_of_Duties_White_Paper.docx

0

Using SQL Server PowerPivot for Excel to Analyze SAP Data, from Microsoft SQL CAT team

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 the vendors who assisted us with this project: Simplement, ERP-Link, Theobald,…

1

SQL Server Migration Assistant (SSMA) v5.0

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 migration as well as migration testing to reduce cost and reduce risk of your…

0

Comparing the Business Value of Microsoft SQL Server 2008 R2 and Oracle Database 11g Perceptions vs. Reality in the RDBMS Marketplace, by CRIMSON Consulting Group

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 Server 2008 R2 is competitive with Oracle Database 11g on large…

0

911-SQL Server End of Support

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 Support will be…

0