Category Archives: SQL Server Development

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