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

Sep5

SQL SERVER – Understanding How to Play With Row Constructor

Pinal Dave

SQL

SQL Function, SQL Scripts, SQL Server, SQL String

Every version of SQL Server brings in something new that challenges our understanding of how the software product works. For me, working with SQL Server is quite refreshing and fulfilling because every single day there is something about the product that I discover and learn. There are tons of professionals who are working on this product and they push the limits of use and bring interesting use cases which I get to learn. Let us learn about Row Constructor.

Sep4

How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087

Pinal Dave

SQL Interview Questions and Answers

SQL Cache, SQL DMV, SQL Scripts, SQL Server

Interviews are fun. Most of the time the interviewer has all the interesting questions, but I often come across a few individuals who stomps the interviewer. I was recently called by one of the organizations where I regularly help with their hiring process. They were stumped by interviewing candidates with one of the questions related to recent executed queries. Let us see the question and its answer.

Sep3

SQL SERVER – SSMS Enhancement – Databases Node Filter Capability

Pinal Dave

SQL Tips and Tricks

SQL Server, SQL Server 2016, SQL Server Management Studio

I have been playing around with SQL Server 2016 for a while now and it is interesting how some of the things have changed drastically with this release. One of the key things I felt was the ability to have a different cycle for SQL Server Management Studio (a.k.a SSMS) enhancements. Since this is a client tool, I see that Microsoft has gone ahead with updating the tool almost every month now. Let us learn about SSMS Enhancement.

Sep2

SQL SERVER – Find Week of the Year Using DatePart Function

Pinal Dave

SQL

SQL DateTime, SQL Function, SQL Scripts, SQL Server

As I blog every single day, lots of people ask me if I have to build a calender for the same. The answer is yes, I do not have a personal calender and I keep a note of all the ideas in the calender. The next day when I get ready to blog, I use the same calender as a reference to blog about the same. Most of the time I plan out my week at a time. Let us learn about how to find week of the year using datepart function.

Sep1

SQL SERVER – Delete All Waiting Workflows in MSCRM to Speed Up Microsoft Dynamics

Last week, during performance tuning consultancy, I faced a very interesting situation when customer’s Microsoft Dynamics CRM was extremely slow. After quickly researched we found that they have a very high number of Mass Waiting Task Workflows in the system. They honestly did not care about those anymore as they were stuck there waiting for over a year and have no meaning at this point of time.

Aug31

SQL SERVER – Database Disaster Recovery Process

Pinal Dave

SQL

ApexSQL, SQL Log, SQL Restore, SQL Server

Many SQL Server DBAs are from time to time confronted with a disaster caused by unintentional or malicious changes on their database. Whatever the nature or intention of these changes are, they can cause great issues whether it was the data loss or a structure loss. With this in mind, it is important to start with the recovery process as soon as possible. Having a recovery scenario and solution for these situations prepared is also a great benefit, and is generally advised where possible. Whatever enhances our chance to recover in case of a disaster, and increases chances of successful and full recovery should be taken without any second thoughts. In this blog post we will learn about Database Disaster Recovery Process.

Aug30

SQL SERVER – Whitepaper – Optimizing SQL Server Network Performance

Pinal Dave

SQL

Nitrosphere, SQL Download, SQL Server, SQL White Papers

I have blogged before regarding how to Identify Application vs Network Performance Issues using SQL Server Dynamic Management Views (DMV).

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.