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
SQL SERVER - Guidelines and Coding Standards Part - 1

SQL SERVER – Guidelines and Coding Standards Part 1

September 23, 2008
Pinal Dave
SQL Performance
Best Practices, Database, Software Development, SQL Coding Standards, SQL Constraint and Keys, SQL Index, SQL Joins, SQL Scripts, SQL Stored Procedure

Guidelines and Coding Standards Part 1: Pascal naming for tables, and naming patterns for stored procedures, triggers, indexes and keys.

Read More
SQLAuthority News - 700 Articles and Author Updates

SQLAuthority News – 700 Articles and Author Updates

September 11, 2008
Pinal Dave
SQLAuthority News
Best Practices, Database, DBA, MVP, SQL User Group

The blog has reached 700 articles. Here is why I write, plus updates since article 600: the SQL Server MVP award, user group work and 4 million visitors.

Read More
Two gooseberry rows and two harvest baskets stand beside a wooden crossbar spanning both rows.

Year-to-Date Totals Next to the Same Period Last Year

August 14, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Business Intelligence, SQL DateTime

A fair year-to-date comparison needs the same dates from last year. Here is a short query, plus the leap day trap.

Read More
Several plain paper folders arranged in a small wooden tray beside a closed notebook.

Organising Notes You Have Already Written

July 18, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn to organise notes around problems, useful search terms, and review dates so earlier SQL Server work becomes easy to find and trust.

Read More
A hand pours red liquid into a copper jelly mold beside two finished jellies of different colors and the same shape.

Parameterized Queries From Application Code

June 29, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Developer, Dynamic SQL, SQL Server, SQL Server Security

Use parameterized queries from application code to prevent SQL injection, improve plan reuse, and avoid parameter length mistakes.

Read More
One blank cream reference card beside a plain pencil and small paper clip on a wooden desk.

A One Page Reference for Everyday SQL Server Work

June 25, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.

Read More
Two plain wooden toolboxes of different sizes resting side by side on a neutral workbench.

Comparing Two Databases Without a Scoreboard

June 19, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Learn how to compare databases using representative work, operational skills, recovery requirements, and costs rather than feature-count scoreboards.

Read More
Previous 1 … 43 44 45 46 47 48 49 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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