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 opened four-part workshop kit ready for a hands-on setup

How to Get Started with SQL Server 2016? – Interview Question of the Week #086

August 28, 2016
Pinal Dave
SQL Interview Questions and Answers
SQL Documentation, SQL in Sixty Seconds, SQL Server 2016, Starting SQL

A candidate asked me in an interview: how do I get started with SQL Server 2016? Here is my answer for anyone who has not tried it yet.

Read More
A row of iron levers in a railway signal box, a hand tying a small red cloth tag to one lever

Documenting SQL Agent Jobs: Schedules, Steps and Owners in One Query

July 6, 2016
Pinal Dave
SQL Tips and Tricks
DBA, SQL Documentation, SQL Scripts, SQL Server Agent

Start documenting SQL Agent jobs with owners, steps, readable schedules and retained run outcomes, then save a reviewed inventory document.

Read More
The cut end of a log showing clear growth rings, a vermilion pin marking the outermost ring.

Putting a Database Under Source Control

September 15, 2015
Pinal Dave
SQL Tips and Tricks
DevOps, Schema, SQL Documentation, SQL Scripts, SQL Server

Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.

Read More
A wooden seed cabinet in a shed with one drawer open, plain seed packets sorted in neat rows inside.

Keeping Your Own Script Library

October 27, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Documentation, SQL Scripts

A script library stays useful when folders, names, review history, and safe headers make each SQL file understandable before it runs.

Read More
Two panels. On the left, a join query with a gray comment line and a note about dashes and block marks. On the right, the same query without the comment, followed by its five result rows.

Why We Use Code Comments in SQL Server: Say Why, Not What

February 25, 2013
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Documentation, SQL Scripts, SQL Server

Why we use code comments comes down to one habit: write the reason, not the action. This post uses a small library table to show single-line and block comments, commenting out a join to test a theory, the Msg 156 trap, nested comments, and whether comments slow a query. Every result comes from SQL Server 2025.

Read More
A hand hanging pruning shears on a shed pegboard where each tool has a painted outline behind it

Keeping Database Documentation Next to the Code

July 22, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Documentation, SQL Server

Keep database documentation close to SQL Server objects with extended properties, durable module comments, and catalog-generated reports.

Read More
cheatsheet

SQL SERVER Cheatsheet – Released for SQL Server 2012 Edition

April 17, 2012
Pinal Dave
SQL Tips and Tricks
Cheatsheet, SQL Documentation, SQL Download, SQL Server

The SQL SERVER Cheatsheet is updated for SQL Server 2012, now with SSMS shortcuts, Columnstore Index, and the datetime, ranking and analytic functions.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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