Query a SQL Database with PowerShell

Query a SQL Database with PowerShell

You can query a SQL database using PowerShell’s Invoke-Sqlcmd cmdlet. This cmdlet is included as part of the Sqlps module, which is installed on a computer by running SQL setup. If you need to load the module, use this command: Import-Module “sqlps”...
How to Pin Windows Update to the Task Bar

How to Pin Windows Update to the Task Bar

Patching windows and SQL is something I do every month on every computer.  One thing that I have found extremely annoying in both Windows 8.x and Server 2012 and 2012 R2 is that you cannot easily pin Windows Update to the task bar to make it easy to launch.  I have...
How to Set a SQL Database to Read-Only

How to Set a SQL Database to Read-Only

You can set a Microsoft SQL database to read-only using either the GUI or a command line. Complete command-line steps are provided below, including steps you should take to prepare your database. Alternate GUI instructions are provided in the step to change the...