I really love DOS commands. They are so powerful and yet simple (most of the time). Few days back I was required to create a script to download files from FTP site to local folder, and this has to be done at scheduled time. I decided to use my all time favorite script language to […]
Strange installation size of MSFT tools
I always prefer to use C drive only for OS and D drive for other installations. And I did the same thing when I installed Visual Studio on my machine. I installed it on D drive and when I tried to install newly downloaded LightSwitch from DreamSpark, I found that even the install directory is […]
Infinite loop in DOS
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 […]