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

May21

SQL SERVER – Unable to Bring SQL Cluster Online – Reason: The Account is Disabled

Pinal Dave

SQL

, SQL Server, SQL Server Cluster, SQL Server Management Studio, SQL Server Security, SSMS

No Comments

This was one of an interesting issue reported by my client. They informed that after some hardening by the security team, they are not able to bring SQL resource online in the cluster. In this blog, we would learn about how to fix the issue where SQL cluster is not coming online.

May20

How to Generate Fibonacci Series for the First 1000 Values? – Interview Question of the Week #174

Pinal Dave

SQL Interview Questions and Answers

SQL Function, SQL Scripts, SQL Server

Question: How to Generate Fibonacci Series for the First 1000 Values?

May19

SQL SERVER – SQL Server Cluster Resource Doesn’t Come Online Randomly

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Cluster, SQL System Table, SQL Trace, System Database

No Comments

This was another interesting situation where client reported that their SQL Server Cluster resource, sometimes, fail to come online when they perform failover of SQL Server from one node to another. In this blog, we would learn how to fix ” SQL Server resource not coming to an online state ” issue.

May18

SQL SERVER – Impact of Transaction on the Free Log Space

Pinal Dave

SQL Tips and Tricks

SQL Log, SQL Scripts, SQL Server, Transaction Log

Earlier I wrote a blog post about SQL SERVER – How to Find Free Log Space in SQL Server? After reading this blog post, I received the following question from one of the users about the impact of the transaction on the free log space.

May17

SQL SERVER – Reading Transaction Log to Identified Who Dropped a Table

Pinal Dave

SQL Tips and Tricks

SQL Log, SQL Scripts, SQL Server, Transaction Log

The other day I received a distress email from a user who wanted to find out who has dropped a table or column from their database. During the On Demand (55 minutes) consultation, not only I was able to help them with restoring their lost data but also was able to find out which user had actually dropped their table “accidentally”. We were lucky enough that the user had a database in full recovery model, hence their transaction log recorded every detail needed.

May16

SQL SERVER – Simple Script to Create a Login and User for a Specific Database with System Admin Rights

Pinal Dave

SQL Tips and Tricks

, SQL Scripts, SQL Server, SQL Server Security

A very popular question I often receive about SQL Server security is what is the difference between SQL Server Login and SQL Server User. I really love this question as I bet only 5% of SQL Server professionals I met know the answer to this question. In this blog post, we are going to see a Simple Script to Create a Login and User for a Specific Database with System Admin Rights.

May15

SQL SERVER – Databases Going to Recovery Pending State Randomly

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, Starting SQL

No Comments

One of my famous offerings is Comprehensive Database Performance Health Check where we always go over various SQL Server and database level properties. Lots of people do not know that there are quite a few SQL Server and database level settings which can help us improve our SQL Server performance many folds. Let us learn in this blog post how to fix the error about Databases Going to Recovery Pending State Randomly.

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 18 SQL Server database books and 118 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.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.