SQLAdmin

Some applications can not use a connectionstring on a given TCP port number or a named database instance. This can be solved by a SQL Alias....

When a ps1-scriptfile contains a Clear-Host statement, which I often use when testing a script in PowerShell ISE, the script fails on SQLPS ...

Often I have to build a command-line statement dynamic and then execute the statement. The PowerShell call operator (&) can be cumberso...

To log the execution and output from all steps in a SQL Server Agent job into a single logfile, you can use SQL Server tokens and macros to ...

When I automate installation or administration I often has to use the major version of the SQL Server database installation. Unfortunately ...