Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed

October 14, 2010

This is my 1500th blog post. I am very happy. In my earlier 1400th blog post mile stone, I made a promise that I would explain why I have chosen SQLAuthority.com as my blog’s name. Let me share with you the story about how I came up with the name.…

SQL SERVER – Visiting Alma Mater – Delivering Session on Database Performance and Career – Nirma Institute of Technology

October 13, 2010

Pinal Dave

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

Best Practices, Database, SQLAuthority Author Visit

Everyone always dream of visiting their school and college, where they have had studied once. It is a great feeling to see the college once again – where you have spent the wonderful golden years of your time. College time is filled with studies, education, emotions and several plans to…

SQL SERVER – Indexed View always Use Index on Table

October 12, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL View

This blog post is written in response to T-SQL Tuesday hosted by Shankar Reddy. I have been recently writing about Views and their Limitations. While writing this article series, I got inspired to write about SQL Server Quiz Questions. You can view the Quiz Question posted over here. In SQL…

SQLAuthority News – Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site

October 11, 2010

Pinal Dave

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

SharePoint, SQLAuthority Author Visit

I am delighted and very excited as I am going to attend very first time SharePoint Conference. Even though I will be attending SP conference, I will be presenting on my favorite subject – SQL Server Performance. Every SharePoint site runs on SQL Server and most of the SharePoint sites…

SQL SERVER – Encrypted Stored Procedure and Activity Monitor

October 10, 2010

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Stored Procedure

I recently had received question if any stored procedure is encrypted can we see its definition in Activity Monitor.

SQLAuthority News – SQL Server 2008 Add-ins and Feature Pack Downloads

October 9, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download, SQL Utility

Here are few of the latest Microsoft Add-ins and downloads recently announced. SQL Server Reporting Services Add-in for SharePoint Technologies The Microsoft SQL Server 2008 SP2 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of…

SQL SERVER – Simple Explanation of Data Type Precedence

October 8, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Datatype, SQL Scripts

While I was working on creating a question for SQL SERVER – SQL Quiz – The View, The Table and The Clustered Index Confusion, I had actually created yet another question along with this question. However, I felt that the one which is posted on the SQL Quiz is much…