SQL Server Performance Tuning Expert frontimage1

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

SQL Server Performance Tuning Expert frontimage2

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

SQLAuthority News – SQL Server Energy Event with Rushabh Mehta – May 20, 2009

The much-awaited SQL Server Energy Event was successfully held on May 20, 2009 in Ahmedabad. It was jointly organized by Gandhinagar SQL Server User Group (President Pinal Dave – SQL MVP) and Ahmedabad SQL Server User Group (President Jacob Sebastian – SQL MVP). This vibrant event was one of the…
Read More

SQLAuthority News – Download – SQL Server 2008 Developer Training Kit

Note : Download SQL Server 2008 Developer Training Kit by Microsoft

SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Read More

SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )

Regular readers of my blog are aware of the fact that I have written about this subject umpteen times earlier, and every time I have spoken about a new issue related to it. Few days ago, I had redone my local home network. I have LAN setup with wireless router…
Read More

SQLAuthority News – SQL Server Energy Event – Mark Your Calendar – May 20, 2009

I am very excited to share this news with all my readers. If you all remember I had already given a hint on my blog just two days back; I mentioned that we are going to host a grand event for Gandhinagar SQL Server User Group. In the past, Gandhinagar…
Read More

SQL SERVER – Fix : Management Studio Error : Saving Changes in not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created

Today, we will delve into a very simple issue that one of the Jr. Developers at my organization confronted. I have a preference for T-SQL. According to me, all the developers should always use T-SQL instead of Design feature of SQL Server Management Studio (SSMS). In fact, sound knowledge of…
Read More

SQLAuthority News – Gandhinagar SQL Server User Group Meeting – International Speaker Visiting

It is my pleasure to announce Gandhinagar SQL Server User Group Meeting on May 20, 2009 Wednesday. Mark this date as we will be having international speaker Rushabh Mehta of SolidQ attending our session. Rushabh Mehta is a Mentor for Solid Quality Mentors’ global Business Intelligence division, based in USA,…
Read More