Pinned

1. Download from PowerShell Gallery via...

   1

   $package = 'https://powershellgallery.com/api/v2/package/dbatools'

   2

   $zipPath = 'C:\temp\dbatools.zip'

   3

   (New-Object System.Net.WebClient).DownloadFile($package, $zipPath)

   4

   $extractPath = 'C:\temp\modules\'

   5

   [io.compression.zipfile]::ExtractToDirectory($zipPath, $extractPath)

2. dbatools

   Forked from sqlcollaborative/dbatools

   🚀 SQL Server automation and instance migrations have never been safer, faster or freer

   PowerShell

3. Keybindings VS Code

   1

   // Place your key bindings in this file to overwrite the defaults

   2

   [

   3

       {

   4

           "key": "alt+up",

   5

           "command": "workbench.action.navigateUp"

4. sp_WhoIsActive query to find and kil...

   1

   IF OBJECT_ID('tempdb..#whoisit') IS NOT NULL

   2

   	DROP TABLE #whoisit;

   3

   GO

   4

   5

   CREATE TABLE #whoisit ( [dd hh:mm:ss.mss] varchar(8000) NULL,[session_id] smallint NOT NULL,[status] varchar(30) NOT NULL,[login_time] datetime NULL)