United States Change | All Microsoft Sites
Microsoft Home | Servers and Tools
This paper is an overview of the Microsoft platform for complex event processing.Audience: High-level
Microsoft IT produced the SQL Utility to improve SQL Server manageability through host consolidation, virtualization, and standardization.
With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers. While SQL Trace can be used to satisfy many auditing needs, SQL Server Audit offers a number of attractive advantages that may help DBAs more easily achieve their goals such as meeting regulatory compliance requirements.Audience: High-level
Microsoft SQL Server 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.Audience: High-level
The combination of SQL Server 2008 and Windows Server 2008 offers enterprise IT administrators and professional developers a superlative platform for mission-critical applications together with enhanced end-to-end security, management, and development capabilities.Audience: High-level
This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as:▪ SQL Server Profiler▪ System Monitor (in the Windows Server 2003 operating system) or ▪ Performance Monitor (in the Windows Vista operating system and Windows Server 2008), also known as Perfmon▪ Dynamic management views (sometimes referred to as DMVs)▪ SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2008.
Microsoft.com Engineering Operations (MSCOM Ops), the team responsible for architecting and managing many of the most heavily trafficked Microsoft Web sites, recently documented substantial replication performance improvements for both push and pull subscriptions in Microsoft® SQL Server® 2008 running on Windows Server® 2008—up to 100 times faster than Microsoft SQL Server 2005 running on Windows Server 2003. This paper provides IT pros with an in-depth look at the tests conducted by the MSCOM Ops team, insight into the results, and technical analysis of the enhancements to Windows Server 2008 and SQL Server 2008 that enable wide area network (WAN)–based geo-replication.Audience: High-level
This document explains key licensing considerations for SQL Server 2008 customers.
This 10-page paper discusses SQL Server 2008 flexibility, manageability, and scalability and performance.Audience: High-level
This paper summarizes tests performed for a joint Microsoft and 3PAR customer who wanted to better understand the benefits of new storage technologies in its environment. 3PAR and Microsoft worked collaboratively to assist the customer with reducing capital and administrative costs while maintaining optimal performance running an OLTP workload on Microsoft SQL Server 2008® Enterprise Edition and a 3PAR® InServ Storage Server.Audience: High-level
This 10-page paper covers the following topics: Scale and Performance, High Availability, Security, and Manageability.Audience: High-level
This paper discusses how Microsoft SQL Server 2008 incorporates the tools and technologies that are necessary to implement relational databases, reporting systems, and data warehouses of enterprise scale, and provides optimal performance and responsiveness.Audience: Mid-level
SQL Server 2008 is 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 security features in SQL Server 2008. 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.Audience: Mid-level
This paper discusses how Microsoft SQL Server 2008 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help you manage your enterprise data environment.Audience: High-level
Microsoft SQL Server 2008 introduces two new compression features: data compression and backup compression. Both compression techniques can be used to reduce the amount of online storage required for databases and their backups.Audience: Mid-level
With the introduction of transparent data encryption (TDE) in SQL Server 2008, users now have the choice between cell-level encryption as in SQL Server 2005, full database-level encryption by using TDE, or the file-level encryption options provided by Windows.Audience: High-level
SQL Server already offers a range of data availability technologies, including support for clustering and transaction log replication. Microsoft System Center Data Protection Manager (DPM) 2007 extends the native SQL Server feature set to provide continuous data protection with byte-level replication and integrity checking, plus full support for disk-to-disk and disk-to-disk-to-tape backup. Audience: Mid-level
In this white paper, we discuss the data warehouse products from three traditional vendors, as well as the newer appliance and column-based vendors. We compare the strengths and weaknesses of these products to Microsoft® SQL Server® 2008 and shows that Microsoft provides the best choice of data warehouse solution among all vendors in the marketplace because of its broadest offerings, openness, and cost-effectiveness. Audience: High-level
This 10-page paper covers the following topics: Unifying Data Storage and Access, Building and Managing Sophisticated BI Solutions, and Extending the Reach of Your BI Solution.Audience: High-level
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. This paper covers a high-level look at the key Analysis Services features available in SQL Server 2008.Audience: High-level
This paper discusses how Microsoft SQL Server 2008 Reporting Services provides a complete server-based platform that is designed to support a wide variety of reporting needs including managed enterprise reporting, ad-hoc reporting, embedded reporting, and web based reporting to enable organizations to deliver relevant information where needed across the entire enterprise.Audience: High-level
This paper discusses the challenges that face businesses that rely on data integration technologies to provide meaningful, reliable information to maintain a competitive advantage in today’s business world. It discusses how SQL Server 2008 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are included.Audience: High-level
This white paper provides an overview of the connectivity options that are available with SQL Server 2008 Integration Services. SQL Server 2008 Integration Services supports an ever-expanding range of connectivity options for a wide variety of data sources. New connectors that have an increased the emphasis on performance and the addition of ADO.NET data sources and destinations contribute to making Integration Services an excellent choice for ETL operations.Audience: High-level
With the 2008 release, SQL Server makes a major advance in scalability for data warehousing. It meets the data warehouse needs of the largest enterprises more easily than ever. SQL Server 2008 provides a range of integrated products that enable you to build your data warehouse, and query and analyze its data. These include the SQL Server relational database system, Analysis Services, Integration Services, and Reporting Services. This paper introduces the new performance and manageability features for data warehousing across all these components. All these features contribute to improved scalability.Audience: High-level
This 10-page paper explores the complete and intuitive set of data mining tools offered in Microsoft SQL Server 2008, which features predictive analysis for all users, insight at every step of the data lifecycle, and data mining awareness in every application.Audience: High-level
To stay competitive, retailers must understand not only current consumer behavior, but must also be able to predict future consumer behavior. Accurate prediction and an understanding of customer behavior can help retailers keep customers, improve sales, and extend the relationship with their customers. SQL Server 2008 offers predictive analysis through data mining, empowering users with actionable insight across the organization. SQL Server 2008 and Microsoft Office Excel 2007 offer data mining capabilities that can help retailers make informed decisions. This white paper explores examples that include churn analysis to estimate the number of customers in danger of being lost, market analysis to show how customers are distributed between high and low value segments, and market basket analysis to determine those products that customers are more likely to buy together.Audience: High-level
This 10-page paper covers the following topics: Improved Productivity through ADO.NET Entity Framework, LINQ, and Visual Studio; Comprehensive Data Platform; and Scalable Data-Centric Solutions.Audience: Technical
This 10-page paper discusses how the new spatial support in SQL Server 2008 can help you make better decisions through visual analysis of location data that can be stored and manipulated in a SQL Server database.Audience: Mid-level
This 11-page paper discusses how Microsoft SQL Server 2008 provides a flexible solution for storing unstructured data and combining it with relational data to build comprehensive solutions that encompass the full range of data across an organization.Audience: Technical
This 16-page paper discusses how Microsoft SQL Server 2008 builds on the extensive support for XML by extending support for XML schema validation and XQuery, and by enhancing the xml data type.Audience: Technical
This white paper explores challenges that arise when you migrate from an Oracle 7.3 database or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms. The entire migration process using SQL Server Migration Assistant (SSMA) 2008 for Oracle is explained in depth, with a special focus on converting database objects and PL/SQL code.Audience: Mid-Level
In this migration guide you will learn the differences between the MySQL and SQL Server 2008 database platforms, and the steps necessary to convert a MySQL database to SQL Server.Audience: Mid-Level
This white paper explores challenges that arise when you migrate from an Informix 11 database to SQL Server 2008. It describes the implementation differences of database objects and procedural code between the two platforms. Emulation of system functions is also discussed.Audience: Mid-Level
This white paper explores challenges that arise when you migrate from a Sybase Adaptive Server Anywhere (ASA) database of version 9 or later to SQL Server 2008. It describes the implementation differences of database objects, SQL dialects, and procedural code between the two platforms.Audience: Mid-Level
This white paper covers known issues for migrating Sybase Adaptive Server Enterprise database to SQL Server 2008. Instructions for handling the differences between the two platforms are included. The paper describes how SQL Server Migration Assistant, the best tool for this type of migration, can help resolve various migration issues.Audience: Mid-Level
This white paper discusses the main reasons that customers might not want to implement Sybase Adaptive Server Enterprise (ASE) in their database solution and why they should think about migrating their existing Sybase database to Microsoft SQL Server. We outline the advantages in both businesses and technical gain by choosing SQL Server 2008 over Sybase and discuss how SQL Server provides customers currently using Sybase with an effective strategy for migrating to SQL Server.Audience: Mid-Level
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.Audience: Mid-level
This white paper reviews many of the key comparisons between SQL Server 2008 databases and Oracle databases, and is intended for Oracle professionals looking to extend and use their Oracle knowledge to manage SQL Server.Audience: Mid-level
SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.Audience: Mid-level
In August 2009, the research firm Edison published the study “Comparative Management Costs Study – Oracle Database 11g vs. Microsoft SQL Server 2008” commissioned by Oracle. That study compares the management costs of Oracle database 11g and SQL Server 2008. This paper, “Response to Oracle’s Edison 2009 Report”, explores details and uncovers inherent flaws about the Edison methodology, questioning the results and accuracies of the overall report.Audience: Mid-level
This paper focuses on the advantages of using SQL Server Integration Services (SSIS) to extract data from heterogeneous sources and import data into Microsoft SQL Server for Business Intelligence (BI) analysis and reporting. Oracle Database 10g data is used as the primary data source. The audience for this paper includes IT professionals, database administrators, and system architects. The reader should have a general understanding of databases and Microsoft SQL Server and Oracle Database 10g. Readers should use the referenced databases on their preferred hardware platform.Audience: High-level
Audience: Technical
See solutions for:
