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

Sep16

SQL SERVER – Case of Different Default Collation on Two Servers

Pinal Dave

SQL

SQL Collation, SQL Server

Along with long term performance tuning engagement, I also provide quick consult (On Demand) to assist with any short-term issue, which might get fixed by talking to an expert. Some of the questions are very good and I get to learn something. This blog is the result of one such conversation like Case of Different Default Collation on Two Servers.

Sep15

SQL SERVER – Puzzle – Playing with Datetime with Customer Data

Pinal Dave

SQL Puzzle

SQL DateTime, SQL Scripts, SQL Server

188

I am preparing for a professional tour of Europe wherein I am planning to meet a number of customers as part of consulting and performance tuning assignments that I have agreed in early October. I am already swamped with the requests and I think the learning experience is second to none when one gets to work on global projects. Let us an interesting puzzle.

Sep14

SQL SERVER – How to Downgrade SQL Server Edition?

Pinal Dave

SQL

SQL DMV, SQL Server

One of a unique advantage of freelancing is learning more and more. I get a chance to hear some of the real word problem and it gives me immense pleasure to provide a feasible solution to them. In this blog post we will discuss How to Downgrade SQL Server Edition?

Sep13

SQL SERVER – Columnstore Index Cannot be Created When Computed Columns Exist

Pinal Dave

SQL Performance

ColumnStore Index, Computed Column, SQL Error Messages, SQL Scripts, SQL Server

Explorations working with SQL Server never stop and I get an opportunity to learn something every other day. Today I thought of bringing pout some learning that happened to me by accident. As I was not sure and assumed certain things, these came as a surprise learning for me. So let us see what is the issue at hand, which is about Columnstore Index and Computed Column.

Sep12

MySQL – Fix Error – WordPress Database Error Duplicate Entry for key PRIMARY for Query INSERT INTO wp_options

Pinal Dave

SQL

MySQL, SQL Constraint and Keys, SQL Error Messages, WordPress

As many of you know that this blog runs on Wordpress and under the hood of Wordpress there is a MySQL database. MySQL database is quite good and is able to hold massive traffic this blog receives every day. However, just like any database MySQL needs tuning as well as proper management of the same. In this blog post we will discuss about how I received a very weird error Wordpress Database Error and how I resolved it.

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.

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.