This blog will no longer be updated.

New content is available on my new blog

t-sql - Piotr Rodak

Browse by Tags

All Tags » t-sql (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: , , , , , , , ,
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: , , , , , ,
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: , , , , , ,
27 January 2010 22:33

relative query cost not accurate when using set rowcount

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...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , , , ,
13 January 2010 21:54

updating column with a random value

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...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , ,
04 January 2010 22:10

updlock, holdlock and deadlocks

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...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , , , ,
22 November 2009 22:02

DATA ACCESS setting on local server

When you look at the sys.servers catalog view, you will see list of linked servers defined on the server plus one additional row for the server itself. You can distinguish the local server from linked servers by column server_id, which in case of local...
Posted by Piotr Rodak | 4 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: , , , , ,
10 October 2009 22:45

DISABLE TRIGGER not captured, SSIS

This post was to be about behavior of SSIS when they insert rows to tables with triggers on them. We had an issue with one of our packs that began to fail 'all of a sudden'. But when I began writing this post and building test SSIS project and...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , , , , ,
More Posts Next page »