zlika's

If you use Outlook 2010 and you prefer to have your data files on external hard drive, you have to point your file location as you add your account manually :-)

Read more…

I’ve passed the Exam 70-431: Microsoft® SQL Server™ 2005 – Implementation and Maintenance (Transcript ID: 907652, Access Code: 38959BBD) on May 25, 2010 at Prometric Testing Center in Montreal. What’s next? Microsoft® SQL Server™ + .NET :-)

Félicitations

The difference between WHERE and HAVING filters in Transact-SQL queries is that WHERE clause is a filter of all the data, while HAVING filters the GROUP BY data. I’ve prepared a simple example.

Read more…

John Lennon said:

Life is what happens to you while you’re busy making other plans

on the Beautiful Boy song.

I wrote a schema of my plans and what’s really happening. Now, the scheme, then I’m gonna explain it.

Plans

If you think smart, you’ll be able to walk near the red path. It’s no good when the blue path persists.

In the next month I’ll take a walk on the red curve and in the same time I’am preparing myself for a hard exam.

Why?

Félicitations

The interesting thing about me is… Several days ago I received a letter from Microsoft. They presented me a voucher for an exam. Now I’m preparing myself for this exam. It’s a hard one, but I learn a lot :-)

Yesterday my sister told me that Slash is preparing something interesting… From song to song I reached “Chinese Democracy” by Guns N Roses. The only one thing that binds “Chinese Democracy” and Guns N Roses is Axl Rose. He has worked a lot and the result is… Great! Axl proved that he is a great musician! I will be nice surprised if Slash shows us something so good as “Chinese Democracy”

Félicitations

If you are not capable to hear the fireflies in the night, don’t push ‘play’ :-)

Félicitations

The cursors in MS SQL Server are not the best way to manipulate the data, because they need more recourse. If you can escape the usage of cursors, do it. OK, the cursors give us a flexible way of manipulating the information. You can imagine a bundle of information, that we use for move through other information and modify it using the information of our bundle (puting the information in the WHERE clause).

Read more…

There is an old, old, old bulgarian tradition. On March 1 everybody ties a bracelet, prepared of red and white threads to all the persons he loves. That’s a way to wish good health and to meet the spring. When the guy, to whom the martenica has been tied, sees a stork, he has to replace it of his hand and tie it to a tree – for fruitfulness.

Few days ago I received an invitation to visit the post office. My sister has told me that she has sent me a letter with several martenitsa. I took my letter and today I’m gonna wear one of them. :-)

As a bad painter, I drew one not so beautiful martenitsa for all the people I love. I’m wishing you good health, guys! :-)

One not so beauty martenica for all the people I love :-)

Félicitations

My ex-colleague asked me how to insert query result in a variable for generate report in Microsoft SQL Server. After few explanations I noticed that she has decided to use SSIS (SQL Server Integration Services) to automate. She sent me an example in which she uses YEAR(), MONTH() and DAY() functions.

Read more…

Тo be consumed in August at the time of your vacance

Ingredients
1. Mp3 Player
2. Deep Purple – Slaves and Masters
3. Rainbow – Strangers in Us All

Method
1. Put those two albums in the Mp3 Player
2. Stir them well
3. Find a few good friends to pass together the vacance on the beach. Drink some beers (excluding the driver). Spontaneously after midnight get in the car. You sit back. Start you Mp3 Player. Close your eyes. Go somewhere else.

Félicitations