Generating SQL Scripts on SQL Workbench/J to Create Amazon Redshift Stored Procedures

Amazon Redshift logo

The task of generating a SQL script for a stored procedure or function is fairly simple in Microsoft SQL Server using SQL Server Management Studio, or in Oracle Database, using SQL Developer. However, if your database is Amazon Redshift, you’re probably using SQL Workbench/J to interact with your database, and unfortunately, its ability to script … Read more

Microsoft Learn for the Win!

design from the Microsoft Lean website

Over the last ten years or so, I have worked with many different computer-based training (CBT) programs from various vendors, some paid, and some free. Of all the ones I’ve used, Microsoft Learn – which is free, as in “free beer”! – has been the best overall. Not only is the variety of subjects available … Read more