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
Jun5

SQL SERVER – Reclaiming Space and Performance: Database Backup History

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

Today we are going to discuss Reclaiming Space and Performance: Database Backup History. I figured out during Comprehensive Database Performance.

Read More
Jun2

SQL SERVER 2022 – Last Valid Restore Time – Improved Backup Metadata

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server 2022
No Comments

One significant addition to the backup metadata is the inclusion of the last valid restore time. In SQL Server 2022, a new improved backup metadata feature.

Read More
Jun1

Balancing Performance, Security, and Scalability as a DBA

Pinal Dave
SQL Tips and Tricks
Idera
No Comments

I had the opportunity to engage in a captivating discussion surrounding on database performance, security, and scalability as a DBA.

Read More
May31

Configuring Parallel Index Operations in SQL Server

Pinal Dave
SQL Performance
MAXDOP, SQL CPU, SQL Index
No Comments

Configuring parallel index operations in SQL Server can significantly impact query performance and scalability. During my popular service, we discuss.

Read More
May30

Performance Tuning MySQL on a Budget: Techniques and Tools

Pinal Dave
SQL Tips and Tricks
Idera
No Comments

I want to address a pressing question to many database administrators: “Performance Tuning MySQL on a Budget: Techniques and Tools.”

Read More
May29

SQL Server 2022: Buffer Pool Scans on Large-Memory Computers

Pinal Dave
SQL Performance
Buffer Pool, SQL Memory
No Comments

Buffer pool scans causing slow operations on large-memory computers have long been a concern for SQL Server users.

Read More
May26

SQL Server 2022 – Thread Management for Performance Improvement

Pinal Dave
SQL Performance
CPU Threads, SQL CPU, SQL Memory, SQL Performance
No Comments

I had a great discussion about Thread Management for Performance Improvement with my client, who recently hired me for Comprehensive Database Performance Health Check.

Read More
Previous 1 … 24 25 26 27 28 29 30 … 830 Next

SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.

SQL SERVER - Recovery Models and Selection datepart-800x258

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice

SQL SERVER - Recovery Models and Selection SQL_CTEDerivedTable

SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table

SQL SERVER - Recovery Models and Selection collationconflict-800x206

SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation

SQL SERVER – LEN and DATALENGTH of NULL Simple Example

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

SQL SERVER – Recovery Models and Selection

Previous 1 … 24 25 26 27 28 29 30 … 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