Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 2008 – Step By Step Installation Guide With Images

June 12, 2008

Database, SQL Server, SQL Server Installation

SQL SERVER 2008 Release Candidate 0 has been released for some time and I have got numerous request about how to install SQL Server 2008. I have created this step by step guide Installation Guide. Images are used to explain the process easier.

SQL SERVER – 2008 – Four Key Pillars

June 11, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development

As SQL Server 2008 is now ready to ship its final product in few months, I get many questions about what is new and attractive in SQL Server 2008. SQL SERVER 2008 has four key pillars. 1) Enterprise Data Platform It has heavily reliable database platform and can be expanded…

SQL SERVER – Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies

June 10, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Data Storage, SQL Download

Note: Download Here by Microsoft Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007.…

SQLAuthority News – SQL Server 2008 Release Candidate 0

June 9, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, SQL Download

Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback. SQL Server 2008 provides a comprehensive data…

SQL SERVER – Order of Conditions in WHERE Clause

June 8, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server

Sr. Developer in my organization asked me the following question about WHERE clause.

Question: Does the order of conditions matter in WHERE clause?

SQL SERVER – PIVOT and UNPIVOT Table Examples

June 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

PIVOT, SQL Joins, SQL Scripts, UNPIVOT

I previously wrote two articles about PIVOT and UNPIVOT tables. I really enjoyed writing about them as it was interesting concept. One of the Jr. DBA at my organization asked me following question. “If we PIVOT any table and UNPIVOT that table do we get our original table?” I really…

SQLAuthority News – Subscribe to the Newsletter for 3 Important Scripts

June 6, 2008

Pinal Dave

SQLAuthority News

Database, , SQL Wait Stats

Lots of people ask me how to stay in touch with SQLAuthority.com. Well, the answer is very simple, you can subscribe to the newsletter of SQLAuthority.com by going to URL here: https://go.sqlauthority.com.