Take a look at the latest SQL Server 2008 R2 Resources to learn how your organization can benefit.
Oceans of data demand a comprehensive platform. Introducing SQL Server 2008 R2 - the next generation of computing. Watch this video for a quick overview of R2.
Microsoft SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence and improve IT and developer efficiency, as well as enable highly scalable and well-managed business intelligence on a self-service basis for your users.
This kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server.
CareGroup started testing Microsoft SQL Server PowerPivot business intelligence tools that are supported by SQL Server 2008 R2. The tools are expected to help employees analyze huge quantities of data while providing greater control over how information is distributed.
The company expects to save $450,000 by using SQL Server 2008 R2 data and backup compression features and $250,000 by migrating its data warehouse from IBM DB2 to SQL Server 2008 R2.
The company will implement Microsoft SQL Server 2008 R2 Enterprise, which works with Microsoft Excel 2010 for business intelligence and Microsoft SharePoint Server 2010 for collaboration. The solution is cost-effective and will help employees do their jobs with less reliance on the IT department
Employees from different teams collaborate more easily through a unified reporting and analysis process. Users are also boosting efficiency by creating statistical analysis reports more quickly and sharing business process information through an enterprise portal.
PREMIER Bankcard, LLC (PREMIER) one of the largest VISA and MasterCard credit providers in the United States, needed to enhance scalability and performance for its business intelligence (BI) data warehouse and online transaction processing (OLTP) databases. "BI began as an area of research for us, but has become absolutely mission critical," says Dan Zerfas, Vice President of Software Development at PREMIER.
BNZ wanted to find a better way to analyze monthly data that is used to provide management information to its branches across New Zealand. The bank found a solution using the business intelligence (BI) tools supported by Microsoft SQL Server 2008 R2, including Microsoft SQL Server PowerPivot for Microsoft Excel and Microsoft SQL Server PowerPivot for Microsoft SharePoint.
In 2010, the company deployed Microsoft SQL Server 2008 R2, Office Professional 2010, and SharePoint Server 2010. Now, customers can access the information they need and employees can use features such as Microsoft SQL Server PowerPivot for Microsoft Excel to boost productivity, raise service levels, and foster innovation.
AMC tested Microsoft SQL Server 2008 R2 along with Microsoft Excel 2010, and it found the software effective and easy to use. With the new solution, AMC easily integrated a previously isolated data source and highlighted business trends with concise graphics.
Information Technology Company, a business unit of Chevron, deployed Microsoft SQL Server 2008 R2 to provide Chevron employees with self-service analysis and report creation capabilities. Users will be able to create enhanced reports with new visualization and analysis tools.
With the new SQL Server 2008 R2 software, MDOT can now provide fast access to large files stored externally and easily generate reports featuring maps that take advantage of existing geospatial information. Furthermore, the new solution provides high availability and scalability and reduces the burden on the agency’s IT staff.
Answers to frequently asked questions about the improvements for database administrators in application and multi-server management.
Answers to frequently asked questions about Microsoft's innovative StreamInsight platform.
Answers to frequently asked questions about the processes and tools in R2 that create a true "master set" of reference data.
Understand how PowerPivot makes BI easily accessible to users, who can take advantage of the power of SQL Server 2008 R2 Analysis Services from within Microsoft Excel 2010 and Microsoft SharePoint Server 2010.
Learn more about Report Builder 3.0, including features such as maps, sparklines, data bars, and indicators.
Scale up to 1 petabyte at low cost? Find out how and get answers to other frequently asked questions about massively parallel processing.
Introducing the Parallel Data Warehouse (formerly known as project "Madison"). Learn about the key features in SQL Server 2008 R2 that make it possible for you to scale from tens to hundreds of terabytes.
Manage by intent, not by chance. Get the facts about the new utility explorer in SQL Server Management Studio.
Process large volumes of complex events with low latency using the StreamInsight data platform.
View the features that empower your users and increase IT efficiency. Includes a section on sharing and collaborating securely via Microsoft SharePoint.
Standardize the data your people rely on to make critical business decisions. Read about the top new features for Master Data Services here.
Transform your data analysis within Microsoft Excel. Learn about how PowerPivot empowers decision making while meeting security and compliance requirements.
Microsoft SQL Server 2008 R2 Enterprise delivers a comprehensive data platform that provides built-in security, availability, and scale, coupled with robust business intelligence offerings. Includes proof points to share with your organization.
Find out the top Datacenter features that SQL Server delivers with R2, such as how to lower costs through optimization and consolidation.
Server consolidation allows you to take advantage of value-added capabilities. Meet more of your business needs while reducing server and storage requirements.
Virtualization with SQL Server 2008 R2 contributes to an agile database infrastructure.
View our roadmap to obtaining maximum business insight from data. Includes proof points from current customers in the mid-market space.
Read how SQL Server 2008 R2 provides a full range of options to help you minimize downtime for your business-critical databases. Includes information on database mirroring, enhanced failover clustering, automatic recovery of corrupt pages, and other key benefits.
Accelerate report creation, facilitate sharing and collaboration, and enable your organization to deliver relevant information to the people who need it.
This datasheet introduces two new premium editions, Datacenter and Parallel Data Warehouse, and reviews the current editions now available in R2 (including Core, Specialized, and Breadth Editions).
With a built-in management console, Microsoft SQL Server 2008 R2 provides a policy-based system for managing one or more instances of SQL Server, along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases.
Application and multi-server management provides the database administrator with the tools necessary to gain centralized insights into instance and database application utilization as well as a better way to develop, deploy, and manage data-tier applications.
A core concept of application and multi-server management in SQL Server 2008 R2 is the Data-tier Application (DAC). A DAC is a self-contained unit of deployment that defines and bundles database objects, SQL Server instance objects that are associated with the database, and deployment requirements of an application.
Event-driven applications use complex event processing (CEP) technology with the goal of identifying meaningful patterns, relationships, and data abstractions from among seemingly unrelated events. With StreamInsight, software developers can create complex and innovative CEP solutions. This paper describes the StreamInsight architecture and major components.
More than ever, organizations can empower individuals to gain deeper insight into all aspects of their business and to share their findings effortlessly and securely. Make better, faster, more relevant decisions using SQL Server 2008 R2 to drive your business intelligence.
This whitepaper walks through the journey of gathering and analyzing the information on which to base all planning and implementation decisions; how to plan, architect, and implement server consolidation; and finally, the considerations for administering a consolidated SQL Server environment.
SQL Server 2008 R2 provides centralized views into resource utilization through application and multi-instance management, and offers improved efficiency for the development and deployment of data-tier applications. End-to-end performance, health monitoring, and analysis capabilities, and Policy-Based Management, help you to optimize your environment and ensure compliance.
Microsoft SQL Server 2008 R2 and Windows Server 2008 R2 work together seamlessly to provide a data platform that delivers a low total cost of ownership (TCO) and that is equipped to handle the needs of even the most demanding mission-critical applications. This data platform provides the agility that businesses need to quickly adapt to changing requirements; the reliability to maintain highly available service provision at scale; and a comprehensive range of tools, features, and functionality to increase IT efficiency and reduce management overhead.
Microsoft SQL Server 2008 R2 Enterprise is a comprehensive data management solution that provides built-in security, availability, and scalability features coupled with robust business intelligence (BI) functionality. SQL Server 2008 R2 Enterprise delivers the highest service levels for mission-critical workloads, and it provides sophisticated and easy-to-use features that lead to insights that drive business growth.
The Microsoft SQL Server 2008 R2 Parallel Data Warehouse offers massive scalability and low cost with a simplified appliance model. Learn more about the hub-and-spoke architecture that integrates Microsoft Business Intelligence tools for a seamless experience.
This deck gets into the true benefits of streamlined deployment with SQL Server 2008 R2: a single unit of deployment called a Date-tier Application. See how the Data-tier Application works--and how it saves your DBAs time in setup, training, and maintenance of database schema.
The Microsoft SQL Server 2008 R2 comprehensive platform is covered in this deck, including the value of Parallel Data Warehouse and SQL Azure for your company. Understand the full benefits we offer through a trusted, scalable platform, IT and Developer efficiency gains, and managed self-service BI.
SQL Server 2008 R2 enables you to manage at scale, automate administrative tasks, and streamline troubleshooting with a range of innovative and effective features. This deck illustrates the solutions we provide to make administration easier and more productive.
SQL Server 2008 R2 not only increases scalability, but also provides new features that allow continuity, enable increased data protection, and simplify management of data recovery. View this deck to understand what availability means for your company in terms of benefits and savings.
Server consolidation has become an increasingly important consideration for most organizations and IT professionals. This deck walks through some of the key considerations for choosing a database platform for consolidation, and highlights some of the key technologies available in SQL Server 2008 R2 that help you consolidate.
This deck demonstrates how SQL Server R2 moves beyond the delivery of standard online analytical processing (OLAP) to help organizations unlock their data, deliver relevant information, and drive actionable insights.
Accelerate your data warehouse roadmap with Fast Track Data Warehouse 2.0. This deck reveals the benefits and features that allow better TCO, predictable performance, and reduced risk through balanced hardware and best practice
This deck explains why the Enterprise edition of SQL Server 2008 R2 is the right version for your company. It showcases numerous customer scenarios to illustrate three points: SQL Server enterprise-class capabilities, organizational business intelligence, and cost reduction opportunities.
The technology capabilities in SQL Server 2008 R2 Enterprise include more than 60 features not in the Standard edition. Review this deck to see why these features matter to your company and can lead to greater scalability, security, manageability, and cost benefits.
This deck provides an overview of Microsoft data warehousing offerings and explains which product customers should use for their specific scenario. With SQL Server 2008 Fast Track Data Warehouse and SQL Server 2008 R2 Parallel Data Warehouse, Microsoft has a solution for every size and scale of data warehousing need, scaling from small data marts to enterprise data warehouse solutions with hundreds of terabytes.
In this clinic, you will learn about the Parallel Data Warehouse architecture, how to work with client connections and tools, and how to manage a Parallel Data Warehouse.
In this clinic, you will understand why complex event processing systems are so compelling, understand the benefits that StreamInsight brings to the table, and begin to learn how to create queries to run within StreamInsight.
In this clinic, you will investigate the improvements to database application development and monitoring using both Microsoft Visual Studio 2010 and SQL Server 2008 R2.
During this clinic, you will gain an understanding of the Windows Azure platform, learn how to optimize your applications for use with SQL Azure, and learn how to migrate your applications and data to SQL Azure. Finally, you will work with database designs that prepare your applications for the scale-out options provided by SQL Azure.
In this clinic, you will learn about new Self-Service Analysis tools (PowerPivot for Excel and PowerPivot for SharePoint), Self-Service Report Authoring, and the enhanced Report Visualization features in SQL Server 2008 R2.
In this clinic, you will gain an understanding of the role of master data and of the value provided to an organization by quality master data. You will also see how to design a master data solution and gain an approach into implementing one.
These two videos introduce the benefits of PowerPivot, both for your line-of-business employees and your IT department. Get them working together by enabling self-service analysis.
View demonstrations of the newest technologies available with SQL Server 2008 R2, and learn about the possibilities for increased efficiency and cost savings.
At the SQLBits 2009 Conference, Andrew Fryer, Microsoft Technical Evangelist, explains to database administrators the specific benefits of having SQL Server 2008 R2 and Windows Server 2008 R2 work together.
Join Principal Consultant Justin Langford of Coeo, Microsoft Gold Certified Partner, at the SQLBits 2009 Conference as he reviews how to virtualize servers running on SQL Server.
Donald Farmer of Microsoft introduces PowerPivot for Excel 2010 and gives a technical approach to the business of analytics in his SQLBits 2009 Keynote address.
Rob Farley of LobsterPot decodes StreamInsight for developers using the Microsoft .NET Framework. He includes a technical overview of Complex Event Processing (CEP), LINQ queries across windows of data, and CEP Server runs in- or out-of-process.
Chris Testa-O'Neill of QA addresses the issues customers face with Reporting Services data, and how you can create and optimize the reports you build for them .
Donald Farmer of Microsoft relates the R2 features to the expanded capabilities in Business Intelligence.
Thomas Kejser of Microsoft gives a technical overview and introduction to the SQL Server 2008 R2 Parallel Data Warehouse and Fast Track data warehousing. The SQLBits 2009 presentation includes hardware architecture, query processing, and data loading.
Donald Farmer of Microsoft reviews master data management as moving from reference data to a system of processes supporting this.
Anthony Howcroft of Microsoft EMEA reviews data warehousing capabilities in SQL Server 2008 R2 and introduces Fast Track data warehousing (“Madison”).
Dr. John Tunnicliffe, Business Intelligence Consultant with Bovi, talks about the processes he uses to transform IT into BI his clients can actually use.
Ian Marritt of Altius, a Microsoft Gold Certified Partner, reviews what master data is and how you can start leveraging processes to utilize this information.
Andrew Fryer, Microsoft Technical Evangelist, reviews the specific features and benefits of Report Builder 3.0, with a focus on affordable, managed self-service business intelligence. He covers desktop analytics, end-user reporting, and SharePoint integration.
Bob Duffy, SQL Server MVP and Database Architect at Prodata, introduces PowerPivot for Excel 2010 and the use case for IT Pros.
Justin Langford, Principal Consultant at Microsoft Gold Certified Partner Coeo, reviews the server consolidation process. He includes the rationale for consolidating, planning and considerations, design and implementation, and troubleshooting.
© 2010 Microsoft Corporation. All rights reserved.