If you have worked with MSI then you probably know that it uses an internal database to store all kind of information and you can actually directly modify this information by using a great tool OCRA. It is tiny utility released by MSFT. But unfortunately it is not “that” simple to get OCRA because it
Author: Gaurang
First thing I would like to write is a question .... Why the hack people write their bio in 3rd person ?
I am Gaurang. I work as DBA / DEV for local company in CT. When I am not working, I am either reading other blogs n news OR "researching" / "experimenting" about things that I can do at home / at work OR tinkering with some new hardware/software OR playing games on my desktop.
If you ever wanted to contact me, I can be reached by meATgaurangpatel.net
Remotely execute file on another machine
As usual, I was searching something over internet and going through random crap to look for something (I don’t remember now what was that) and I somehow found that there is really great utility available in good ol’ Sysinternals Suite which literally allows user to remotely execute any application on another machine !! That utility
SVN checkout using BATCH and PowerShell
Few days back I was working on a script to automate project builds. And at one step I was required to checkout code from source control and build the application. Since everything was done using a single script there was no way I could prompt to user GUI because in this case it was just
Use of SYSPREP to duplicate windows image with new SIDs
From past some time I am trying to create windows domain in home computer with bunch of VMs using Windows Server 2008 R2 for “educational” purposes … my ultimate goal was to setup clustered windows system and have SQL Server in that environment. I want to lean about how SQL Server behaves in clustered systems
How to ruin a very good site reputation !
I know that in recent times, I am kind of feeling more sensitive towards users experience in general, weather it is @ customer support for any item or @ email system … or this time @ one of my favorite download site (at least it used to be but not anymore). For years I have
Policy Based Management in SQL Server
This great feature was introduced in SQL Server 2008 and since then it has been considered as one of “standard” method to administer database proactively. As the name suggests, it allows DBAs to create various policies to enforce certain rules to single database, to group of databases or to whole server… for example default database
SQL Saturday # 184
One of my favorite event for which I always had to travel just too far .. either at NY or at MA for past few years … but this year CT is going to have it’s very own SQL Saturday. For anyone who have not heard about this great event then think of it as