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
Removing Favorite, HomeGroup and Libraries from Explorer in Windows 7
I like Windows 7. No doubt that it is better than Windows Vista at few aspects (but still XP was the best , I really miss search of XP). With new UI, Windows 7 has add new options in Windows Explorer like Favorites, HomeGroup and Libraries. But I personally believe that they are just a
Powering on a virtual machine after connecting a USB device fails with the error
I’ve used VMWare now and then for my virtual machines. And I think, it is the best virtualization software out there in market (but not anymore, I like Virtual BOX more than VMWare). When I was trying out VMWare Workstation on my new machine, I found that I was not able to use USB sticks