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
Gouache painting of a canal lock with its far gate closed and three narrow boats waiting in calm water in a line, slate blue and sage green, with a vermilion lantern on the lead boat

Say No at Work Without Burning Bridges When You’re Over-Committed

November 4, 2015
Pinal Dave
Personal
Best Practices, Career Advice, DBA, Life Lessons, Professional Development

To say no at work without burning bridges, queue the request instead of refusing it. This post borrows a busy server’s habit of holding requests in line with a clear wait time. You’ll get a short reply format, ways to offer options and a limit for the queue.

Read More
A scale model of a house on a table with the real house visible through the window behind it

Test Data That Looks Like Production

July 22, 2015
Pinal Dave
SQL Tips and Tricks
DBA, SQL Sample Database, SQL Server Security, Testing

Test data that looks like production matches distributions, relationships, and volume without copying sensitive values into development.

Read More
A small shop grown into a crooked patchwork of many tiny add-on extensions, a red door on the newest one

Autogrowth Settings: Why 1 MB and 10 Percent Still Hurt

June 17, 2015
Pinal Dave
SQL Tips and Tricks
DBA, SQL Data Storage, SQL Server Configuration, Transaction Log

Inspect autogrowth settings across database files, review retained growth events and VLFs, and choose tested fixed-size increments.

Read More
Gouache painting of a small wooden workshop seen from the front, its door firmly closed in a slate-blue wall, a sage-green garden around it and one blank vermilion tag hanging from the door handle

Deep Work Time: Book It Like a Server Maintenance Window

May 28, 2015
Pinal Dave
Personal
Career Advice, DBA, Professional Development, Self Help

Deep work time disappears unless you book it. This post treats your own focus like a server maintenance window: a named block, a runbook, an emergency rule and a short review. Try two 90-minute windows this week.

Read More
A hand pulls a clean wooden skewer from the center of a freshly baked cake on a cooling rack.

Checking That a Patch Really Installed

May 18, 2015
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Setup

Checking That a Patch Really Installed means comparing full versions, reading Setup summary logs, and confirming the startup error log.

Read More
A red windsock stretched straight in a strong wind as a dark storm builds over sunny hills

SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825

January 20, 2015
Pinal Dave
SQL Tips and Tricks
Database Corruption, Database Mail, DBA, SQL Error Messages, SQL Server Agent

Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.

Read More
Two wax-sealed wine bottles on a cellar rack, one seal whole and the other with a fine crack across it.

Page Verify CHECKSUM and Why It Matters

December 24, 2014
Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC

Page verify CHECKSUM detects altered database pages on read; inspect old settings, understand new writes, and review suspect pages.

Read More
Previous 1 … 8 9 10 11 12 13 14 … 45 Next
  • Books
  • Testimonials
  • Privacy Policy

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