Microsoft SQL Server 2012 deploys a full data warehouse or data mart solution on your own hardware and custom configuration of choice.
Ideal for small to large data warehouses or for data marts, Microsoft SQL Server 2012 is a software solution allowing you to deploy on your own hardware configuration. SQL Server 2012 includes the capabilities to run your data from cleansing and loading to analysis and reporting.
SQL Server 2012 supports industry standard data warehousing design principles. For example, you can implement:
SQL Server 2012’s integrated tools perform sophisticated data warehouse ETL operations such as merging, time/date stamping, de-duplication, data type conversion, normalization, surrogate key insertion, and other cleansing operations necessary for managing data in a typical data warehouse. For example, in SQL Server 2012:
SQL Server 2012 optimizes performance and resource management according to your organizational priorities. For example, administrators can use:
Microsoft uniquely ships major components of an integrated BI solution with our data warehousing offerings out-of-the-box. Overcoming the traditional BI challenges of low user adoption due to the complexity and costs, Microsoft SQL Server Data Warehousing also leverages Office and SharePoint to empower business users with familiar interfaces opening up complex data analysis to everyone.
xVelocity memory optimized ColumnStore index enables you to achieve break-through speed ups for common data warehouse queries.
Get answers to technical questions about SQL Server for implementation and development.
Read how organizations like yours use SQL Server to achieve their goals.
Join the SQL Server Community to access resources, connect with peers, and learn from experts.