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.

10 Considerations for a Database Migration to AWS RDS

This article includes 10 things that you should consider when migrating to the cloud, with an example using RDS that explains how these are applied to an actual database being created.

The Work of Work

Meeting are work, even though we sometimes don't think of them as a productive part of our job.

Data Lineage Scripts for Microsoft SQL Server and Azure SQL

Learn how you can easily analyze the data lineage in your SQL Server database.

SQL Server Internals: Reading Pages

The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.