zlika's

Today my mother asked me to fix her computer. I started Team Viewer and began to do it. One of the things she wanted me to do is to fix her shortcuts for the online radios. I decided to copy the portable version of Screamer Radio to her computer and in few minutes she had more than 100 radio stations plus some favorites on her desktop.

I copied the portable version to my flash drive and now I have my favorite radio stations whenever I go :-)

Félicitations

Who played the bass on this song? And… how it would sound if McCartney played the bass? :-)

OK, that’s not so important right now. The most important thing is that after one year living in Montreal I start to work. I don’t start to work any job, but I start my job in a SQL development! :-)

I’ll do my best!

Félicitations

The monsters gone,
He’s on the run and your daddy’s here

Félicitations

Almost all the time as I am in front of my computer, there is music playing. It usually passed along my ears. From time to time, a song makes me listen and stop doing what I’m doing. Today this song made me turn up a little the volume of my car radio. :-)

Félicitations

Yesterday I was asked about the way a table is stored in several files in a filegroup.

Read more…

As we can read in Books Online in SQL Server

Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are nondeterministic.

I have created simple example for usage of the Ranking function DENSE_RANK().

Read more…

…but not all the time :-)

Félicitations

Microsoft® SQL Server™ Integration Services is the tool that connects the database to the world and works instead of us. I’ll show you how to extract simple data from the database, store the files in a the file system, rename them, upload them on FTP and report the errors to administrator if any.

Read more…