Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Microsoft SQL Server 2008 Enterprise Evaluation: Trial Experience for IT Professionals / Developers

December 4, 2008

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

Download SQL Server 2008 180-day Trial Software. Microsoft SQL Server 2008 is a database platform for large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications; it is also a business intelligence platform for data analysis and reporting solutions. SQL Server 2008 is a trusted, productive, and intelligent data platform…

SQL SERVER – Default Collation of SQL Server 2008

December 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

Recently I wrote article about SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial, I received couple of comment suggesting that I did not talk about SQL Server default collation setting or how to change default collation when installing…

SQL SERVER – 2008 – Install SQL Server 2008 – How to Upgrade to SQL Server 2008 – Installation Tutorial

December 2, 2008

Pinal Dave

SQL Tips and Tricks

Database, SQL Server, SQL Server Installation

SQL SERVER 2008 RTM 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. I had previously written the same article earlier. It seemed necessary to re post it again as request of me posting Step by Step tutorial has increased for quite some time.

SQL SERVER – Roadmap of Microsoft Certifications – SQL Server Certifications

December 1, 2008

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, DBA, Microsoft Certifications, SQL Download

In these times of economical slowdown, more and more IT professionals are concerned about their jobs and their qualifications. It is a common trend for developers to start looking for ways to update their skills when jobs are not secure. Pure knowledge and real world work experience are always a…

SQL SERVER – Interesting Observation – Use of Index and Execution Plan

November 30, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Best Practices, SQL Index, SQL Scripts

Previously I wrote article about SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY and I have received tremendous response from my readers by emails and comments. Readers demanded that I should have written little more for the same subject. As I really liked the subject myself…

SQLAuthority News – Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008

November 29, 2008

Pinal Dave

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

MVP, Openday, SQL Backup and Restore, SQL User Group, SQLAuthority Author Visit

Today is special day for SQL Server enthusiastic as we will have SQL Server User Group Meeting today in Ahmedabad. Today in User Group we will have UG President Jacob Sebastian (MVP) participating from New York and UG Vice President Pinal Dave (MVP) will talk about “How to become MVP?”…

SQL Server – Switch Between Result Pan and Query Pan – SQL Shortcut

November 28, 2008

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SQL Shortcut

Many times when I am writing query I have to scroll the result displayed in the result set. Let us learn about the shortcut today.