Piotr Rodak

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)

Happy New Year

Piotr Rodak — Wed, 30 Dec 2009 23:49:00 GMT

Well, this is my last post this year - I know, there weren't too many of them anyway, but I plan to improve my frequency, promise . I have a few days off and all of a sudden I got a flu or cold, felt pretty rubbish two days ago. I spent all day in...(read more)

Default value or value provided for the report parameter .. is not a valid value

Piotr Rodak — Tue, 15 Dec 2009 22:36:00 GMT

I've been working on a report for last few days. It worked fine on my visual Studio and when it was ready, I decided to deploy it to our application server which runs Report Server 2005. To my disappointment, the report didn't want to work after...(read more)

DATA ACCESS setting on local server

Piotr Rodak — Sun, 22 Nov 2009 22:02:00 GMT

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

Makesafe script - set up security for developers

Piotr Rodak — Sat, 24 Oct 2009 12:35:00 GMT

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

DISABLE TRIGGER not captured, SSIS

Piotr Rodak — Sat, 10 Oct 2009 21:45:00 GMT

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

on update cascade...

Piotr Rodak — Thu, 24 Sep 2009 21:12:00 GMT

When you define a foreign key constraint, you can also decide what SQL Server should do when primary key to which the constraint references to gets deleted or updated. While I always knew and imagined that ON DELETE CASCADE may be useful, I wondered,...(read more)

Sql release builder

Piotr Rodak — Sun, 19 Jul 2009 23:13:00 GMT

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

ETL performance test - parallel package execution

Piotr Rodak — Fri, 12 Jun 2009 23:38:00 GMT

I was recently busy with testing performance of our ETL process. Each day we process a number of independent feeds, which will increase in the future. These feeds contain usually similar number of rows. At present we have over 100 hundred feeds that are...(read more)