Piotr Rodak

Good practices - database programming, unit testing

Piotr Rodak — Mon, 24 May 2010 00:27:00 GMT

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...(read more)

The penultimate audit trigger framework

Piotr Rodak — Mon, 10 May 2010 23:18:00 GMT

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...(read more)

COLUMNS_UPDATED() for audit triggers

Piotr Rodak — Wed, 28 Apr 2010 22:27:00 GMT

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...(read more)

Coding standards

Piotr Rodak — Thu, 11 Mar 2010 22:07:00 GMT

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...(read more)

An internal error occurred on the report server - no disk space for database.

Piotr Rodak — Tue, 23 Feb 2010 22:04:00 GMT

Last week was pretty hectic for me. I was developing SSRS report that was to be deployed to our QA, UAT and production environments. The report consists of many sections, which I had to implement as tables rather than subreports, because SSRS for SQL...(read more)

Kayleigh

Piotr Rodak — Mon, 22 Feb 2010 23:46:00 GMT

It's been about 25 years since I've heard Misplaced Childhood or the first time in my life. There was time when I could sing the whole album along with Fish . Thankfully karaoke and youtube weren't as popular in Poland in 1985 as they are...(read more)

relative query cost not accurate when using set rowcount

Piotr Rodak — Wed, 27 Jan 2010 22:33:00 GMT

When tuning performance of a query, it is quite common to compare different variants of the query in the same batch and compare the execution plans to see if changes that you made actually work for better or not. Often you would compare just relative...(read more)

like in the old times

Piotr Rodak — Fri, 22 Jan 2010 14:35:00 GMT

My little brother got recently an old 50mm Pentax-M 1:2 lens. While this lens is not known for the best image quality amongst Pentax prime 50mm lenses, it gave me first opportunity to take pictures 'the old way' on my K10D. This is quite nostalgic...(read more)

updating column with a random value

Piotr Rodak — Wed, 13 Jan 2010 21:54:00 GMT

I have been working recently on load testing of our ETL. One of the factors that determines amount of transfered data is a lookup table that is joined to the source. I populated this table with aproppriate values, and then realized that I also need some...(read more)

updlock, holdlock and deadlocks

Piotr Rodak — Mon, 04 Jan 2010 22:10:00 GMT

We have a process that manages sliding window over a number of tables in our reporting database. This process is triggered by first call to our reporting ETL. There is table that contains two dates that are important for the partitioning and business...(read more)