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
No Windows Installer Projects in Visual Studio 2012 !!
Recently I had chance to look at Visual Studio 2012 RTM and this came to me as a bit of surprise that newer version of Visual Studio 2012 doesn’t have Windows Installer Project templates ! I mean you can still use Install Shield project templates but no more Windows Installer Project. I am really upset
RAISERROR with TRY … CATCH block
RAISERROR is one of the most efficient method to raise user created exception based on various situations. And TRY CATCH block is perhaps the most known method for exception handling in any programing language. But it is a bit tricky to use both of them together due to manner in which they transfer control to