Sep 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

SQLAuthority News – Whitepaper – Auditing in SQL Server 2008

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
Auditing in SQL Server 2008 SQL Server Technical Article Writer: Il-Sung Lee, Art Rask Technical Reviewer: Jack Richins, Rick Byham, Sameer Tejani, Al Comeau, JC Cannon Published: February 2009 With SQL Server Audit, SQL Server 2008 introduces an important new feature that provides a true auditing solution for enterprise customers.…
Read More

SQLAuthority News – Accessing SQL Server Databases with PHP

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL White Papers
Accessing SQL Server Databases with PHP SQL Server Technical Article Writer: Brian Swan Published: August 2008 The 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…
Read More

SQL SERVER – Download Logical Query Processing Poster

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Download, SQL Server

You can download the poster from Itzik Ben-Gan’s T-SQL Querying page over here.

Earlier this year, I had written article on SQL SERVER – Logical Query Processing Phases – Order of Statement Execution and I had asked one question to readers. I got very good response for this question. Today, I am going to discuss about one of the errata I have made there. I had displayed the Logical Query Processing order, where I had incorrectly listed the last two operations. I have listed the operations as ORDER BY first and TOP afterwards. The fact is that TOP is always executed first and ORDER BY after that.

Read More

SQLAuthority News – Download IIS Database Manager

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download, SQL Utility
IIS Database Manager allows you to easily manage your local and remote databases from within IIS Manager. IIS Database Manager automatically discovers databases based on the Web server or application configuration and also provides the ability to connect to any database on the network. Once connected, IIS Database Manager provides…
Read More

SQL SERVER – Introduction to Service Broker and Sample Script

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Service Broker, SQL Download, SQL Scripts
Service Broker in Microsoft SQL Server 2005 is a new technology that provides messaging and queuing functions between instances. The basic functions of sending and receiving messages forms a part of a “conversation.” Each conversation is considered to be a complete channel of communication. Each Service Broker conversation is considered…
Read More