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
A figure sweeping a metal detector across a long beach, a small vermilion flag marking one spot.

Searching the Error Log by Date and Text With xp_readerrorlog

April 27, 2021
Pinal Dave
SQL Tips and Tricks
DBA, SQL Error Messages, SQL Log, SQL Scripts

Search the SQL Server error log by date and text, select archives, capture matching rows, and cycle logs without losing context.

Read More
A figure raising an arm at a tiny dark railway halt as a small train comes round the bend.

Azure SQL Database Serverless: Auto-Pause and What Wakes It

April 6, 2021
Pinal Dave
SQL Tips and Tricks
Cloud Computing, DBA, SQL Azure

Understand Azure SQL Database serverless limits, auto-pause, resume delays, and billing metrics before choosing an idle strategy.

Read More
A farmhouse fireplace just relit in the morning, a small flame catching on kindling under cold logs.

When Did SQL Server Last Restart? Four Ways to Check

April 2, 2021
Pinal Dave
SQL Tips and Tricks
DBA, SQL DMV, SQL Log, SQL Server, SQL TempDB

Find SQL Server’s last restart using startup metadata, tempdb, logs, and sessions, then interpret reset counters correctly.

Read More
A heavy sled hauled almost to the top of a snowy slope, its red rope trailing back down

Before You KILL a Session: Estimating the Rollback Cost

February 4, 2021
Pinal Dave
SQL Tips and Tricks
DBA, SQL Lock, SQL Server, SQL Transactions

Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.

Read More
A hand pausing on a dusty draw-stop of an old church organ, the other stops polished from use

Finding Old Agent Jobs Not Run in Months or Never Scheduled

December 14, 2020
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server Agent, SQL System Table

Review agent jobs not run recently or lacking schedules, combine history and activity, and disable approved candidates for review.

Read More
A row of market shutters locked with heavy padlocks at night, one held shut only by a twist of wire.

CHECK_POLICY and CHECK_EXPIRATION for SQL Logins

November 16, 2020
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Password, SQL Server Security

Audit CHECK_POLICY and password expiration for SQL logins, inspect LOGINPROPERTY evidence, and plan safe service-account exceptions.

Read More
Plaits of drying onions hanging from a barn beam, many fresh ones at one end and fewer older ones further along.

Long-Term Backup Retention in Azure SQL Database

October 3, 2020
Pinal Dave
SQL Tips and Tricks
Cloud Computing, DBA, SQL Azure, SQL Backup and Restore

Configure long-term backup retention in Azure SQL Database, inspect retained recovery points, restore a separate copy, and review costs.

Read More
Previous 1 2 3 4 5 6 7 … 45 Next
  • Books
  • Testimonials
  • Privacy Policy

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