About: pinaldave
- Full Name
- Pinalkumar Dave
- Website
- http://blog.sqlauthority.com/
- Details
- Pinalkumar Dave is Microsoft SQL Server MVP and author of over 900 SQL Server articles. He has six years experience as Principal Database Administrator in MS SQL Server 2008/2005, .NET (C#) and ColdFusion MX. He has a Masters of Science degree in Computer Networks, along with MCDBA, MCAD(.NET) and ColdFusion Advanced MX Certifications.
Posts by pinaldave:
-
July 6, 2009 SQL SERVER – Languages for BI – MDX, DMX, XMLA
-
July 5, 2009 SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
-
July 4, 2009 SQL SERVER – Disk Partition Alignment Best Practices
-
July 3, 2009 SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
-
July 2, 2009 SQLAuthority News – MVP Award Renewed
-
July 1, 2009 SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
-
June 30, 2009 SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
-
June 29, 2009 SQL SERVER – Maximum Number of Index per Table
-
June 28, 2009 SQL SERVER – 2008 – Management Studio New Features
-
June 27, 2009 SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
-
About Pinal Dave
Pinalkumar Dave is Microsoft SQL Server MVP and a prominent author of over 1000 SQL Server articles. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager specializing in SQL Server Programming with over 7 years of hands-on experience. He holds a degree in Masters of Science and has accomplished a number of certifications including MCDBA and MCAD (.NET). He has also been awarded Regional Mentor for PASS Asia.
-
Blog Stats
- 8,332,547 Readers
-
SQLAuthority Links

My Homepage
My Resume
My Other Blog
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 1
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Categories
- About Me (49)
- Best Practices (82)
- Business Intelligence (6)
- Data Warehousing (27)
- Database (257)
- DBA (121)
- DigiCorp (7)
- MVP (79)
- Poll (5)
- Readers Contribution (22)
- Readers Question (28)
- Software Development (62)
- SQL Add-On (88)
- SQL Backup and Restore (48)
- SQL BOL (8)
- SQL Coding Standards (21)
- SQL Constraint and Keys (49)
- SQL Cursor (30)
- SQL Data Storage (36)
- SQL DateTime (36)
- SQL Documentation (193)
- SQL Download (198)
- SQL Error Messages (116)
- SQL Function (104)
- SQL Humor (22)
- SQL Index (82)
- SQL Interview Questions and Answers (54)
- SQL Joins (61)
- SQL Optimization (51)
- SQL Performance (204)
- SQL Puzzle (18)
- SQL Security (115)
- SQL Server DBCC (42)
- SQL Server Management Studio (17)
- SQL Stored Procedure (97)
- SQL String (17)
- SQL System Table (27)
- SQL Trigger (27)
- SQL User Group (39)
- SQL Utility (116)
- SQL White Papers (8)
- SQLAuthority (304)
- SQLAuthority Author Visit (60)
- SQLAuthority Book Review (18)
- SQLAuthority News (274)
- SQLAuthority Website Review (23)
- SQLServer (41)
- Tech (769)
- Pinal Dave (758)
- SQL Scripts (490)
- Technology (1020)
- SQL (1020)
- SQL Authority (1020)
- SQL Query (1020)
- SQL Server (1020)
- SQL Tips and Tricks (1020)
- T SQL (1020)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL Server Interview Questions and Answers Complete List Download
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - 2005 - Create Script to Copy Database Schema and All The Objects - Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - Shrinking Truncate Log File - Log Full
- SQL SERVER - 2005 NorthWind Database or AdventureWorks Database - Samples Databases
- SQL Server Interview Questions and Answers - Part 1
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
-
Authors
-
pinaldave
- SQL SERVER – Languages for BI – MDX, DMX, XMLA
- SQLAuthority News – FIX : Error : HP OfficeJet Scanning and Printing Gray or Pink Shades
- SQL SERVER – Disk Partition Alignment Best Practices
- SQLAuthority News – Book Review – The Rational Guide to Building Technical User Communities (Rational Guides)
- SQLAuthority News – MVP Award Renewed
- SQL SERVER – Difference between Line Feed (\n) and Carriage Return (\r) – T-SQL New Line Char
- SQL SERVER – 2008 – Policy-Based Management – Create, Evaluate and Fix Policies
- SQL SERVER – Maximum Number of Index per Table
- SQL SERVER – 2008 – Management Studio New Features
- SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
-
Archives
- July 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Pages
Category Cloud
About Me Best Practices Database DBA MVP Pinal Dave Software Development SQL SQL Add-On SQL Authority SQLAuthority Author Visit SQLAuthority News SQL Documentation SQL Download SQL Error Messages SQL Function SQL Index SQL Interview Questions and Answers SQL Joins SQL Optimization SQL Performance SQL Query SQL Scripts SQL Security SQL Server SQL Stored Procedure SQL Tips and Tricks SQL Utility Technology T SQL


