Essential Guide

This Essential Guide is a collection of articles, videos and other content selected by our editors to give you a comprehensive view of this topic.

Guide to SQL Server data management and data quality

Learn how to make the most of SQL Server data management tools and services with the articles in this Essential Guide.

Organizations store and manage enterprise data in various systems and formats, often making effective data management and governance challenging. Data quality can suffer without a strategy for effective management. In addition, more enterprises are placing a focus on business intelligence and data analysis, which have much to offer in terms of business value. SQL Server offers features for data management, data governance and business intelligence (BI) capabilities, with SQL Server Master Data Services and SQL Server Integration Services, as well as a number of management tools.

Database administrators have a significant role to play in data management, of course. However, with SQL Server 2012, Microsoft aims to include business users in managing data and processing BI reports as well.

The articles in this Essential Guide deliver helpful information on the features available through SQL Server, examples of how different tools can be applied and expert advice for improving SQL Server data management in your enterprise.

SQL Server data management

1. Improving SQL Server data management and data quality

SQL Server offers different features for administering, viewing, cleansing and managing data. The articles in this section provide expert insights for how to view, store and standardize data with SQL Server Data Quality Services, Master Data Services and other tools.

BI and SSIS

2. Business intelligence and SQL Server Integration Services

With growing emphasis on business intelligence becoming a reality in many companies, efficiently managing, integrating and viewing data is more important than ever. The stories in this section examine new features of SQL Server Integration Services for SQL Server 2012, as well as other BI tools.

Data management tools

3. SQL Server tools to enhance data management and governance

Data management, data governance and data visualization are easier than ever with helpful new SQL Server management tools. The articles in this section discuss tools such as GeoFlow, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) and how they contribute to an effective data management strategy.