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 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
A wall of identical pressure gauges in a plant room, every needle resting at the same steady value.

Hey DBA – Baselines and Performance Monitoring – Why? – Notes from the Field #058

December 11, 2014
Pinal Dave
SQL Tips and Tricks
DBA, Notes from the Field, SQL Activity Monitor, SQL Server

Mike Walsh explains why baselines and performance monitoring matter for every DBA, and how to know what normal looks like on your servers.

Read More
Gouache painting of a row of eight apple trees growing from sapling to tall tree with one red apple on the last

Database Maintenance Checklist: Daily, Weekly and Monthly

November 1, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, Maintenance Plan, SQL Backup and Restore

A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.

Read More
A herd of goats on a hillside following one old lead goat wearing the only bell toward a gate

Finding Databases Owned by Personal Logins and Fixing Them

August 12, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Login, SQL Server, SQL Server Security

Find databases owned by personal logins, review an approved replacement owner, and test dbo mapping and execution-context effects.

Read More
A new set of watercolor paints tied with a red ribbon handed across a desk

Getting Your Employer to Pay for Training

July 22, 2014
Pinal Dave
SQL Tips and Tricks
Career Advice, DBA, Professional Development, SQL Training

Ask your employer to pay for training with a short proposal that ties the course to work, shows cost, and shares the result with the team.

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