Microsoft Corp. has recently announced that SQL Server 2012, the next-generation of the world’s most recognized and widely used data platform, is now generally available for purchase and download. With this new release, Microsoft is touting SQL Server 2012′s capabilities for mission-critical workloads with high availability and disaster recovery, business intelligence and the ability for customers to extend data across on-premises or public cloud.
What SQL hosting customers can expect with Microsoft’s new SQL Server 2012.
SQL Server 2012 allows customers to take advantage of a powerful new set of features and capabilities that deliver increased performance, enhanced application availability and more scale and security. To help individuals and businesses fully understand how they can benefit from SQL Server 2012, below we list the highlights for what’s available in SQL Server 2012 in terms of features and functionality.
SQL Server AlwaysOn – a new high-availability component delivering greater uptime and data protection along with lower TCO.
ColumnStore Indexes – a new unique feature in SQL Server that allows data to be grouped and stored in a compressed column index resulting in blazing-fast query performance and reduced I/O and memory utilization.
Enhanced PowerPivot – delivers new advanced analytic capabilities and adds functionality to make model creation and sharing easier.
Power View – a web-based data visualization and presentation solution that allows business users to create mash-ups of BI reports from all over the Enterprise.
Business Intelligence (BI) Semantic Model – a hybrid model for BI applications that allows one data model to support all BI experiences in SQL Server.
Enhanced Auditing – audit is now available in all editions of SQL Server. Provides comprehensive reporting and greater flexibility with new filtering features.
SQL Server Data Tools (SSDT) – one of the most important new tools added to SQL Server 2012. SSDT unifies SQL Server and cloud SQL Azure development for developing database, business intelligence and web solutions.
There are many other data integration and management tools available in SQL Server 2012. With the above mentioned and other SQL Server 2012’s features and updates, customers now have the opportunity to take their businesses to the next level by being provided with everything they need to add more business value to their solutions or to reach new customer segments.
ServerPoint.com will soon be integrating SQL Server 2012 database to our hosting offerings to allow SQL server hosting customers to take advantage of the new platform and all the features and capabilities it offers.