Earlier this month, I was very fortunate to visit Microsoft User Group Hyderabad lead by Hima Vindu Vejella. Hima is a very enthusiastic leader and kind person. I had a wonderful time meeting her as well her husband during my visit to Hyderabad. I had presented session on Index, which was well received.
Brief information on [...]
Archive for the ‘SQL Training’ Category
SQLAuthority News – MUGH – Microsoft User Group Hyderabad – Feb 2, 2010 Session Review
Posted in MVP, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQL User Group, SQLAuthority Author Visit, SQLAuthority News, T SQL, Technology on February 25, 2010 | 9 Comments »
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
Posted in SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, T SQL, Technology on December 24, 2009 | 12 Comments »
Earlier this year we had offered Query Optimization course and it was sold out in minutes. Due to popular demand we are offering the same course in very first week of next year. The title of the course is ‘MS SQL Server 2005/2008 Query Optimization And Performance Tuning‘.
The course is scheduled to be delivered from [...]
SQL Authority News – Training MS SQL Server 2005/2008 Query Optimization And Performance Tuning
Posted in Pinal Dave, SQL, SQL Authority, SQL Index, SQL Optimization, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL Training, SQLAuthority News, T SQL, Technology on November 10, 2009 | 21 Comments »
This is very short note announcing details about my course details for ‘MS SQL Server 2005/2008 Query Optimization And Performance Tuning‘.
The course is scheduled to be delivered from 19th Nov, 2009 and 21st Nov, 2009 in Pune, India.
This three day course is an intensive course designed to give attendees an in-depth look at the query [...]
About Pinal Dave
Pinalkumar Dave is a Microsoft SQL Server MVP and a Mentor for Solid Quality India. He has written over 1200 articles on the subject on his blog at http://blog.sqlauthority.com. He is a dynamic and proficient Principal Database Architect, Corporate Trainer and Project Manager, who specializes in SQL Server Programming and has 7 years of hands-on experience. He holds a Masters of Science degree and a number of certifications, including MCDBA and MCAD (.NET). He is also Regional Mentor for PASS Asia.

-
Blog Stats
- 13,605,678 (13 Million+)
SQLAuthority Links
.
My Homepage
My Resume
My Other Blog
I prefer Idera
--------------------
Top Downloads
PDF Downloads
Script Downloads
Script Bank
Favorite Scripts
All Scripts - 1
All Scripts - 2
Top Articles
Best Articles
Favorite Articles - 1
Favorite Articles - 2
--------------------
SQL Interview Q & A
SQL Coding Standards
SQL FAQ Download
--------------------
Jobs @ SQLAuthority
Pages
Categories
- About Me (69)
- Best Practices (98)
- Business Intelligence (27)
- Data Warehousing (39)
- Database (284)
- DBA (130)
- MVP (109)
- Poll (5)
- Readers Contribution (42)
- Readers Question (53)
- Software Development (67)
- SQL Add-On (93)
- SQL Backup and Restore (55)
- SQL BOL (11)
- SQL Coding Standards (21)
- SQL Constraint and Keys (52)
- SQL Cursor (28)
- SQL Data Storage (48)
- SQL DateTime (38)
- SQL Documentation (240)
- SQL Download (241)
- SQL Error Messages (134)
- SQL Function (126)
- SQL Humor (25)
- SQL Index (115)
- SQL Interview Questions and Answers (59)
- SQL Joins (65)
- SQL Optimization (88)
- SQL Performance (249)
- SQL Puzzle (29)
- SQL Security (121)
- SQL Server DBCC (42)
- SQL Server Management Studio (28)
- SQL Stored Procedure (105)
- SQL String (22)
- SQL System Table (54)
- SQL Trigger (24)
- SQL User Group (53)
- SQL Utility (128)
- SQL White Papers (50)
- SQLAuthority (431)
- SQL Training (3)
- SQLAuthority Author Visit (92)
- SQLAuthority Book Review (20)
- SQLAuthority News (397)
- SQLAuthority Website Review (39)
- SQLServer (104)
- Tech (1002)
- Pinal Dave (992)
- SQL Scripts (581)
- Technology (1279)
- SQL (1279)
- SQL Authority (1279)
- SQL Query (1279)
- SQL Server (1279)
- SQL Tips and Tricks (1279)
- T SQL (1279)
-
Top Posts
- SQL SERVER - Insert Data From One Table to Another Table - INSERT INTO SELECT - SELECT INTO TABLE
- SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL
- SQL SERVER - Import CSV File Into SQL Server Using Bulk Insert - Load Comma Delimited File Into SQL Server
- SQL SERVER - Retrieve Current Date Time in SQL Server CURRENT_TIMESTAMP, GETDATE(), {fn NOW()}
- SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
- SQL SERVER - Convert Text to Numbers (Integer) - CAST and CONVERT
- SQL SERVER - Shrinking Truncate Log File - Log Full
- 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 Interview Questions and Answers Complete List Download
- SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
- SQL SERVER - Restore Database Backup using SQL Script (T-SQL)
- SQL SERVER - 2005 List All Tables of Database
Top 5 Commenters
-
Authors
-
pinaldave
- SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE
- SQL SERVER – Quick Note of Database Mirroring
- SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU
- SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You
- SQLAuthority News – SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update)
- SQLAuthority News – Download Microsoft SQL Server JDBC Driver 3.0 CTP 1
- SQL SERVER – Checklist for Analyzing Slow-Running Queries
- SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
- SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting
- SQL SERVER – Improve Performance by Reducing IO – Creating Covered Index
-
Archives
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- 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

