Show and Know beats Care and Prayer
As a consultant I rarely see systems that are operating well. People don’t take their cars to the mechanic when they are functioning properly. I appreciate that this colours my
Automating Oracle Data Integrator
I’ve worked on a lot of warehouses using a number of different ETL tools. Most of these tools make my job as technical lead very difficult. They are opaque: they
The Exec Exec trick
SQL Server’s Transact SQL has some weird constraints. One of which is that certain statements must be the first one in their batch. This causes all kinds of head-aches for
T-SQL Common Table Expressions are Turing Complete
I’ve seen some wonderful, powerful, and creative T-SQL Common Table Expression (CTE) SQL statements recently. Our tools have been improved, and we’re eagerly exploring them. Recursive CTEs make individual SQL
Small is reliable
As consultant, I have the privilege of learning from a lot of clients. There are different ways of writing software, and I get to see a lot of them. One
RSS - Posts