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.
1SQL Server data management-
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.
Access detailed examples of SQL dynamic management views (DMVs), learning how they facilitate administration of SQL Server databases. Continue Reading
Gain insights from expert Denny Cherry on Microsoft's data-cleansing tool, SQL Server Data Quality Services. Continue Reading
Learn how the Master Data Services (MDS) feature of SQL Server enables business to standardize sets of data. Continue Reading
2BI and SSIS-
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.
Learn about more SQL Server Integration Services (SSIS) features of SQL Server 2012 in this tip discussing connection managers and column mapping. Continue Reading
This third part of a series on SQL Server Integration Services discusses package and project parameters, and undo and redo operations. Continue Reading
See what analysts have to say about Microsoft SQL Server 2012 BI capabilities such as Power View and master data management. Continue Reading
Read how Intel is using SQL 2012 business intelligence, and self-service BI in particular, to keep up with Moore's Law. Continue Reading
3Data management tools-
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.
Learn what expert Ashish Kumar Mehta has to say about six important SQL Server management tools, such as BIDS and SSDT. Continue Reading
The new Microsoft GeoFlow three-dimensional SQL Server mapping tool adds 3-D mapping capabilities to Excel. Continue Reading
Get insights into essential SQL Server management tools that help save time and enhance performance. Continue Reading
With the release of SQL Server 2012, the Microsoft BI stack adds new tools to the familiar lineup. Continue Reading
Learn how to make the most of data governance tools by also implementing best practices and standard processes. Continue Reading