Finding metadata regarding table and column names in Redshift can be daunting, especially if you do not know if the tables are internal or external. Redshift has a table called SVV_EXTERNAL_COLUMNS that is useful for looking at external tables, and there are scripts to look at internal tables as well. The SQL code I wrote … Read more
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
Blockchain is a technology that I hear about almost every day now. And yet I haven’t found the best place to learn about it – both its concepts and its implementation. With so many courses and books, where to begin? Those of you who have learned about it and use it regularly – what resources … Read more