Mar 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Oct11

Watch My All Pluralsight Courses for FREE – This Week

Pinal Dave
SQLAuthority News
Pluralsight
No Comments

This is a great week to watch My All Pluralsight Courses for FREE. The link to watch the courses for FREE is over here: Free Week.

Read More
Oct10

Accessing Non-Relational Databases in Go at Pluralsight

Pinal Dave
SQL
Go Lang, Pluralsight
1 Comment

I just released my 43rd course on the learning platform Pluralsight. It was fun to build this new course Accessing Non-Relational Databases in Go.

Read More
Sep19

Maximize the Business Impact with Quest EMPOWER

Pinal Dave
SQL
Quest
No Comments

You do not want to miss out on signing up with Quest EMPOWER. I will be there along with Brent Ozar and the best Industry experts.  Quest EMPOWER

Read More
Aug24

SQL SERVER – Reasons – Not Able to Shrink the Transaction Log

Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Log, SQL Server, System Database
No Comments

Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.

Read More
Aug2

Swap Columns – SQL in Sixty Seconds #199

Pinal Dave
SQL Video
SQL Column, SQL in Sixty Seconds
No Comments

Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.

Read More
Jul25

Accessing Relational Databases in Go at Pluralsight

Pinal Dave
SQL
Go Lang, Pluralsight
No Comments

I just released my 42nd course on the learning platform Pluralsight. It was fun to build this new course Accessing Relational Databases in Go.

Read More
Jun28

Hybrid Cloud Monitoring

Pinal Dave
SQL
Idera, MySQL
No Comments

AWS, MS Azure and GCP are extremely popular for hosting applications and databases. Let us discuss Hybrid Cloud Monitoring. 

Read More
Previous 1 … 28 29 30 31 32 33 34 … 829 Next

SQL SERVER – 2005 Improvements in TempDB

SQL SERVER – Recompile All The Stored Procedure on Specific Table

SQL SERVER – Fix : Error : Server: Msg 131, Level 15, State 3, Line 1 The size () given to the type ‘varchar’ exceeds the maximum allowed for any data type (8000)

SQL SERVER – Explanation of WITH ENCRYPTION clause for Stored Procedure and User Defined Functions

SQL SERVER – 2005 Comparison SP_EXECUTESQL vs EXECUTE/EXEC

SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable

SQL SERVER – Definition, Comparison and Difference between HAVING and WHERE Clause

Previous 1 … 28 29 30 31 32 33 34 … 829 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 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.


Comprehensive Database Performance Health Check

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.


SQL Server Performance Tuning Practical Workshop

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.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com