Feb 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
Aug18

Webinar – Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis

Pinal Dave
SQLAuthority News
Idera, SQL Index, Webinar
No Comments

The webinar topic is Mastering SQL Query Performance: A Deep Dive into Index Tuning and Analysis. I will be hosting this webinar.

Read More
Aug17

SQL SERVER – Unique Indexes on Nullable Columns

Pinal Dave
SQL Tips and Tricks
SQL Index, SQL NULL
No Comments

As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.

Read More
Aug16

The Pigeonhole Principle: Bridging Mathematics and SQL

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function
No Comments

The other day I was reading Wikipedia, and I ended up on the Pigeonhole Principle. I find it very intriguing about this and I decide to blog

Read More
Aug15

SQL SERVER – Banker’s Rounding

Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function
5 Comments

Also known as unbiased rounding or round half to even, banker’s rounding follows a set of rules that ensures numbers are rounded.

Read More
Aug14

SQL SERVER – Making Recursive Parent-Child Queries Efficient

Pinal Dave
SQL Performance
Challenge, Recursive, SQL Joins
2 Comments

One puzzle is finding out how many employees each manager is responsible for in a company. Let us Make Recursive Parent-Child Queries Efficient.

Read More
Aug11

MySQL Administration – Video Course

Pinal Dave
SQLAuthority News
MySQL, Pluralsight
No Comments

I’m thrilled to announce the launch of my 52nd course on Pluralsight – “MySQL Administration.” We dive into optimizing MySQL performance.

Read More
Aug10

Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable

Pinal Dave
SQL Tips and Tricks
SQL Browser, SQL Instance, SQL Server Security
1 Comment

Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.

Read More
Previous 1 … 15 16 17 18 19 20 21 … 829 Next

SQL SERVER – 2008 Katmai – Download Datasheet Final from Microsoft

SQL SERVER – Download Microsoft SQL Server 2005 System Views Map

SQL SERVER – Explanation SQL Command GO

SQL SERVER - Query to Find First and Last Day of Current Month - Date Function CLRSupport-800x293

SQL SERVER – Fix : Error : Msg 6263, Level 16, State 1, Line 2 Enabling SQL Server 2005 for CLR Support

SQL SERVER – 2005 – List all the database

SQL SERVER – UDF – Function to Parse AlphaNumeric Characters from String

SQL SERVER - Query to Find First and Last Day of Current Month - Date Function bigclock-800x800

SQL SERVER – Query to Find First and Last Day of Current Month – Date Function

Previous 1 … 15 16 17 18 19 20 21 … 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 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.


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