Windows Authentication by SQLCMD uses the current Windows identity with -E. It does not need a Windows password in the command.
SQL SERVER – 2008 – 2008 R2 – Create Script to Copy Database Schema and All The Objects – Data, Schema, Stored Procedure, Functions, Triggers, Tables, Views, Constraints and All Other Database Objects
Use the SQL Server script generator wizard to copy database schema, data and all objects, then run the large script with SQLCMD on the new instance.
SQL SERVER – Running Multiple Batch Files Together in Parallel
I needed SQL code running in parallel for a demo, so I used sqlcmd and start cmd.exe to run multiple batch files together. Can PowerShell do it better?
SQL SERVER – Activity Monitor and Performance Issue
A small story with a big moral about Activity Monitor and performance issue: a client left the tool open, and the monitor itself slowed the server down.
The New Go-Based sqlcmd: What Changed
The Go-based sqlcmd adds modern commands and contexts, but ODBC sqlcmd scripts need flag, output, and exit-code tests before a swap.
SQL SERVER – Get Query Running in Session
I forgot the simple syntax to get query running in session and ended up on my own old post. Here is the one method I use most during performance tuning.
Fast Exports With bcp
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.