This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Jun10

BACKUP WITH CHECKSUM: What It Checks and What It Cannot

Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC
No Comments

Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.

Continue Reading
Jun9

Point-in-Time Restore: Getting Back Rows Deleted by Accident

Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Delete, Transaction Log
3 Comments

Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.

Continue Reading
Jun8

Column Aliases: Where You Can Use Them and Where You Cannot

Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Column, SQL Order By
No Comments

Why does WHERE say the alias does not exist? Here is the order SQL Server follows, two clean fixes and one quiet trap to avoid.

Continue Reading
Jun7

MySQL – Introduction to CONCAT and CONCAT_WS functions

Pinal Dave
SQL Tips and Tricks
MySQL
1 Comment

MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.

Continue Reading
Jun6

SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action

Pinal Dave
SQL Tips and Tricks
SQL Analysis Services
5 Comments

SSAS actions let users open a report, a web page or drill through from cube data. Here is what actions are and how to build a Reporting Action step by step.

Continue Reading
Jun5

SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL High Availability, SQL Scripts, SQL Server
5 Comments

In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.

Continue Reading
Jun4

Explain a SQL Server Index in Sixty Seconds, Then Prove It

Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts
No Comments

How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.

Continue Reading
Previous 1 … 429 430 431 432 433 434 435 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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 19 books and 125 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 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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