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
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
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
Importing Fixed Position file into SQL Server
For any DBMS system (I know that it sounds redundant) data can come into variety of forms and formats .. say CSV, XML, another DBMS, tab limited file or fixed position file or any proprietary format (as long as you have data providers for them ). And most of connected DBMS systems have different approaches
Exporting data from SQL Server to Fixed Position Flat file
Just as usual, this post is kind of “Bi-product” of my attempt to create a demo for another post in which I need to use fixed position file. At first I tried to create a fixed position file using BCP. BCP has query out option to export query results into a file, but I was
File Integritry verfication … using File Checksum Integrity Verifier
Lets say you download a file from internet and you want to make sure that this file’s source is legitimate (say you just downloaded new ISO of Ubuntu from their site). Or in another case you want to make sure that there is no corruption in file that you just downloaded from internet (now you
Use of SLL in IIS
I recently got curious about use of SSL in SSRS. I mean I know that it has an option to use secure HTTP but I have never used it. Because in all of the places where I have worked were either not interested in using SSL or just felt that it is too expensive to
What’s the point ?
Like many people, me too don’t like to install stuff in default C: drive. I think that sine C: drive is a system drive it should exclusively used for system files only. And all other programs should be installed in drive other than C:. But you will be surprised to find that there are many