Installing The SqlServer Powershell Module

Aaron Nelson has some tips when installing the SQL Server Powershell module:

Whatever you do, try to avoid using the -Scope CurrentUser option.  You may need to use it if you don’t have high enough permissions, in that situation go ahead and use -Scope CurrentUser.  However, if you can avoid using it, do so.  I have lost a lot of time to having used this option.

Read on for more tips.

Related Posts

Checking If UseLargeFRS Is Enabled

Cody Konior has a quick post showing how to see if you have the UseLargeFRS switch turned on for your SQL Server disks: PureStorage has a pretty cool post that mentions the importance of formatting SQL Server disks with a 64KB clusters and the /L flag (also known as the UseLargeFRS switch on PowerShell’s Format-Volume cmdlet). […]

Read More

Installing dbatools

Chrissy LeMaire has a good walkthrough on how to install a module from the Powershell gallery, using dbatools as an example: It’s easy for PowerShell toolmakers to forget that new users may have questions about ExecutionPolicy and Repositories. If dbatools is the first module you’ve ever installed and used, this guide is intended to help […]

Read More

Categories

September 2017
MTWTFSS
« Aug Oct »
 123
45678910
11121314151617
18192021222324
252627282930