Author: Ian Fogelman

Ian is a database enthusiast with expertise across multiple database technologies including SQL Server, RDS, Snowflake, MySQL and Postgres. Other technologies and concepts that Ian has expert level experience with include AWS, ETL strategies, Python scripting, Cloud architecture and system automation.

The Essence and Configuration of AWS Virtual Private Cloud

10:01 AWS, Cloud

Amazon Web Service environment is a fully digital experience of a typical brick-and-mortar data...
Read More

How to Use REPLACE in SQL

10:12 Database development, Statements

When querying data with SQL, the need to manipulate string-based results is very common. There are many options across the major relational...
Read More

The AWS Secrets Manager

12:59 AWS, Cloud • 2 Comments

Problem Statement Keeping credentials and other sensitive data out of application code can be a challenge. AWS Secrets Manager is meant to...
Read More

Overview of T-SQL PRINT Statement

09:57 Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program...
Read More

T-SQL Stuff Command

08:45 Database development, Statements

The main idea around the SQL Server function called STUFF is concatenating multiple columns into a single column with more flexibility than...
Read More

An Overview of the PRINT Statement in SQL Server

12:08 Database development, Statements

The SQL PRINT statement serves to display the user-defined message. For example, you are developing a script with T-SQL Loops, and you want...
Read More