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 screwdriver with a red bit in its handle beside an open case of spare bits.

SQLCMD Mode in SSMS: Variables, :CONNECT and :r Includes

January 12, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, sqlcmd

Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.

Read More
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 fitted brass key engages the archive door lock while another key remains unused.

SQL SERVER – Connecting to Server Using Windows Authentication by SQLCMD

May 19, 2011
Pinal Dave
SQL Video
SQL Scripts, SQL Server, SQL Utility, sqlcmd

Windows Authentication by SQLCMD uses the current Windows identity with -E. It does not need a Windows password in the command.

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
A small camping stove with one simmering pot on a picnic table in a quiet clearing at dusk

LocalDB: SQL Server on a Developer’s Laptop

March 12, 2011
Pinal Dave
SQL Tips and Tricks
Developer, SQL Server, SQL Server Express, sqlcmd

LocalDB runs SQL Server Express engine features in a developer-friendly local process; learn how to start, connect, and recognize its limits.

Read More
Two identical white eggs spinning on a kitchen counter, one smooth and one wobbling, a hand hovering above

The New Go-Based sqlcmd: What Changed

October 9, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Server, SQL Utility, sqlcmd

The Go-based sqlcmd adds modern commands and contexts, but ODBC sqlcmd scripts need flag, output, and exit-code tests before a swap.

Read More
A hand winding a mantel clock with a brass key

Backing Up SQL Server Express Without Agent

February 13, 2010
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Express, sqlcmd

Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.

Read More
Previous 1 2 3 4 5 6 Next
  • Books
  • Testimonials
  • Privacy Policy

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