June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

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

SQLAuthority News – Database Encryption in SQL Server 2008 Enterprise Edition

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Server Encryption, SQL Server Security, SQL White Papers
Database Encryption in SQL Server 2008 Enterprise Edition SQL Server Technical Article Writers: Sung Hsueh Technical Reviewers: Raul Garcia, Sameer Tejani, Chas Jeffries, Douglas MacIver, Byron Hynes, Ruslan Ovechkin, Laurentiu Cristofor, Rick Byham, Sethu Kalavakur Published: February 2008 TDE does not replace cell-level encryption, EFS, or BitLocker. This white paper…
Read More

SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query

Pinal Dave
SQL, SQL Performance, SQL Puzzle, SQL Server, SQL Tips and Tricks
SQL Index, SQL Scripts, SQL White Papers
Recently, I was working on an optimization project for one of the large organizations. While working on one of the queries, we came across a very interesting observation. We found that there was a query on the base table and when the query was run, it used the index, which…
Read More

SQL SERVER – Plan Caching and Schema Change – An Interesting Observation

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Cache, SQL Documentation, SQL Profiler, SQL Scripts, SQL Server Management Studio, SQL Stored Procedure, SQL Utility, SQL White Papers
Last week, I had published details regarding SQL SERVER – Plan Caching in SQL Server 2008 by Greg Low on this blog. Similar to any other white paper, I have read this paper very carefully and enjoyed reading it. One particular topic in the white paper that caught my attention…
Read More