Microsoft SQL Server is a complete set of enterprise-ready technologies and tools that help people derive the most value from information at the lowest total-cost-of-ownership. Enjoy high levels of performance, availability, and security; employ more productive management and development tools; and deliver pervasive insight with self-service business intelligence (BI).
Featured Documents
DownloadAs the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence.
SQL Server 2012 Download
As the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence.
DownloadDownloadSQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
SQL Server 2012 Overview
SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
DownloadDownloadThe launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software licensing and pricing approach. With SQL Server 2012, Microsoft is offering a new set of streamlined editions that are well aligned with database and BI needs and an industry-standard pricing approach based on cores.
IDC White Paper: Microsoft SQL Server 2012: Potential Game Changer
The launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software licensing and pricing approach. With SQL Server 2012, Microsoft is offering a new set of streamlined editions that are well aligned with database and BI needs and an industry-standard pricing approach based on cores.
Download
DownloadThe next wave of SQL Server investments will help extend organizations beyond the database with a cloud-ready information platform that delivers mission critical confidence, breakthrough insight, and cloud on your terms.
The Fantastic 12 of 2012
The next wave of SQL Server investments will help extend organizations beyond the database with a cloud-ready information platform that delivers mission critical confidence, breakthrough insight, and cloud on your terms.
DownloadDownloadThe SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions.
SQL Server 2012 Licensing Datasheet and FAQ
The SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions.
DownloadDownloadLearn more about SQL Server 2012 licensing.
SQL Server 2012 Core Factor Table
Learn more about SQL Server 2012 licensing.
DownloadDownloadLearn more about SQL Server 2012 Editions and Licensing in this reference guide.
SQL Server 2012 Licensing Reference Guide
Learn more about SQL Server 2012 Editions and Licensing in this reference guide.
DownloadDownloadLearn about AlwaysOn - HA/DR improvements/enhancements for SQL Server from Justin Erickson, Senior Program Manager from SQL Server Engine team.
SQL Server AlwaysOn Video
Learn about AlwaysOn - HA/DR improvements/enhancements for SQL Server from Justin Erickson, Senior Program Manager from SQL Server Engine team.
DownloadDownloadWatch this video from SQL Server Principal Program Manager in query processing team, Eric Hanson, on Column Index in upcoming SQL Server 2012
SQLServerColumnStoreIndex
Watch this video from SQL Server Principal Program Manager in query processing team, Eric Hanson, on Column Index in upcoming SQL Server 2012
DownloadDownloadLearn security & compliance features for SQL Server from Il-Sung Lee, Senior Program Manager from SQL Server Engine Security team.
SQL Server 2012 Security
Learn security & compliance features for SQL Server from Il-Sung Lee, Senior Program Manager from SQL Server Engine Security team.
DownloadDownloadOverview of Microsoft® Services Premier Mission Critical can help you tackle the support requirements of the most demanding solutions. An add-on to Premier Support, Premier Mission Critical provides a scalable service and support program, with services spanning from a solution validation and architectural reviews, to proactive and problem resolution services.
Premier Mission Critical Support and Service Overview
Overview of Microsoft® Services Premier Mission Critical can help you tackle the support requirements of the most demanding solutions. An add-on to Premier Support, Premier Mission Critical provides a scalable service and support program, with services spanning from a solution validation and architectural reviews, to proactive and problem resolution services.
DownloadDownloadAs the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence.
SQL Server 2012 Download
As the foundation of the cloud-ready information platform, SQL Server 2012 will help organizations unlock breakthrough insights across the organization as well quickly build solutions and extend data across on-premises and public cloud backed by mission critical confidence.
DownloadDownloadThe SQL Server 2012 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2012.
SQL Server 2012 Feature Pack
The SQL Server 2012 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2012.
DownloadDownloadThis whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012.
What's New in SQL Server 2012 Whitepaper
This whitepaper provides an overview of the new features, benefits, and functionality in Microsoft SQL Server 2012.
DownloadDownloadDemo of SQL Server 2012 User-Defined Server Roles features. Server Roles increase flexibility, manageability, and facilitate compliance towards better separation of duties. It allows creation of new server roles to suit different organizations that separate multiple administrators according to roles.
SQL Server 2012 User Defined Server Roles Demo
Demo of SQL Server 2012 User-Defined Server Roles features. Server Roles increase flexibility, manageability, and facilitate compliance towards better separation of duties. It allows creation of new server roles to suit different organizations that separate multiple administrators according to roles.
DownloadDownloadSQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development.
SQL Server Data Tools Download
SQL Server Data Tools (SSDT) is a toolset that allows professional database and application developers to carry out all their database design work for SQL Server and SQL Azure within Visual Studio. SSDT provides a rich SQL Server development experience with first class language services and VS integration, as well as declarative, model-based tools that can be utilized for both online and offline development.
DownloadDownloadNecessary tools to gain centralized insights into instance and database application utilization as well as a better way to develop, deploy, and manage data-tier applications.
Introduction to Application and Multi-Server Management
Necessary tools to gain centralized insights into instance and database application utilization as well as a better way to develop, deploy, and manage data-tier applications.
DownloadDownloadThis demo provides an overview of SQL Server 2012 Contained Database Authentication. Contained Database Authentication increases compliance by allowing users to be authenticated directly into user databases without logins.
SQL Server 2012 Contained Database Authentication Demo
This demo provides an overview of SQL Server 2012 Contained Database Authentication. Contained Database Authentication increases compliance by allowing users to be authenticated directly into user databases without logins.
DownloadDownloadSQL Server 2012 brings additional flexibility, usability for auditing and security manageability across SQL Server environment to help making it even easier for organizations to meet compliance policies.
SQL Server 2012 Security and Compliance Datasheet
SQL Server 2012 brings additional flexibility, usability for auditing and security manageability across SQL Server environment to help making it even easier for organizations to meet compliance policies.
DownloadDownloadBuild applications that target your on-premise environment or the cloud with powerful new developer tools and frameworks.
SQL Server 2012 Programmability Datasheet
Build applications that target your on-premise environment or the cloud with powerful new developer tools and frameworks.
DownloadDownloadLearn about the vision of database programmability tools for SQL Server 2012 from Krzysztof Kozielczyk, Program Manager from SQL Server Programmability team.
SQL Server 2012 Data Programmability Tools
Learn about the vision of database programmability tools for SQL Server 2012 from Krzysztof Kozielczyk, Program Manager from SQL Server Programmability team.
DownloadDownloadThe SQL Server 2012 Product Guide download contains the latest datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to help you evaluate the SQL Server 2012 release. The Product Guide organizes the content for easier viewing.
SQL Server 2012 Product Guide
The SQL Server 2012 Product Guide download contains the latest datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to help you evaluate the SQL Server 2012 release. The Product Guide organizes the content for easier viewing.
DownloadDownloadThe SQL Server 2012 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2012 database and BI solutions.
SQL Server 2012 Developer Training Kit
The SQL Server 2012 Developer Training Kit includes technical content designed to help you learn how to develop SQL Server 2012 database and BI solutions.
DownloadDownloadSQL Server 2012 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.
SQL Server 2012 Analysis Services Datasheet
SQL Server 2012 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.
DownloadDownloadSQL Server 2012 Master Data Services (MDS) enables organizations of all sizes to operationalize their commitment to information.
SQL Server 2012 Master Data Services Datasheet
SQL Server 2012 Master Data Services (MDS) enables organizations of all sizes to operationalize their commitment to information.
DownloadDownloadDeliver Breakthrough Insights to Drive Real-Time Decisions
SQL Server 2012 BI Overview
Deliver Breakthrough Insights to Drive Real-Time Decisions
DownloadDownloadPredictive Analysis in Microsoft SQL Server 2012
SQL Server 2012 Data Mining Datasheet
Predictive Analysis in Microsoft SQL Server 2012
DownloadDownloadSQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
SQL Server 2012 Overview
SQL Server 2012 is a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization and quickly build solutions to extend data across on-premises and public cloud, backed by mission critical confidence.
DownloadDownloadSQL Server 2012 Reporting Services is a comprehensive, highly scalable solution that enhances real-time decision-making across the enterprise by enabling the creation, management, and delivery reports for pixel-perfect printing, interactive web viewing, and ad hoc data exploration. Microsoft enhances agility and offers greater choice by extending reporting into the cloud, allowing customers to take advantage of the cloud’s accessibility and elasticity.
SQL Server 2012 BI Reporting Overview
SQL Server 2012 Reporting Services is a comprehensive, highly scalable solution that enhances real-time decision-making across the enterprise by enabling the creation, management, and delivery reports for pixel-perfect printing, interactive web viewing, and ad hoc data exploration. Microsoft enhances agility and offers greater choice by extending reporting into the cloud, allowing customers to take advantage of the cloud’s accessibility and elasticity.
DownloadDownloadThe launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software licensing and pricing approach. With SQL Server 2012, Microsoft is offering a new set of streamlined editions that are well aligned with database and BI needs and an industry-standard pricing approach based on cores.
IDC White Paper: Microsoft SQL Server 2012: Potential Game Changer
The launch of SQL Server 2012 has revealed a major new release with many feature enhancements as well as a new software licensing and pricing approach. With SQL Server 2012, Microsoft is offering a new set of streamlined editions that are well aligned with database and BI needs and an industry-standard pricing approach based on cores.
DownloadDownloadSQL Server 2012 provides a set of features and capabilities that enable businesses to achieve the highest level of availability and data protection without the cost and complexity.
SQL Server 2012 High Availability Datasheet
SQL Server 2012 provides a set of features and capabilities that enable businesses to achieve the highest level of availability and data protection without the cost and complexity.
DownloadDownloadSQL Server Data Quality Services (DQS) provides approachable data quality capabilities for organizations of all sizes to help improve the quality of their data.
SQL Server 2012 Data Quality Services Datasheet
SQL Server Data Quality Services (DQS) provides approachable data quality capabilities for organizations of all sizes to help improve the quality of their data.
DownloadDownloadIn this snack, you will see how SQL Server 2012 provides Required 9s and data protection, Blazing-fast performance and Organizational security and performance
SQL Server 2012 Mission Critical Confidence Snack Video
In this snack, you will see how SQL Server 2012 provides Required 9s and data protection, Blazing-fast performance and Organizational security and performance
DownloadDownloadIn this snack you will see how SQL Server 2012 provides Rapid data exploration with stunning visualizations, Consistent data and Credible data
SQL Server 2012 Breakthrough Insight Snack Video
In this snack you will see how SQL Server 2012 provides Rapid data exploration with stunning visualizations, Consistent data and Credible data
DownloadDownloadIn this snack you will see how SQL Server 2012 and SQL Azure provide Scale on Demand and Greater Interoperability and The Ability to Extend to Any Data, Anywhere
SQL Server 2012 Cloud On Your Terms Snack Video
In this snack you will see how SQL Server 2012 and SQL Azure provide Scale on Demand and Greater Interoperability and The Ability to Extend to Any Data, Anywhere
DownloadDownloadThis white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server 2012.
SQL Server 2012 What's New Breakthrough Insight Whitepaper
This white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server 2012.
DownloadDownloadSecurity is a crucial part of any mission-critical application. This paper describes best practices for setting up and maintaining security in SQL Server 2012.
SQL Server 2012 Security Best Practice Whitepaper
Security is a crucial part of any mission-critical application. This paper describes best practices for setting up and maintaining security in SQL Server 2012.
DownloadDownloadMicrosoft’s vision is to enable all users to gain business insights from virtually any data, including insights previously hidden in unstructured data.
Microsoft Big Data Solution Sheet
Microsoft’s vision is to enable all users to gain business insights from virtually any data, including insights previously hidden in unstructured data.
DownloadDownloadLearn more about the Microsoft Big Data solution to unable organizations to unleash business insights from their own structured and unstructured data.
Big Data Solution Datasheet
Learn more about the Microsoft Big Data solution to unable organizations to unleash business insights from their own structured and unstructured data.
DownloadDownloadLearn how to easily synchronize between SQL Azure and On-Premise SQL Server Databases using SQL Azure DataSync.
SQL Azure DataSync Datasheet
Learn how to easily synchronize between SQL Azure and On-Premise SQL Server Databases using SQL Azure DataSync.
DownloadDownloadThis white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server 2012 for technical decision makers.
SQL Server 2012 Breakthrough Insight White Paper for TDMs
This white paper presents an overview of the new features related to the business intelligence stack in Microsoft SQL Server 2012 for technical decision makers.
DownloadDownloadThis technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012.
SQL Server 2012 Upgrade Technical Reference Guide Whitepaper
This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012.
DownloadDownloadLearn more about how SQL Server 2012 provides all the components needed for an effective EIM solution in a single product.
SQL Server 2012 Enterprise Information Management Whitepaper
Learn more about how SQL Server 2012 provides all the components needed for an effective EIM solution in a single product.
DownloadDownloadLearn more about SQL Server 2012 virtualization licensing options available and take a closer look at the key principles involved.
SQL Server 2012 Virtualization Licensing Guide
Learn more about SQL Server 2012 virtualization licensing options available and take a closer look at the key principles involved.
DownloadDownloadGuide to help customers determine SQL Server 2012 licensing requirements for deployed SQL Server databases at the time of their Software Assurance renewal.
Determining SQL Server 2012 Core Licensing Requirements at SA Renewal
Guide to help customers determine SQL Server 2012 licensing requirements for deployed SQL Server databases at the time of their Software Assurance renewal.
DownloadDownloadThis paper examines the factors that have made the combination of SQL Server and Intel Xeon processors so effective.
SQL Server 2012 Intel Flexibility and TCO Benefits for Mission Critical Databases
This paper examines the factors that have made the combination of SQL Server and Intel Xeon processors so effective.
DownloadDownloadIn this white paper, we will discuss the new mission critical, and we will examine the built-in capabilities that Microsoft SQL Server 2012 delivers.
SQL Server 2012 Mission Critical White Paper
In this white paper, we will discuss the new mission critical, and we will examine the built-in capabilities that Microsoft SQL Server 2012 delivers.
DownloadDownloadIn this paper, we will cover the performance and scalability capabilities of SQL Server 2012.
SQL Server 2012 Performance White Paper
In this paper, we will cover the performance and scalability capabilities of SQL Server 2012.
DownloadDownloadBy extending your Oracle DBA skills to learn how to take advantage of SQL Server 2012 you will be in a better position to help solve more of the complex business problems in your organization.
Becoming a Bilingual Oracle and SQL Server DBA
By extending your Oracle DBA skills to learn how to take advantage of SQL Server 2012 you will be in a better position to help solve more of the complex business problems in your organization.
DownloadDownloadMicrosoft’s overarching strategy of delivering a cost-efficient flexible solution based on the individual organization’s workload sharply contrasts with Oracle’s implacable one-size-fits-all approach.
ITIC Study: Comparison of Oracle Database to SQL Server
Microsoft’s overarching strategy of delivering a cost-efficient flexible solution based on the individual organization’s workload sharply contrasts with Oracle’s implacable one-size-fits-all approach.
DownloadDownloadThis paper compares the major features of both the latest version of SQL Server 2012 and MySQL 5 (including 5.5) in each product in five separate categories. It will help customers choose which database is most suitable for their database applications.
SQL Server 2012 Compared with MySQL 5
This paper compares the major features of both the latest version of SQL Server 2012 and MySQL 5 (including 5.5) in each product in five separate categories. It will help customers choose which database is most suitable for their database applications.
DownloadDownloadThis paper compares the major features of both the latest version of SQL Server 2012 and PostgreSQL 9 in each product in six separate categories. It will help customers choose which database is most suitable for their database applications.
SQL Server 2012 Compared with PostgreSQL 9
This paper compares the major features of both the latest version of SQL Server 2012 and PostgreSQL 9 in each product in six separate categories. It will help customers choose which database is most suitable for their database applications.
DownloadDownloadThis paper explains the different ways in which databases are packaged among the three leading enterprise database vendors: Microsoft SQL Server, IBM DB2, and Oracle DB.
SQL Server 2012 Gives You More Advanced Features Out of the Box
This paper explains the different ways in which databases are packaged among the three leading enterprise database vendors: Microsoft SQL Server, IBM DB2, and Oracle DB.
DownloadDownloadThis white paper provides information that will help business and IT decision makers select the right Microsoft reporting and analysis front-end tools based on their business users’ intent: self-service reporting, data mashups, professional reporting, dashboarding, and scorecarding.
SQL Server 2012: How to Choose the Right Reporting and Analysis Tools to Suite Your Style
This white paper provides information that will help business and IT decision makers select the right Microsoft reporting and analysis front-end tools based on their business users’ intent: self-service reporting, data mashups, professional reporting, dashboarding, and scorecarding.
DownloadDownloadThe purpose of this white paper is to show how SQL Server 2012 can deliver superior licensing value compared to the Oracle Database—in particular in the premium Enterprise Edition SKUs—by comparing the cost to license each in a number of key scenarios.
SQL Server Licensing Value vs Oracle Database
The purpose of this white paper is to show how SQL Server 2012 can deliver superior licensing value compared to the Oracle Database—in particular in the premium Enterprise Edition SKUs—by comparing the cost to license each in a number of key scenarios.
DownloadDownloadIn this white paper, we discuss the main reasons why customers might not want to implement Oracle Real Application Clusters (RAC) in their database solution.
SQL Server 2012: Why Oracle RAC Might Not Be Suitable for You
In this white paper, we discuss the main reasons why customers might not want to implement Oracle Real Application Clusters (RAC) in their database solution.
DownloadDownloadOverview of Microsoft Hybrid-IT Solutions.
Hybrid-IT Overview Poster
Overview of Microsoft Hybrid-IT Solutions.
DownloadDownloadSQL Server 2012 is an optimal database for enabling mission-critical environments, offering availability and performance at low total cost of ownership (TCO) for SAP installations of all sizes.
SAP on SQL Server 2012
SQL Server 2012 is an optimal database for enabling mission-critical environments, offering availability and performance at low total cost of ownership (TCO) for SAP installations of all sizes.
DownloadDownloadOverview of SQL Server 2012 Data Warehousing features.
SQL Server 2012 Data Warehousing Datasheet
Overview of SQL Server 2012 Data Warehousing features.
DownloadDownloadMicrosoft’s Enterprise Integration Management (EIM) technologies, built on the foundation of SQL Server 2012, provide a scalable, user-driven solution that empowers organizations to unlock the business value of their data.
SQL Server 2012 Enterprise Information Management Datasheet
Microsoft’s Enterprise Integration Management (EIM) technologies, built on the foundation of SQL Server 2012, provide a scalable, user-driven solution that empowers organizations to unlock the business value of their data.
DownloadDownloadOverview of SQL Server Integration Services enabling organizations to integrate and consolidate data from any industry standard third party sources.
SQL Server 2012 Integration Services Datasheet
Overview of SQL Server Integration Services enabling organizations to integrate and consolidate data from any industry standard third party sources.
DownloadDownloadOverview of SQL Server 2012 Private Cloud solutions.
SQL Server 2012 Private Cloud Poster
Overview of SQL Server 2012 Private Cloud solutions.
DownloadDownloadThe Dell Quickstart Data Warehouse Appliance with SQL Server 2012 is built on the proven Microsoft SQL Server 2012 Fast Track Data Warehouse Reference Architecture.
SQL Server 2012 Dell Quickstart Data Warehouse Appliance Datasheet
The Dell Quickstart Data Warehouse Appliance with SQL Server 2012 is built on the proven Microsoft SQL Server 2012 Fast Track Data Warehouse Reference Architecture.
DownloadDownloadLearn more about BI solutions for mid-market companies.
Putting Data to Work for Mid-Market Companies
Learn more about BI solutions for mid-market companies.
Download
Featured Documents
DownloadThis kit is ideal for developers who want to understand how to take advantage of the key improvements, and for developers who are new to SQL Server.
SQL Server 2008 R2 Developer Training Kit
This kit is ideal for developers who want to understand how to take advantage of the key improvements, and for developers who are new to SQL Server.
DownloadDownloadThis two-hour clinic explores the capabilities of SQL Server 2008 R2 Parallel Data Warehouse. In this clinic, you will learn about: Examining Parallel Data Warehouse Core Concepts, Designing and Implementing Data Models for Parallel Data Warehouse, Querying and Loading Data, and Managing the Parallel Data Warehouse.
SQL Server 2008 R2 Parallel Data Warehouse
This two-hour clinic explores the capabilities of SQL Server 2008 R2 Parallel Data Warehouse. In this clinic, you will learn about: Examining Parallel Data Warehouse Core Concepts, Designing and Implementing Data Models for Parallel Data Warehouse, Querying and Loading Data, and Managing the Parallel Data Warehouse.
Download
DownloadThe Dell Parallel Data Warehouse Appliance is built on Microsoft® SQL Server® 2008 R2 Parallel Data Warehouse technology, and provides a scalable, high-performance data warehousing solution that can be implemented quickly and cost-effectively.
Dell Parallel Data Warehouse Appliance Datasheet
The Dell Parallel Data Warehouse Appliance is built on Microsoft® SQL Server® 2008 R2 Parallel Data Warehouse technology, and provides a scalable, high-performance data warehousing solution that can be implemented quickly and cost-effectively.
DownloadDownloadMicrosoft provides a range of solutions to help customers address big data challenges. Our family of data warehouse solutions offer a robust and scalable platform for storing and analyzing data in a traditional data warehouse.
Microsoft Big Data Solution Sheet
Microsoft provides a range of solutions to help customers address big data challenges. Our family of data warehouse solutions offer a robust and scalable platform for storing and analyzing data in a traditional data warehouse.
DownloadDownloadThis kit is ideal for developers who want to understand how to take advantage of the key improvements, and for developers who are new to SQL Server.
SQL Server 2008 R2 Developer Training Kit
This kit is ideal for developers who want to understand how to take advantage of the key improvements, and for developers who are new to SQL Server.
DownloadDownloadOverview diagram of how to optimize SQL Server 2008 R2 for private cloud.
SQL Server 2008 R2 for Private Cloud Poster
Overview diagram of how to optimize SQL Server 2008 R2 for private cloud.
DownloadDownloadThis two-hour clinic explores the capabilities of SQL Server 2008 R2 Parallel Data Warehouse. In this clinic, you will learn about: Examining Parallel Data Warehouse Core Concepts, Designing and Implementing Data Models for Parallel Data Warehouse, Querying and Loading Data, and Managing the Parallel Data Warehouse.
SQL Server 2008 R2 Parallel Data Warehouse
This two-hour clinic explores the capabilities of SQL Server 2008 R2 Parallel Data Warehouse. In this clinic, you will learn about: Examining Parallel Data Warehouse Core Concepts, Designing and Implementing Data Models for Parallel Data Warehouse, Querying and Loading Data, and Managing the Parallel Data Warehouse.
DownloadDownloadThis two-hour clinic explores the capabilities of Microsoft SQL Server 2008 R2 StreamInsight and covers the following topics: StreamInsight core concepts, querying stream-based events, designing and working with event models, hosting queries and configuring adapters.
Introduction to Microsoft SQL Server 2008 R2 StreamInsight
This two-hour clinic explores the capabilities of Microsoft SQL Server 2008 R2 StreamInsight and covers the following topics: StreamInsight core concepts, querying stream-based events, designing and working with event models, hosting queries and configuring adapters.
DownloadDownloadDuring this clinic, you will gain an understanding of the Windows Azure platform, learn how to optimize your applications, and learn how to migrate to SQL Azure.
Introduction to Microsoft SQL Azure
During this clinic, you will gain an understanding of the Windows Azure platform, learn how to optimize your applications, and learn how to migrate to SQL Azure.
DownloadDownloadIn this clinic, you will learn about new Self-Service Analysis, Self-Service Report Authoring, and the enhanced Report Visualization features in SQL Server 2008 R2.
SQL Server 2008 R2 Managed Self-Service Business Intelligence
In this clinic, you will learn about new Self-Service Analysis, Self-Service Report Authoring, and the enhanced Report Visualization features in SQL Server 2008 R2.
DownloadDownloadGain an understanding of the role of master data and quality master data. See how to design a master data solution and gain an approach into implementing one.
Introduction to SQL Server 2008 R2 Master Data Services
Gain an understanding of the role of master data and quality master data. See how to design a master data solution and gain an approach into implementing one.
DownloadDownloadAfter completing this lab, you will be able to: Extract a data tier application. Upgrade a SQL Server schema.
MSDN Virtual Lab: Extracting and Upgrading a Data Tier Application with SQL Server 2008 R2 (Level 100)
After completing this lab, you will be able to: Extract a data tier application. Upgrade a SQL Server schema.
DownloadDownloadThis white paper focuses on why organizations need master data management and how SQL Server 2008 R2 Master Data Services addresses the master data management problem.
An Introduction to Master Data Services
This white paper focuses on why organizations need master data management and how SQL Server 2008 R2 Master Data Services addresses the master data management problem.
DownloadDownloadNecessary tools to gain centralized insights into instance and database application utilization as well as a better way to develop, deploy, and manage data-tier applications.
Introduction to Application and Multi-Server Management
Necessary tools to gain centralized insights into instance and database application utilization as well as a better way to develop, deploy, and manage data-tier applications.
DownloadDownloadMicrosoft’s investments in application and multi-server management will help reduce the complexity around developing, deploying, and managing applications.
Data-Tier Applications in Microsoft SQL Server 2008 R2
Microsoft’s investments in application and multi-server management will help reduce the complexity around developing, deploying, and managing applications.
DownloadDownloadStreamInsight™ allows software developers to create complex and innovative CEP solutions along two scenarios: (1) building packaged event-driven applications for low latency processing and (2) developing custom event-driven applications for businesses with high throughput, low latency needs.
Introducing Microsoft StreamInsight
StreamInsight™ allows software developers to create complex and innovative CEP solutions along two scenarios: (1) building packaged event-driven applications for low latency processing and (2) developing custom event-driven applications for businesses with high throughput, low latency needs.
DownloadDownloadSQL Server 2008 R2 helps organizations improve IT and developer efficiency. Simply put, it redefines how organizations deliver and succeed with BI.
Microsoft SQL Server 2008 R2 Business Intelligence
SQL Server 2008 R2 helps organizations improve IT and developer efficiency. Simply put, it redefines how organizations deliver and succeed with BI.
DownloadDownloadMicrosoft SQL Server 2008 R2 builds on the enterprise-class manageability capabilities of earlier releases, and introduces application and multi-instance management for improved efficiencies around managing resources at scale and data-tier application deployments and upgrades.
Microsoft SQL Server 2008 R2 Manageability
Microsoft SQL Server 2008 R2 builds on the enterprise-class manageability capabilities of earlier releases, and introduces application and multi-instance management for improved efficiencies around managing resources at scale and data-tier application deployments and upgrades.
DownloadDownloadSQL Server 2008 R2 Enterprise is a comprehensive data platform that provides built-in security, availability, and scalability features coupled with robust BI functionality.
Empowering Enterprise Solutions with Microsoft SQL Server 2008 R2
SQL Server 2008 R2 Enterprise is a comprehensive data platform that provides built-in security, availability, and scalability features coupled with robust BI functionality.
DownloadDownloadSQL 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.
SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2
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.
DownloadDownloadThis whitepaper provides detailed steps for planning and implementing SQL Server virtualization. Manage a SQL Server virtual environment with SQL Server native capabilities and System Center products such as (VMM) 2008 R2, Configuration Manager 2007 R2, Operations Manager 2007 R2 and Data Protection Manager 2010.
Plan, Implement and Support Virtualization with Windows Server 2008 R2 Hyper-V and Live Migration
This whitepaper provides detailed steps for planning and implementing SQL Server virtualization. Manage a SQL Server virtual environment with SQL Server native capabilities and System Center products such as (VMM) 2008 R2, Configuration Manager 2007 R2, Operations Manager 2007 R2 and Data Protection Manager 2010.
DownloadDownloadLearn more about Report Builder 3.0, including features such as maps, sparklines, data bars, and indicators
Report Builder 3.0
Learn more about Report Builder 3.0, including features such as maps, sparklines, data bars, and indicators
DownloadDownloadAnswers to frequently asked questions about the improvements for database administrators in application and multi-server management.
Application and Multi-Server Management
Answers to frequently asked questions about the improvements for database administrators in application and multi-server management.
DownloadDownloadAnswers to frequently asked questions about Microsoft's innovative StreamInsight platform.
StreamInsight
Answers to frequently asked questions about Microsoft's innovative StreamInsight platform.
DownloadDownloadAnswers to frequently asked questions about the processes and tools in SQL Server 2008 R2 that create a true "master set" of reference data.
Master Data Services
Answers to frequently asked questions about the processes and tools in SQL Server 2008 R2 that create a true "master set" of reference data.
DownloadDownloadUnderstand 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.
PowerPivot
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.
DownloadDownloadScale up to 1 petabyte at low cost? Find out how and get answers to other frequently asked questions about massively parallel processing.
Parallel Data Warehouse FAQ
Scale up to 1 petabyte at low cost? Find out how and get answers to other frequently asked questions about massively parallel processing.
DownloadDownloadDelivers several breakthrough capabilities that will enable your organization to scale database operations with confidence and improve IT and developer efficiency
SQL Server 2008 R2 Datasheet
Delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence and improve IT and developer efficiency
DownloadDownloadLearn about the key features in SQL Server 2008 R2 that make it possible for you to scale from tens to hundreds of terabytes
SQL Server 2008 R2 Parallel Data Warehouse Datasheet
Learn about the key features in SQL Server 2008 R2 that make it possible for you to scale from tens to hundreds of terabytes
DownloadDownloadManage by intent, not by chance. Get the facts about the new utility explorer in SQL Server Management Studio.
SQL Server 2008 R2 Application and Multi-Instance Management
Manage by intent, not by chance. Get the facts about the new utility explorer in SQL Server Management Studio.
DownloadDownloadProcess large volumes of complex events with low latency using the StreamInsight data platform
SQL Server StreamInsight
Process large volumes of complex events with low latency using the StreamInsight data platform
DownloadDownloadView the features that empower your users and increase IT efficiency. Includes a section on sharing and collaborating securely via Microsoft SharePoint.
SQL Server 2008 R2 Business Intelligence
View the features that empower your users and increase IT efficiency. Includes a section on sharing and collaborating securely via Microsoft SharePoint.
DownloadDownloadLearn more about the top features for Master Data Services in SQL Server 2008 R2.
SQL Server 2008 R2 Master Data Services
Learn more about the top features for Master Data Services in SQL Server 2008 R2.
DownloadDownloadTransform your data analysis within Microsoft Excel. Learn about how PowerPivot empowers decision making while meeting security and compliance requirements
Give Your Data Meaning: PowerPivot for Excel 2010
Transform your data analysis within Microsoft Excel. Learn about how PowerPivot empowers decision making while meeting security and compliance requirements
DownloadDownloadMicrosoft SQL Server PowerPivot technology gives users the ability to analyze massive quantities of data, and its seamless integration with Microsoft SharePoint Server 2010 helps IT departments monitor and manage how users collaborate.
SQL Server 2008 R2 PowerPivot Datasheet
Microsoft SQL Server PowerPivot technology gives users the ability to analyze massive quantities of data, and its seamless integration with Microsoft SharePoint Server 2010 helps IT departments monitor and manage how users collaborate.
DownloadDownloadRead 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.
SQL Server 2008 R2 High-Availability Technologies Datasheet
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.
DownloadDownloadFind out the top Datacenter features that SQL Server delivers with R2, such as how to lower costs through optimization and consolidation.
SQL Server 2008 R2 Datacenter Edition Datasheet
Find out the top Datacenter features that SQL Server delivers with R2, such as how to lower costs through optimization and consolidation.
DownloadDownloadWith a built-in management console, 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
SQL Server 2008 R2 Manageability Datasheet
With a built-in management console, 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
DownloadDownloadThis 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).
SQL Server 2008 R2 Editions Overview
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).
DownloadDownloadView our roadmap to obtaining maximum business insight from data. Includes proof points from current customers in the mid-market space.
SQL Server 2008 R2 Enterprise for Mid-Market Organizations
View our roadmap to obtaining maximum business insight from data. Includes proof points from current customers in the mid-market space.
DownloadDownloadAccelerate report creation, facilitate sharing and collaboration, and enable your organization to deliver relevant information to the people who need it.
SQL Server 2008 R2 Reporting Services Overview
Accelerate report creation, facilitate sharing and collaboration, and enable your organization to deliver relevant information to the people who need it.
DownloadDownloadServer consolidation allows you to take advantage of value-added capabilities. Meet more of your business needs while reducing server and storage requirements.
SQL Server 2008 R2 Server Consolidation Overview
Server consolidation allows you to take advantage of value-added capabilities. Meet more of your business needs while reducing server and storage requirements.
DownloadDownloadSQL 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.
Ten Reasons to Choose SQL Server 2008 R2 Enterprise Edition
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.
DownloadDownloadVirtualization with SQL Server 2008 R2 contributes to an agile database infrastructure.
SQL Server 2008 R2 Virtualization Overview
Virtualization with SQL Server 2008 R2 contributes to an agile database infrastructure.
DownloadDownloadOceans of data demand a comprehensive platform. Introducing SQL Server 2008 R2 - the next generation of computing.
SQL Server 2008 R2 Overview
Oceans of data demand a comprehensive platform. Introducing SQL Server 2008 R2 - the next generation of computing.
DownloadDownloadThese two videos introduce the benefits of PowerPivot, both for your line-of-business employees and your IT department.
PowerPivot for Excel 2010 Part 1
These two videos introduce the benefits of PowerPivot, both for your line-of-business employees and your IT department.
DownloadDownloadGet them working together by enabling self-service analysis.
PowerPivot for Excel 2010 Part 2
Get them working together by enabling self-service analysis.
DownloadDownloadDonald Farmer of Microsoft reviews master data management as moving from reference data to a system of processes supporting this
Introducing SQL Server Master Data Services
Donald Farmer of Microsoft reviews master data management as moving from reference data to a system of processes supporting this
DownloadDownloadInsider interview with Torsten Grabs who discusses StreamInsight.
SQL Server 2008 R2 Featuring StreamInsight
Insider interview with Torsten Grabs who discusses StreamInsight.
DownloadDownloadInsider interview with Madhan Arumugam who discusses SQL Server 2008 R2 virtualization features.
Virtualization Features in SQL Server 2008 R2
Insider interview with Madhan Arumugam who discusses SQL Server 2008 R2 virtualization features.
DownloadDownloadInsider interview with Julie Stauss, who discusses the new Analysis Services features in SQL Server 2008 R2, including PowerPivot for Excel.
Analysis Services in SQL Server 2008 R2
Insider interview with Julie Stauss, who discusses the new Analysis Services features in SQL Server 2008 R2, including PowerPivot for Excel.
DownloadDownloadInsider interview with Shawn Bice who discusses Multi-Server Management features in SQL Server 2008 R2.
Multi-Server Management Features in SQL Server 2008 R2
Insider interview with Shawn Bice who discusses Multi-Server Management features in SQL Server 2008 R2.
DownloadDownloadInsider Interview with Tobias Ternstrom who discusses some of the new web development features in SQL Server 2008 R2, including PHP driver support.
Web Development Features in SQL Server 2008 R2
Insider Interview with Tobias Ternstrom who discusses some of the new web development features in SQL Server 2008 R2, including PHP driver support.
DownloadDownloadInsider interview with Roger Sanborn who discusses the new features available in Report Builder 3.0.
Report Builder 3.0 Features
Insider interview with Roger Sanborn who discusses the new features available in Report Builder 3.0.
DownloadDownloadInsider interview with Il-Sung Lee, who discusses some of the new security features in SQL Server 2008 R2, including SQL Server Audit.
SQL Server 2008 R2 Security Features
Insider interview with Il-Sung Lee, who discusses some of the new security features in SQL Server 2008 R2, including SQL Server Audit.
DownloadDownloadInsider Interview with David Robinson, who discusses the features and benefits of SQL Azure.
SQL Azure Features and Benefits
Insider Interview with David Robinson, who discusses the features and benefits of SQL Azure.
DownloadDownloadIan Marritt of Altius, a Microsoft Gold Certified Partner, reviews what master data is and how you can start leveraging processes to utilize this information.
An Introduction to Master Data Services
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.
DownloadDownloadAnthony Howcroft of Microsoft EMEA reviews data warehousing capabilities in SQL Server 2008 R2 and introduces Fast Track data warehousing (“Madison”).
Data Warehouse on a Fast Track Forwards
Anthony Howcroft of Microsoft EMEA reviews data warehousing capabilities in SQL Server 2008 R2 and introduces Fast Track data warehousing (“Madison”).
DownloadDownloadChris 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.
I Need My Reports…Yesterday!
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.
DownloadSQL Server 2008 R2 - It's All About You
Reporting Services Video
DownloadSQL Server 2008 R2 - Saves Time
Reporting Services Video
DownloadDownloadThomas 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.
Introducing Project “Madison”
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.
DownloadDownloadRob 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.
Introduction to Microsoft StreamInsight
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.
DownloadDownloadDr. John Tunnicliffe, Business Intelligence Consultant with Bovi, talks about the processes he uses to transform IT into BI his clients can actually use.
Introduction to the Microsoft BI Technology Stack
Dr. John Tunnicliffe, Business Intelligence Consultant with Bovi, talks about the processes he uses to transform IT into BI his clients can actually use.
DownloadDownloadDonald Farmer of Microsoft relates the R2 features to the expanded capabilities in Business Intelligence.
Microsoft SQL Server 2008 R2: What's New in Reporting Services
Donald Farmer of Microsoft relates the R2 features to the expanded capabilities in Business Intelligence.
DownloadDownloadAndrew 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.
Report Builder 3.0
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.
DownloadDownloadDonald Farmer of Microsoft introduces PowerPivot for Excel 2010 and gives a technical approach to the business of analytics in his SQLBits 2009 Keynote address.
Self-Service Business Intelligence with PowerPivot
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.
DownloadDownloadBob Duffy, SQL Server MVP and Database Architect at Prodata, introduces PowerPivot for Excel 2010 and the use case for IT Pros.
Self-Service Business Intelligence: Project “Gemini”
Bob Duffy, SQL Server MVP and Database Architect at Prodata, introduces PowerPivot for Excel 2010 and the use case for IT Pros.
DownloadDownloadAt 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.
The R2 Duo - SQL Server 2008 R2 running on Windows Server 2008 R2 Core
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.
DownloadDownloadJoin 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.
Virtualizing SQL Server
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.
DownloadDownloadDiscover how to centrally manage critical data assets, make it possible for more people to manage master data securely, and help ensure data integrity with Master Data Services.
Master Data Services
Discover how to centrally manage critical data assets, make it possible for more people to manage master data securely, and help ensure data integrity with Master Data Services.
DownloadDownloadGet a high-level overview of key SQL Server 2008 R2 features such as Managed Self-Service BI, Master Data Services, StreamInsight, Application and Multi-Server Management, and Live Migration with Windows Server 2008 R2.
SQL Server 2008 R2 Overview
Get a high-level overview of key SQL Server 2008 R2 features such as Managed Self-Service BI, Master Data Services, StreamInsight, Application and Multi-Server Management, and Live Migration with Windows Server 2008 R2.
DownloadDownloadThe Business Intelligence engineering team have prototyped a new concept that couples the Silverlight PivotViewer control with a utility that uses Reporting Services to automatically generate collections. We showcased this concept at the BI conference in New Orleans with overwhelming support and interest from our community and are making this demo and related components available here for you to sample.
PivotViewer extension for SQL Server Reporting Services
The Business Intelligence engineering team have prototyped a new concept that couples the Silverlight PivotViewer control with a utility that uses Reporting Services to automatically generate collections. We showcased this concept at the BI conference in New Orleans with overwhelming support and interest from our community and are making this demo and related components available here for you to sample.
DownloadDownloadFind out how to give users the power to gain deeper business insights and to share their findings easily and securely with PowerPivot for Excel and SharePoint.
PowerPivot for Excel and SharePoint
Find out how to give users the power to gain deeper business insights and to share their findings easily and securely with PowerPivot for Excel and SharePoint.
DownloadDownloadSee how to create visualizations and data comparisons right out of the box with Microsoft SQL Server 2008 R2 Reporting Services and Report Builder 3.0.
SSRS and Report Builder 3.0
See how to create visualizations and data comparisons right out of the box with Microsoft SQL Server 2008 R2 Reporting Services and Report Builder 3.0.
DownloadDownloadLearn how to gain visibility across the application lifecycle and proactively manage database environments with the Application and Multi-Server Management feature in SQL Server 2008 R2.
Application and Multi-Server Management
Learn how to gain visibility across the application lifecycle and proactively manage database environments with the Application and Multi-Server Management feature in SQL Server 2008 R2.
DownloadDownloadWalk through each key step to migrate from Oracle to Microsoft SQL Server.
Migrating from Oracle to SQL Server
Walk through each key step to migrate from Oracle to Microsoft SQL Server.
DownloadDownloadDiscover how to deploy a scalable and reliable data warehouse platform to enable Business Intelligence solutions at the lowest possible cost using Parallel Data Warehouse.
Parallel Data Warehouse
Discover how to deploy a scalable and reliable data warehouse platform to enable Business Intelligence solutions at the lowest possible cost using Parallel Data Warehouse.
DownloadDownloadLearn about SQL Server tools for authoring, management, and delivery of reports, including Map Visualization Creation and Query Designer. See how to publish reports in SharePoint or embedded in ASP .NET applications.
Develop Rich Reporting Solutions with Microsoft SQL Server 2008 R2.
Learn about SQL Server tools for authoring, management, and delivery of reports, including Map Visualization Creation and Query Designer. See how to publish reports in SharePoint or embedded in ASP .NET applications.
DownloadDownloadLearn ways to connect core systems seamlessly, inside and outside your organization, with Microsoft BizTalk Server 2009, Master Data Services, and StreamInsight Complex Event Processing (CEP).
SQL Server 2008 R2 and BizTalk Server
Learn ways to connect core systems seamlessly, inside and outside your organization, with Microsoft BizTalk Server 2009, Master Data Services, and StreamInsight Complex Event Processing (CEP).
DownloadDownloadSee how to monitor, analyze, and act on data in motion to make informed business decisions in real time with StreamInsight Complex Event Processing (CEP).
StreamInsight Complex Event Processing
See how to monitor, analyze, and act on data in motion to make informed business decisions in real time with StreamInsight Complex Event Processing (CEP).
DownloadDownloadSee ways to reduce deployment time and adapt to changes in hardware utilization or capacity requirements quickly, with minimal downtime, using SQL Server and Windows Server 2008 R2 Hyper-V Live Migration.
Business Continuity with SQL Server and Windows Server 2008 R2 Hyper-V Live Migration
See ways to reduce deployment time and adapt to changes in hardware utilization or capacity requirements quickly, with minimal downtime, using SQL Server and Windows Server 2008 R2 Hyper-V Live Migration.
DownloadDownloadLearn about Web-facing versus hosted database solutions, fault tolerance and backup, seamless synchronization, and helpful development tools included in Microsoft SQL Azure.
Introduction to SQL Azure
Learn about Web-facing versus hosted database solutions, fault tolerance and backup, seamless synchronization, and helpful development tools included in Microsoft SQL Azure.
DownloadDownloadGet an overview of Microsoft's Business Intelligence Consolidation story. This comprehensive BI solution delivers the necessary technologies for accelerated BI and Performance Management from a single source.
Lower Costs through BI Consolidation
Get an overview of Microsoft's Business Intelligence Consolidation story. This comprehensive BI solution delivers the necessary technologies for accelerated BI and Performance Management from a single source.
DownloadDownloadSQL Server 2008 R2 Data Warehouse Appliance provides a cost-effective, ready-to-use, light footprint solution, for small and midsize data mart and data warehouse implementation requiring agility, light concurrency, and high performance for data volumes of up to 5 terabytes (TBs).
SQL Server 2008 R2 Data Warehouse Appliance Licensing Overview
SQL Server 2008 R2 Data Warehouse Appliance provides a cost-effective, ready-to-use, light footprint solution, for small and midsize data mart and data warehouse implementation requiring agility, light concurrency, and high performance for data volumes of up to 5 terabytes (TBs).
DownloadDownloadMicrosoft® Business Intelligence Appliance 2012 provides a cost-effective, ready-to-use business intelligence (BI) solution with Microsoft SQL Server® 2008 R2 database software and Microsoft SharePoint® Server 2010 for small and midsize businesses and enterprise departments.
Microsoft Business Intelligence Appliance 2012 Licensing Overview
Microsoft® Business Intelligence Appliance 2012 provides a cost-effective, ready-to-use business intelligence (BI) solution with Microsoft SQL Server® 2008 R2 database software and Microsoft SharePoint® Server 2010 for small and midsize businesses and enterprise departments.
DownloadDownloadLearn how to easily synchronize between SQL Azure and On-Premise SQL Server Databases using SQL Azure DataSync.
SQL Azure DataSync Datasheet
Learn how to easily synchronize between SQL Azure and On-Premise SQL Server Databases using SQL Azure DataSync.
Download
Microsoft SQL Server 2008 provides a trusted, productive, and intelligent data platform that enables you to run your most demanding mission-critical applications, reduce time and cost of development and management of applications, and deliver actionable insight to your entire organization. For additional resources, please visit SQL Server on MSDN or SQL Server 2008 on TechNet .
Why upgrade from Microsoft® SQL Server® 2008 to SQL Server 2008 R2?
SQL Server 2008 R2 is the most powerful SQL Server version yet. Two new editions—Microsoft® SQL Server® 2008 R2 Datacenter and Microsoft® SQL Server® 2008 R2 Parallel Data Warehouse—provide premium performance and scalability features at a low cost of ownership.
Get SQL Server 2008 R2
| Top Highlights | 2008 | | 2008 R2 |
|---|
| Transparent Data Encryption | | | |
| SSAS Performance and Scale | | | |
| Microsoft Hyper-V Live Migration | | | |
| PowerPivot for Microsoft SharePoint | | | |
| Report Builder 3.0 | | | |
DownloadEnabling organizations to derive insights from streaming information in near real-time
SQL Server 2008 StreamInsight Datasheet
Enabling organizations to derive insights from streaming information in near real-time
DownloadDownloadUpgrading from SQL Server 2008, SQL Server 2005, and SQL Server 2000—Your Data, Any Place, Any Time
Why Upgrade Datasheet
Upgrading from SQL Server 2008, SQL Server 2005, and SQL Server 2000—Your Data, Any Place, Any Time
DownloadDownloadMicrosoft® SQL Server® 2008 provides a scalable BI platform optimized for data integration, reporting, and analysis enabling organizations to deliver intelligence where users want it.
SQL Server 2008 Business Intelligence Datasheet
Microsoft® SQL Server® 2008 provides a scalable BI platform optimized for data integration, reporting, and analysis enabling organizations to deliver intelligence where users want it.
DownloadDownloadRealize impressive savings by consolidating on SQL Server 2008, an enterprise-class, low-cost, feature-rich, and easy-to-use data platform.
SQL Server 2008 Server Consolidation Datasheet
Realize impressive savings by consolidating on SQL Server 2008, an enterprise-class, low-cost, feature-rich, and easy-to-use data platform.
DownloadDownloadMicrosoft® SQL Server® 2008 provides growing databases with the tools and features necessary to optimize performance, scale-up individual servers and scale-out for very large databases.
SQL Server 2008 Performance and Scalability Datasheet
Microsoft® SQL Server® 2008 provides growing databases with the tools and features necessary to optimize performance, scale-up individual servers and scale-out for very large databases.
DownloadDownloadMicrosoft® SQL Server® 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications which ultimately helps end users make better decisions.
SQL Server 2008 Spatial Data Datasheet
Microsoft® SQL Server® 2008 delivers comprehensive spatial support that enables organizations to seamlessly consume, use, and extend location-based data through spatial-enabled applications which ultimately helps end users make better decisions.
DownloadDownloadMicrosoft® SQL Server® 2008 is a comprehensive data platform that provides the scalability, availability, security, and manageability that you need for mission-critical OLTP applications.
SQL Server 2008 OLTP Datasheet
Microsoft® SQL Server® 2008 is a comprehensive data platform that provides the scalability, availability, security, and manageability that you need for mission-critical OLTP applications.
DownloadWhy Upgrade to SQL Server 2008 R2
DownloadDownloadThis white paper examines the main reasons why customers might not want to implement Oracle Real Application Clusters (RAC) in their database solutions. This paper also describes common database scenarios where a Microsoft SQL Server may provide a better solution than Oracle RAC and explains some of the common myths or misunderstandings about Oracle RAC.
Why SQL Server May Be More Suitable for You than Oracle RAC
This white paper examines the main reasons why customers might not want to implement Oracle Real Application Clusters (RAC) in their database solutions. This paper also describes common database scenarios where a Microsoft SQL Server may provide a better solution than Oracle RAC and explains some of the common myths or misunderstandings about Oracle RAC.
DownloadDownloadWipro study of 68 SAP/ERP customers
Microsoft SQL Server Migration Pays Big Dividends for SAP/ERP Customers
Wipro study of 68 SAP/ERP customers
DownloadDownloadMicrosoft SQL Server 2008 Analysis Services builds on the value delivered with the significant investments in Analysis Services 2005 around scalability, advanced analytics and Microsoft Office interoperability.
SQL Server 2008 Analysis Services Overview
Microsoft SQL Server 2008 Analysis Services builds on the value delivered with the significant investments in Analysis Services 2005 around scalability, advanced analytics and Microsoft Office interoperability.
DownloadDownloadSee how capable SQL Server 2008 Express can be and how it can help you write Web sites faster.
SQL Server 2008 Express for Web Developers
See how capable SQL Server 2008 Express can be and how it can help you write Web sites faster.
DownloadDownloadUpgrading to Microsoft SQL Server 2008 R2 from Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000
Why Upgrade Whitepaper
Upgrading to Microsoft SQL Server 2008 R2 from Microsoft SQL Server 2008, SQL Server 2005, and SQL Server 2000
DownloadDownloadMicrosoft® Database Consolidation Appliance 2012 offers a complete solution for organizations that want help in reducing costs and increasing IT efficiency by consolidating database services in a scaled-out virtualized database solution.
Microsoft Database Consolidation Appliance 2012 Licensing Overview
Microsoft® Database Consolidation Appliance 2012 offers a complete solution for organizations that want help in reducing costs and increasing IT efficiency by consolidating database services in a scaled-out virtualized database solution.
Download
Microsoft SQL Server 2005 is a comprehensive, integrated data management and analysis software that enables organizations to reliably manage information and run business applications. SQL Server 2005 allows companies to gain insight from their business information. For additional resources, please visit SQL Server on MSDN or SQL Server 2005 on TechNet .
Being aware of your support milestones can help you ensure you have the right level of support and the right version of SQL for your business. In April 2011, SQL Server 2005 will transition from Mainstream Support to Extended Support.
SQL Server 2005
| Top Highlights | 2005 | | 2008 |
|---|
| Database Mirroring | | | |
| Management Studio | | | |
| SSAS Performance and Scale | | | |
| Transparent Data Encryption | | | |
| Report Builder 2.0 | | | |
DownloadMicrosoft SQL Server 2005 (64-bit) offers dramatic improvements in memory availability and parallel processing performance when compared to SQL Server software running in a 32-bit environment. This paper describes the capabilities of the 64-bit solution, highlights differences from the 32-bit environment, and discusses some of the applications and usage scenarios that can benefit from running on a SQL Server platform optimized for the 64-bit environment.
Advantages of a 64-bit Environment
Microsoft SQL Server 2005 (64-bit) offers dramatic improvements in memory availability and parallel processing performance when compared to SQL Server software running in a 32-bit environment. This paper describes the capabilities of the 64-bit solution, highlights differences from the 32-bit environment, and discusses some of the applications and usage scenarios that can benefit from running on a SQL Server platform optimized for the 64-bit environment.
DownloadDownloadWith SQL Server 2005, Analysis Services provides, for the first time, a unified and integrated view of all your business data as the foundation for all of your traditional reporting, OLAP analysis, Key Performance Indicator (KPI)scorecards and data mining.
Analysis Services Datasheet
With SQL Server 2005, Analysis Services provides, for the first time, a unified and integrated view of all your business data as the foundation for all of your traditional reporting, OLAP analysis, Key Performance Indicator (KPI)scorecards and data mining.
DownloadDownloadSQL Server™ 2005 is designed to help enterprises address these challenges by providing a robust, scalable Data Warehouse platform that enables organizations to build data warehouses quickly with the enterprise ready ETL platform, manage their data with the scalable and manageable relational data platform and deliver business insight and information with the Microsoft® BI platform.
Data Warehousing Datasheet
SQL Server™ 2005 is designed to help enterprises address these challenges by providing a robust, scalable Data Warehouse platform that enables organizations to build data warehouses quickly with the enterprise ready ETL platform, manage their data with the scalable and manageable relational data platform and deliver business insight and information with the Microsoft® BI platform.
DownloadDownloadMicrosoft® SQL Server™ 2005 Workgroup Edition is the easy to use, affordable, and simple to manage database for small organizations or workgroups within larger enterprises.
SQL Server 2005 Workgroup Edition Datasheet
Microsoft® SQL Server™ 2005 Workgroup Edition is the easy to use, affordable, and simple to manage database for small organizations or workgroups within larger enterprises.
DownloadDownloadReport Builder, a new component of Microsoft SQL Server 2005 Reporting Services, allows business users to create their own reports using a user-friendly model of their data. Report Builder leverages the Reporting Services platform to bring ad hoc reporting to all end users
SQL Server 2005 Reporting Services Report Builder Overview
Report Builder, a new component of Microsoft SQL Server 2005 Reporting Services, allows business users to create their own reports using a user-friendly model of their data. Report Builder leverages the Reporting Services platform to bring ad hoc reporting to all end users
DownloadDownloadThis guide highlights the most important aspects of Microsoft SQL Server 2005. It is intended to help reviewers assess the scope and functionality of the SQL Server 2005 data management and analysis platform. This guide assumes that you are familiar with the basic features of enterprise databases and business intelligence solutions.
SQL Server 2005 Product Guide
This guide highlights the most important aspects of Microsoft SQL Server 2005. It is intended to help reviewers assess the scope and functionality of the SQL Server 2005 data management and analysis platform. This guide assumes that you are familiar with the basic features of enterprise databases and business intelligence solutions.
DownloadDownloadMicrosoft® SQL Server™ 2005 Express Edition is the free, easy-to-use, lightweight, and embeddable version of SQL Server, the leading relational database management system.
SQL Server Express Datasheet
Microsoft® SQL Server™ 2005 Express Edition is the free, easy-to-use, lightweight, and embeddable version of SQL Server, the leading relational database management system.
DownloadDownloadReport Builder, a new component of Microsoft SQL Server 2005 Reporting Services, allows business users to create their own reports using a user-friendly model of their data. Report Builder leverages the Reporting Services platform to bring ad hoc reporting to all end users.
SQL Server 2005 Reporting Services Report Builder Enterprise Overview
Report Builder, a new component of Microsoft SQL Server 2005 Reporting Services, allows business users to create their own reports using a user-friendly model of their data. Report Builder leverages the Reporting Services platform to bring ad hoc reporting to all end users.
DownloadDownloadSQL Server 2005 Reporting Services extends the Microsoft Business Intelligence (BI) platform to reach the information worker who needs access to business data. Reporting Services is a server-based enterprise reporting environment, managed via web services.
SQL Server 2005 Enterprise Reporting Services Datasheet
SQL Server 2005 Reporting Services extends the Microsoft Business Intelligence (BI) platform to reach the information worker who needs access to business data. Reporting Services is a server-based enterprise reporting environment, managed via web services.
DownloadDownloadMicrosoft SQL Server 2005 Analysis Services establishes new ground for data mining. By creating an easy to use, extensible, accessible, and flexible platform, SQL Server 2005 Analysis Services’ data mining capabilities introduces data mining to organizations that previously would never have considered a data mining solution.
SQL Server 2005 Analysis Services Data Mining Overview
Microsoft SQL Server 2005 Analysis Services establishes new ground for data mining. By creating an easy to use, extensible, accessible, and flexible platform, SQL Server 2005 Analysis Services’ data mining capabilities introduces data mining to organizations that previously would never have considered a data mining solution.
DownloadDownloadThe SQL Server Integration Services platform takes the place of a popular feature in SQL Server 2000, Data Transformation Services (DTS). But SSIS is completely new for SQL Server2005, providing the features and performance necessary to build enterprise class data integration applications.
SQL Server 2005 Integration Services Datasheet
The SQL Server Integration Services platform takes the place of a popular feature in SQL Server 2000, Data Transformation Services (DTS). But SSIS is completely new for SQL Server2005, providing the features and performance necessary to build enterprise class data integration applications.
DownloadDownloadMicrosoft® SQL Server™ 2005 Compact Edition extends the Microsoft SQL Server 2005 Mobile Edition technology by offering a maintenance free, compact embedded database for single-user client applications for all Windows Platforms including Tablet PCs, Pocket PCs, Smart Phones and desktop computers.
SQL Server Compact 3.5 Overview
Microsoft® SQL Server™ 2005 Compact Edition extends the Microsoft SQL Server 2005 Mobile Edition technology by offering a maintenance free, compact embedded database for single-user client applications for all Windows Platforms including Tablet PCs, Pocket PCs, Smart Phones and desktop computers.
DownloadDownloadSQL Server 2005 is the first version of this server software released since Microsoft developed and implemented its Trustworthy Computing initiative. The software is now secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important new security features in SQL Server 2005. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
SQL Server 2005 Security Overview for Administrators
SQL Server 2005 is the first version of this server software released since Microsoft developed and implemented its Trustworthy Computing initiative. The software is now secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important new security features in SQL Server 2005. It tells you how, as an administrator, you can install SQL Server securely and keep it that way even as applications and users make use of the data stored within.
DownloadDownloadThis white paper discusses the advantages of using SQL Server 2005 in a virtual environment and the factors an organization must consider when determining whether to virtualize SQL Server 2005.
Using SQL Server 2005 in a Virtual Environment
This white paper discusses the advantages of using SQL Server 2005 in a virtual environment and the factors an organization must consider when determining whether to virtualize SQL Server 2005.
DownloadDownloadThis white paper covers some of the operational and administrative tasks associated with Microsoft® SQL Server™ 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
SQL Server 2005 Security Best Practices: Operational and Administrative Tasks
This white paper covers some of the operational and administrative tasks associated with Microsoft® SQL Server™ 2005 security and enumerates best practices and operational and administrative tasks that will result in a more secure SQL Server system.
DownloadDownloadThis white paper enumerates the connectivity options for databases with SQL Server 2005 Integration Services and mentions special considerations that are required when using some database sources with some of the more complex transformations.
Connectivity and SQL Server 2005 Integration Services
This white paper enumerates the connectivity options for databases with SQL Server 2005 Integration Services and mentions special considerations that are required when using some database sources with some of the more complex transformations.
DownloadDownloadReduce the time it takes to create reports—and take full advantage of your data—with customizable reports for Microsoft SQL Server Reporting Services. Smooth integration supports a range of common data sources from OLE DB and the Open Database Connectivity (ODBC) interface to Microsoft Office System applications.
SQL Server Reporting Services for Microsoft Dynamics GP Overview
Reduce the time it takes to create reports—and take full advantage of your data—with customizable reports for Microsoft SQL Server Reporting Services. Smooth integration supports a range of common data sources from OLE DB and the Open Database Connectivity (ODBC) interface to Microsoft Office System applications.
DownloadDownloadMicrosoft’s new tool for extract, transform, and load (ETL) addresses enterprise ETL requirements like collaborative development, dedicated administration, and server scalability. It also goes beyond ETL to include functions related to data integration, such as data quality, data profiling, and text mining. These advancements bring Microsoft out of the data utility ghetto where Data Transformation Services (DTS)played and into the enterprise ETL arena, where SQL Server Integration Services (SSIS) will compete favorably with mid-tier vendors.
Forrester Research: Microsoft Addresses Enterprise ETL
Microsoft’s new tool for extract, transform, and load (ETL) addresses enterprise ETL requirements like collaborative development, dedicated administration, and server scalability. It also goes beyond ETL to include functions related to data integration, such as data quality, data profiling, and text mining. These advancements bring Microsoft out of the data utility ghetto where Data Transformation Services (DTS)played and into the enterprise ETL arena, where SQL Server Integration Services (SSIS) will compete favorably with mid-tier vendors.
DownloadDownloadThis IDC study examines the business intelligence (BI) tools market and vendor shares for the period 2003.2005. Worldwide market sizing is provided for 2005, with trends from 2003. Geographic and operating system splits for the overall market are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2005. This study also includes profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
IDC: Worldwide Business Intelligence Tools 2005 Vendor Shares
This IDC study examines the business intelligence (BI) tools market and vendor shares for the period 2003.2005. Worldwide market sizing is provided for 2005, with trends from 2003. Geographic and operating system splits for the overall market are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2005. This study also includes profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
DownloadDownloadThe goal of this paper is to provide guidance for anyone interested in choosing a database for deploying highly available enterprise applications. The paper explores the different options available, examining the pros and cons of each. It goes behind the marketing claims to examine how customers are really using the technologies today.
Solutions for Highly Scalable Database Applications: An analysis of architectures and technologies
The goal of this paper is to provide guidance for anyone interested in choosing a database for deploying highly available enterprise applications. The paper explores the different options available, examining the pros and cons of each. It goes behind the marketing claims to examine how customers are really using the technologies today.
DownloadDownloadThis whitepaper explains the key differences between Microsoft SQL Server 2005 databases and Oracle databases. It compares SQL Server and Oracle database architecture and provides information on the newest features in SQL Server 2005. This paper is intended for Oracle professionals who want to leverage their Oracle knowledge to manage SQL Server or prepare to migrate an Oracle database to SQL Server 2005. Other topics discussed in this white paper include backups, database security, management options and high availability options.
SQL Server 2005 for Oracle Professionals
This whitepaper explains the key differences between Microsoft SQL Server 2005 databases and Oracle databases. It compares SQL Server and Oracle database architecture and provides information on the newest features in SQL Server 2005. This paper is intended for Oracle professionals who want to leverage their Oracle knowledge to manage SQL Server or prepare to migrate an Oracle database to SQL Server 2005. Other topics discussed in this white paper include backups, database security, management options and high availability options.
DownloadDownloadOverview of how technologies can work in tandem to drive successful operations.
Ventana Research: Business Intelligence Meets Business Process Management
Overview of how technologies can work in tandem to drive successful operations.
DownloadDownloadThis white paper describes how application developers can apply performance-tuning techniques to their Microsoft SQL Server 2005 Analysis Services Online Analytical Processing (OLAP) solutions.
Microsoft SQL Server 2005 Analysis Services Performance Guide
This white paper describes how application developers can apply performance-tuning techniques to their Microsoft SQL Server 2005 Analysis Services Online Analytical Processing (OLAP) solutions.
DownloadDownloadThis white paper outlines the current business and consumer environment and the key factors that influence the need for this new generation of applications. It describes how SQL Server Compact Edition can be used to satisfy the data platform demands of these applications.
Microsoft SQL Server 2005 Compact Edition Overview
This white paper outlines the current business and consumer environment and the key factors that influence the need for this new generation of applications. It describes how SQL Server Compact Edition can be used to satisfy the data platform demands of these applications.
DownloadDownloadSQL Server Enterprise Manager and Query Analyzer are combined to create a single unified tool that can be integrated with your choice of source control, creating a more flexible and manageable solution for the system administrator and the DBA. This white paper tells you how to select the best tool for the job and gives you best practices to make your use of the tools more productive from the start.
SQL Server 2005 Management Tools Overview
SQL Server Enterprise Manager and Query Analyzer are combined to create a single unified tool that can be integrated with your choice of source control, creating a more flexible and manageable solution for the system administrator and the DBA. This white paper tells you how to select the best tool for the job and gives you best practices to make your use of the tools more productive from the start.
Download