SQL Server
T-SQL scripts and SSMS habits from years on SQL Server: queries, shortcuts and SSIS helpers.
8 articles
- SQL ServerHow to Make VS Code Look and Feel Like SSMSA keybindings.json file and a small VS Code extension that bring SSMS column selection, Ctrl+R and Query Shortcuts such as Ctrl+3 for top 1000 rows to VS Code.
- SQL ServerSP_Helptext Get DDL informationHow to display the code of a stored procedure, view, function or trigger in SQL Server with sp_helptext, plus sp_help for more details on an object.
- SQL ServerManagement Studio - Faster with multiple selectHow to select a column of text with Alt+Shift and the arrow keys in SSMS or Notepad++, for example to put quotes around a list of values for an IN clause.
- SQL ServerSSIS - Create Environment from Packages variablesA T-SQL script that reads your deployed SSIS projects and generates the code to create their environments and variables with default values, and to assign them.
- SQL ServerSSMS - Query Shortcuts : Feel like a superman developerHow to set up Query Shortcuts in SSMS, with ready-to-paste queries for top 1000 rows, row count, table description and running queries on Ctrl+3 to Ctrl+0.
- SQL ServerSSIS - Log Execution timeA query on the SSISDB catalog that shows the start time, end time, duration in minutes and last status of each SSIS package, child packages included.
- SQL ServerSSIS - Export SSIS Catalog EnvironmentsA T-SQL script that generates the code to recreate an SSIS Catalog folder, environment and variables on another server, then map them to your project parameters.
- SQL ServerSP_WHO3 - Running Queries (Toolbox)A query that lists every running request on SQL Server with its user, host, database, SQL text, CPU and reads, and which session is blocking which.
