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
Aug12

SQL SERVER – Understanding the Basics of Write Ahead Logging (WAL) Protocol

Pinal Dave
SQL Tips and Tricks
SQL Server, Transaction Log
2 Comments

Doing the basics right matters. Here is a simple, story-driven explanation of the Write Ahead Logging (WAL) protocol that keeps SQL Server transactions safe.

Continue Reading
Aug11

SQL SERVER – Error while starting SQL Server logFileSize <= BlkToByteOffset ((ULONG)-1)

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
7 Comments

A tempdb mistake left SQL Server unable to start. Here is the error while starting SQL Server, a failed assertion on logFileSize, and the fix.

Continue Reading
Aug10

SQL SERVER – Error: Msg 4305, Level 16, State 1 – The log in this backup set terminates at LSN, which is too early to apply to the database.

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
4 Comments

Msg 4305 says the log in this backup set is too early or too recent to apply. I build a sample database with backups to show why it happens during a log restore.

Continue Reading
Aug9

Interview Question of the Week #031 – How to do Case Sensitive SQL Query Search

Pinal Dave
SQL Interview Questions and Answers
SQL Collation
3 Comments

Run a case sensitive SQL query search with explicit collations, inspect current settings, and design an index for repeated exact matches.

Continue Reading
Aug8

ADD FILE in an Availability Group: What Happens on the Secondary Replica

Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL High Availability, SQL Scripts, SQL Server
2 Comments

ADD FILE on the primary of an availability group reaches every secondary as a log record. If the same path doesn’t exist on a secondary, the operation fails and data movement is suspended. Here is how to resume it.

Continue Reading
Aug7

SQL SERVER – How to do IF…THEN in SQL SERVER?

Pinal Dave
SQL Tips and Tricks
1 Comment

How do you write IF…THEN in SQL Server? Use a CASE statement, or IIF from SQL Server 2012. Here are simple examples of both for a .NET developer.

Continue Reading
Aug6

SQL SERVER – A Stored Procedure for Executing SSIS Packages in the SSIS Catalog – Notes from the Field #092

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Backup and Restore, SSIS
12 Comments

SSIS expert Andy Leonard shares a stored procedure for executing SSIS packages in the SSIS Catalog, from the book SSIS Design Patterns. Notes from the Field #092.

Continue Reading
Previous 1 … 364 365 366 367 368 369 370 … 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