Server consolidation and data warehousing

Access all your data to help inform decisions, and align your operations to help your school stay on target.
  • Consolidate information stored in silos.
  • Improve information access and permissions.
  • Help secure sensitive information across databases, data files, and log files.
     
    Next steps
    Call 888-237-8376
    Call or chat weekdays 9 AM - 6 PM Eastern Time
    Overview

    Data warehousing in education

    Information is power, but an abundance of data is of little use if it is scattered across desktops, schools, campuses, and formats, especially if you can’t easily retrieve or consolidate it. To improve your business results, you need the ability to analyze diverse information sets, regardless of where they originate. Server consolidation and data warehousing can be effective solutions for these issues.
    Store, manage, govern data
    The Microsoft data platform provides a complete solution for storing, managing, and governing data, along with a rich set of services for interacting with information, including search, queries, data analysis, reporting, integration, and synchronization. With the solution in place, academic institutions can find information, make it available as insight, and use it to support decision-making and operations, thanks to core capabilities that include:
    • Highly scalable data warehousing that can support thousands of users across terabytes of data. Built-in compression, transparent table partitioning, and query optimization help reduce response time and accelerate performance. You can use change tables to incorporate information more quickly and easily into data warehouses.
    • Policy-based manageability to help reduce overhead and total cost of ownership, along with a new declarative framework for managing compliance, changes, and administrative tasks. Administrators can institute and monitor policy compliance with automated enforcement, event notification, and scheduled evaluations.
    • Occasionally connected systems to support remote workers and mobile devices with unified synchronization across applications, data stores, and data types. The solution supports change-tracking, so agencies can develop robust, occasionally connected applications with minimal performance overhead.
    • Streamlined development to provide a rich environment that supports the entire testing, development, and installation cycle. Business entities that can be queried with any .NET language provide easier access to data. Developers can work with a logical entity model and then define physical implementations as columns and tables.
    • Security to transparently encrypt entire databases, data files, and log files without affecting applications. The solution provides advanced auditing capabilities and helps minimize vulnerabilities by enabling only needed features and functions according to policy-based configurations.
    • Continuity of operations and disaster recovery to increase reliability and simplify recovery with seamlessly mirroring applications, databases, and web services. The solution transfers operational data automatically between active and backup systems and allows administrators to add system resources without disruption.
    The Microsoft Data Platform and SQL Server 2008 provide the technologies that academic institutions need to contain proliferation, manage data in all its divergent forms, and make information easy to access and use. Microsoft and your partners will help you determine the capabilities you need and can work with you through every step of development and installation.
     
    Case Studies
    Products