This blog will no longer be updated.

New content is available on my new blog

programming - Piotr Rodak

Browse by Tags

All Tags » programming (RSS)
24 May 2010 01:27

Good practices - database programming, unit testing

Jason Brimhall wrote today on his blog that new book, Defensive Database Programming , written by Alex Kuznetsov ( blog ) is coming to bookstores. Alex writes about various techniques that make your code safer to run. SQL injection is not the only one...
Posted by Piotr Rodak | 3 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: , , , , , ,
11 March 2010 22:07

Coding standards

This post will be about coding standards. There are countless articles and blog posts related to this topic, so I know this post will not be too revealing. Yet I would like to mention a few things I came across during my work with the T-SQL code. Naming...
Posted by Piotr Rodak | 3 comment(s)
Filed under: , , , , , ,
24 October 2009 13:35

Makesafe script - set up security for developers

I worked yesterday on a script that is supposed to run on DEV database after it has been restored from production. This script adjusts configuration data and security in the database so developers can work safely on production data without compromising...
Posted by Piotr Rodak | with no comments
Filed under: , , , , ,