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 - How to Connect Using NT AUTHORITY \ SYSTEM Account?

SQL SERVER – How to Connect Using NT AUTHORITY \ SYSTEM Account?

February 8, 2016
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Server, SQL Server Security

SSMS will not let you type in Windows credentials. Here is how to connect using NT AUTHORITY\SYSTEM account with PsExec from Sysinternals.

Read More
Gouache painting: a tin-can telephone, two paper cups joined by a taut vermilion string stretched across a gap between a slate-blue windowsill and a sage-green doorway

Connect to MySQL From the Command Prompt: Host, Port, User

March 25, 2014
Pinal Dave
SQL Tips and Tricks
Command Line, MariaDB, MySQL, SQL Connection

To connect to MySQL from the command prompt, you pass a host, a port, a user and a password to the mysql client. This post runs every switch, then shows the exact error that a wrong port, user, password or database produces.

Read More
Gouache painting: a long archive wall of identical wooden drawers, one pulled open with a brass lamp beside it and a small vermilion tag on its handle

Find mysqld.exe on Windows and Fix ‘mysql’ Is Not Recognized

November 8, 2013
Pinal Dave
SQL Tips and Tricks
Command Line, MariaDB, MySQL, SQL Error Messages, Windows

To find mysqld.exe on Windows, search the drive with dir or where, or ask the running server where it lives. This post fixes the ‘mysql’ is not recognized error by adding the bin folder to PATH, and it shows every command with its real output.

Read More
SQL Server - Using SSMS Command Line Parameters

SQL Server – Using SSMS Command Line Parameters

January 8, 2013
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Server, SQL Server Management Studio

My friend Vinod Kumar shows how SSMS Command Line parameters can save you a few clicks every time you open Management Studio and connect to a server.

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 travel plug held in front of a wall socket of a different shape, with the right adapter resting on a shelf below

Fast Exports With bcp

July 18, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, CSV, SQL Server, SQL Utility

Fast exports with bcp compares native and character files, shows a format file, and explains where batch size helps and how to check a large export.

Read More
A pottery kiln working on its own in an empty studio at night

Installing SQL Server Silently From the Command Line

April 25, 2010
Pinal Dave
SQL Tips and Tricks
Command Line, DBA, PowerShell, SQL Server Installation, SQL Setup

Installing SQL Server silently takes a reviewed ConfigurationFile.ini, required setup switches, and a check of logs and active instance settings.

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

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