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 hand pressing a signet ring into red sealing wax on a folded parcel, a candle and wax stick beside it

Connecting Java Applications With the JDBC Driver

March 13, 2010
Pinal Dave
SQL Tips and Tricks
Java, SQL Connection, SQL Server, SQL Server Encryption

Choose a current JDBC driver for SQL Server, verify its connection URL and encryption settings, and test integrated authentication on the app host.

Read More
An old brass kitchen tap above a sink, with new copper pipes visible in the open cupboard beneath

Migrating From Access to SQL Server

December 19, 2009
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Datatype, SQL Migration, SQL Server

Migrating from Access to SQL Server can keep the familiar front end while tables move, linked tables are tested, and Access queries are rewritten.

Read More
A child's hand fitting a star-shaped block into the matching hole of a wooden shape-sorter box

Connecting PHP to SQL Server

October 11, 2009
Pinal Dave
SQL Tips and Tricks
Developer, SQL Connection, SQL Server, SQL Server Security

Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.

Read More
Two identical glass bottles on a kitchen shelf, one with a red ribbon on its neck, a hand pausing before it.

Color-Coding Production Connections in SSMS

September 10, 2009
Pinal Dave
SQL Tips and Tricks
Best Practices, DBA, SQL Connection, SQL Server Management Studio

Color-coding production connections in SSMS adds a visual warning, while an identity query confirms the real destination.

Read More
Two tin-can telephones joined by a taut string across a garden fence, one held by a hand

What TDS Is and Why It Matters to You

January 17, 2009
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Encryption

What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.

Read More
A mountain stream disappearing under a rock and flowing out again, a red leaf on it

Connection Resiliency: Surviving Brief Wi-Fi and Network Drops

December 25, 2008
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Azure, SQL Connection, SQL Server

Configure connection resiliency for brief idle network drops, test ConnectRetryCount and ConnectRetryInterval, and separate retryable failures.

Read More
A covered serving dish passes through a small kitchen hatch toward a hand reaching from a dark room.

Encrypting Connections to SQL Server

November 3, 2008
Pinal Dave
SQL Tips and Tricks
SQL Connection, SQL Server, SQL Server Configuration, SQL Server Encryption, SQL Server Security

Encrypting connections to SQL Server requires a trusted certificate, careful Force Encryption rollout, and tests with real drivers.

Read More
Previous 1 … 6 7 8 9 10 Next
  • Books
  • Testimonials
  • Privacy Policy

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