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
Author: Gaurang
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
Using configuration file for SSIS package
SQL Server Integration Services (SSIS) are really nice ELT tool for data transformation, conversion and transfer. But they not of much use if they can’t be configured to accept different parameters. For example, a once task to move file is designed if it can’t be used to look for file in different folder or FTP
Setting up personal Source Control Server using Visual SVN Server
I was working on one of my personal projects and I thought that it would be really cool if I have my own source control mechanism so I can always rollback to older versions if I ever need to do it. Till now, I was always just keep multiple copies of each project so if
“EXECUTE AS” clause in T-SQL
In T-SQL there is really interesting clause available which allows DB engine to execute some particular module (function, SP, trigger etc) with context to some user. This clause is very handy when we don’t want some specific user to have access to some schema but we still want that user to allow access to data
Becoming administrator of my own machine !!
I know, it sounds strange. But it is fact that when we install Windows 7 or Vista (say any non-server post XP OS ?), and even if select ourselves as local administrator we actually don’t become administrator !! And due to that even if you disable that notorious UAC notifications you will still sometimes need
High Availability in ASP.NET application
From Wikipedia, High availability is a system design approach and associated service implementation that ensures a prearranged level of operational performance will be met during a contractual measurement period. And it could include multiple database and application server connected in a clustered environment with redundant hardware. One of the method to make ASP.NET application available