Guide to SQL Server data management and data quality

Last updated:October 2013

Editor's note

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.

1Business 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.

2SQL 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.