This blog will no longer be updated.

New content is available on my new blog

util,script - Piotr Rodak

Browse by Tags

All Tags » util » script (RSS)
11 May 2010 00:18

The penultimate audit trigger framework

So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks. The first part of this miniseries describes the mechanics of the encoding which columns are updated within DML operation. The task I was faced with...
Posted by Piotr Rodak | 2 comment(s)
Filed under: , , , , , , , , ,
28 April 2010 23:27

COLUMNS_UPDATED() for audit triggers

In SQL Server 2005, triggers are pretty much the only option if you want to audit changes to a table. There are many ways you can decide to store the change information. You may decide to store every changed row as a whole, either in a history table or...
Posted by Piotr Rodak | 2 comment(s)
Filed under: , , , , , ,
20 July 2009 00:13

Sql release builder

For a number of weeks, we have been regularly releasing code to our UAT database. The release process of database code differs slightly from releasing binary code because the release has to take into account existing data and schema in the database. With...
Posted by Piotr Rodak | with no comments
Filed under: , , , ,