SQL Server Performance Tuning Expert - SQL Authority with Pinal Dave

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.

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.

An Index Reduces Performance of SELECT Queries (Video)
3 Common Mistakes to Kill SQL Server Performance (Video)
Click here for More Free Videos

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

Jun26

SQL SERVER – Unable to Start SQL Resource in Cluster – HUGE Master Database!

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Cluster, System Database

One of my clients contacted me and informed that SQL in cluster failed over from Node 01 to Node 02. It failed to come online on Node 02, failed back to Node 01, and it failed to come online there either. They contacted me to know why they are not able to start SQL Server in the cluster. Let us learn how to start the SQL Resource in Cluster when there is a huge master database.

Jun25

SQL SERVER – Alternate Rows Color in Table Background in HTML

Pinal Dave

SQL Tips and Tricks

HTML, SQL Scripts, SQL Server

Have you ever felt when you get hired to do a job and your customers ask you question, which you would have not imagined in your wildest dream? Well, just happened to me yesterday where I was asked how to write T-SQL to show alternate rows color in table background in HTML.

Jun24

How to Find Service Account for SQL Server and SQL Server Agent? – Interview Question of the Week #179

Pinal Dave

SQL Interview Questions and Answers

SQL Log, SQL Scripts, SQL Server, SQL Server Security, SQL Server Services

Question: How to Find Service Account for SQL Server and SQL Server Agent?

Answer: As they say – There are more ways than one to skin a cat. In this blog, we will find multiple methods to find out service account used for SQL Server service and SQL Agent Service

Jun23

SQL SERVER – Save Auto Recover Information – SSMS

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server Management Studio, SSMS

Though, I have many complaints about SQL Server Management Studio (SSMS) (read the latest one here), I also like some of the features for sure. In this blog post, we will take about Auto Recover feature of SQL Server Management Studio.

Jun22

Free Video – SQL Server Performance Tuning Made Easy

Pinal Dave

SQL Video

SQL Performance, SQL Server, SQL Training

SQL Server Performance Tuning is not as difficult as most of the people think. Actually, SQL Server performance tuning is very easy and simple, if you exactly know what to do and when to do. Well, that is what is the theme of the free webinar which I have done for 24 Hours of PASS.

Jun21

SQL SERVER – Transfer Logins Error: Msg 15419: Supplied Parameter sid Should be Binary(16) – sp_help_revlogin

Pinal Dave

SQL

SQL Error Messages, , SQL Scripts, SQL Server, SQL Server Security

No Comments

While I was writing my earlier blog, I came across another interesting issue with sp_help_revlogin script. In this blog we would learn about the cause of Msg 15419, “Supplied parameter sid should be binary(16)” while transferring the login using sp_help_revlogin and see how to fix it.

Jun20

SQL SERVER – Unable to Install Reporting Service Add-In for SharePoint – System.ArgumentException

Pinal Dave

SQL

SharePoint, SQL Error Messages, SQL Server, SQL Server Installation

No Comments

There are so many components in SQL Server and sometimes there is an error in installing components which I have not used at all. One such component is SSRS with SharePoint. To use this, we need to install Reporting Service Add-In for SharePoint. In this blog, we would see how to fix error System.ArgumentException which was encountered during the installation of Reporting Service Add-In for SharePoint.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.