Invalid command-line argument. Consult the Windows Installer SDK for detailed command-line help. Let us see the error about Installation Failure.
SQL SERVER – Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926, state 1, severity 25
An upgrade failed: Script level upgrade for database ‘master’ failed because upgrade step msdb110_upgrade.sql encountered error 926. I explain the cause and the fix.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.
Collapsing Repeated Spaces and Line Breaks With REGEXP_REPLACE
Tabs, line breaks and a sneaky character 160 can all hide in a name that looks fine. Here is how to clean them on purpose.
Parse and Compile Time: Reading the First Line of STATISTICS TIME
Someone pastes a compile time of 24 ms and asks if the server is slow. Run it twice and watch the plan cache do its job.
SQL SERVER – How to Install SSMS From Command Line? Error: The Specified Value for Setting ‘MEDIALAYOUT’ is Invalid.
How to install SSMS from command line? A client’s silent install failed: the specified value for setting MEDIALAYOUT is invalid. Here is the fix.
PowerShell – Querying SQL Server From Command Line
A client’s deployment scripts got me curious about PowerShell. Here is how to start querying SQL Server from the command line with a PowerShell script.