Apr 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
  • Hire Me
  • Health Check
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
Jun23

Real-Time Monitoring of MySQL Server

Pinal Dave
SQL
Idera, MySQL
No Comments

Everyone in the organization wants to know the reasons and resolution. For any DBA, they must know the real-time insight into their server.

Read More
Jun21

File-Based Log Monitoring on AWS MYSQL RDS

Pinal Dave
SQL
Idera, MySQL
No Comments

The way the cloud platform works on Azure is very different from how it operates on Amazon MySQL RDS. Let us learn today.

Read More
Jun16

MYSQL Long Running Queries

Pinal Dave
SQL
Idera, MySQL
No Comments

The data that used to be available freely now starts to get locked, and queries sprinting are now turning into long running queries.

Read More
Previous 1 … 29 30 31 32 33 34 35 … 830 Next

SQL SERVER – 2005 Best Practices Analyzer (July BPA)

SQL SERVER – 2005 Best Practices Analyzer Tutorial – Sample Example

SQL SERVER – 2005 – Microsoft Document Explorer cannot be shown because the specified help collection ‘ms-help://MS.SQLCC.v9

SQL SERVER – FIX : Error : msg 8115, Level 16, State 2, Line 2 – Arithmetic overflow error converting expression to data type

SQL SERVER – Convert Text to Numbers (Integer) – CAST and CONVERT

SQL SERVER – SQL Joke, SQL Humor, SQL Laugh – Generic Quotes

SQL SERVER – FIX : ERROR Msg 244, Level 16, State 1 – FIX : ERROR Msg 245, Level 16, State 1

Previous 1 … 29 30 31 32 33 34 35 … 830 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