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
Neatly arranged plain wooden building pieces beside a pencil on a quiet worktable.

Writing T-SQL Somebody Else Can Maintain

September 15, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Write maintainable T-SQL with clear names, explicit results, focused procedures, and comments that explain the business reason behind the code.

Read More
An open key cabinet on the stone wall of a mountain hut, a brass key on its hook above a coiled rope and lantern.

Doing Remote DBA Work Well

September 10, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Consulting, DBA, SQL Monitoring

Remote DBA work succeeds with controlled access, current runbooks, agreed change windows, and communication that makes every action visible.

Read More
A tangled ball of twine beside the same twine wound neatly onto five spools

Refactoring a Long Stored Procedure Into Readable Steps

August 20, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Server, SQL Stored Procedure

Learn refactoring a long stored procedure with output baselines, named temp tables, dead-code removal, and two-way EXCEPT checks before release.

Read More
Three small plain wooden blocks and a single empty space arranged neatly on an oak tabletop.

The SQL Basics Almost Everybody Skips

August 19, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Revisit SQL basics that change query results: NULL logic, logical processing order, grouped filters, and the difference between two common counts.

Read More
A stone cairn at a fork in a misty mountain path, its vermilion top stone pointing the way, a distant hiker on that trail.

Writing Clear Error Messages in Procedures

August 16, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Error Messages, SQL Server, SQL Stored Procedure

Clear error messages in procedures identify the failed operation, useful keys, and next action without exposing sensitive data.

Read More
A compact wooden organizer holding several simple measuring tools on a softly lit workbench.

The Dynamic Management Views Worth Knowing by Heart

August 16, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use dynamic management views to inspect active requests, waits, cached queries, index activity, and file space without guessing at server health.

Read More
Two plain brass keys with different teeth beside a small wooden lock block on a table.

Orphaned Users After a Restore, and How to Fix Them

August 2, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Security

Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.

Read More
Previous 1 … 48 49 50 51 52 53 54 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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