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.
Loading Data From an API Into SQL Server
Loading data from an API into SQL Server takes paging, JSON staging, retries, and durable checkpoints so a failed request can resume safely.
Building a Test Server From a Script
Build a test server from a script with unattended SQL Server setup, repeatable configuration, and sample data that can be reset after each run.
SQL Assessment API Findings: From Scan to Action
SQL Assessment API findings can guide a health review, provided the scan’s scope and evidence are clear. I separate collection problems from recommendations before deciding what to change. A short list is useful only when I know what was checked.
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.