tag:blogger.com,1999:blog-4951517370322579863Mon, 02 Nov 2009 12:18:46 +0000A collection of white papers useful for SQL Server professionalshttp://www.sqlwhitepapers.com/jacob@dotnetquest.com (jacob.sebastian)Blogger136125SqlServerWhitePapershttp://feedburner.google.comtag:blogger.com,1999:blog-4951517370322579863.post-782394971062156617Thu, 06 Aug 2009 11:51:00 +00002009-08-06T04:51:32.799-07:00SQL Server 2008OptimizationThis paper explains how SQL Server 2008 allocates memory for plan caching, how query batches are cached and suggests best practices on maximizing reuse of cached plans. It also explains scenarios in which batches are recompiled, and gives best practices for reducing or eliminating unnecessary recompilations and for minimizing plan cache pollution. Read the white paper: http://msdn.microsoft.com/http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/qD6KOLooVxo/sql-server-2008-white-paper-plan.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/qD6KOLooVxo" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/08/sql-server-2008-white-paper-plan.htmltag:blogger.com,1999:blog-4951517370322579863.post-1384816164044246060Wed, 15 Jul 2009 05:55:00 +00002009-07-14T22:55:49.011-07:00SQL Server 2008Resource GovernerSQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices. The Resource Governor is a new feature in the Microsoft SQL Server 2008 http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/D3KuWu-AmwI/sql-server-2008-using-resource-governor.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/D3KuWu-AmwI" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/07/sql-server-2008-using-resource-governor.htmltag:blogger.com,1999:blog-4951517370322579863.post-4155855630599162794Sun, 14 Jun 2009 09:19:00 +00002009-06-14T02:19:18.624-07:00SQL Server 2008Policy based managementThis paper explores Policy-Based Management, a new management feature introduced in SQL Server 2008. Policy-Based Management allows DBAs to define a set of policies that can control many different aspects of SQL Server. Policies can be applied to a single server or to groups of servers. For example, a DBA could define a policy that specifies how a particular configuration option should be set on http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/H_JuwCGIlrY/sql-server-2008-policy-based-management.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/H_JuwCGIlrY" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/06/sql-server-2008-policy-based-management.htmltag:blogger.com,1999:blog-4951517370322579863.post-194919806921914294Sun, 14 Jun 2009 09:18:00 +00002009-06-14T02:18:27.346-07:00SQL Server 2008MDWSQL Server 2008 introduces the Management Data Warehouse (MDW) to SQL Server Management Studio for streamlined performance troubleshooting. MDW is a set of components that enable a database developer or administrator to quickly track down problems that could be causing performance degradation. Read the white paper: http://msdn.microsoft.com/en-us/library/dd939169.aspx http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/d2rXKpv06Zc/sql-server-2008-management-data.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/d2rXKpv06Zc" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/06/sql-server-2008-management-data.htmltag:blogger.com,1999:blog-4951517370322579863.post-2583117279011314391Sun, 14 Jun 2009 09:16:00 +00002009-06-14T02:16:37.464-07:00SQL Server 2008PowershellIn this paper we’ll walk through an introduction to Windows PowerShell and its key elements.  We’ll then look at the special PowerShell executable program provided with SQL Server 2008, sqlps.exe.  Sqlps.exe incorporated a set of cmdlets specific to using PowerShell with SQL Server, and adds a PowerShell drive (PSDrive) allowing us to navigate SQL Server as though it were a filesystem.  We’ll http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/3WqKCnLwdXM/understanding-and-using-powershell.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/3WqKCnLwdXM" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/06/understanding-and-using-powershell.htmltag:blogger.com,1999:blog-4951517370322579863.post-4748583420816548507Mon, 08 Jun 2009 02:54:00 +00002009-06-07T19:54:11.926-07:00SQL Server 2008Extended Events is an extended event handling system for SQL Server. It has a highly scalable and highly configurable architecture that allows administrators to collect as much or as little information as is necessary to troubleshoot or identify a problem. It is important to note that it is not currently a replacement for the existing diagnostic features of SQL Server, though it has many parallelhttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/O-ljKu1eoV0/using-sql-server-2008-extended-events.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/O-ljKu1eoV0" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/06/using-sql-server-2008-extended-events.htmltag:blogger.com,1999:blog-4951517370322579863.post-218856966365597198Mon, 01 Jun 2009 05:58:00 +00002009-05-31T22:58:49.342-07:00SQL Server 2008Windows Server 2008Microsoft.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 Windowshttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/qUQMhn7_p8c/geo-replication-performance-gains-with.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/qUQMhn7_p8c" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/geo-replication-performance-gains-with.htmltag:blogger.com,1999:blog-4951517370322579863.post-5354180420730963356Mon, 01 Jun 2009 05:56:00 +00002009-05-31T22:56:05.207-07:00SQL Server 2008Microsoft 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. Download Whitepaper: http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQL2008_http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/uGcux9ZVhLI/sql-server-2008-product-overview.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/uGcux9ZVhLI" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/sql-server-2008-product-overview.htmltag:blogger.com,1999:blog-4951517370322579863.post-3236484817224574812Mon, 01 Jun 2009 05:54:00 +00002009-05-31T22:54:21.583-07:00SQL Server 2008AuditingWith 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. These include the ability to provide http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/LsS0jqwd6MQ/auditing-in-sql-server-2008.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/LsS0jqwd6MQ" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/auditing-in-sql-server-2008.htmltag:blogger.com,1999:blog-4951517370322579863.post-8572056932828437370Mon, 01 Jun 2009 05:52:00 +00002009-05-31T22:52:52.324-07:00SQL Server 2008SustainabilityThis white paper examines the deployment of the SQL Utility within Microsoft IT, including the decisions that Microsoft IT made, implementation details, and aspects of system quality. It assumes that readers are technical decision makers and are somewhat familiar with Windows Server and SQL Server technologies. Many of the principles and techniques described in this paper can apply to other http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/JEW9mvGTIhM/improving-sustainability-and-use-of-sql_31.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/JEW9mvGTIhM" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/improving-sustainability-and-use-of-sql_31.htmltag:blogger.com,1999:blog-4951517370322579863.post-3646414763885864588Mon, 01 Jun 2009 05:50:00 +00002009-05-31T22:50:39.913-07:00SQL Server 2008CEPAlthough most relational database applications are query-driven, event-driven applications have become increasingly important. Event-driven applications are characterized by high data rates, and millisecond latency requirements that make traditional store and query techniques impractical for timely and relevant processing of data. In contrast to the typical database scenario of hundreds of http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/p_oXtTjxNOI/introducing-microsofts-platform-for.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/p_oXtTjxNOI" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/introducing-microsofts-platform-for.htmltag:blogger.com,1999:blog-4951517370322579863.post-2440199726075310005Sun, 24 May 2009 06:43:00 +00002009-05-23T23:43:03.007-07:00SQL Server 2008FILESTREAMThis white paper describes the FILESTREAM feature of SQL Server 2008, which allows storage of and efficient access to BLOB data using a combination of SQL Server 2008 and the NTFS file system. It covers choices for BLOB storage, configuring Windows and SQL Server for using FILESTREAM data, considerations for combining FILESTREAM with other features, and implementation details such as partitioninghttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/Nfey8eQBwnY/filestream-storage-in-sql-server-2008.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/Nfey8eQBwnY" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/filestream-storage-in-sql-server-2008.htmltag:blogger.com,1999:blog-4951517370322579863.post-5786575604047574813Sun, 24 May 2009 06:41:00 +00002009-05-23T23:41:20.837-07:00SQL Server 2008FILESTREAMThe proliferation of digital content has significant implications for the way in which organizations store and access business data. Increasingly, databases that are at the core of business applications must be integrated with unstructured data in the form of documents, images, video content, and other multimedia formats. Organizations increasingly need to be able to store and manage digital datahttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/f7IUUu55xhA/white-paper-managing-unstructured-data.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/f7IUUu55xhA" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/white-paper-managing-unstructured-data.htmltag:blogger.com,1999:blog-4951517370322579863.post-1924941676649745528Sat, 02 May 2009 19:02:00 +00002009-05-02T12:02:43.176-07:00SQL Server 2008PHPSQL Server 2005SQL Server 2000The SQL Server 2005 Driver for PHP is a Microsoft-supported extension of PHP 5 that provides data access to SQL Server 2005 and SQL Server 2008. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2008. The SQL Server 2005 Driver for PHP API provides a comprehensive data access solution from PHP, and includes support for many featureshttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/vyC2v_estlY/accessing-sql-server-databases-with-php.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/vyC2v_estlY" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/accessing-sql-server-databases-with-php.htmltag:blogger.com,1999:blog-4951517370322579863.post-2454371520618898654Sat, 02 May 2009 19:00:00 +00002009-05-02T12:00:01.416-07:00SQL Server 2008CDCPerformanceChange data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/jqIIVIswxdM/tuning-performance-of-change-data.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/jqIIVIswxdM" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/tuning-performance-of-change-data.htmltag:blogger.com,1999:blog-4951517370322579863.post-3921401812661288972Sat, 02 May 2009 18:58:00 +00002009-05-02T11:58:52.652-07:00SQL Server 2008This 10-page paper discusses SQL Server 2008 flexibility, manageability, and scalability and performance. Read the White Paper: http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008Consolidation.docx http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/kefV189fRrA/server-consolidation-with-sql-server.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/kefV189fRrA" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/server-consolidation-with-sql-server.htmltag:blogger.com,1999:blog-4951517370322579863.post-8349680226282329070Sat, 02 May 2009 18:57:00 +00002009-05-02T11:57:56.114-07:00SQL Server 2008TroubleshootingPerformanceThis 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 (http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/t8YATHjJbG0/troubleshooting-performance-problems-in.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/t8YATHjJbG0" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/troubleshooting-performance-problems-in.htmltag:blogger.com,1999:blog-4951517370322579863.post-5154496527140752964Sat, 02 May 2009 18:56:00 +00002009-05-02T11:56:30.782-07:00SQL Server 2008Windows Server 2008The 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. Read the White Paper: http://download.microsoft.com/download/6/9/d/69d1fea7-5b42-437a-b3ba-a4ad13e34ef6/SQL2008onWinSvr2008.docx http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/vXVVbxLnR7Y/running-microsoft-sql-server-2008-on.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/vXVVbxLnR7Y" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/running-microsoft-sql-server-2008-on.htmltag:blogger.com,1999:blog-4951517370322579863.post-7284899867127955847Sat, 02 May 2009 18:55:00 +00002009-05-02T11:55:08.731-07:00Microsoft IT produced the SQL Utility to improve SQL Server manageability through host consolidation, virtualization, and standardization. Download the White Paper: http://download.microsoft.com/download/C/F/B/CFB498D0-37B0-4805-9B41-EE2FCA3F1196/SQL%20Sustainability%20Technical%20White%20Paper.doc http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/OnueGiZI-Vg/improving-sustainability-and-use-of-sql.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/OnueGiZI-Vg" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/05/improving-sustainability-and-use-of-sql.htmltag:blogger.com,1999:blog-4951517370322579863.post-6425807003375094663Tue, 31 Mar 2009 03:35:00 +00002009-03-30T20:35:15.379-07:00SSISSQL Server 2005This 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 2005 Integration Services (SSIS) can help Information Technology departments meet data integration requirements in their companies. Real-world scenarios are http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/gAJjRrZKvBQ/introduction-to-sql-server-2005.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/gAJjRrZKvBQ" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/introduction-to-sql-server-2005.htmltag:blogger.com,1999:blog-4951517370322579863.post-1690584019087103964Tue, 31 Mar 2009 03:32:00 +00002009-03-30T20:32:35.338-07:00SQL Server 2000The purpose of this paper is to provide a concentrated, yet pragmatic, overview of ADO.NET by highlighting the performance and usability benefits of using ADO.NET with Microsoft® SQL Server™ 2000. The intended audience is architects and developers who are familiar with ADO and are interested in learning about data access in the Microsoft .NET Framework. Read the White Paper: http://http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/_H1qvpj9zHU/adonet-primer.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/_H1qvpj9zHU" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/adonet-primer.htmltag:blogger.com,1999:blog-4951517370322579863.post-9094099621928103132Tue, 31 Mar 2009 03:30:00 +00002009-03-30T20:31:00.618-07:00Business IntelligenceAnalysis ServicesData MiningBIGet a high-level overview of the benefits of the extensibility framework in SQL Server 2005 Analysis Services that allows independent software developers to easily integrate new data mining algorithms into the product Read the White Paper: Technet Link: http://technet.microsoft.com/en-us/library/aa964125.aspx MSDN Link: http://msdn.microsoft.com/hi-in/library/aa964125(en-us).aspx http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/InvMnqeQhbs/add-custom-data-mining-algorithms-to.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/InvMnqeQhbs" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/add-custom-data-mining-algorithms-to.htmltag:blogger.com,1999:blog-4951517370322579863.post-5480639972876921700Sat, 28 Mar 2009 03:40:00 +00002009-03-27T20:40:50.795-07:00ReplicationSQL Server 2005This paper first discusses the benefits and evolution of peer-to-peer transactional replication. It then outlines the steps for configuring a peer-to-peer topology and provides scripts and detailed directions for completing setup of this topology. The paper closes with some frequently asked questions about peer-to-peer replication. Read White Paper: http://technet.microsoft.com/en-us/library/http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/1zUnlBVcOEQ/achieving-scalability-and-availability.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/1zUnlBVcOEQ" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/achieving-scalability-and-availability.htmltag:blogger.com,1999:blog-4951517370322579863.post-7393999798222674157Fri, 27 Mar 2009 02:30:00 +00002009-03-26T19:30:44.920-07:00Data Protection ManagerSQL Server™ 2005 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 backuphttp://feedproxy.google.com/~r/SqlServerWhitePapers/~3/piCzTn1kT4E/white-paper-protecting-sql-server-with.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/piCzTn1kT4E" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/white-paper-protecting-sql-server-with.htmltag:blogger.com,1999:blog-4951517370322579863.post-7339779865136724781Fri, 27 Mar 2009 02:28:00 +00002009-03-26T19:28:45.761-07:00System Centre Data Protection ManagerDownload Data sheet: http://download.microsoft.com/download/1/b/7/1b72a630-c72d-4e59-b89f-5c2e7e08d5e7/DPM2007_datasheet_How_to_protect_SQL_Server.docx http://feedproxy.google.com/~r/SqlServerWhitePapers/~3/_BAwUIJcZAg/datasheet-how-to-protect-sql-server.htmljacob@dotnetquest.com (jacob.sebastian)0<img src="http://feeds.feedburner.com/~r/SqlServerWhitePapers/~4/_BAwUIJcZAg" height="1" width="1"/>http://www.sqlwhitepapers.com/2009/03/datasheet-how-to-protect-sql-server.html