Resources

This is a list of good resources I have found in the past.

IT Infrastructure Tools

• USB Drive Quality Checker

• RDP

  • Troubleshoot Broken Clipboard
  • Multi Monitor setup/troubleshooting/duel monitors

PHP

• IIS, PHP, and XDebug

Python

• Debugging

SQL

• SQL Server

• Restore SQL Server DB
• String Agg on SQL Server 2016 or before
• Trigger Tips
• Audit Fields
• upper and lower case compare
• Create a linked server to another SQL Server
• search entire database for a string somewhere

• PostgreSQL

• Progress/OpenEdge Database

  • Table/Column Search Query
  • SQL Functions/Expressions
  • DBeaver Setup
  • php odbc_connect to progress database
  • String Case Compare
  • UNIX Epoch to YYYYMMDD
  • First Day Of Current Month
  • Last Day of Current Month

• Pervasive SQL

  • POSTGRES TO PERVASIVE

• SQL Agnostic

  • Poor SQL Formatting Tool
  • Remove Returns

SSIS

• Installation

• How to Install SQL SSIS to existing SQL Server

• Setup Troubleshooting

  • Excel ETL to Table
  • Note: all paths in SSIS must be UNC (Click to see what UNC means)
  • Deploying a Catelog for the first time
  • Making sure you are using 32 bit (Should this be an issue)
  • Depending on your version of SSIS, changing the job to 32 might look like this.
  • Change the job owner to SA should the agent job not want to run.

• Scripts and Tools

  • Data fetching tool (VDBC#)
  • Webscrapping

SSRS

• ssrs-report-usage-queries
• Installation Guide

IDEs

• Datagrip
• Rainfrog - TUI IDE for RDBMSes

automation

• Tiny Task

Excel Tools