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.
go-sqlcmd: The New Command Line Tool for SQL Server
Set up go-sqlcmd on Windows, verify the executable, run scripts and variables, control output, and review optional container commands.
SQL SERVER – How Do I Evaluate Monitoring Tools?
I evaluate monitoring tools by collection cost, historical context and usefulness in choosing a correction. Customer discussions shaped those three criteria.
How to Change Language for SSMS? – Interview Question of the Week #194
How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.
SQL SERVER – SSIS – Package Error: “ODBC Source” Failed Validation and Returned Validation Status “VS_NEEDSNEWMETADATA”
A client’s SSIS package failed: “ODBC Source” failed validation and returned validation status “VS_NEEDSNEWMETADATA”. I explain which metadata and the fix.
How to Schedule a Job in SQL Server? – Interview Question of the Week #160
How do you Schedule a Job in SQL Server? First make sure SQL Server Agent is running, then follow these simple screens to add the job, its steps and a schedule.
SQL Server Backup Compression: How Much Space It Saves
Backup compression needs only the COMPRESSION option in the BACKUP statement. This post backs up a demo database twice and compares the sizes and times. It also checks the restore, explains the error that mixing compressed and plain backups raises, and covers the costs.