BISQL #21:All White Paper For SQL Server R2 Review and Better Understanding
Following is direct link which I got on SQL Server R2 Website,Its so important that I thought of having post on the same
Discover SQL Server 2008 through a variety of solution and technology-focused white papers.
- Online Transaction Processing/Data Management
- Business Intelligence and Data Warehousing
- Application Development/Data Programmability
- Switching to SQL Server 2008
- Additional Resources
- Introducing Microsoft StreamInsight™ in SQL Server 2008 R2
This paper is an overview of Microsoft’s platform for complex event processing, StreamInsight™, available soon in SQL Server 2008 R2.
- SQL Server 2008 R2 Manageability
Microsoft® SQL Server® 2008 R2 builds on the management capabilities of previous versions and provides a variety of tools and frameworks to help you manage your enterprise data environment.
- SQL Server 2008 Sustainability
Microsoft IT produced the SQL Utility to improve SQL Server manageability through host consolidation, virtualization, and standardization.
- Auditing in SQL Server 2008
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.
- SQL Server 2008 Product Overview
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.
- Microsoft SQL Server 2008 R2: The Best Data Platform on Windows Server 2008 R2
Microsoft SQL Server 2008 R2 and Windows Server 2008 R2 work together seamlessly to provide a data platform that delivers a low total cost of ownership (TCO) and that is equipped to handle the needs of even the most demanding mission-critical applications.
- Troubleshooting Performance Problems in SQL Server 2008 Whitepaper
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 Perform
▪ 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.
- Geo-Replication Performance Gains with Microsoft SQL Server 2008 Running on Windows 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.
- SQL Server 2008 Licensing Overview
This document explains key licensing considerations for SQL Server 2008 customers.
- Server Consolidation with SQL Server 2008
This 10-page paper discusses SQL Server 2008 flexibility, manageability, and scalability and performance.
Online Transaction Processing/Data Management
- Manageability and Performance Benefits of 3PAR Utility Storage in a Microsoft SQL Server Environment
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.
- Enterprise Policy Management Framework with SQL Server 2008
- Backup Compression Part 2
- Scheduling Sub-Minute Log Shipping in SQL Server 2008
- Online Transaction Processing in SQL Server 2008
This 10-page paper covers the following topics: Scale and Performance, High Availability, Security, and Manageability.
- SQL Server 2008 Performance and Scale
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.
- SQL Server 2008 Security Overview for Database Administrators
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.
- SQL Server 2008 Manageability
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.
- Microsoft SQL Server 2008 Data and Backup Compression
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.
- Database Encryption in SQL Server 2008 Enterprise Edition
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.
- Protecting SQL Server with System Center Data Protection Manager 2007
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.
Business Intelligence and Data Warehousing
- Reporting Services Performance Optimizations
- Top Performance and Productivity Reasons to Use SQL Server 2008 for Your Business Intelligence Solutions
- Data Warehousing in the Enterprise
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.
- Business Intelligence in SQL Server 2008
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.
- 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. This paper covers a high-level look at the key Analysis Services features available in SQL Server 2008.
- SQL Server 2008 Reporting Services
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.
- An Introduction to SQL Server 2008 Integration Services
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.
- 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. 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.
- Introduction to New Data Warehouse Scalability Features in SQL Server 2008
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 analyse 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.
- Predictive Analysis with SQL Server 2008
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.
- Predictive Analysis for the Retail Industry
To stay competitive, retailers must understand not only current consumer behaviour, but must also be able to predict future consumer behaviour. Accurate prediction and an understanding of customer behaviour 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.
Application Development/Data Programmability
- Microsoft SQL Server 2008 and Microsoft Data Platform Development
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.
- SQL Server 2008: Delivering Location Intelligence with Spatial Data
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.
- Managing Unstructured Data with SQL Server 2008
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.
- What’s New for XML in SQL Server 2008
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.
Switching to SQL Server 2008
- Guide to Migrating from Oracle to SQL Server 2008
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.
- Guide to Migrating from MySQL to SQL Server 2008
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.
- Guide to Migrating from Informix to SQL Server 2008
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.
- Guide to Migrating from Sybase ASA to SQL Server 2008
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.
- Guide to Migrating from Sybase ASE to SQL Server 2008
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.
- A Competitive Review of Sybase ASE
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.
- 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.
- Practical SQL Server 2008 for Oracle Professionals
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.
- SQL Server 2008 Compared to Oracle Database 11g
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.
- Response to Oracle’s Edison 2009 Report
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.
- SQL Server Integration Services with Oracle Database 10g
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.
- SQL Server 2000 to 2008 Upgrade Whitepaper
- SQL Server 2005 to 2008 Upgrade Whitepaper
- Upgrading to SQL Server 2008
- SQL Server Blogs
- SQL Server Forums on MSDN
- SQL Server TechCenter on TechNet
- SQL Server Developer Center on MSDN
For more interesting information on SQL we can also look into similar topics such as
Hope you will like this post on White paper for SQL server R2 review.
If you really like reading my blog and understood at least few thing then please don’t forget to subscribe my blog.
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog: Link Resource Website
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
Copyright © 2011 – 2012 Vishal Pawar