June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

Pinal Dave
Personal, SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News
Best Practices, Database, SQL Index, SQL Scripts, SQL Training
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…
Read More

SQLAuthority News – SQL Server Performance Optimization – Seminar Series

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
MVP, SQL Training, SQLAuthority Author Visit
I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more…
Read More

SQLAuthority News – Download – SQL Server Monitoring Management Pack

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQL Documentation, SQL Download
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…
Read More

SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script

Pinal Dave
SQL, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Server

I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.

Read More