Tuote lyhyesti

Microsoft SQL Server tarjoaa skaalattavan yritystietokäyttöympäristön, jolla käyttäjät voivat kerätä, analysoida ja jakaa raportteja sekä tehdä entistä parempia päätöksiä. Tämä on mahdollista, koska työntekijät voivat luoda ja jakaa tehokkaita analyysiratkaisuja tutuilla ja helppokäyttöisillä työkaluilla. SQL Server tukee itse tehtyjen yritystietoanalyysien jakamista ja yhteistyötä niiden parissa organisaation muiden käyttäjien kanssa.

Tuote pähkinänkuoressa

• Boost data warehouse performance
• Consolidate all of your data for optimized reporting and analysis
• Increase developer productivity
• Reduce management overhead
• Realize the power of high performance
• Empower end users and extend reporting reach
• Create high-performance Analysis Services solutions with improved cube designers, subspace computation, and MOLAP enabled write-back capabilities
• Implement more responsive Reporting Services solutions through enhancements to on-demand processing and instance-based rendering
• Publish reports securely over the Internet

Tuotteen ominaisuudet

• Boost data warehouse performance
  Integrate large volumes of data into your data warehouse faster by using SQL Server Integration Services, and consolidate real-time data by capturing data changes. Increase the manageability and performance of large tables with partitioning, which enables you to manage growing volumes of data and users of your SQL Server data warehouse more efficiently.
• Consolidate all of your data for optimized reporting and analysis
  Work with all of your data and interact the way you want through support for both relational and non-relational data, including new data types that enable you to efficiently store, manage, and analyze unstructured data, such as documents and images. Incorporate data from multiple sources directly into a single report. Use the data source view to integrate data from across the enterprise and create a Unified Dimension Model that consolidates data from heterogeneous, enterprise-wide data stores, such as SQL Server, Oracle, DB2, and Teradata, to create a holistic view of your business, helping end users gain enterprise-wide insight.
• Increase developer productivity
  Use the rich visual development environment provided by SQL Server Business Intelligence Development Studio, which supports the entire development life cycle of developing, testing, and deploying robust, secure, scalable solutions. Implement best practice analysis applications through automatic notifications about potential issues in your design throughout the entire Analysis Services development process. Optimize OLAP performance with the innovative new Aggregation Designer.
• Reduce management overhead
  Focus on high-value tasks while spending less time on routine maintenance and tuning operations, by using the unified management tool to provide an integrated management experience across all SQL Server technologies for increased productivity, flexibility, and manageability.
• Realize the power of high performance
  Build highly responsive reporting solutions with on-demand processing and instance based rendering by using SQL Server Reporting services to take your enterprise reporting to new levels of performance and scale. Drive broader analysis with the extensive analytical capabilities provided by SQL Server Analysis Services. Use intuitive cube design tools and enhanced dimension designers to streamline the development of your analysis infrastructure and build robust, high performing solutions. Take advantage of subspace computations to significantly improve analysis cube performance, which enables users to increase the depth of hierarchies and the complexity of computations.
• Empower end users and extend reporting reach
  Enable business users to build ad hoc reports and create reports with any structure by using the powerful report designer. Increase report flexibility by combining fixed and dynamic rows by using the Tablix report design template that enables data presentation scenarios that have previously been difficult or impossible to build. Incorporate rich formatting in reports to increase usability.