_README - KaaS - Obsidian Publish

# Code  *This directory houses various code snippets, scripts, and tips/tricks for a variety of my most commonly used Programming Languages*  ## Contents - [[#Cascading Style Sheets (CSS)|Cascading Style Sheets (CSS)]] - [[#GitHub Actions|GitHub Actions]] - [[#JavaScript|JavaScript]] - [[#Linux|Linux]] - [[#Linux#Bash|Bash]] - [[#Linux#WSL|WSL]] - [[#Pandoc|Pandoc]] - [[#PowerShell (Core)|PowerShell (Core)]] - [[#Python|Python]] - [[#R|R]] - [[#Structured Query Language (SQL)|Structured Query Language (SQL)]] - [[#Structured Query Language (SQL)#BigQuery|BigQuery]] - [[#Structured Query Language (SQL)#PostgreSQL|PostgreSQL]] - [[#Structured Query Language (SQL)#Microsoft SQL Server (MSSQL / T-SQL)|Microsoft SQL Server (MSSQL / T-SQL)]] - [[#Windows|Windows]] - [[#Windows#Batch Scripts|Batch Scripts]] - [[#Windows#Miscellaneous|Miscellaneous]] - [[#Windows#Registry (RegEdit)|Registry (RegEdit)]] - [[#Windows#Run Commands|Run Commands]] - [[#Windows#Visual Basic|Visual Basic]] - [[#Visual Basic#Visual Basic for Applications (VBA) - Excel VBA|Visual Basic for Applications (VBA) - Excel VBA]] - [[#Windows#Windows Command Line (CMD/MS-DOS)|Windows Command Line (CMD/MS-DOS)]] - [[#Windows#Windows PowerShell|Windows PowerShell]] - [[#MindMap|MindMap]] - [[#Appendix: Links|Appendix: Links]] ## Cascading Style Sheets (CSS) - [[2-Areas/Code/CSS/_README|CSS]] - CSS Code Snippets. - [[CSS - Default Obsidian Theme Styling]] - [[CSS - GitHub Obsidian Theme]] ## GitHub Actions - [[2-Areas/Code/GitHub Actions/_README|GitHub Actions]] - GitHub Action Code Snippets. - [[GHA - R Build-Check-Install]]: Build, Check, and Install R Package - [[GHA - R Code Coverage]]: Run Code Coverage on an R Package - [[GHA - Git-Cliff]]: automate the generation of `CHANGELOG.md`'s using [[Git-Cliff]]. - [[GHA - R pkgdown]]: Generate and deploy a dedicated [[R Package - pkgdown|pkgdown]] Documentation Website - [[GHA - R Package Validation]]: Perform R Package Validations - [[GHA - R Spelling]]: Run `spelling::spellcheck()` on your R Package - [[GHA - Release]]: Create a new GitHub Release - [[GHA - R roxygen]]: Document your R package via [[R Package - roxygen2|roxygen2]] - [[GHA - GitHub Actions for R]]: List of various R Github Actions ## JavaScript - [[2-Areas/Code/Javascript/_README|Javascript Code]] - Javascript Code Snippets. - [[JS - Remove all YouTube Watch Later Videos]] - [[JS - Obsidian Web Clipper Bookmarklet]] ## Linux ### Bash - [[2-Areas/Code/Linux/Bash/_README|Bash]] - Linux Bash Code Snippets. - [[Bash - Git-Auto]] - [[Bash - Install NVM]] - [[Bash - Install oh-my-zsh]] - [[Bash - GitHub Downloader]] ### WSL - [[2-Areas/Code/Linux/WSL/_README|WSL]] - Code Snippets and Scripts Specific to [[Windows Subsystem for Linux]] (WSL) - [[Bash - Install WSLU]] ## Pandoc - [[Pandoc - Convert Word to Markdown]] ## PowerShell (Core) - [**PowerShell**](2-Areas/MOCs/PowerShell.md) - PowerShell Code Snippets. - [[2-Areas/Code/PowerShell/PowerShell - Cleanup Windows Script]]: Cleanup and Debloat Windows - [[2-Areas/Code/PowerShell/PowerShell - Custom Installation Helpers]]: Some of my custom installation helper functions - [[2-Areas/Code/PowerShell/PowerShell - Edge Scripts]]: Edge related functions - [[2-Areas/Code/PowerShell/PowerShell - Git AutoCommit]]: Autocommit with [[Git]] - [[PowerShell - Install AWS CLI]]: Install [[AWS CLI]] using [[3-Resources/Tools/Developer Tools/Languages/PowerShell]] - [[2-Areas/Code/PowerShell/PowerShell - Install Azure-CLI]]: Install [[Azure CLI]] using [[3-Resources/Tools/Developer Tools/Languages/PowerShell]] - [[PowerShell - Install Backblaze Client]]: Install the [[Backblaze]] Client - [[PowerShell - Install Chocolatey]]: Install [[Chocolatey]] Package Manager - [[PowerShell - Map Drives Function]]: Map Drives - [[PowerShell - Open Obsidian Vault]]: Launch an [[Obsidian]] Vault using the [[Obsidian URI]] - [[PowerShell - QuickAccess Utilities]]: QAT utilities - [[PowerShell - Retrieve Local Public IPv4 IP Address]]: Retrieve your IPv4 IP Address - [[PowerShell - Scoop Import]]: Custom [[Scoop]] Import - [[PowerShell - System PATH Helpers]]: Helper functions for working with your system `%PATH%` environment variables - [[PowerShell - Toast Notification Example]]: Toast notifications - [[PowerShell - Useful Profile Utility Functions]]: Miscellaneous utility functions ## Python - [[2-Areas/Code/Python/_README|Python]] - Python Code Snippets. - [[Python - Upgrade PIP]]: Upgrade [[Python - pip|pip]] ## R - [[2-Areas/Code/R/_README|R]] - R Code Snippets. - [[R - docker_shiny_mssql]] - [[R - mssql_rstudio]] - [[R - Handle long polling process in Plumber or Shiny]] - [[R - Excel Helpers]] - [[R - Package Management Scripts]] - [[R - Retrieve GitHub Starred Repo Data]] - [[R - Run Shiny App in Background for Development]] - [[R - Simulate Actuarial Claims Data - Simulation R Script]] - [[R - Upgrade R and Migrate Packages]] ## Structured Query Language (SQL) - [[SQL]] ### BigQuery #Status/WIP - [[2-Areas/Code/SQL/BigQuery/_README|BigQuery]] ### PostgreSQL - [[SQL/PostgreSQL]] - [[SQL - PostgreSQL - Audit Trigger]] - [[SQL - PostgreSQL - Basic Instance Information]] - [[SQL - PostgreSQL - Calculating the Median]] - [[SQL - PostgreSQL - Clone Schema]] - [[SQL - PostgreSQL - Count NULLs]] - [[SQL - PostgreSQL - Create modified_at columns and triggers]] - [[SQL - PostgreSQL - Creating Equal-Sized Buckets using ntile]] - [[SQL - PostgreSQL - Cumulative Distribution]] - [[SQL - PostgreSQL - DataDictionary]] - [[SQL - PostgreSQL - Date Dimension Table]] - [[SQL - PostgreSQL - Dump Entire Database to CSV]] - [[SQL - PostgreSQL - Dynamic Trigger]] - [[SQL - PostgreSQL - ETL Function Template]] - [[SQL - PostgreSQL - Extensions]] - [[SQL - PostgreSQL - Extracting Values from JSON Strings]] - [[SQL - PostgreSQL - Filter for the Last x Days]] - [[SQL - PostgreSQL - Find Recent Activity]] - [[SQL - PostgreSQL - Formatting Dates and Timestamps]] - [[SQL - PostgreSQL - Generate Timeseries of Dates and Times]] - [[SQL - PostgreSQL - Get all Primary Keys and Columns]] - [[SQL - PostgreSQL - Get Current DB Sessions]] - [[SQL - PostgreSQL - Get Last Day of Month]] - [[SQL - PostgreSQL - Get the Last Element of an Array]] - [[SQL - PostgreSQL - Histogram Bins]] - [[SQL - PostgreSQL - Human-Readable Timestamps]] - [[SQL - PostgreSQL - Information Schema Queries]] - [[SQL - PostgreSQL - Kill Running or Idle Connections]] - [[SQL - PostgreSQL - MONTH() Equivalent]] - [[SQL - PostgreSQL - Moving Average]] - [[SQL - PostgreSQL - Multi-Replace (plpgsql)]] - [[SQL - PostgreSQL - Normalize Whitespace]] - [[SQL - PostgreSQL - Pivot Query]] - [[SQL - PostgreSQL - Ranking Data]] - [[SQL - PostgreSQL - RegEx to Parse URL String]] - [[SQL - PostgreSQL - RegEx to Validate an Email Address]] - [[SQL - PostgreSQL - Replace Empty Strings with NULLs]] - [[SQL - PostgreSQL - Replace NULLs]] - [[SQL - PostgreSQL - Reverse an Array]] - [[SQL - PostgreSQL - Set Default UTF8 Encoding]] - [[SQL - PostgreSQL - Simulate IIF From SQL Server]] - [[SQL - PostgreSQL - Split a Single Column into Separate Rows]] - [[SQL - PostgreSQL - Stored Procedure - Merge Tables]] - [[SQL - PostgreSQL - Strip Accents from Strings]] - [[SQL - PostgreSQL - UPSERT]] - [[SQL - PostgreSQL String Manipulation]] ### Microsoft SQL Server (MSSQL / T-SQL) Code Snippets for Microsoft's [[SQL Server]] or [[SQL Server|MSSQL]]: - [[SQL Server]] - [[SQL - SQL Server - Convert Integer (Clarion) Date to SQL Datetime]] - [[SQL - SQL Server - Check if a Column is Accessible]] - [[SQL - SQL Server - Check Size of DB Objects]] - [[SQL - SQL Server - Concatenate Strings]] - [[SQL - SQL Server - Create Date Dimension with Fiscal Years]] - [[SQL - SQL Server - Cumulative Distribution Functions]] - [[SQL - SQL Server - Find the First Row of Each Group]] - [[SQL - SQL Server - Find Unused Indexes]] - [[SQL - SQL Server - Get Number of Open Connections]] - [[SQL - SQL Server - Installation Script for DBA MultiTool]] - [[SQL - SQL Server - Monitor Query Plans]] - [[SQL - SQL Server - POST HTTP API Request]] - [[SQL - SQL Server - Re-build all Indexes]] - [[SQL - SQL Server - Retrieve Stored Procedures and Functions Execution Times Counts and Averages]] - [[SQL - SQL Server - Retrieve Top Slow Requests]] - [[SQL - SQL Server - Retrieve Who is Doing What]] - [[SQL - SQL Server - Search for Text Within Stored Procedures]] - [[SQL - SQL Server - Useful Queries]] ## Windows ### Batch Scripts #Status/WIP - [[2-Areas/Code/Windows Batch/_README|Batch]] - [[Batch - MediaCreationTool]] - [[Batch - Magic Variables]] ### Miscellaneous - [[Add Tabs to Windows 11 Explorer]] ### Registry (RegEdit) #Status/WIP - [[2-Areas/Code/Windows Registry/Regedit - Enable Long Path Support on Windows]] - [[2-Areas/Code/Windows Registry/Regedit - Export Saved Registry Favorites]] - [[RegEdit - Restart Explorer and StartMenu Context Bar]] - [[RegEdit - Take Ownership Context Menu]] ### Run Commands #Status/WIP - [[Run - Cleanup]] - [[Run - GodMode All Tasks]] - [[Run - Obsidian Vault Launcher]] - [[Run - Resource Monitor]] - [[Run - Startup]] ### Visual Basic #Status/WIP #### Visual Basic for Applications (VBA) - Excel VBA - [[VBA - Notes]] - [[VBA - Alert]] - [[VBA - Balloon Notification]] - [[VBA - Check for Broken Links in Workbook]] - [[VBA - Copy Module from one Workbook to Another]] - [[VBA - Create and Run a SQL Query]] - [[VBA - File Dialog]] - [[VBA - ListLinks Module]] - [[VBA - Make All Open Files Read Only]] - [[VBA - Module Template]] - [[VBA - Optimize Speed]] - [[VBA - Page Setup and Print Macros]] - [[VBA - Refresh All]] - [[VBA - Save All]] - [[VBA - SQL Stored Procedure Caller Module]] - [[VBA - Unhide All Worksheets]] - [[VBA - Unhide all Rows and Columns]] - [[VBA - Useful Utilities]] ### Windows Command Line (CMD/MS-DOS) - [[2-Areas/Code/Windows CMD/_README|Windows Command Line]] - Windows Command Line Code Snippets. - [[CMD - Create a Network Performance Windows Report 1]] - [[CMD - Delete Network Data 1]] - [[CMD - Delete Windows Update Leftover Files 1]] - [[CMD - DISM Commands 1]] - [[CMD - FlushDNS]] - [[CMD - Retrieve Stored Wi-Fi Passwords 1]] - [[CMD - Retrieve Windows Credential Manager Saved Secrets 1]] - [[CMD - Run the Hardware Diagnostic Troubleshooter 1]] - [[CMD - Run the WinSAT Diagnostics Score 1]] - [[CMD - Start a Windows Defender Virus Scan]] - [[CMD - View Available Disks on Windows]] - [[CMD - Extended Disk Cleanup 1]] - [[CMD - Memory Diagnostic]] - [[CMD - Troubleshooter Commands]] - [[CMD - View Available Disks on Windows]] ### Windows PowerShell #Status/WIP Nothing Yet. ## MindMap #Status/WIP ![](https://i.imgur.com/wJCIHVX.png) *** ## Appendix: Links **See Also:** - My [[thiscodeWorks]] Dashboard: [jimbrig - Dashboard | thiscodeWorks](https://www.thiscodeworks.com/user/dashboard#) - My [[GitHub]] Gists: [jimbrig’s gists (github.com)](https://gist.github.com/jimbrig) - My stashed [[Python Package - keep|keep]] commands: [Backup for keep - https://github.com/OrkoHunter/keep](https://gist.github.com/jimbrig/da88cb0d6ad1ff9037ce4e209728adfa) **Backlinks:** - [[Tools]] - [[Programming Languages]] - [[Development]] - [[Web Development]] - [[Data Engineering]] - [[Databases]]