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
Gouache painting of a row of ten clay flowerpots on a long wooden shelf, nine of similar height and one much taller, with a vermilion ribbon tied round the pot of middle height

Median Day Planning: Time Management That Survives a Normal Week

July 23, 2015
Pinal Dave
Personal
Best Practices, Career Advice, Life Lessons, Professional Development

Median day planning means sizing your week around a typical day, not your best one. This post shows how to measure your own median in ten workdays, split work into a commit list and a stretch list, and keep a small buffer. Your plan then survives a normal week.

Read More
Useful woodworking tools selected for building a boat

Interview Question of the Week #028 – Few SQL Best Practices

July 19, 2015
Pinal Dave
SQL Interview Questions and Answers
Best Practices

Apply SQL best practices through ten reasoned rules for data meaning, predicates, parameters, indexes, ordering, and workload measurement.

Read More
A small seaplane moored at a lake jetty at dawn, a hand holding the mooring line before untying it

Pre-Flight Checks at the Top of a Script With THROW

July 8, 2015
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Learn pre-flight checks with practical SQL Server examples, clear checks, and the limits you need before changing application data.

Read More
A whiteboard with three blank sticky notes in a row and a marker resting on the ledge.

SQL SERVER – 3 Common Mistakes of Agile Development – Notes from the Field #074

April 2, 2015
Pinal Dave
SQL Tips and Tricks
Best Practices, Notes from the Field, SQL Server Security

Agile builds software in small, time boxed steps. In Notes from the Field #074, Stuart Ainsworth shares stories about 3 common mistakes of Agile Development.

Read More
One large stone and a pile of small pebbles rest in separate shallow wooden trays.

Reading a Workload Capture Without a Tool

December 13, 2014
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Read a workload capture by grouping related queries, comparing total resource use, and separating one slow execution from repeated work.

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
Previous 1 … 12 13 14 15 16 17 18 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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