Few days back I was working on some task and as a part of that I was required to run some command line utility. Now condition was to keep running that utility all the time and for whatever reasons it crashes it should start by itself. Now, I could do it by creating another application
Logging in SSIS Package
Logging is an essential part of any application. It gives user an insight of application operation. And it proves valuable in event of any issue. Same stands true for SSIS packages as well. Since SSIS package will get executed usually by SQL Server Agent or some Windows Scheduled Task and in both case it is
Self Introduction in 3rd person in BLOG ?? Or it is actually written by another person ??
Just like many people, internet is my another playground (after our backyard ). I use google for many things, for work related stuff, to search cheap deal of computer hardware or just to find some crazy video. And every time I go to some personal blog or site, it always amazes me that why people
Isolation levels in SQL Server … part II
In previous post I explained basics of ISOLATION levels in general. This post is a sort of demo of isolation levels in SQL Server. In SQL Server, Isolation property can be configured using “SET ISOLATION” command. This command can be used to set isolation at any given transaction. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO
Isolation levels in SQL Server … part I
Just like any reliable transaction system, SQL Server supports ACID properties. If you have never heard of ACID properties before than it is actually set of four properties Atomicity, Consistency, Isolation and Durability. These set of properties makes sure that what ever transaction we do in SQL Server (or any DBMS) and database performs consistently
Overclocking my Radeon HD 6770
With my new rig I bought an average graphic card as well. I am not hardcore gamer at all but I do sometimes like to shoot some zombies or build my galactic empire … so I bought this cheap but very nice graphic card from ATI Radeon 6770 HD from Sapphire. And I must say
Resolving … Agent XPs disabled issue in SQL Server 2005
SQL Server sometimes behaves very strangely for no apparent reason. Few days back I was playing with our staging server and I had to stop SQL Server service for some testing purposes. When I started it back, I saw that SQL Server Agent was disabled and next to it a message showing that “Agent XPs