All enterprise applications rely on an enterprise database with the capability to handle large capacity of data and quick retrieval. Microsoft SQL Server is a full-featured database primarily designed to support large scale implementations for transactions and reports.

Key features:

  • Enterprise level data processing speed and storage capacity.
  • Analysis services to develop Business Intelligence reports within OLAP, Data Warehouse and Data Mart solutions.
  • Reporting Services to develop custom and Dynamics AX reports including tabular, matrix, graphical, and free-form.
  • Integration Services is a point-to-point integration tool including graphical interface to be used for moving, copying, and transforming data.
  • Master Data Services for data management for Master Data (products, customers, accounts) hierarchies, granular security, transactions, data versioning, and business rules using user tools such as Excel.
  • Largest database support community.

Data Warehouse and Data Marts

  • Support large scale storage of data
  • Combine data from heterogeneous data sources into a single homogenous structure (via ESB or DTS)
  • Store, validate, consolidate and format data for analysis
  • Support Data Mart generation

Business Intelligence (SSIS) and Reporting Services (SSRS)

  • On-line analytical processing (OLAP, ROLAP, MOLAP, HOLAP) for multi-dimensional, hierarchical data structures for drill-down.
  • Cost and profit analysis for each line of business
  • Trending
  • Business activity
  • Breakeven point
  • Financial statements
  • Business performance indicators
  • Balanced scorecard
  • Profit ranking reports by product, customer and other options
  • Tools to create, deploy, and manage reports
  • Efficient analysis of large data sets
  • Efficiently load large data files into tables
  • Supports Microsoft Excel

Performance and Availability

  • High performance for transactional processing (SQL2014: World record for 10TB and 3TB TPC-H with ProLiant DL 580 G8)
  • Highly available with SQL Server AlwaysOn feature offering a significant reduction in planned and unplanned downtime
  • Configurable up to eight secondaries to further enhance availability, data protection and performance