Blogs about: Pinal Dave

Featured Blog

Congratulations Pinal Dave!

In the recently concluded MVP Summit, Pinal Dave was named one of the Top Contributors in SQL Server community. His blog is really a great source for SQL Server. I believe his blog is second only to M… more →

Marlon Ribunal's Note On SQL Server

SQLAuthority News - Book Review - The Rational Guide to Building Technical User Communities (Rational Guides)

pinaldave wrote 1 day ago: The Rational Guide to Building Technical User Communities (Rational Guides) (Paperback) by Greg Low … more →

Tags: SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Book Review, SQLAuthority News, T-SQL

SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char — 4 comments

pinaldave wrote 3 days ago: Today, we will examine something very simple and very generic that can apply to hordes of programmin … more →

Tags: SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, sqlcmd, T-SQL, technology

SQL SERVER - Maximum Number of Index per Table — 8 comments

pinaldave wrote 5 days ago: TechEd on Road Ahmedabad, June 20, 2009, was a huge success. This grand event saw over 200 attendees … more →

Tags: reader's contribution, Reader's question, SQL, SQL Authority, SQL Index, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL

SQL SERVER - Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to 'master'.

pinaldave wrote 1 week ago: I had previously written two articles about an intriguing observation of triggers online. SQL SERVER … more →

Tags: Reader's question, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQL Trigger

SQLAuthority News - Authors Visit - K-MUG TechEd Trivandrum on June 27, 2009

pinaldave wrote 1 week ago: K-MUG is organizing TechEd Trivandrum on 27th June, 2009. Not just this, they are launching an offic … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Visit, SQLAuthority News, T-SQL

SQLAuthority News - Update on pinaldave.com and SQLAuthority.com — 2 comments

pinaldave wrote 1 week ago: Problem: SQLAuthority.com site was not allowed in some browsers as pinaldave.com site was marked as … more →

Tags: Database, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, SQLSERVER, T-SQL

SQLAuthority News - TechEd on Road Ahmedabad June 20, 2009 - An Astounding Success — 8 comments

pinaldave wrote 1 week ago: TechEd on Road Ahmedabad In India, TechEd was held in Hyderabad in the month of May. You can read my … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority Visit, SQLAuthority News

SQL SERVER - Why You Should Attend PASS Summit Unite 2009- Seattle — 1 comment

pinaldave wrote 2 weeks ago: PASS Summit Unite 2009 – the premier event for SQL Server professionals – will be held i … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, SQLSERVER

SQL SERVER Interview Questions

nagarajreddy321 wrote 2 weeks ago: What is the difference between clustered and a non-clustered index? A clustered index is a special t … more →

Tags: Database, SQL, SQL Authority, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Index, SQL Interview Questions and Answers, SQL Joins

SQL SERVER - Clustered Index on Separate Drive From Table Location — 3 comments

pinaldave wrote 2 weeks ago: How to improve performance of SQL Server Queries is a common topic of discussion among many of us. M … more →

Tags: Best Practices, SQL, SQL Authority, SQL Constraint and Keys, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Server

SQLAuthority News - 1000th Article Milestone - 8 Millions Views - Solid Quality Mentors — 11 comments

pinaldave wrote 2 weeks ago: Achieving a milestone gives a great sense of accomplishment! Today, I am writing my 1000th Article o … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, T-SQL

SQL SERVER - Effect of Normalization on Index and Performance — 3 comments

pinaldave wrote 3 weeks ago: Of late, I have been using Twitter quite frequently, and I am gradually discovering its usefulness. … more →

Tags: SQL, SQL Authority, SQL Index, SQL OPTIMIZATION, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL

SQLAuthority News - Registration and Competition - TechEd on Road - Ahmedabad - June 20, 2009 Saturday — 7 comments

pinaldave wrote 3 weeks ago: We have an upcoming grand event of TechEd on Road organized in Ahmedabad. This is a FREE event and A … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, T-SQL

SQL SERVER - Performance Counters from System Views - By Kevin Mckenna

pinaldave wrote 3 weeks ago: I just love social media and all the new concepts of Web 2.0. There are bloggers who are overwhelmed … more →

Tags: reader's contribution, SQL, SQL Authority, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks

SQLAuthority News - TechEd On Road Ahmedabad, India is Announced - June 20, 2009 Saturday — 1 comment

pinaldave wrote 3 weeks ago: Register here : http://techedahmedabad.eventbrite.com/ Register here : http://techedahmedabad.event … more →

Tags: MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL User Group, SQLAuthority News, SQLSERVER

SQL SERVER - Fix : Error: 15372 Failed to generate a ser instance od SQL Server due to a failure in starting the process for the user instance. The connection will be closed — 1 comment

pinaldave wrote 3 weeks ago: Just a day ago, I was installing SQL Server Express on backup computer. I only use this computer whe … more →

Tags: SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology, SQL Server Express

SQL SERVER - Order of Hotfix and Service Pack — 2 comments

pinaldave wrote 4 weeks ago: On an average once a week I receive a question from my readers regarding what should be the sequence … more →

Tags: Reader's question, SQL, SQL Authority, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology

SQLAuthority News - Rambling of Author and Technology Musing - Bing, Google, Windows 7, Books, Blogs, Twitter and Life — 1 comment

pinaldave wrote 4 weeks ago: I have been planning to write a general post on the latest technology for a long time but SQL keeps … more →

Tags: dba, MVP, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority News, T-SQL

SQL SERVER - Connect Item - Vote for Feature Request Function TRIM — 3 comments

pinaldave wrote 1 month ago: Till date, I have met the SQL Server Product Team twice: first time at SQL Server MVP Meet, Seattle, … more →

Tags: SQL, SQL Authority, SQL Function, SQL Query, SQL Server, SQL Tips and Tricks, T-SQL, technology, Microsoft Connect


Have your say. Start a blog.

See our free features →

Related Tags
All →

Follow this tag via RSS

Find other items tagged with “pinal-dave”:
Technorati Del.icio.us IceRocket