Few days back I was just goofing about in system I stumbled upon really interesting feature of Windows 7 it is called … “Problem Step Recorder”. I am surprised that MSFT has not given it any short ‘n sweet name but rather strange and mouthful name … But as you can guess from it’s name
Tag: Tips
Infinite loop in DOS
Few days back I was working on some task and as a part of that I was required to run some command line utility. Now condition was to keep running that utility all the time and for whatever reasons it crashes it should start by itself. Now, I could do it by creating another application
“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
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
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
Managing Orphaned database users in SQL Server
It one of the most common issue you will face when you will move/copy your database from one server to another server. You will have all finely setup SQL Server Logins and their related database users but when you copy or move your database those Server Logins will not get transferred automatically. Result is what
Truncate Vs Delete in SQL Server
If you have been looking for job in Database related field then you might be already familiar with this age old question (which I was asked in almost all interviews) is “What is difference between DELETE and TRUNCATE ?” And usually if you read on internet you will see that people answer it with just