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
A walker seen from behind at a mountain trail fork, three paths marked by stacked stone cairns

How to Read a T-SQL Syntax Diagram

June 7, 2007
Pinal Dave
SQL Tips and Tricks
Developer, SQL Documentation, SQL Index, SQL Server

Read a T-SQL syntax diagram without guessing: brackets mean optional, braces mean required choices, pipes separate options, and dots repeat items.

Read More
A hand fitting the matching hose connector to a brass garden tap, three other connectors on the ledge below

Which SQL Server Client Driver to Use Now

May 27, 2007
Pinal Dave
SQL Tips and Tricks
Developer, SQL Connection, SQL Server, SQL Server Encryption

Choose a SQL Server client driver by application stack: ODBC, current OLE DB, Microsoft.Data.SqlClient, or JDBC, then test security defaults.

Read More
A plumber pressure-tests a new copper pipe with a hand pump as a single bead of water forms at one joint.

Testing an Application for SQL Injection

May 21, 2007
Pinal Dave
SQL Tips and Tricks
Developer, Dynamic SQL, SQL Server Security, Testing

Testing an application for SQL injection on a safe copy reveals response clues and unsafe query construction before repair.

Read More
Hands placing a leaking tap assembly on a cloth at a shop counter, its worn washer and screw laid out in a row

How to Ask a SQL Server Question That Gets Answered

February 24, 2007
Pinal Dave
SQL Tips and Tricks
Best Practices, Developer, SQL Error Messages, SQL Server

A SQL Server question that gets answered includes the exact build, full error text, a small repro, and the fixes already tried.

Read More
Previous 1 … 5 6 7 8
  • Books
  • Testimonials
  • Privacy Policy

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