script,programming - Piotr Rodak

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: tips and tricks, t-sql, errors, script, programming, error, API, unit testing, error handling

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: tips and tricks, t-sql, Numbers table, util, script, practices, programming

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: tips and tricks, t-sql, source code, script, practices, programming, troubleshooting

Piotr Rodak

This Blog

Syndication

Search

Tags

Navigation

Archives

Browse by Tags

Good practices - database programming, unit testing

COLUMNS_UPDATED() for audit triggers

Coding standards