Human Extract, Transform, and Load

HETL (Human Extract, Transform, and Load) Definition:  When an employee in the field captures data with a pen or pencil & paper, drives back to the office at the end of the workday, and manually transcribes the data into a back-end computer system. You're probably thinking this is an antiquated phenomenon that disappeared decades ago with the advent of... Continue Reading →

Reducing SQL Server Sync I/O Contention :: Tip 3

Uniqueness is a key factor when synchronizing data between SQL Server/Azure and multiple endpoints like Slates and Smartphones. With data simultaneously created and updated on servers and clients, ensuring rows are unique to avoid key collisions is critical. As you know, each row is uniquely identified by its Primary Key.

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑