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
May14

SQL SERVER – SSIS and How to Load Binary Large Objects, or Blobs – Notes from the Field #080

Pinal Dave
SQL Tips and Tricks
DotNet, Notes from the Field, SQL Server, SSIS
2 Comments

In Notes from the Field #080, Andy recalls his first project loading product images with SSIS and explains how to load binary large objects, or Blobs.

Continue Reading
May13

SQL SERVER – PowerShell Script – When Was SQL Server Last Restarted?

Pinal Dave
SQL Tips and Tricks
PowerShell
6 Comments

A simple PowerShell script that reads the ErrorLog to answer a common question: when was SQL Server last restarted? Tips to improve it are welcome.

Continue Reading
May12

SQL SERVER – Identify Page Splits Using Extended Events in SQL Server

Pinal Dave
SQL Tips and Tricks
SQL Extended Events
2 Comments

How can you track page splits inside SQL Server? PerfMon gives you a count, but here is how to see each of the page splits using Extended Events.

Continue Reading
May11

SQL SERVER – Introduction to Database Engine Tuning Advisor (a.k.a. DTA)

Pinal Dave
SQL Performance
8 Comments

An introduction to Database Engine Tuning Advisor, or DTA, the tool that ships with SQL Server client tools and suggests indexes and statistics.

Continue Reading
May10

Interview Question of the Week #019 – How to Reset Identity of Table

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts
No Comments

Reset identity values with DBCC CHECKIDENT, distinguish DELETE from TRUNCATE, and prove that identity alone does not prevent duplicates.

Continue Reading
May9

SQL SERVER – Script: Current IO Related Waits on SQL Server

Pinal Dave
SQL Tips and Tricks
SQL Wait Stats
4 Comments

A friend’s SQL Server in an Azure VM slowed down suddenly. Here is my handy script using sys.dm_io_pending_io_requests to see current IO related waits.

Continue Reading
May8

SQL SERVER – Backup Failure – Error: 3203, Severity: 16, State: 1

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages
5 Comments

A transaction log backup failed with Error: 3203, saying the read on the LDF file failed with Incorrect function. Here is what I found.

Continue Reading
Previous 1 … 377 378 379 380 381 382 383 … 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