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 RC0 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 SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions.
SQL Server 2012 Licensing Datasheet
The SQL Server 2012 Editions have been streamlined to better align with how customers are deploying applications and solutions.
DownloadDownloadFAQs about SQL Server 2012 editions and licensing
SQL Server 2012 Editions and Licensing FAQ
FAQs about SQL Server 2012 editions and licensing
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 RC0 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 RC0 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2012 RC0.
SQL Server 2012 RC0 Feature Pack
The SQL Server 2012 RC0 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2012 RC0.
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.
DownloadDownloadOverview presentation of the security features in SQL Server 2012.
SQL Server 2012 Security Features Overview Presentation
Overview presentation of the security features in SQL Server 2012.
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.
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.
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
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.
DownloadDownloadOverview of how to optimize SQL Server for private cloud.
SQL Server for Private Cloud
Overview of how to optimize SQL Server 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 better able to import data into PowerPivot, create table relationships, create calculated columns, create a PivotTable report, create measures, format the PivotTable report, and publish the PowerPivot workbook to SharePoint.
MSDN Virtual Lab: Building and Sharing Your First SQL Server 2008 R2 PowerPivot for Excel Workbook (Level 100)
After completing this lab, you will be better able to import data into PowerPivot, create table relationships, create calculated columns, create a PivotTable report, create measures, format the PivotTable report, and publish the PowerPivot workbook to SharePoint.
DownloadDownloadAfter completing this lab, you will be better able to create and configure an Analysis Services project, create a data source, create a data source view, create dimensions, assemble and format a cube, and browse the cube.
MSDN Virtual Lab: Building Your First Cube with SQL Server 2008 R2 Analysis Services (Level 100)
After completing this lab, you will be better able to create and configure an Analysis Services project, create a data source, create a data source view, create dimensions, assemble and format a cube, and browse the cube.
DownloadDownloadLearn about the newest Microsoft SQL Server sales and marketing kit, intended to help you drive successful conversations about SQL Server hosting solutions.
TechNet Webcast: Microsoft SQL Server Hosting Solutions: New Resources for Hosters (Level 100)
Learn about the newest Microsoft SQL Server sales and marketing kit, intended to help you drive successful conversations about SQL Server hosting solutions.
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.
DownloadDownloadThis paper describes the comprehensive Microsoft solution for optimizing SQL Server databases for the private cloud. The paper also discusses the HP Database Consolidation Solution and how it pulls everything together.
Microsoft and HP Database Consolidation Solution for SQL Server 2008 R2 Whitepaper
This paper describes the comprehensive Microsoft solution for optimizing SQL Server databases for the private cloud. The paper also discusses the HP Database Consolidation Solution and how it pulls everything together.
DownloadDownloadThis white paper is written for a technical audience to understand the various aspects and considerations for planning consolidation with SQL Server 2008.
Server Consolidation Using Microsoft SQL Server 2008
This white paper is written for a technical audience to understand the various aspects and considerations for planning consolidation with SQL Server 2008.
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.
DownloadDownloadHealthcare Group enhances information access with powerful business intelligence tools. The tools are expected to help employees analyze huge quantities of data while providing greater control over how information is distributed.
CareGroup Healthcare System
Healthcare Group enhances information access with powerful business intelligence tools. The tools are expected to help employees analyze huge quantities of data while providing greater control over how information is distributed.
DownloadDownloadFood-service company reduces time for custom analysis from weeks to hours. The company also 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.
Large U.S. Food Service Company
Food-service company reduces time for custom analysis from weeks to hours. The company also 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.
DownloadDownloadMultichannel retailer will upgrade to SQL Server 2008 R2 Enterprise, which works with Excel 2010 for business intelligence and SharePoint Server 2010 for collaboration. The new software will consolidate data from multiple IT systems into “one version of the truth,” helping employees make decisions more quickly and reliably.
Studio Moderna
Multichannel retailer will upgrade to SQL Server 2008 R2 Enterprise, which works with Excel 2010 for business intelligence and SharePoint Server 2010 for collaboration. The new software will consolidate data from multiple IT systems into “one version of the truth,” helping employees make decisions more quickly and reliably.
DownloadDownloadPension provider integrates business data and improves collaboration between teams by implementing SQL Server 2008 R2 data management software and Office SharePoint Server 2007. The company now has integrated data from disparate sources, so employees use updated information for decision making. Employees from different teams collaborate more easily through a unified reporting and analysis process.
China Life Pension Company
Pension provider integrates business data and improves collaboration between teams by implementing SQL Server 2008 R2 data management software and Office SharePoint Server 2007. The company now has integrated data from disparate sources, so employees use updated information for decision making. Employees from different teams collaborate more easily through a unified reporting and analysis process.
DownloadDownloadSQL Server 2008 R2 helps credit card company scale and secure mission-critical systems. The upgraded deployments provide a better view of the business, enterprise-grade scalability, maintenance without scheduled downtime, and easier database management.
PREMIER Bankcard, LLC
SQL Server 2008 R2 helps credit card company scale and secure mission-critical systems. The upgraded deployments provide a better view of the business, enterprise-grade scalability, maintenance without scheduled downtime, and easier database management.
DownloadDownloadNew Zealand bank turns to new BI tools in SQL Server 2008 R2 for delivering vital branch performance data processes. With the self-service BI tools, BNZ expects to simplify and accelerate the delivery of information to branches while allowing its BI department to manage the distribution and publication of information with greater efficiency.
BNZ
New Zealand bank turns to new BI tools in SQL Server 2008 R2 for delivering vital branch performance data processes. With the self-service BI tools, BNZ expects to simplify and accelerate the delivery of information to branches while allowing its BI department to manage the distribution and publication of information with greater efficiency.
DownloadDownloadOnline retailer boosts productivity with self-service BI solution. Now, customers can access the information they need and employees can use features such as SQL Server PowerPivot for Microsoft Excel to boost productivity, raise service levels, and foster innovation.
Vente-privee.com
Online retailer boosts productivity with self-service BI solution. Now, customers can access the information they need and employees can use features such as SQL Server PowerPivot for Microsoft Excel to boost productivity, raise service levels, and foster innovation.
DownloadDownloadTheatre company easily integrates data and displays information graphically. AMC tested SQL Server 2008 R2 along with 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.
AMC Theatres
Theatre company easily integrates data and displays information graphically. AMC tested SQL Server 2008 R2 along with 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.
DownloadDownloadChevron, deployed Microsoft SQL Server 2008 R2 to provide Chevron employees with self-service analysis and report creation capabilities.
Chevron
Chevron, deployed Microsoft SQL Server 2008 R2 to provide Chevron employees with self-service analysis and report creation capabilities.
DownloadDownloadWith 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.
Mississippi Department of Transportation
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.
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
Microsoft 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
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
Microsoft 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.
Business Intelligence
View the features that empower your users and increase IT efficiency. Includes a section on sharing and collaborating securely via Microsoft SharePoint.
DownloadDownloadStandardize the data your people rely on to make critical business decisions. Read about the top new features for Master Data Services here
Master Data Services
Standardize the data your people rely on to make critical business decisions. Read about the top new features for Master Data Services here
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.
High-Availability Technologies
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.
Introducing Microsoft SQL Server 2008 R2 Datacenter Edition
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, 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
Manageability
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
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).
Microsoft 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.
Microsoft SQL Server 2008 R2 Enterprise for Mid-Market Organization
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.
Microsoft SQL Server 2008 R2 Reporting Services
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.
Server Consolidation
Server consolidation allows you to take advantage of value-added capabilities. Meet more of your business needs while reducing server and storage requirements.
DownloadDownloadMicrosoft 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.
Ten Reasons to Choose Microsoft SQL Server 2008 R2 Enterprise Edition
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.
DownloadDownloadVirtualization with SQL Server 2008 R2 contributes to an agile database infrastructure.
Virtualization
Virtualization with SQL Server 2008 R2 contributes to an agile database infrastructure.
DownloadDownloadParallel Data Warehouse offers massive scalability and low cost with a simplified appliance model.
Microsoft SQL Server 2008 R2 Parallel Data Warehouse
Parallel Data Warehouse offers massive scalability and low cost with a simplified appliance model.
DownloadDownloadThe Microsoft vision is to make SQL Server the fastest, simplest and most affordable database management system for data warehouse customers of all sizes.
SQL Server 2008 R2 Data Warehousing Overview & Vision
The Microsoft vision is to make SQL Server the fastest, simplest and most affordable database management system for data warehouse customers of all sizes.
DownloadDownloadSee how the Data-tier Application works--and how it saves your DBAs time in setup, training, and maintenance of database schema.
Application and Multi-Server Management
See how the Data-tier Application works--and how it saves your DBAs time in setup, training, and maintenance of database schema.
DownloadDownloadView this deck to understand what availability means for your company in terms of benefits and savings
Microsoft SQL Server 2008 R2 High Availability Technologies
View this deck to understand what availability means for your company in terms of benefits and savings
DownloadDownloadThis 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.
Advantages of Microsoft SQL Server 2008 R2 Enterprise Edition
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.
DownloadDownloadThe 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.
Benefits of Microsoft SQL Server 2008 R2 Enterprise Edition
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.
DownloadDownloadThis 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.
Microsoft SQL Server 2008 R2 Analysis Services
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.
DownloadDownloadSQL 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.
Microsoft SQL Server 2008 R2 Manageability
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.
DownloadDownloadAccelerate 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
Microsoft SQL Server Fast Track Data Warehouse 2.0
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
DownloadDownloadServer 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
Reduce Your Costs and Improve Your Agility with SQL Server Consolidation
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
DownloadDownloadThis 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.
SQL Server Data Warehousing Overview
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.
DownloadDownloadMicrosoft is committed to deliver an Information Platform which enables your people and provides you with a complete set of enterprise-ready technologies and tools to help you realize more value from your information at the lowest total cost of ownership.
SQL Server 2008 R2 Technical Overview
Microsoft is committed to deliver an Information Platform which enables your people and provides you with a complete set of enterprise-ready technologies and tools to help you realize more value from your information at the lowest total cost of ownership.
DownloadDownloadOceans 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
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.
DownloadDownloadView demonstrations of the newest technologies available with SQL Server 2008 R2, and learn about the possibilities for increased efficiency and cost savings.
Why Upgrade to SQL Server 2008 R2?
View demonstrations of the newest technologies available with SQL Server 2008 R2, and learn about the possibilities for increased efficiency and cost savings.
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
DownloadDownloadWendy Harms from HP talks to Microsoft partners about SQL Server 2008 R2.
SQL Server 2008 R2 Partners
Wendy Harms from HP talks to Microsoft partners about SQL Server 2008 R2.
DownloadDownloadMicrosoft partners talk about PowerPivot and SQL Server 2008 R2.
PowerPivot Partners
Microsoft partners talk about PowerPivot and SQL Server 2008 R2.
DownloadDownloadMicrosoft partners discuss Master Data Services in SQL Server 2008 R2.
Master Data Services Partners
Microsoft partners discuss Master Data Services in SQL Server 2008 R2.
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.
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.
DownloadDownloadMicrosoft® 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).
Microsoft SQL Server 2008 R2 Data Warehouse Appliance Licensing Overview
Microsoft® 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.
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.
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 | | | |
DownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
PowerEdge T610 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
HP ProLiant DL380G6 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
ES7000 Model 7600R Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
NEC Express5800/A1080a-E Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
IBM System x3850 X5 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
HP ProLiant DL385G7 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
Dell PowerEdge R910 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC-H results shown are grouped by database size to emphasize that only results within each group are comparable.
Top ten TPC-H results
The TPC-H results shown are grouped by database size to emphasize that only results within each group are comparable.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
ES7000 Model 7600R Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
ProLiant DL785 G6 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
ProLiant DL380 G6 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
ES7000 Model 7600R Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
HP Proliant DL785 G6 Benchmark Results
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadThe TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
Benchmarks
The TPC is a non-profit corporation founded to define transaction processing and database benchmarks and to disseminate objective, verifiable TPC performance data to the industry.
DownloadDownloadWe will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server. We look forward to sharing our knowledge and hearing your feedback.
SQL Server Manageability Team Blog
We will be blogging about our tools, scripts, webcasts, and miscellaneous tips that will help you get the most out of SQL Server. We look forward to sharing our knowledge and hearing your feedback.
DownloadDownloadThis is the blog of Ed Katibah, Spatial Program Manager, SQL Server, Microsoft Corporation, otherwise known as Ed's Katiblog...
MSDN Blog: Spatial Ed
This is the blog of Ed Katibah, Spatial Program Manager, SQL Server, Microsoft Corporation, otherwise known as Ed's Katiblog...
DownloadDownloadAll about the SQL Server Driver for PHP, SQL Server and PHP.
SQL Server Driver for PHP Team Blog
All about the SQL Server Driver for PHP, SQL Server and PHP.
DownloadDownloadA blog about SQL Server Integration Services (SSIS) from a developer on the team with helpful information and examples on how to use SQL Server Integration Services.
SQL Server Integration Services Team Blog
A blog about SQL Server Integration Services (SSIS) from a developer on the team with helpful information and examples on how to use SQL Server Integration Services.
DownloadDownloadThis Blog will provide information about running SAP applications on SQL Server and Windows. The Blog is written by folks of Microsoft who are working with SAP and SQL Server for more than a decade.
SAP on SQL Server Technical Blog
This Blog will provide information about running SAP applications on SQL Server and Windows. The Blog is written by folks of Microsoft who are working with SAP and SQL Server for more than a decade.
DownloadDownloadDiscussions related to Microsoft JDBC driver.
JDBC Blog
Discussions related to Microsoft JDBC driver.
DownloadDownloadOfficial News from Microsoft's Information Platform
SQL Server Team Blog
Official News from Microsoft's Information Platform
DownloadDownloadA Blog from the Microsoft SQL Server Reporting Services Team.
SQL Server Reporting Services Team Blog
A Blog from the Microsoft SQL Server Reporting Services Team.
DownloadBizIntelligence.TV Blog
Business Intelligence Team Blog
DownloadDownloadBlog by a Senior Technical Professional at Microsoft with a long background in technology. In this blog he'll help you get the most out of your computing platform.
Buck.Woody Carpe Datum Blog
Blog by a Senior Technical Professional at Microsoft with a long background in technology. In this blog he'll help you get the most out of your computing platform.
DownloadSQL Server Engine Tips
Helpful tips.
DownloadDownloadWhatever comes to mind "The official blog of the SQL Server Analysis Services Data Mining Architect" (tm)
Jamie's Junk Blog
Whatever comes to mind "The official blog of the SQL Server Analysis Services Data Mining Architect" (tm)
DownloadSQL Server Storage Engine Blog
Blog about Data Compression
DownloadDownloadDell’s SQL Server 2008 R2 solutions can boost performance, cut costs, and reduce energy consumption – making your IT leaner and greener.
Dell’s SQL Server 2008 R2 solutions
Dell’s SQL Server 2008 R2 solutions can boost performance, cut costs, and reduce energy consumption – making your IT leaner and greener.
DownloadDownloadHome Financing Center is a growing mortgage banker that needed to gain better control of its data. After replacing a difficult-to-use Oracle database with Microsoft SQL Server 2005 data management software, the director of business intelligence recovered 90 percent of his time. Now he’s standardizing other databases on SQL Server and building companywide business intelligence capabilities that will help the company stay ahead of competition.
Home Financing Center - Mortgage Lender Saves Estimated $70,000 with New Database Solution
Home Financing Center is a growing mortgage banker that needed to gain better control of its data. After replacing a difficult-to-use Oracle database with Microsoft SQL Server 2005 data management software, the director of business intelligence recovered 90 percent of his time. Now he’s standardizing other databases on SQL Server and building companywide business intelligence capabilities that will help the company stay ahead of competition.
DownloadDownloadQuanta Computer is one of the world’s largest manufacturers of laptop computers and other computing devices for the biggest names in the industry. With its SAP database supporting its global operations growing by more than half a terabyte a month, Quanta needed either to replace its SAN infrastructure or to find a compression solution. The company upgraded to Microsoft® SQL Server® 2008 Enterprise (64-bit) to take advantage of new SQL Server compression technology. SQL Server 2008 Database Compression has reduced some tables by as much as 90 percent, while SQL Server 2008 Backup Compression has provided compression of 85 percent.
Quanta Computer Gains 80 Percent Data Compression for SAP with SQL Server 2008
Quanta Computer is one of the world’s largest manufacturers of laptop computers and other computing devices for the biggest names in the industry. With its SAP database supporting its global operations growing by more than half a terabyte a month, Quanta needed either to replace its SAN infrastructure or to find a compression solution. The company upgraded to Microsoft® SQL Server® 2008 Enterprise (64-bit) to take advantage of new SQL Server compression technology. SQL Server 2008 Database Compression has reduced some tables by as much as 90 percent, while SQL Server 2008 Backup Compression has provided compression of 85 percent.
DownloadDownloadEpicor Software wanted to maximize the efficient management of its websites and better promote its brand and services. The company chose Microsoft SharePoint Server 2010 as the foundation for its intranet, extranet, and corporate websites. Content owners now update sites easily, without help from the IT department. The IT department benefits from a consolidated website environment, which results in an approximate 30 percent savings in administrative and development time and costs.
Epicor Software Sharpens Competitive Edge, Improves Processes with Unified Websites
Epicor Software wanted to maximize the efficient management of its websites and better promote its brand and services. The company chose Microsoft SharePoint Server 2010 as the foundation for its intranet, extranet, and corporate websites. Content owners now update sites easily, without help from the IT department. The IT department benefits from a consolidated website environment, which results in an approximate 30 percent savings in administrative and development time and costs.
DownloadDownloadTÜV NORD Group sought a way to simplify remote access to IT resources. Mobile employees also needed an easier way to work with the company’s mission-critical customer relationship management system from SAP. And with databases growing by approximately 100 gigabytes a month, TÜV NORD needed an effective data-compression tool. In 2007, the company addressed its challenges with Windows Server® 2008, Microsoft® SQL Server® 2008, and Microsoft Visual Studio® 2008. As a result of its new solutions, TÜV NORD is saving money, accelerating remote-access setup, speeding application development, and boosting system security and availability.
TUV NORD group
TÜV NORD Group sought a way to simplify remote access to IT resources. Mobile employees also needed an easier way to work with the company’s mission-critical customer relationship management system from SAP. And with databases growing by approximately 100 gigabytes a month, TÜV NORD needed an effective data-compression tool. In 2007, the company addressed its challenges with Windows Server® 2008, Microsoft® SQL Server® 2008, and Microsoft Visual Studio® 2008. As a result of its new solutions, TÜV NORD is saving money, accelerating remote-access setup, speeding application development, and boosting system security and availability.
DownloadDownloadMicrosoft® SQL Server® 2008 Express is a free edition of SQL Server ideal for learning, developing and powering desktop and small server applications and for redistribution by ISVs.
SQL Server 2008 Express Datasheet
Microsoft® SQL Server® 2008 Express is a free edition of SQL Server ideal for learning, developing and powering desktop and small server applications and for redistribution by ISVs.
DownloadDownloadMicrosoft® SQL Server® provides database developers with a powerful set of new and improved features for efficiently creating next generation applications that manage any type of data.
SQL Server 2008 Programmability Datasheet
Microsoft® SQL Server® provides database developers with a powerful set of new and improved features for efficiently creating next generation applications that manage any type of data.
DownloadDownloadEnabling 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 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.
SQL Server 2008 Analysis Services Datasheet
Microsoft® SQL Server® 2008 helps enable organizations to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar tools.
DownloadDownloadUpgrading to Microsoft® SQL Server® 2008 provides you with next-generation database capabilities built on the trusted fundamentals of Microsoft® SQL Server®.
SQL Server 2005 to 2008 Upgrade Datasheet
Upgrading to Microsoft® SQL Server® 2008 provides you with next-generation database capabilities built on the trusted fundamentals of Microsoft® SQL Server®.
DownloadDownloadMicrosoft® SQL Server® 2008 is at the heart of a comprehensive data platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data services across the enterprise.
SQL Server 2008 Application Development Datasheet
Microsoft® SQL Server® 2008 is at the heart of a comprehensive data platform that enables you to access and manipulate business-critical data from a variety of diverse devices, platforms, and data services across the enterprise.
DownloadDownloadMicrosoft® SQL Server® 2008 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 and SQL Server instances.
SQL Server 2008 Manageability Data Sheet
Microsoft® SQL Server® 2008 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 and SQL Server instances.
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.
DownloadDownloadMicrosoft® SQL Server® 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources.
SQL Server 2008 Integration Services Datasheet
Microsoft® SQL Server® 2008 provides a scalable enterprise data integration platform with exceptional ETL and integration capabilities, enabling organizations to more easily manage data from a wide array of data sources.
DownloadDownloadMicrosoft® SQL Server® 2008 Always On Technologies provides a full range of options to minimize downtime and maintain appropriate levels of application availability.
SQL Server 2008 High Availability Datasheet
Microsoft® SQL Server® 2008 Always On Technologies provides a full range of options to minimize downtime and maintain appropriate levels of application availability.
DownloadDownloadMicrosoft® SQL Server® 2008 offers security feature enhancements that help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.
SQL Server 2008 Security Datasheet
Microsoft® SQL Server® 2008 offers security feature enhancements that help provide effective management of security feature configuration, strong authentication and access control, powerful encryption and key management capabilities, and enhanced auditing.
DownloadDownloadChoose Microsoft® SQL Server® 2008 as your optimal database for deploying highly available, high performance, and reliable SAP® installations of all sizes on the Microsoft platform. SQL Server 2008 can run the most demanding and critical SAP applications, allowing you to share and leverage company information, and deliver actionable insight to your company. It also provides scalability and security to meet the database needs of SAP customers.
SAP on SQL Server 2008 Datasheet
Choose Microsoft® SQL Server® 2008 as your optimal database for deploying highly available, high performance, and reliable SAP® installations of all sizes on the Microsoft platform. SQL Server 2008 can run the most demanding and critical SAP applications, allowing you to share and leverage company information, and deliver actionable insight to your company. It also provides scalability and security to meet the database needs of SAP customers.
DownloadUse Compression to Improve Query Performance
Video of compression benefits
DownloadDownloadVideo of backup compression benefits
Accelerate Backup With Backup Compression
Video of backup compression benefits
DownloadDownloadVideo of change data capture benefits
Change Data Capture
Video of change data capture benefits
DownloadStarJoinQuery Optimization
Video of StarJoinQuery benefits
DownloadDownloadThe definitive guide to automating SQL Server administration with Powershell scripts
SQL Server 2008 Administration
The definitive guide to automating SQL Server administration with Powershell scripts
DownloadDownloadFrom the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.
Microsoft SQL Server 2008
From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press®-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals.
DownloadDownloadPro SQL Server 2008 Mirroring is part of Apress’ two-pronged approach to high-availability in the SQL Server space. It is a focused and deep book on mirroring that perfectly complements Apress’ upcoming book no failover clustering. Taken together, the combination of Pro SQL Server 2008 Mirroring and Pro SQL Server 2008 Failover Clustering deliver the deepest and most authoritative content for those charged with the stressful and demanding task of ensuring that their SQL Server databases are up and running all of the time, no matter what.
Pro SQL Server 2008 Mirroring (Expert's Voice in SQL Server)
Pro SQL Server 2008 Mirroring is part of Apress’ two-pronged approach to high-availability in the SQL Server space. It is a focused and deep book on mirroring that perfectly complements Apress’ upcoming book no failover clustering. Taken together, the combination of Pro SQL Server 2008 Mirroring and Pro SQL Server 2008 Failover Clustering deliver the deepest and most authoritative content for those charged with the stressful and demanding task of ensuring that their SQL Server databases are up and running all of the time, no matter what.
DownloadWhy Upgrade to SQL Server 2008 R2
DownloadDownloadView broadcasts from Eric Hanson on Channel 9
Eric Hanson Broadcasts on Channel 9
View broadcasts from Eric Hanson on Channel 9
DownloadDownloadVideo by Baldwin Ng on Assessment and Planning Toolkit 3.1
Assessment and Planning Toolkit 3.1 for SQL Server 2008 Migration
Video by Baldwin Ng on Assessment and Planning Toolkit 3.1
DownloadDownloadPass Summit 2008 Keynote from David J. Dewitt
Pass Summit 2008 Keynote from David J. Dewitt
Pass Summit 2008 Keynote from David J. Dewitt
DownloadDownloadPass Summit 2008 Keynote from Ted Kummert
Pass Summit 2008 Keynote from Ted Kummert
Pass Summit 2008 Keynote from Ted Kummert
DownloadDownloadPass Summit 2008 Keynote from Tom Casey
Pass Summit 2008 Keynote from Tom Casey
Pass Summit 2008 Keynote from Tom Casey
DownloadDownloadLearn More About Microsoft Parallel Data Warehouse Solutions
SQL Server 2008 Parallel Data Warehouse Solutions
Learn More About Microsoft Parallel Data Warehouse Solutions
DownloadDownloadScale-up to the largest servers in the world with support for 256 logical processors
WinHec Keynote by Bill Laing
Scale-up to the largest servers in the world with support for 256 logical processors
DownloadBuilding Occasionally Connected Systems
Video by Chris Henley
DownloadChange Data Capture
Video by Bryan Von Axelson
DownloadDatabase Mirroring
Video by Bryan Von Axelson
DownloadDimension Designer and Best Practice Alerts
Video by Chris Henley
DownloadPolicy-Based Management
Video by Bryan Von Axelson
DownloadExtended Events (Xevents)
Video by Bryan Von Axelson
DownloadHierarchyID
Video by Chris Henley
DownloadNew Date/Time Data Types
Video by Chris Henley
DownloadReporting Services Enhancements
Video by Bryan Von Axelson
DownloadTable Value and Merge Statements
Video by Chris Henley
DownloadXML Enhancements
Video by Chris Henley
DownloadDownloadThis video demonstrates how to define and deploy an OLAP cube using Analysis Services.
Training Video: Defining and Deploying a Cube (SQL Server Video)
This video demonstrates how to define and deploy an OLAP cube using Analysis Services.
DownloadDownloadOrganizational Best Practices for Implementing Analysis Services
Training Video: Implementing Best Practices for Large Analysis Services Databases
Organizational Best Practices for Implementing Analysis Services
DownloadDownloadTune in to these webcasts and learn more about the security advancements and high-availability capabilities in SQL Server 2008. You can view webcasts live or stream or download them to view on demand.
Webcast: Supporting HIPAA Compliance with SQL Server 2008
Tune in to these webcasts and learn more about the security advancements and high-availability capabilities in SQL Server 2008. You can view webcasts live or stream or download them to view on demand.
DownloadDownloadAfter completing this lab, you will be better able to create a report using the Table Wizard, publish report parts, create a report using the Map Wizard, and introduce report parts into a report.
MSDN Virtual Lab: Building and Sharing Your First Report Builder 3.0 Report (Level 100)
After completing this lab, you will be better able to create a report using the Table Wizard, publish report parts, create a report using the Map Wizard, and introduce report parts into a report.
DownloadDownloadAfter completing this lab, you will be better able to connect to the ReportService2010 Web service, invoke the ReportService2010 Web service’s ListChildren method, and configure the ReportViewer control in remote processing mode.
MSDN Virtual Lab: Building Your First Analytical Reporting Application with the Visual Studio 2010 ReportViewer Control (Level 100)
After completing this lab, you will be better able to connect to the ReportService2010 Web service, invoke the ReportService2010 Web service’s ListChildren method, and configure the ReportViewer control in remote processing mode.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
24 hours of SQL Server 2008
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
Application Development with SQL Server 2008
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
Business Intelligence Webcast
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
Data Warehousing with SQL Server 2008
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadNow more than ever, you need to get the right information to the right person, faster, and in an easy-to-consume format. Learn more about Microsoft's comprehensive and fully integrated set of business intelligence (BI) technologies that can help you reduce the complexity of organizing and distributing information, enable better business decisions, and improve your bottom line.
Microsoft Business Intelligence: Thinking Bigger About BI
Now more than ever, you need to get the right information to the right person, faster, and in an easy-to-consume format. Learn more about Microsoft's comprehensive and fully integrated set of business intelligence (BI) technologies that can help you reduce the complexity of organizing and distributing information, enable better business decisions, and improve your bottom line.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
Mission-Critical Applications for Online Transaction Processing (OLTP)
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadWatch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
Server Consolidation with SQL Server 2008
Watch a webcast and get ready for the next release of Microsoft SQL Server. Tune in and see how SQL Server 2008 allows you to manage, monitor, secure, and optimize consolidated data systems effectively. We show you how to consolidate servers with multiple databases, consolidate data services through virtualization, and migrate databases easily.
DownloadDownloadAttend this webcast to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries.
MSDN Webcast: Building Spatial Applications with SQL Server 2008 (Level 300)
Attend this webcast to learn how to use spatial functionality in next version of SQL Server to build and optimize spatial queries.
DownloadDownloadJoin us to learn about the high-availability capabilities in Microsoft SQL Server 2005 and get a peek into the enhancements in the Microsoft SQL Server 2008 release.
TechNet Webcast: Overview of SQL Server Availability Features and Upcoming Improvements (Level 200)
Join us to learn about the high-availability capabilities in Microsoft SQL Server 2005 and get a peek into the enhancements in the Microsoft SQL Server 2008 release.
DownloadDownloadPayment Card Industry Data Security Standards (PCI DSS) is a preventative standard intended to reduce the risk of payment card fraud and information theft. In this webcast, we discuss how to confirm that PCI requirements are applied when implementing Microsoft SQL Server 2008 technology and why it is important to implement SQL Server based on PCI DSS standards.
TechNet Webcast: SQL Server 2008 Capabilities for Meeting PCI Compliance Needs (Level 200)
Payment Card Industry Data Security Standards (PCI DSS) is a preventative standard intended to reduce the risk of payment card fraud and information theft. In this webcast, we discuss how to confirm that PCI requirements are applied when implementing Microsoft SQL Server 2008 technology and why it is important to implement SQL Server based on PCI DSS standards.
DownloadDownloadIn this webcast, we provide an in-depth introduction to the new auditing feature introduced in Microsoft SQL Server 2008. We also discuss and demonstrate end-to-end use cases and scenarios for the SQL Server Audit feature.
TechNet Webcast: Security Talk: Auditing in SQL Server 2008 (Level 300)
In this webcast, we provide an in-depth introduction to the new auditing feature introduced in Microsoft SQL Server 2008. We also discuss and demonstrate end-to-end use cases and scenarios for the SQL Server Audit feature.
DownloadDownloadIn this webcast, we introduce Dynamic Management Views, and drill down into many examples of their usage. Join us to learn not only which views are available, but also how to build effective queries, reports, and even cubes that you can use to understand and monitor the behaviour of your Analysis Services servers.
TechNet Webcast: Advanced Manageability for SQL Server 2008 Analysis Services (Level 300)
In this webcast, we introduce Dynamic Management Views, and drill down into many examples of their usage. Join us to learn not only which views are available, but also how to build effective queries, reports, and even cubes that you can use to understand and monitor the behaviour of your Analysis Services servers.
DownloadDownloadIn this webcast, learn about the Data Mining Add-ins for the 2007 Office system, and see exciting demonstrations that highlight these enhancements to Microsoft Office Excel 2007 functionality that is accessible by any user.
TechNet Webcast: Data Mining Add-ins for the 2007 Office System (Level 200)
In this webcast, learn about the Data Mining Add-ins for the 2007 Office system, and see exciting demonstrations that highlight these enhancements to Microsoft Office Excel 2007 functionality that is accessible by any user.
DownloadDownloadIn this webcast, we review the new features in Analysis Services that may help Contoso accelerate development and achieve optimal performance.
TechNet Webcast: 24 Hours of SQL Server 2008: AS Design and Performance Improvements (Level 200)
In this webcast, we review the new features in Analysis Services that may help Contoso accelerate development and achieve optimal performance.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
Migrate from Microsoft Access
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
Migrate from MySQL
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
Migrate from Oracle
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Oracle to SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Sybase ASE to SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.
Migrate from Sybase
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Sybase ASE to SQL Server 2005, SQL Server 2008 and 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
DownloadDownloadThis white paper provides an overview of the connectivity options that are available with SQL Server 2008 Integration Services.
Connectivity Options for Microsoft® SQL Server® 2008 Integration Services
This white paper provides an overview of the connectivity options that are available with SQL Server 2008 Integration Services.
DownloadDownloadThe SAP SD standard mySAP ERP 2004 application benchmark performed on October 24, 2005 by HP in Houston, TX,
SAP Standard Application Benchmarks Certification
The SAP SD standard mySAP ERP 2004 application benchmark performed on October 24, 2005 by HP in Houston, TX,
DownloadDownloadThis video will help you get started with the Data Mining Table Analysis Tools add-in for Excel by showing you how to open the tools, use the sample Excel data, and connect to an Analysis Services server.
Getting Started with the Table Analysis Tools for Excel
This video will help you get started with the Data Mining Table Analysis Tools add-in for Excel by showing you how to open the tools, use the sample Excel data, and connect to an Analysis Services server.
DownloadDownloadIn this tutorial you will learn how to use the Forecast Table Analysis Tool for Excel. The Forecast tool uses the Microsoft time series algorithm to predict future values based on trends in existing time series data.
Forecast Table Analysis Tool
In this tutorial you will learn how to use the Forecast Table Analysis Tool for Excel. The Forecast tool uses the Microsoft time series algorithm to predict future values based on trends in existing time series data.
DownloadDownloadIn this tutorial you will learn how to use the Prediction Calculator Table Analysis Tool for Excel. This tool generates both interactive and printable calculators for scoring new data against a desired outcome.
Prediction Calculator Table Analysis Tool
In this tutorial you will learn how to use the Prediction Calculator Table Analysis Tool for Excel. This tool generates both interactive and printable calculators for scoring new data against a desired outcome.
DownloadDownloadIn this tutorial you will learn how to use the Analyze Key Influencers Table Analysis Tool for Excel. The Analyze Key Influencers tool uses the Microsoft Clustering algorithm to enable you to select a column that contains a desired outcome or target value, and then analyze the patterns in your data to determine which factors had the strongest influence on that outcome
Analyze Key Influencers Table Analysis Tool
In this tutorial you will learn how to use the Analyze Key Influencers Table Analysis Tool for Excel. The Analyze Key Influencers tool uses the Microsoft Clustering algorithm to enable you to select a column that contains a desired outcome or target value, and then analyze the patterns in your data to determine which factors had the strongest influence on that outcome
DownloadDownloadIn this tutorial you will learn how to use the Shopping Basket Analysis Table Analysis Tool for Microsoft Excel. The Shopping Basket Analysis tool uses the Microsoft Association Rules algorithm to detect the relationship of items frequently purchased together.
Shopping Basket Table Analysis Tool for Data Mining
In this tutorial you will learn how to use the Shopping Basket Analysis Table Analysis Tool for Microsoft Excel. The Shopping Basket Analysis tool uses the Microsoft Association Rules algorithm to detect the relationship of items frequently purchased together.
DownloadDownloadIn this tutorial we will learn how to use the Fill From Example Table Analysis Tool for Excel.
Fill From Example Table Analysis Tool
In this tutorial we will learn how to use the Fill From Example Table Analysis Tool for Excel.
DownloadDownloadIn this tutorial we will learn how to use the Detect Categories Table Analysis Tool for Excel.
Detect Categories Table Analysis Tool
In this tutorial we will learn how to use the Detect Categories Table Analysis Tool for Excel.
DownloadDownloadIn this tutorial we will learn how to use the Highlight Exceptions Table Analysis Tool for Excel. The Highlight Exceptions tool uses the Microsoft clustering algorithm and pattern analysis to find values in a dataset that are atypical.
Highlight Exceptions Table Analysis Tool for Data Mining
In this tutorial we will learn how to use the Highlight Exceptions Table Analysis Tool for Excel. The Highlight Exceptions tool uses the Microsoft clustering algorithm and pattern analysis to find values in a dataset that are atypical.
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.
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 | | | |
DownloadThe company, which runs Oracle databases for operational systems, decided to deploy a new data warehouse using Microsoft® SQL Server™ 2005 running on an HP Integrity Superdome server equipped with Intel Itanium processors.
Barnes & Noble Gains Business Insights Across Sales Channels with New Data Warehouse
The company, which runs Oracle databases for operational systems, decided to deploy a new data warehouse using Microsoft® SQL Server™ 2005 running on an HP Integrity Superdome server equipped with Intel Itanium processors.
DownloadDownloadSaddled with a home-grown business-management tool originally designed for its retail business, the growing business unit sought a solution that would support its extensive outside sales force and would provide a commercial CRM solution it could sell to business customers. Best Buy for Business found both in Microsoft Dynamics™ CRM.
Best Buy Supports New Line of Business and World-Class Sales Force
Saddled with a home-grown business-management tool originally designed for its retail business, the growing business unit sought a solution that would support its extensive outside sales force and would provide a commercial CRM solution it could sell to business customers. Best Buy for Business found both in Microsoft Dynamics™ CRM.
DownloadDownloadBT, one of the world’s leading telecommunications operators, wanted to centralise its Microsoft® Office Access databases to improve performance and manageability of its Access-based applications. Using Microsoft SQL Server™ Migration Assistant (SSMA) for Access, BT successfully migrated 60 databases from Access to a centralised SQL Server system in a single day.
BT Saves 60 Days’ Work and Achieves Rapid Database Migration with New Conversion Tool
BT, one of the world’s leading telecommunications operators, wanted to centralise its Microsoft® Office Access databases to improve performance and manageability of its Access-based applications. Using Microsoft SQL Server™ Migration Assistant (SSMA) for Access, BT successfully migrated 60 databases from Access to a centralised SQL Server system in a single day.
DownloadDownloadBallard Power Systems, a world leader in fuel cell development, needed to give its researchers faster, fuller insights into manufacturing and test processes and data, in order to cut time-to-market and increase competitiveness. Ballard plans to achieve its goals—including a 30 percent cut in time-to-market—with a business intelligence solution for manufacturing, based on Incuity EMI software from Microsoft® Gold Certified Partner Incuity Software.
Fuel Cell Maker Cuts Time-to-Market Up to 30 Percent with Business Intelligence Solution
Ballard Power Systems, a world leader in fuel cell development, needed to give its researchers faster, fuller insights into manufacturing and test processes and data, in order to cut time-to-market and increase competitiveness. Ballard plans to achieve its goals—including a 30 percent cut in time-to-market—with a business intelligence solution for manufacturing, based on Incuity EMI software from Microsoft® Gold Certified Partner Incuity Software.
DownloadDownloadBuilding upon the success of an earlier deployment of SAP running on Microsoft® SQL Server™ 2000, chose SQL Server 2005 Enterprise Edition (64-bit) for its Global SAP System. When SAP has been fully deployed to all organizations within FUJIFILM Group, SQL Server 2005 will be supporting several terabytes of data. FFCS has found that SQL Server 2005 is easy to manage, and provides the scalability the global organization needs.
FUJIFILM Supports Multi-terabyte SAP Deployment with Microsoft SQL Server 2005
Building upon the success of an earlier deployment of SAP running on Microsoft® SQL Server™ 2000, chose SQL Server 2005 Enterprise Edition (64-bit) for its Global SAP System. When SAP has been fully deployed to all organizations within FUJIFILM Group, SQL Server 2005 will be supporting several terabytes of data. FFCS has found that SQL Server 2005 is easy to manage, and provides the scalability the global organization needs.
DownloadDownloadIt upgraded to SQL Server 2005 Enterprise Edition running on Intel® Xeon® processor based servers to gain the high availability benefits of SQL Server 2005 Database Mirroring, which creates a continually updated copy of data to a separate server for disaster recovery.
Global IT Services Company Protects SAP with SQL Server 2005 Database Mirroring
It upgraded to SQL Server 2005 Enterprise Edition running on Intel® Xeon® processor based servers to gain the high availability benefits of SQL Server 2005 Database Mirroring, which creates a continually updated copy of data to a separate server for disaster recovery.
DownloadDownloadSAP software is mission critical to the Missiles and Fire Control unit of global aerospace manufacturer Lockheed Martin, which wanted to significantly reduce the costs of its deployment while improving its performance. Its solution: migrate the SAP infrastructure from Reduced Instruction Set Computing (RISC) platforms running UNIX to the Microsoft® Windows Server® 2003 operating system and Microsoft SQL Server™ 2005 on Intel technologies.
Lockheed Martin Unit Moves SAP from UNIX to Windows, Cuts Technology Cost 41%
SAP software is mission critical to the Missiles and Fire Control unit of global aerospace manufacturer Lockheed Martin, which wanted to significantly reduce the costs of its deployment while improving its performance. Its solution: migrate the SAP infrastructure from Reduced Instruction Set Computing (RISC) platforms running UNIX to the Microsoft® Windows Server® 2003 operating system and Microsoft SQL Server™ 2005 on Intel technologies.
DownloadDownload When Navitaire’s existing reservation system was approaching the limits of its processing capabilities for some of its largest customers, a change was needed. Navitaire upgraded to a solution using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit) running on Intel-based 8-CPU 64-bit database servers. To address this need, the company developed a new reservation system, using Microsoft Visual Studio® 2005 and the Microsoft .NET Framework.
Mission-Critical Airline Reservation System deployed on SQL Server 2005
When Navitaire’s existing reservation system was approaching the limits of its processing capabilities for some of its largest customers, a change was needed. Navitaire upgraded to a solution using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit) running on Intel-based 8-CPU 64-bit database servers. To address this need, the company developed a new reservation system, using Microsoft Visual Studio® 2005 and the Microsoft .NET Framework.
DownloadDownloadThe Alaska Department of Revenue, Permanent Fund Dividend (PFD) Division, managed a multitude of disconnected and continually failing technologies, housing several terabytes of data, with only a six-person IT staff. It needed a new data infrastructure to support its operations, which includes the distribution of between U.S.$500 million and a billion in dividends to approximately 630,000 Alaskans each year. Using Microsoft® SQL Server™ 2005 Enterprise Edition, the organization’s new data warehouse contains 15 million images of historical and current documents, and has the ability to scale to support the roughly 3 million images added each year.
New Data Warehouse to Buoy 7 Terabytes for State of Alaska
The Alaska Department of Revenue, Permanent Fund Dividend (PFD) Division, managed a multitude of disconnected and continually failing technologies, housing several terabytes of data, with only a six-person IT staff. It needed a new data infrastructure to support its operations, which includes the distribution of between U.S.$500 million and a billion in dividends to approximately 630,000 Alaskans each year. Using Microsoft® SQL Server™ 2005 Enterprise Edition, the organization’s new data warehouse contains 15 million images of historical and current documents, and has the ability to scale to support the roughly 3 million images added each year.
DownloadDownloadNetwork Appliance, IBM, and Microsoft have collaborated on a TPC-C transaction processing benchmark for a 16-way, 64-bit Intel Xeon MP-based computer using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit). The system, priced at a total of U.S.$3.14 million, achieved 492,307 tpmC, with a cost per tpmC of $6.37. This benchmark demonstrates the performance of SQL Server 2005 on NetApp RAID-DP storage systems and IBM’s new eServer xSeries 460. In addition, it shows how SQL Server 2005 is able to exploit technology advances from key vendors like Intel, IBM, and Network Appliance to deliver advances in performance and cost efficiency.
New Database Benchmark Hits Enterprise "Sweet Spot"
Network Appliance, IBM, and Microsoft have collaborated on a TPC-C transaction processing benchmark for a 16-way, 64-bit Intel Xeon MP-based computer using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit). The system, priced at a total of U.S.$3.14 million, achieved 492,307 tpmC, with a cost per tpmC of $6.37. This benchmark demonstrates the performance of SQL Server 2005 on NetApp RAID-DP storage systems and IBM’s new eServer xSeries 460. In addition, it shows how SQL Server 2005 is able to exploit technology advances from key vendors like Intel, IBM, and Network Appliance to deliver advances in performance and cost efficiency.
DownloadDownloadThe company needed to ensure high availability of its services, and increase its scalability to keep up with its rapid growth. The company upgraded its database to Microsoft® SQL Server™ 2005 Enterprise Edition Service Pack 1. The company uses the Database Mirroring feature of SQL Server 2005 to mirror its data at a geographically separate disaster recovery datacenter to help ensure high availability. ServiceU has reduced the need for scheduled downtime through use of SQL Server 2005 Online Indexing. Scalability has been enhanced as the move to SQL Server 2005 has helped reduce CPU utilization.
Online Event Software Gets Disaster Recovery with SQL Server 2005 Database Mirroring
The company needed to ensure high availability of its services, and increase its scalability to keep up with its rapid growth. The company upgraded its database to Microsoft® SQL Server™ 2005 Enterprise Edition Service Pack 1. The company uses the Database Mirroring feature of SQL Server 2005 to mirror its data at a geographically separate disaster recovery datacenter to help ensure high availability. ServiceU has reduced the need for scheduled downtime through use of SQL Server 2005 Online Indexing. Scalability has been enhanced as the move to SQL Server 2005 has helped reduce CPU utilization.
DownloadDownloadThe company generates so much data, typically held for 40 days, that it needed a more efficient way to delete aged data because the process was slowing its system for several hours each day. Gomez upgraded its central 2.7-terabyte database to Microsoft® SQL Server™ 2005 Enterprise Edition. The Table Partitioning feature of SQL Server 2005 enables Gomez to perform daily deletions (about 280 million rows of data age off the system each day) in seconds that used to require several hours—enhancing the user experience while giving new life to existing resources.
Web Monitoring Firm Enhances Management of 2.7 Terabyte Database with SQL Server
The company generates so much data, typically held for 40 days, that it needed a more efficient way to delete aged data because the process was slowing its system for several hours each day. Gomez upgraded its central 2.7-terabyte database to Microsoft® SQL Server™ 2005 Enterprise Edition. The Table Partitioning feature of SQL Server 2005 enables Gomez to perform daily deletions (about 280 million rows of data age off the system each day) in seconds that used to require several hours—enhancing the user experience while giving new life to existing resources.
DownloadDownloadMicrosoft 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.
DownloadDownloadThis IDC study examines the BI tools market for the period from 2004 to 2006.Worldwide market size is provided for 2006, with trends from 2004. Geographic region splits for the overall market and its sub segments are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2006. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
IDC: Competitive Analysis Worldwide BI Tools 2006 Vendor Shares
This IDC study examines the BI tools market for the period from 2004 to 2006.Worldwide market size is provided for 2006, with trends from 2004. Geographic region splits for the overall market and its sub segments are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2006. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
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.
DownloadDownloadThis IDC study examines the relational DBMS market for the period from 2005 to2007. Worldwide market size is provided for 2007, with trends from 2006. Revenue and market share of the leading vendors is provided for 2007. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
IDC: Competitive Analysis Worldwide Relational Database Management Systems 2007 Vendor Share
This IDC study examines the relational DBMS market for the period from 2005 to2007. Worldwide market size is provided for 2007, with trends from 2006. Revenue and market share of the leading vendors is provided for 2007. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
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.
DownloadDownloadMicrosoft Dynamics™ is a line of financial, customer relationship and supply chain management solutions that help organizations work more effectively. Delivered through a network of channel partners providing specialized services, these integrated, adaptable business solutions work like and with familiar Microsoft software to streamline processes across an entire business.
SQL Server 2005 for Microsoft Dynamics AX Key Facts Datasheet
Microsoft Dynamics™ is a line of financial, customer relationship and supply chain management solutions that help organizations work more effectively. Delivered through a network of channel partners providing specialized services, these integrated, adaptable business solutions work like and with familiar Microsoft software to streamline processes across an entire business.
DownloadDownloadThe data platform of choice for Microsoft Dynamics TM GP deployments, Microsoft® SQL Server TM 2005 offers enhanced availability of information, performance, and ease of operation to drive business intelligence, data management, and developer productivity.
SQL Server 2005 for Microsoft Dynamics GP Key Facts Datasheet
The data platform of choice for Microsoft Dynamics TM GP deployments, Microsoft® SQL Server TM 2005 offers enhanced availability of information, performance, and ease of operation to drive business intelligence, data management, and developer productivity.
DownloadDownloadMicrosoft Dynamics™ is a line of financial, customer relationship and supply chain management solutions that help organizations work more effectively. Delivered through a network of channel partners providing specialized services, these integrated, adaptable business solutions work like and with familiar Microsoft software to streamline processes across an entire business.
SQL Server 2005 for Microsoft Dynamics NAV Key Facts Datasheet
Microsoft Dynamics™ is a line of financial, customer relationship and supply chain management solutions that help organizations work more effectively. Delivered through a network of channel partners providing specialized services, these integrated, adaptable business solutions work like and with familiar Microsoft software to streamline processes across an entire business.
DownloadDownloadThe next release of SQL Server is designed to help enterprises address these challenges. SQL Server 2005 is Microsoft’s next generation data management and analysis solution that will deliver increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage.
SQL Server 2005 Overview
The next release of SQL Server is designed to help enterprises address these challenges. SQL Server 2005 is Microsoft’s next generation data management and analysis solution that will deliver increased security, scalability, and availability to enterprise data and analytical applications while making them easier to create, deploy, and manage.
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.
DownloadDownloadMicrosoft has implemented strong security features into the Microsoft® SQL Server™ 2005, which provides a security-enabled platform for enterprise-class relational database and analysis solutions. SQL Server 2005 provides cutting edge security technology and addresses several security issues, including automatic secured updates and encryption of sensitive data.
SQL Server 2005 Security Overview
Microsoft has implemented strong security features into the Microsoft® SQL Server™ 2005, which provides a security-enabled platform for enterprise-class relational database and analysis solutions. SQL Server 2005 provides cutting edge security technology and addresses several security issues, including automatic secured updates and encryption of sensitive data.
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.
DownloadDownloadThis IDC study examines the relational DBMS market for the period from 2005 to2007. Worldwide market size is provided for 2007, with trends from 2006. Revenue and market share of the leading vendors is provided for 2007. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
IDC Competitive Analysis: Worldwide Relational Database Management Systems 2007 Vendor Shares
This IDC study examines the relational DBMS market for the period from 2005 to2007. Worldwide market size is provided for 2007, with trends from 2006. Revenue and market share of the leading vendors is provided for 2007. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
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.
DownloadDownloadMicrosoft® SQL Server™ 2005 redefines the capabilities that customers should expect from their Database Management System. SQL Server 2005 is designed to help organizations reliably and securely manage enterprise servers. By automating routine tasks, SQL Server 2005 helps lower the cost of ongoing maintenance with increased efficiency and provides deeper insight into system health for monitoring, tuning and optimization.
SQL Server 2005 Manageability Overview
Microsoft® SQL Server™ 2005 redefines the capabilities that customers should expect from their Database Management System. SQL Server 2005 is designed to help organizations reliably and securely manage enterprise servers. By automating routine tasks, SQL Server 2005 helps lower the cost of ongoing maintenance with increased efficiency and provides deeper insight into system health for monitoring, tuning and optimization.
DownloadDownloadSiebel and Microsoft have a longstanding technical and sales alliance. Siebel has selected Microsoft .NET as the best way to deliver the new generation of Web services applications. Siebel is taking advantage of Microsoft’s web services and .NET software, and Microsoft is leveraging Siebel’s leading customer-relationship management(CRM) capabilities.
SQL Server 2005 for Siebel Deployments Overview
Siebel and Microsoft have a longstanding technical and sales alliance. Siebel has selected Microsoft .NET as the best way to deliver the new generation of Web services applications. Siebel is taking advantage of Microsoft’s web services and .NET software, and Microsoft is leveraging Siebel’s leading customer-relationship management(CRM) capabilities.
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.
DownloadDownloadThis 350-page document contains guidance for SQL Server administrators, developers, and IT decision makers who would like to move their SQL Server 2000 or 7.0 databases to SQL Server 2005.
SQL Server 2005 Upgrade Technical Reference Guide
This 350-page document contains guidance for SQL Server administrators, developers, and IT decision makers who would like to move their SQL Server 2000 or 7.0 databases to SQL Server 2005.
DownloadDownloadA case study on the comparative costs of database administration for two of the premier enterprise relational database management systems.
SQL Server and Oracle Total Cost of Administration (TCA) Comparative Study
A case study on the comparative costs of database administration for two of the premier enterprise relational database management systems.
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.
DownloadDownloadWith SQL Server 2005, users and IT professionals across your organization will benefit from reduced application downtime, increased scalability and performance, and tight yet flexible security controls. SQL Server 2005 also includes many new and improved capabilities to help make your IT staff more productive.
What's New in SQL Server 2005
With SQL Server 2005, users and IT professionals across your organization will benefit from reduced application downtime, increased scalability and performance, and tight yet flexible security controls. SQL Server 2005 also includes many new and improved capabilities to help make your IT staff more productive.
DownloadDownloadThis paper will examine the differences between the security posture of Microsoft’s SQL Server and Oracle’s RDBMS based upon flaws reported by external security researchers and since fixed by the vendor in question. Only flaws affecting the database server software itself have been considered in compiling this data so issues that affect, for example, Oracle Application Server have not been included.
Which Database is More Secure?
This paper will examine the differences between the security posture of Microsoft’s SQL Server and Oracle’s RDBMS based upon flaws reported by external security researchers and since fixed by the vendor in question. Only flaws affecting the database server software itself have been considered in compiling this data so issues that affect, for example, Oracle Application Server have not been included.
DownloadDownloadAce your preparation for the skills measured by MCITP Exam 70-441—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Prep for MCITP (Exam 70-441): Designing Database Solutions by Using Microsoft SQL Server 2005
Ace your preparation for the skills measured by MCITP Exam 70-441—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
DownloadDownloadAce your preparation for the skills measured by MCTS Exam 70-445—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
Prep for MCTS (Exam 70-445): Microsoft SQL Server 2005 Business Intelligence—Implementation and Maintenance
Ace your preparation for the skills measured by MCTS Exam 70-445—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Custom Components.
SQL Server 2005 Integration Services Custom Components Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Custom Components.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Custom Scripting.
SQL Server 2005 Integration Services Custom Scripting Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Custom Scripting.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Data Quality Services.
SQL Server 2005 Integration Services Data Quality Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Data Quality Services.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Data Warehouse Smarts.
SQL Server 2005 Integration Services Data Warehouse Smarts Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Data Warehouse Smarts.
DownloadDownloadSelf-guided tour of SQL Server 2005 Analysis Services.
SQL Server 2005 Analysis Services: Delivering Business Insight at Every Desktop
Self-guided tour of SQL Server 2005 Analysis Services.
DownloadDownloadSelf-guided tour of SQL Server 2005 Analysis Services.
SQL Server 2005 Analysis Services: Developing an Enterprise-Scale Analysis Services Solution
Self-guided tour of SQL Server 2005 Analysis Services.
DownloadDownloadSelf-guided tour of SQL Server 2005 Analysis Services.
SQL Server 2005 Analysis Services: Extending the Solution with Comprehensive Analytics
Self-guided tour of SQL Server 2005 Analysis Services.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services.
SQL Server 2005 Integration Services: Heterogeneous Data Connectivity Guided Tour
Self-guided tour of SQL Server 2005 Integration Services.
DownloadDownloadLesson 1: Overview and Installation
SQL Server 2005 Migration Assistant for Access (SSMA)
Lesson 1: Overview and Installation
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 1: What is a database?
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 10: Getting Started with Reporting Services
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 11: Building and Customizing Reports in Business Intelligence Development Studio
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 12: Creating and Using Stored Procedures
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 13: Enabling Full-Text Search in your Text Data
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 2: Migration Process and Settings
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 2: Understanding Database Tables and Records
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 3: Migration Review and Considerations
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 3: More about Column Data Types and Other Properties
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Lessons: Lesson 4: Designing Relational Database Tables
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 5: Manipulating Database Data
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 6: More Structured Query Language
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 7: Understanding Security and Network Connectivity
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 8: Connecting your Web Application to SQL Server 2005 Express Edition
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided training video for SQL Server 2005.
SQL Server Beginners Series: Lesson 9: Using SQL Server Management Studio
Self-guided training video for SQL Server 2005.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Manageability and Deployment.
SQL Server 2005 Integration Services Manageability and Deployment Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Manageability and Deployment.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Metadata Management.
SQL Server 2005 Integration Services Metadata Management Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Metadata Management.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Scalability & Parallel Task Execution.
SQL Server 2005 Integration Services Scalability & Parallel Task Execution Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Scalability & Parallel Task Execution.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services.
SQL Server 2005 Integration Services Guided Tour
Self-guided tour of SQL Server 2005 Integration Services.
DownloadDownloadSelf-guided tour of SQL Server 2005 Reporting Services Model Designer.
SQL Server 2005 Reporting Services Model Designer
Self-guided tour of SQL Server 2005 Reporting Services Model Designer.
DownloadDownloadSelf-guided tour of SQL Server 2005 Reporting Services Report Builder.
SQL Server 2005 Reporting Services Report Builder
Self-guided tour of SQL Server 2005 Reporting Services Report Builder.
DownloadDownloadSelf-guided tour of SQL Server 2005 Reporting Services Report Designer.
SQL Server 2005 Reporting Services Report Designer
Self-guided tour of SQL Server 2005 Reporting Services Report Designer.
DownloadDownloadSelf-guided tour of SQL Server 2005 Reporting Services Report Manager.
SQL Server 2005 Reporting Services Report Manager
Self-guided tour of SQL Server 2005 Reporting Services Report Manager.
DownloadDownloadSelf-guided tour of SQL Server 2005 Reporting Services Report Viewer.
SQL Server 2005 Reporting Services Report Viewer
Self-guided tour of SQL Server 2005 Reporting Services Report Viewer.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, Conclusion
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, Data Management Views Reports
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, Database Tuning Advisor
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, DDL Triggers
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, Introduction
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, Maintenance Plans
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadOverview presentation of SQL Server 2005 Enterprise Data Management.
SQL Server 2005 Video Presentation: Enterprise Data Management, SQL Server Management Studio Walkthrough
Overview presentation of SQL Server 2005 Enterprise Data Management.
DownloadDownloadSelf-guided tour of SQL Server 2005 Integration Services Visual Development Environment.
SQL Server Integration Services Visual Development Environment Guided Tour
Self-guided tour of SQL Server 2005 Integration Services Visual Development Environment.
DownloadDownloadOn-demand webcasts for 64-bit computing for SQL Server 2005.
64-bit Computing Webcasts
On-demand webcasts for 64-bit computing for SQL Server 2005.
DownloadDownloadSend e-mail messages from a database engine using Database Mail, a new feature in Microsoft SQL Server 2005. Database Mail, designed from the ground up for reliability, scalability, security, and supportability, uses Simple Mail Transfer Protocol for sending e-mail messages with no dependency on Outlook. Join this webcast and get a look at this new feature in SQL Server 2005.
TechNet Webcast: Database Mail in SQL Server 2005 (Level 300)
Send e-mail messages from a database engine using Database Mail, a new feature in Microsoft SQL Server 2005. Database Mail, designed from the ground up for reliability, scalability, security, and supportability, uses Simple Mail Transfer Protocol for sending e-mail messages with no dependency on Outlook. Join this webcast and get a look at this new feature in SQL Server 2005.
DownloadDownloadFor database administrators who live vicariously through the command line for task automation, the SQLCMD utility takes the OSQL utility to the next level. Join this webcast for demonstrations on the practical uses of the new features of the SQLCMD utility and how they apply to development, deployment, and management of SQL Server 2005 database engine instances. This webcast also demonstrates how to use the SQLCMD utility with the Windows Task Scheduler for running maintenance jobs for Microsoft SQL Server Express instances.
TechNet Webcast: Manage SQL Server 2005 Using Command Line Tools and the SQLCMD Utility (Level 200)
For database administrators who live vicariously through the command line for task automation, the SQLCMD utility takes the OSQL utility to the next level. Join this webcast for demonstrations on the practical uses of the new features of the SQLCMD utility and how they apply to development, deployment, and management of SQL Server 2005 database engine instances. This webcast also demonstrates how to use the SQLCMD utility with the Windows Task Scheduler for running maintenance jobs for Microsoft SQL Server Express instances.
DownloadDownloadMicrosoft SQL Server 2005 offers some new features for database administrators and information technology (IT) professionals. Join this webcast to learn about new administration tools, including SQL Management Studio; SQLCMD, the new command-line utility (and its GUI equivalent in SQL Management Studio); and SQLiMail, the new Simple Mail Transfer Protocol (SMTP)-based replacement for SQLMail. We look at SQL Server Express 2005, a “light” version of SQL Server 2005 that replaces the Microsoft Desktop Engine (MSDE). We conclude by exploring maintenance and performance tools included in SQL Server 2005, such as maintenance plans, SQL Profiler, and SQL Server Agent.
TechNet Webcast: Managing and Administering SQL Server 2005 (Level 200)
Microsoft SQL Server 2005 offers some new features for database administrators and information technology (IT) professionals. Join this webcast to learn about new administration tools, including SQL Management Studio; SQLCMD, the new command-line utility (and its GUI equivalent in SQL Management Studio); and SQLiMail, the new Simple Mail Transfer Protocol (SMTP)-based replacement for SQLMail. We look at SQL Server Express 2005, a “light” version of SQL Server 2005 that replaces the Microsoft Desktop Engine (MSDE). We conclude by exploring maintenance and performance tools included in SQL Server 2005, such as maintenance plans, SQL Profiler, and SQL Server Agent.
DownloadDownload Learn how you can be more productive by using SQL Server Agent to automate routine tasks. Significant changes were made to the SQL Server Agent feature in Microsoft SQL Server 2005. In this webcast, we will take an in-depth look at both the functionality and the internal architecture of SQL Agent in SQL Server 2005. Join us and get a jump-start into the new features and capabilities of SQL Server Agent.
TechNet Webcast: SQL Agent in SQL Server 2005 (Level 300)
Learn how you can be more productive by using SQL Server Agent to automate routine tasks. Significant changes were made to the SQL Server Agent feature in Microsoft SQL Server 2005. In this webcast, we will take an in-depth look at both the functionality and the internal architecture of SQL Agent in SQL Server 2005. Join us and get a jump-start into the new features and capabilities of SQL Server Agent.
DownloadDownload The Microsoft SQL Server 2005 Database Tuning Advisor is a brand new tool in Microsoft SQL Server 2005 that provides database administrators with guidance and best practices for maximizing performance. The Tuning Advisor features guidance on indexes and partitions. This webcast takes an in-depth look at this new tool and shows you how to utilize it for optimum performance of your SQL Server database.
TechNet Webcast: SQL Server 2005 Database Tuning Advisor (Level 300)
The Microsoft SQL Server 2005 Database Tuning Advisor is a brand new tool in Microsoft SQL Server 2005 that provides database administrators with guidance and best practices for maximizing performance. The Tuning Advisor features guidance on indexes and partitions. This webcast takes an in-depth look at this new tool and shows you how to utilize it for optimum performance of your SQL Server database.
DownloadDownload Are you paying attention to Microsoft Operations Manager (MOM)? This webcast shows how to manage Microsoft SQL Server 2005 better by using MOM. See what is new in the Microsoft SQL Server 2005 Management Pack. Learn how to use different capabilities in Management Pack such as Client Side Monitoring, Service Availability, Performance Monitoring, Space Monitoring, and the ability to launch tasks. We show you how to effectively monitor your SQL Server installations using built-in Reports and State Components in MOM.
TechNet Webcast: SQL Server 2005 Manageability Using Management Pack for MOM (Level 200)
Are you paying attention to Microsoft Operations Manager (MOM)? This webcast shows how to manage Microsoft SQL Server 2005 better by using MOM. See what is new in the Microsoft SQL Server 2005 Management Pack. Learn how to use different capabilities in Management Pack such as Client Side Monitoring, Service Availability, Performance Monitoring, Space Monitoring, and the ability to launch tasks. We show you how to effectively monitor your SQL Server installations using built-in Reports and State Components in MOM.
DownloadDownloadLearn more about Microsoft SQL Server 2005 whenever and wherever you want. Stream or download these audio podcasts on to your favorite podcast software or mobile device, and quickly and easily access content with RSS feeds. These podcasts are free and do not require registration—just click, listen, and learn.
SQL Server 2005 Podcasts
Learn more about Microsoft SQL Server 2005 whenever and wherever you want. Stream or download these audio podcasts on to your favorite podcast software or mobile device, and quickly and easily access content with RSS feeds. These podcasts are free and do not require registration—just click, listen, and learn.
DownloadDownloadTest drive Microsoft SQL Server 2005 and see how it delivers increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. In these labs, you can experience many of the features in SQL Server 2005, including XML support and deep business intelligence integration.
SQL Server 2005 Virtual Labs for IT Pros
Test drive Microsoft SQL Server 2005 and see how it delivers increased scalability, availability, and security to enterprise data and analytical applications while making them easier to create, deploy, and manage. In these labs, you can experience many of the features in SQL Server 2005, including XML support and deep business intelligence integration.
DownloadDownloadSee how you can increase the scale, performance, and security of your existing systems with Microsoft SQL Server 2005. Our subject matter experts walk through all of the major features and enhancements built into SQL Server 2005 and show you how you can use the powerful and flexible set of DBA productivity tools to meet the demands of your business.
SQL Server 2005 Webcasts
See how you can increase the scale, performance, and security of your existing systems with Microsoft SQL Server 2005. Our subject matter experts walk through all of the major features and enhancements built into SQL Server 2005 and show you how you can use the powerful and flexible set of DBA productivity tools to meet the demands of your business.
DownloadDownload Enhancements to Microsoft SQL Server 2005 focus on security, reliability, and performance to give you a solid, dependable foundation for your business applications. This webcast covers maintenance and monitoring features in SQL Server 2005 like maintenance plans, database tuning, dynamic management, views, and logs.
TechNet Webcast: Understanding Maintenance and Monitoring Enhancements to SQL Server 2005 (Level 200)
Enhancements to Microsoft SQL Server 2005 focus on security, reliability, and performance to give you a solid, dependable foundation for your business applications. This webcast covers maintenance and monitoring features in SQL Server 2005 like maintenance plans, database tuning, dynamic management, views, and logs.
DownloadDownloadSee how you can increase the scale, performance, and security of your existing systems with Microsoft SQL Server 2005. Our subject matter experts walk through all of the major features and enhancements built into SQL Server 2005 and show you how you can use the powerful and flexible set of DBA productivity tools to meet the demands of your business.
Watch SQL Server 2005 Security Webcasts
See how you can increase the scale, performance, and security of your existing systems with Microsoft SQL Server 2005. Our subject matter experts walk through all of the major features and enhancements built into SQL Server 2005 and show you how you can use the powerful and flexible set of DBA productivity tools to meet the demands of your business.
DownloadDownloadLearn how native XML technologies, interoperability through Web services, and integration with XML, Visual Studio 2005, and the Microsoft .NET Framework can help you be more productive. Webcasts include a 10-part primer miniseries with industry-renowned SQL Server expert Kimberly Tripp and a 16-part miniseries based on Microsoft ADO.NET Step by Step by Rebecca M. Riordan (Microsoft Press, 2002).
SQL Server 2005: Discover the Next Paradigm for Database Development
Learn how native XML technologies, interoperability through Web services, and integration with XML, Visual Studio 2005, and the Microsoft .NET Framework can help you be more productive. Webcasts include a 10-part primer miniseries with industry-renowned SQL Server expert Kimberly Tripp and a 16-part miniseries based on Microsoft ADO.NET Step by Step by Rebecca M. Riordan (Microsoft Press, 2002).
DownloadDownloadExplore these resources that help you deploy, maintain, and support SQL Server 2005.
SQL Server 2005 TechNet Resources
Explore these resources that help you deploy, maintain, and support SQL Server 2005.
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 paper discusses the important drivers, reasons, and technology features when integrating SQL Server 2005 and the 2007 Office system.
Microsoft SQL Server 2005: Business Intelligence Integration with the 2007 Microsoft Office System
This paper discusses the important drivers, reasons, and technology features when integrating SQL Server 2005 and the 2007 Office system.
DownloadDownloadThe power of SQL Server 2005 Enterprise Edition delivers a complete platform to support your most challenging, large-scale, mission-critical, and demanding analytical database applications. Learn how the advanced capabilities in SQL Server 205 Enterprise Edition can improve your enterprise database and analytical applications.
Empowering Enterprise Solutions with SQL Server 2005 Enterprise Edition
The power of SQL Server 2005 Enterprise Edition delivers a complete platform to support your most challenging, large-scale, mission-critical, and demanding analytical database applications. Learn how the advanced capabilities in SQL Server 205 Enterprise Edition can improve your enterprise database and analytical applications.
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.
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.
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 study presents preliminary data regarding the top 5 vendors in the relational database management systems market for 2006 as well as the market as a whole. This data will be super-ceded by a later study once data collection is completed in IDC’s Software Market Forecaster (SMF). For a complete explanation of the data and its collection in this study, see the Methodology in the Learn More section of this study.
IDC Opinion, Worldwide RDBMS 2006 Vendor Shares: Preliminary Results for the Top 5 Vendors, April 2007
This study presents preliminary data regarding the top 5 vendors in the relational database management systems market for 2006 as well as the market as a whole. This data will be super-ceded by a later study once data collection is completed in IDC’s Software Market Forecaster (SMF). For a complete explanation of the data and its collection in this study, see the Methodology in the Learn More section of this study.
DownloadDownloadThis paper describes how you can leverage Microsoft SQL Server Analysis Services and Teradata technologies to improve your analytical OLAP application environment, specifically relational (ROLAP) type solution.
Improve your OLAP Environment with Microsoft and Teradata
This paper describes how you can leverage Microsoft SQL Server Analysis Services and Teradata technologies to improve your analytical OLAP application environment, specifically relational (ROLAP) type solution.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
Get the SQL Server Migration Assistant for MySQL (SSMA for MySQL)
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from MySQL to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
DownloadDownloadMicrosoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
SSMA for Access v4.2, for SQL Server 2005 and 2008
Microsoft SQL Server Migration Assistant (SSMA) is a toolkit that dramatically cuts the effort, cost, and risk of migrating from Access to SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 and SQL Azure.
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.
DownloadDownloadWith SQL Server 2005, businesses can extend the value of their Microsoft Dynamics solution using a complete set of data-management tools and put critical, timely information in the hands of all employees.
Dynamics on SQL Server 2005 Datasheet
With SQL Server 2005, businesses can extend the value of their Microsoft Dynamics solution using a complete set of data-management tools and put critical, timely information in the hands of all employees.
DownloadDownloadReview this FAQ to find answers to common questions about using the SQL Server Migration Assistant and related technologies.
SQL Server Migration Assistant Frequently Asked Questions (FAQ)
Review this FAQ to find answers to common questions about using the SQL Server Migration Assistant and related technologies.
DownloadDownloadThis IDC study examines the BI tools market for the period from 2004 to 2006.Worldwide market size is provided for 2006, with trends from 2004. Geographic region splits for the overall market and its sub segments are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2006. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
IDC Opinion, Worldwide Business Intelligence Tools 2006 Vendor Shares, June 2007
This IDC study examines the BI tools market for the period from 2004 to 2006.Worldwide market size is provided for 2006, with trends from 2004. Geographic region splits for the overall market and its sub segments are provided in addition to a vendor competitive analysis, with revenue and market share for the leading vendors for 2006. This study also provides profiles of leading vendors and identifies the characteristics that vendors will need to be successful in the future.
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.
DownloadDownloadDownload the April 2006 version of Microsoft SQL Server 2005 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 to help you prepare for upgrades to SQL Server 2005.
Simplify the Upgrade Process with the Upgrade Advisor
Download the April 2006 version of Microsoft SQL Server 2005 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 7.0 and SQL Server 2000 to help you prepare for upgrades to SQL Server 2005.
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.
Download
