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 wooden drawbridge being lowered across a moat toward an open stone gateway

Connecting to SQL Server From Linux

December 4, 2011
Pinal Dave
SQL Tips and Tricks
Linux, SQL Connection, SQL Server, SQL Server Encryption, sqlcmd

Connecting to SQL Server from Linux requires the right Microsoft ODBC packages, a Kerberos plan, and certificate trust that matches the server name.

Read More
A grain silo with its main doors blocked by spilled grain and a small side hatch open with a lantern inside.

Diagnosing a Frozen Server With the Dedicated Admin Connection

May 4, 2011
Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL Server Configuration, sqlcmd

The dedicated admin connection provides a narrow emergency path to a stalled SQL Server; prepare remote access and keep diagnostics light.

Read More
Two hands at a relay baton exchange on a running track, a small gap between the red baton and the open palm

Reading a Network Trace of a SQL Server Connection

March 20, 2010
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Connection, SQL Server, SQL Server Security

Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.

Read More
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
Previous 1 … 3 4 5 6 7 Next
  • Books
  • Testimonials
  • Privacy Policy

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