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

Sep11

How to Hide Stored Procedure’s Code? – WITH ENCRYPTION – Interview Question of the Week #088

Pinal Dave

SQL Interview Questions and Answers

SQL Server, SQL Server Encryption, SQL Stored Procedure

Question: How to Hide Stored Procedure’s Code so anyone with access to stored procedure cannot see it?

Sep10

SQL SERVER – Setup Screen Not Launching While Updating a Patch

Pinal Dave

SQL

SQL Log, SQL Server, SQL Service Pack

This is one of the client contacts where I realized the importance of looking at right log file. The client said that he double clicks the.exe, a window flash by and disappears. It looked like something was happening, but it’s failing to move forward. Let us learn a very rare but critical error about setup screen not launching while updating a patch.

Sep9

SQL SERVER – How to Increase the SSMS Grid Font Size?

Pinal Dave

SQL Tips and Tricks

Presentation, SQL Server, SQL Server Management Studio

SQL Server Management Studio (SSMS) is part of SQL DBAs life. I use it while doing the presentation. If you are sitting in a big room like below, then the guy sitting in the last row may not be able to see it properly. As a conference speaker and trainer, it is very critical for me to make sure that everyone in the room understand and learn from me. Let us learn in this blog post how to increase the SSMS Grid Font Size?

Sep8

SQLAuthority News – New SQL in Sixty Seconds Video

Today I am going to discuss the new SQL in Sixty Seconds Videos which I have released. Let us learn about them together. Do not forget to subscribe.

Sep8

SQL SERVER – FIX Error 18456, Severity: 14, State: 5. Login failed for user

Pinal Dave

SQL

SQL Error Messages, , SQL Server

Some errors are historic and have the most common root cause. Sometimes we really don’t know why they happen and I have seen clients go nuts to identify the real reason for the problem. In a recent email interaction with one customer – who was migrating from Oracle to SQL Server. He kept telling me that they were getting login errors from their Java application. And even when they used the SQL Server Management Studio it was erroring out with Error 18456 code. They sent me a snapshot like this for login failed:

Sep7

SQL SERVER – Database Backup and Restore Job Management

Pinal Dave

SQL

ApexSQL, SQL Backup, SQL Restore, SQL Server, SQL Utility

ApexSQL Backup is a tool for Microsoft SQL Server, intended for database backup and restore job management. The application supports all native SQL Server backups (full, differential and transaction log backups), and allows users to easily create, save and manage all backup related jobs. ApexSQL Backup can be used to run, schedule and monitor all backup operations across the domain from a single location.

Sep6

Consultant’s Life – 30 Minutes Pre Call With Customer for SQL Server Performance Tuning

Pinal Dave

Personal

Consultation, SQL Server

I am working as an independent SQL Server Performance Tuning Consultant and I love my job. Let us learn about Pre Call with a customer.

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.