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 packed wooden trunk latched shut on a pale stone platform with a vermilion strap

Send the Payload, Skip the Meeting: Async Updates That Save Hours

February 11, 2016
Pinal Dave
Personal
Best Practices, Career Advice, Professional Development

Async updates save hours when each message carries everything the reader needs. This post shows the five fields of a clean update, a made-up example and a default action that keeps work moving. It also says when a meeting still wins.

Read More
A magnifying glass beside a blank paper ledger and one plain brass key on a wooden desk.

Finding Out Who Changed That Row

February 9, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Security

Investigate who changed data using existing audit evidence, transaction log limits, and the distinction between logins and individual users.

Read More
A small magnifying glass over blank index cards connected with plain cotton thread on wood.

Finding Where an Object Is Used Across a Database

February 2, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use dependency metadata, definition searches, and runtime evidence to find object usage while accounting for dynamic SQL and external callers.

Read More
Wooden coat toggle passing through one of two fabric loops

Circular Foreign Keys: Inserting Rows That Point at Each Other

January 20, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Constraint and Keys, SQL Server

Two tables point at each other, and every insert fails. Here is the nullable column that gives you a way in.

Read More
A community garden of separate raised beds, each with its own tools, a red trowel in one

Giving Every Developer a Dedicated Development Database

January 18, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Developer, Software Development

Set up a dedicated development database from approved schema scripts and clean seed data, with repeatable rebuilds and drift checks.

Read More
Gouache painting of a row of wooden beads on linen ending in a small vermilion knot, with the last bead sitting apart on the cloth

Extracting the Folder and File Name From a Full Path in T-SQL

December 14, 2015
Pinal Dave
SQL Tips and Tricks
Best Practices, File format, SQL Server

Split a path at the last backslash and handle the odd inputs. Bare names, empty values, trailing spaces and NULL all behave.

Read More
Gouache painting of a wide wicker basket heaped with small sage and grey pebbles, with one vermilion pebble on top

Context Switching Has a Cost: Batch Your Interruptions

November 19, 2015
Pinal Dave
Personal
Best Practices, Career Advice, Professional Development

Context switching costs more than the seconds it takes to change windows. This post compares attention with SQL Server commits: pay the fixed fee once per batch, not once per ping. It gives concrete ways to batch messages, tickets and reviews, and ends with a short checklist.

Read More
Previous 1 … 11 12 13 14 15 16 17 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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