Author Archives: Roland Alexander

About Roland Alexander

Pursuer of knowledge, maker of music and poetry, bird watcher, cat lover, maven of literature and fine beer, and champion of reason...

The Artful Dodgery of Estimation

Of the many necessary evils of development, I suspect I like estimation the least. Providing estimates of the number of hours to complete a task, or some set of tasks, is far more art than science. There is also a … Continue reading

Posted in Uncategorized | Leave a comment

On reusability and SQL Server

In my past life as a VB developer, I, like my peers, followed the mantra of reusability. Generic, we said, was good. Loosely coupled, parameter-driven code that made sound use of control flow was our goal. When I crossed the … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment

On theory and practice

A conversation with a data modeler and a comment left on another blog led to this week’s commentary. The former revolved around how a PK should be defined on a child table. The data model called for Parent_ID to be … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment

When standards become straitjackets

I am not a fan of the proliferation of coding standards. Don’t get me wrong: they have their uses. Database collation, ANSI settings, file locations, security practices: these are all sensible candidates for enterprise-level rules. But telling me that I … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment

On getting better every day

I once had a conversation with a colleague regarding a script she had written for a one-time UPDATE and SELECT. I suggested some changes that I felt would improve the performance noticeably and save the DBA who would be running … Continue reading

Posted in SQL Server Development | Tagged | Leave a comment