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
An experienced hand passing a wooden mallet to an apprentice over a nearly finished boat hull

Consulting Wrap Up – What Next and How to Get Started

March 30, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, DBA, SQL Server

Use this consulting wrap up to keep a practical engagement checklist, choose the right service, and prepare the first email to get started.

Read More
A hand pulling a dandelion from a lawn with its whole long root intact

Consulting 105 – Why Don’t I Want My Customers to Return for the Same Problem?

March 29, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Performance, SQL Server

Learn to diagnose the same problem yourself, distinguish symptom relief from a root-cause fix, and know when a follow-up is useful.

Read More
Two hands passing a jar of sourdough starter across a counter, a loaf from it cooling behind

Consulting 104 – Why Do I Give All the Performance Tuning Scripts to My Customers?

March 28, 2019
Pinal Dave
SQL Performance
Best Practices, Comprehensive Database Performance Health Check, Consulting, SQL Scripts, SQL Server

Keep performance tuning scripts with explanations, before-values, undo steps, and a configuration history your team can compare later.

Read More
An old coal scuttle still holding fuel beside a newer container

Retired Features Still in Your Schema: Stretch, text and More

March 18, 2019
Pinal Dave
SQL Tips and Tricks
Best Practices, Schema, SQL Server

Before an upgrade, look for text and image columns, old rules and defaults, and Stretch metadata. These queries show what is there.

Read More
Four small wooden blocks sit around one larger central block on an oak tabletop.

Watching Many Servers Without Buying Anything

March 14, 2019
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Use scheduled snapshots to monitor SQL Server with central storage, failure reporting, and four focused queries collected every five minutes.

Read More
Gouache painting of an old stump with many growth rings beside a young sapling tied with a vermilion ribbon.

Build Your Own SQL Script Library

November 1, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Coding Standards, SQL Scripts

A SQL script library saves you from solving the same problem twice. This post shows a folder layout by task, a header block with the tested version, naming habits, a safe history, tests on a scratch server and a way to retire old scripts, with one small read-only script as an example.

Read More
A plaster hawk beside one freshly plastered wall patch and one unchanged patch

Comparing Old and New Values in a Trigger With inserted and deleted

October 10, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Trigger

Build a small audit trigger that joins inserted and deleted, handles NULL changes correctly and ignores saves that change nothing.

Read More
Previous 1 … 5 6 7 8 9 10 11 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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