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 rope splicing fid separating paired strands before joining a single strand

Line Endings: CHAR(13), CHAR(10) and Files From Other Systems

April 21, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Command Line, SQL Server

Why does a value that looks perfect fail a compare? Because of a line ending you cannot see. Five small demos make it visible.

Read More
Gouache painting of a grey shed beside the water with its door open and a vermilion key in the lock

SSMS Command Line Options: Server, Database and Login

June 15, 2020
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Command, SQL Server Management Studio

SSMS command line options open Management Studio already pointed at a server and a database. This post finds SSMS.exe, lists the switches that SSMS 22 documents in its own usage text, and shows how to turn them into a shortcut without saving a password.

Read More
Gouache painting of a gravel track branching into footpaths leading to three sheds, the nearest with a vermilion door

Windows Path Variable: Run oStress From Any Folder

May 9, 2020
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Utility, sqlcmd, Windows

The Windows Path variable is a list of folders that Windows searches when you type a program name. This post shows how to test a change in one window, add a folder for good and check that it works. It uses oStress and sqlcmd as the examples and ends with rules for a clean Path.

Read More
Gouache painting of a wooden spoon with a vermilion handle beside a big cream stand mixer

sqlcmd vs SSMS: How to Time the Same Loop Fairly

April 29, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, sqlcmd, Testing

A sqlcmd vs SSMS timing is fair only when both tools run the same file. The clock must sit inside the script. This post times 10,000 inserts three ways with a log table, shows what changed and what didn’t, and lists the settings to match before you compare.

Read More
Gouache painting of a grey wheelbarrow of pumpkins beside a vermilion tractor on a farm track

oStress vs SSMS: What Each Tool Is Built to Measure

April 28, 2020
Pinal Dave
SQL Performance
Command Line, SQL Scripts, SQL Server Management Studio, Testing

oStress vs SSMS is not a race, because the tools measure different things. This post times 10,000 inserts in three ways with a clock inside the script, then shows how eight sessions finish the same work faster. It explains what a one-session loop really measures.

Read More
Gouache painting of a plank bridge over a brook loaded with sandbags, the top one vermilion

oStress Load Test: Run Many Sessions Against SQL Server

April 27, 2020
Pinal Dave
SQL Performance
Command Line, SQL Server, sqlcmd, Testing

An oStress load test runs one query from many connections at once, so you can watch SQL Server under a crowd. This post explains the main switches and runs a small first test with five connections. It also builds the same test with sqlcmd workers, for machines without oStress.

Read More
A small red folding bicycle being unfolded on a train platform beside a heavy old bicycle

go-sqlcmd: The New Command Line Tool for SQL Server

October 8, 2019
Pinal Dave
SQL Tips and Tricks
Command Line, SQL Server, SQL Utility, sqlcmd

Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.

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

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