All Articles - SQL Authority with Pinal Dave

SQL SERVER – Default Collation of SQL Server 2008

December 3, 2008

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.

SQLAuthority News – Download Tools and Documentation for SQL SERVER

November 27, 2008

Pinal Dave

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

SQL Download

SQL Server 2008 Report Definition Language Specification The goal of Report Definition Language (RDL) is to promote the interoperability of commercial reporting products by defining a common schema that allows interchange of report definitions. An important aspect to understand is that RDL is a schema definition, not a programmatic interface…

SQLAuthority News – Help to Find Recession Proof Job

November 26, 2008

Pinal Dave

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

Database, DBA, SQL Jobs

Recently I have been receiving a lot of emails from employees asking where they can find good employee. I was under impression that due to global recession job market is down but from looking at recent increase in emails for looking for right candidate I have to say that there…

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

November 25, 2008

Pinal Dave

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

Database, DBA, MVP, Openday, SQL User Group, SQLAuthority Author Visit

It is time again to announce SQL Hour – SQL Server User Group Meeting for November 2008. This time it is going to be one really interesting event. Our User Group is growing and getting more interesting. Lots of new SQL Server enthusiastic have contacted me recently for User Group…

SQL SERVER – Interesting Observation about Order of Resultset without ORDER BY

November 24, 2008

Pinal Dave

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

SQL Constraint and Keys, SQL Scripts

Today I observed very interesting little thing about SQL Server and I felt that I should share this with my readers. I ran following two queries and found that I am getting different result-set. When I carefully observed I found that actually the result was same but order of the…