Pinned Loading

1. tsql-coding-patterns tsql-coding-patterns Public

   A collection of amazing code patterns for T-SQL

2. sp_who3 sp_who3 Public

   The sp_who3 stored procedure is a custom and open source alternative to the sp_who system stored procedures available in SQL Server.

   TSQL 53 14

3. Install SqlServer Powershell module ... Install SqlServer Powershell module to a machine without access to PowerShell Gallery

   1

   # download the module to local folder

   2

   Invoke-WebRequest -Uri powershellgallery.com/api/v2/package/sqlserver -Out C:\temp\sqlserver.zip

   3

   4

   # unzip the file

   5

   Expand-Archive -LiteralPath 'C:\temp\sqlserver.zip' -DestinationPath C:\temp\sqlserver