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“.

SQL SERVER – Practical Tips to Reduce SQL Server Database Table Size – Experts Opinion

I am one of those fortunate people who has friends everywhere in the world. Syrovatchenko Sergey is one of my good friends who is an expert on SQL Server. When we met a few days ago in one of the event, we end up discussing about practical tips to reduce SQL Server database table size. Upon returning home, I found Sergey has sent me an amazing article on this subject. It is beautifully written article and I enjoyed it very much. Let us read what Sergey has to say about this subject in his own words.

Read More

Interview Question of the Week #047 – Logic To Find Weekdays Between Two Dates

I often enjoy seeing interview questions where the contestant has to write SQL Scripts. Here is another such example. Question: How to find weekdays between two dates? Answer: Here is a function which can be used to find weekdays between two dates. CREATE FUNCTION dbo.getDayCount(@startdate date, @enddate date) RETURNS INT…
Read More

SQL SERVER – Availability Group and the Six Critical Steps for DBAs to Follow – Notes from the Field #104

Mike’s, “now what am I supposed to do?”, face. [Note from Pinal]: In this episode of the Notes from the Field series database expert Mike Lawell explains about Availability Group and the Six Critical Steps for DBAs to Follow.  A few weeks ago, I asked questions in conferance, how many people…
Read More