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

Dec18

SQL SERVER – Creating the SSIS Catalog – Notes from the Field #058

Pinal Dave

SQL Tips and Tricks

Notes from the Field, SQL Server, SSIS

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Creating the SSIS catalog. With the release of SQL Server 2012, Integration Services (SSIS) received a significant overhaul. The most notable change was the addition of the SSIS catalog, a new deployment and storage mechanism that helps to centralize and standardize the storage, execution, and logging of SSIS packages. In this post, I will briefly illustrate how to set up the SSIS catalog on a new installation of SQL Server 2012 or 2014.

Dec17

SQL SERVER – Reverse String Word By Word – Part 3

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL String

No Comments

Earlier I wrote a blog post about SQL SERVER – Reverse String Word By Word. SQL Server Expert Sanjay Monpara wrote a great comment to the blog post where he has proposed alternate solution. Right after the solution of the Sanjay, another expert Yuri Petrov suggested a modification to the script. In this blog…

Dec16

SQL SERVER – Proving that the Source of the Problems aren’t Tied to the Database

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Dell

I have always wondered how Sherlock Holmes cracked the toughest of mysteries every single time. This fascination always lead me to learn new techniques every single time. The backbone for every successful detective is to be logical in their approach while working on the case. While watching movies, I have…

Dec15

SQL SERVER – Reverse String Word By Word – Part 2

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Function, SQL Scripts, SQL String

Dec14

SQL SERVER – Can Database Primary File Have Any Other Extention Than MDF

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Scripts

Here is interesting question I received yesterday. I personally think it is one of the most interesting questions I have received this month. “Can Database Primary File Have Any Other Extention Than MDF?” Before you read the answer – think for a moment. Now read the answer in the next…

Dec13

SQL SERVER – Download RML Utilities for SQL Server

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Download

Microsoft RML Utilites are very helpful when analysing performance. It helps answering questions like Do you know which databases are using the most resources on your server? Do you know which applications are using the most resources on your server? How will a service pack upgrade, configuration change or application…

Dec12

SQL SERVER – Monitoring SQL Server Never Got This Easy

Pinal Dave

SQL

Idera, SQL Activity Monitor, SQL Scripts, SQL Server

In administering SQL Server databases, the DBA is often presented with the task of identifying resource bottlenecks on the system and the sources of those bottlenecks. Also, the DBA is challenged with the task of identifying why specific queries take significant time to execute or affect the performance of other queries on the system. This allows the DBA to find opportunities to tune queries and improve their performance and the overall performance impact on the system. In this blog we will explore identifying if any disk I/O bottlenecks are present that impact query performance on the system. Such action would allow a DBA to further deal with the I/O bottleneck. Let us learn about Monitoring SQL Server.

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.