Leveraging the Script Activity within Azure Data Factory

Learn how to use the Script activity in an Azure Data Factory pipeline to deploy and populate databases using DDL, DCL, and DML statements.

The Azure Database Timezone

Cassandra Springboot Integration

In this article, you will see how to initialize a Cassandra database that is used in a Springboot application.

Introducing the MySQL INSERT statement

In the previous article in this series, I introduced you to the SELECT statement, one of several SQL statements that fall into the category of data manipulation language (DML), a subset of statements used to query and modify data. Another DML statement is the INSERT statement, which lets you add data to MySQL tables, both permanent and temporary. This article covers the INSERT statement and the different ways you can use it to add data.

PARSEing strings

The Scariest Data Type

SAP S/4HANA and Microsoft Azure SQL Integration and Hard Deletion Handling

This article shows how one can use SSIS to find differences in SAP.

SQL Cheat Sheet for Basic T-SQL Commands

In this article, we cover some basic T-SQL commands that show you how to interact with a SQL Server database table.

Friendship and Your Career

PASS Data Community Summit is coming up like an out of control freight train. Another couple of weeks and it'll be here. I'm excited about it every year and I really hope to see you there. Please, consider this a personal invite to say hi if you see me around. I'm bringing all this up […]

SQL Stored Procedure Input and Output Parameters, Types, Error Handling, Security and more

In this article, we look at various aspects of creating SQL Server stored procedures along with several examples of how to build a stored procedure.