June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Server 2008 Analysis Services Performance Guide

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Business Intelligence, SQL Documentation, SQL Download, SQL White Papers
Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments. Enhancing Query Performance – Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark…
Read More

SQL SERVER – Whitepaper Consolidation Using SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Consolidation Using SQL Server 2008 Writer: Allan Hirt, Megahirtz LLC (allan@sqlha.com) Technical Reviewers: Lindsey Allen, Madhan Arumugam, Ben DeBow, Sung Hsueh, Rebecca Laszlo, Claude Lorenson, Prem Mehra, Mark Pohto, Sambit Samal, and Buck Woody Published: October 2009 Many companies are considering or have already implemented consolidation of computing resources, including…
Read More

SQLAuthority News – Disk Partition Alignment Best Practices for SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, SQL White Papers
Disk Partition Alignment Best Practices for SQL Server Writers: Jimmy May, Denny Lee Contributors: Mike Ruthruff, Robert Smith, Bruce Worthington, Jeff Goldner, Mark Licata, Deborah Jones, Michael Thomassy, Michael Epprecht, Frank McBath, Joseph Sack, Matt Landers, Jason McKittrick, Linchi Shea, Juergen Thomas, Emily Wilson, John Otto, Brent Dowling Technical Reviewers:…
Read More

SQL SERVER – Sharepoint Resource Available for SQL Server

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SharePoint, SQL Documentation, SQL White Papers
Here is quick list of the tools which are available for SQL Server and Sharepoint. These are recently updated resources from Microsoft. External Collaboration Toolkit for SharePoint This solution allows users to create collaboration environments that use the familiar SharePoito deploy a SharePoint-based environment for collaboration with people outside your…
Read More

SQLAuthority News – Data Compression Strategy Capacity Planning and Best Practices

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Data Storage, SQL White Papers
Data Compression: Strategy, Capacity Planning and Best Practices SQL Server Technical Article Writer: Sanjay Mishra Contributors: Marcel van der Holst, Peter Carlin, Sunil Agarwal Technical Reviewer: Stuart Ozer, Lindsey Allen, Juergen Thomas, Thomas Kejser, Burzin Patel, Prem Mehra, Joseph Sack, Jimmy May, Cameron Gardiner, Mike Ruthruff, Glenn Berry (SQL Server…
Read More

SQL SERVER – Tuning the Performance of Change Data Capture in SQL Server 2008

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL White Papers
Change data capture (CDC) is a new feature in SQL Server 2008 designed to capture insert, update, merge, and delete activities applied to SQL Server tables and to avail those changes in an easy-to-understand format. Conventionally, detecting changes in a source database to transfer these changes to a data warehouse…
Read More

SQLAuthority News – Best Practices for Integration Services Configurations

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Business Intelligence, SQL White Papers, SSIS
Best Practices for Integration Services Configurations by Jamie Thomson This article explains what SQL Server Integration Services configurations are used for, why you should use Integration Services configurations, and what options you have for leveraging configurations. It will also make some simple recommendations that are based on my experiences of…
Read More