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

Jun5

We Are Sold Out – Practical Real World Performance Tuning – SQL Authority News

Pinal Dave

SQLAuthority News

Brent Ozar, SQL Performance

No Comments

I am very excited to announce that we are sold out for the two of our class focusing on the USA time zone for Practical Real World Performance Tuning. This is indeed very exciting. If you have signed up for the training, we will be meeting later this week and next week. If you have not signed up for the training, indeed we will miss you during our training.

To be super honest, the request for this training was in demand for a quite a while and at the price point of USD 495, it was a quite a deal. Honestly, I had never thought that this training will be sold out so quickly. When I am looking back at this, I feel pretty comfortable that both the classes are filled up 100% and the audience is going to have lots of fun.

Jun4

Driving up Database Coding Standards and Productivity with SQL Prompt

Alongside specialists, an IT department needs people who are broadly skilled and adaptable, who can pivot quickly to new projects, slot easily into new teams, and be productive quickly. In this blog post, we will learn about database coding standards and productivity.

Jun3

SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).

Pinal Dave

SQL

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

My lab machine is my playground. Other than my real-world client’s problem, many blogs have come from my lab machine because I keep on breaking something or another on my server. Once I found that I was unable to start SQL Server Agent service for one of the SQL Server instances. In this blog, we would learn how to fix error Failed to initialize SQL Agent log (reason: Access is denied)

Jun2

SQL SERVER – All the Features not Listed While Installing SQL Server

Pinal Dave

SQL

Business Intelligence, SQL Error Messages, SQL Server, SQL Server Installation

I was trying to install SQL BI features for one of the assignments I had got. In the setup wizard when I reached the Features Page I got a surprise of my life. There were many features missing! I could not see features available while installing SQL Server listed here:

Jun1

SQL SERVER – Always On Replica Disconnected After Changing SQL Server Service Account

Pinal Dave

SQL

AlwaysOn, SQL Error Messages, , SQL Server, SQL Server Security

In my lab environment, I was testing a script to change service account and it worked fine. I had Always On configured on this SQL Server and soon I realized that after changing the SQL Server service account, the secondary replica went into a disconnected state.

May31

How to Enable Files & Folders Level Auditing in SQL Server? – Interview Question of the Week #176

Pinal Dave

SQL Interview Questions and Answers

Policy Management, SQL Audit, SQL Error Messages, SQL Log, SQL Server, SQL Server Security, Transaction Log

Question: How to Enable Files & Folders Level Auditing in SQL Server?

May30

SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction

Pinal Dave

SQL

AlwaysOn, Registry, SQL Error Messages, SQL High Availability, SQL Server, SQL Server Cluster

As a part of my AlwaysOn related consultancy, one of my clients was having challenges to install SQL Server 2016 in a clustered environment. In this blog, we would learn about the cause of Slow SQL Server 2016 Installation in Cluster.

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