PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
SQL SERVER – Fix: Error: File Cannot be Loaded Because the Execution of Scripts is Disabled on This System
After a fresh install, PowerShell stopped me with an error: execution of scripts is disabled on this system. The fix takes two lines with Set-ExecutionPolicy.
SQL SERVER – Powershell – Get a List of Fixed Hard Drive and Free Space on Server
A PowerShell way to get a list of fixed hard drives and free space on server: MVP Ravikanth’s short script with Get-WmiObject and Win32_LogicalDisk.
SQL SERVER – PowerShell Version Info
Two commands show your PowerShell version: $PSVersionTable and $host. Only one worked on Version 1, so I ask PowerShell experts to explain why.
SQLAuthority News – Guest Post – Performance Counters Gathering using Powershell
A guest post by Laerte Junior on gathering performance counters with Powershell, so a busy DBA can automate routine checks and get home a little earlier.
SQL SERVER – Size of Index Table for Each Index – Solution 3 – Powershell Index Size
Laerte Junior fixed my Powershell setup remotely in minutes and sent solution 3 to my puzzle on the size of each index. Here is his Powershell Index Size answer.
SQL SERVER – Enable xp_cmdshell using sp_configure
Enable xp_cmdshell with sp_configure: turn on show advanced options, set xp_cmdshell to 1 and run RECONFIGURE. The full script is ready to run in SSMS.