This was the error that I was getting when i was trying to deploy our database project to one of our test system in a batch script. To me it was a bit surprise because I had done same process many times in past and it has worked just fine. But today I spent hefty
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
The wiser we get ….. an IT example ?
Few days back I changed password of one of my email accounts in Gmail and I got this notification in email. Now funny thing is this email is in same account of which I had changed password !! I can understand the good intensions (!!) of great G but consider a scenario where this account
Creating Application Shortcut in Programs for Windows Installer Project
It has been while since I posted something. Actually I was on very long vacation for almost 2 months and during that time all I did was eating, traveling, sleeping and eating again … and now it is ended and I am back .. I think I have gained few pounds… so (just like every
Database Snapshots … The Good, Bad and Ugly
In SQL Server 2005 MSFT introduced very new feature … Database Snapshots … which is basically a read-only view of database at the time when snapshot was taken. Just as a side note…even at the time this feature was introduced in SQL Server, other age old DBMSes like Oracle and DB2 were already offering similar
Importing Fixed Width file into database using SSIS package
Ok, few weeks back I posted how to create a fixed width file using SSIS for test purposes. Then after that I posted TSQL way to import it into database, and now today I am going to show how to import it using SSIS package… I have used same database (which I used to generate
Advance MSI creation … Part II
In First part of this How To I explained essential component required to manipulate MSI installation process and create funky installation process. In this part I will use that theory of 1st part and create an advance installation process which will do following steps as part of installation process … 1) Install a file at
Advance MSI creation … Part I
Couple of months back I created a post about using Windows Installer Project in VS 2010 and how to create MSI from that. At that time I had very simple requirement to work on, create an installation package that just installs our product … recently that requirement got changed a bit and now I am