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

Automating Data Importation With dbatools

Bob Pusateri shows how to keep a dataset up to date using Powershell and dbatools: Now for the magic – let’s load some data! The dbatools command that does all the heavy lifting here is called Import-DbaCsvToSql. It loads CSV files into a SQL Server table quickly and easily. As an added bonus, the entire import […]

Read More

Type Information Change In Export-CSV Cmdlet

Max Trinidad notes that a default parameter in the Export-Csv cmdlet has flipped between Powershell on Windows and Powershell Core 6: For a long time, in Windows PowerShell, we had to add the parameter “-NoTypeInformation“, so the “#TYPE …” line on the first row of the *CSV would not be included. So, in Windows PowerShell executing the command […]

Read More

Categories

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