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.

How to Use AWS Secrets Manager: Tutorial & Examples

AWS, Cloud • 2 Comments

Keeping credentials and other sensitive data out of application code can be a challenge. AWS...
Read More

What is Amazon VPC: Tutorial Guide

AWS, Cloud

Amazon Web Service environment is a fully digital experience of a typical brick-and-mortar data center. All components, such as firewalls...
Read More

SUBSTRING Command in SQL: A Primer

SQL Server

Similar to my article regarding the SQL Server STUFF command, today we will be examining the SUBSTRING SQL server command. It is similar to...
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

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

SQL Stuff Function

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

How to Connect Python to SQL Server to Automate Backend Process

Automation, Database administration

Automating backend processes in your SQL Server instance is a common task. Whether it is refreshing the statistics, rebuilding indexes,...
Read More

An Overview of the PRINT Statement in SQL Server

Database development, Statements

The SQL PRINT statement serves to display the user-defined message. For example, you are developing...
Read More
Close