Microsoft SQL Server 2012

A cloud-ready platform to bring scalability, performance, and self-service business intelligence to your agency’s data center.

By taking advantage of a common architecture spanning traditional servers, appliances, and the cloud, your agency gains operational flexibility and the ability to scale your data center beyond the constraints of any one deployment environment. With a cloud database implementation, your agency can enjoy rapid provisioning, high availability, and reduced overhead. Extending data to the cloud also supports collaboration and productivity for your agency’s teleworkers and provides constituents with more secure, web-based access to information and services—without the need for additional hardware and software investments.

Enhanced compression capabilities in SQL Server 2012 can speed the performance of I/O intensive workloads by shrinking volumes of data, and new Column Store Index technology and an advanced query-execution paradigm can significantly accelerate common data warehouse queries. SQL Active Secondary lets you run report queries, backup operations, and other workloads on secondary instances, helping to improve your resource utilization by minimizing idle hardware. Always On, a new integrated suite of high-availability and disaster-recovery features, provides redundancy to assist fast application failover during planned and unplanned downtime, helping to safeguard access to your mission-critical applications and data when you need them.

Get rapid and powerful insight out of the multitude of data across your organizations, agencies, and municipalities. SQL Server Power View offers interactive web-based querying and rich visualization with sub-second response times. With Power View, Microsoft Excel 2010 PowerPivot, and the Microsoft self-service analytics platform, anyone can search and perform complex analysis on diverse data sources. Users can view and collaborate around intuitive Excel PowerPivot reports or leverage the new semantic search capabilities to potentially “connect” otherwise independent events. SQL Azure Reporting helps you keep citizens and staff informed without the need to have an IT specialist build reports for you, and integration with Microsoft SharePoint lets stakeholders share business intelligence across your organization for timely collaboration and decision-making.