Category: SQL
-
The All Roads Project – Loading the CCC Data from Staging Area

For the All Roads Project, the Catechism data have been staged. It is on to loading the data into the landing set of tables.
-
Designing the Database Structures for The All Roads Project

Designing a database is a fun process. I will step through the basics of conceptual, logical, and physical design. The end result will be used for The All Roads Project.
-
Banding Data via SQL (after a quick import)
This article goes over a simple technique of banding a data set after importing into SQL Server.