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
Category: Tips
Change default port in Apache
This quick post is about changing default port in Apache. Say if you wanted to work with IIS and Apache both. Now, both web server uses port 80 and so you can’t have both of them at the same time. So one has to sacrifice it’s favorite port . In my case it was Apache
Disable Shutdown Event Tracker
I’ve been using Windows Servers provided by MSFT for free from past few years (not by downloading from Torrent sites by via DreamSpark program) ranging from 2003r2 to the latest one 2008r2. And almost all of them have one feature that really annoys me and that is “Shutdown Event Tracker”. I simply don’t understand that
‘Delete ‘ with Alias in T-SQL
Last week I was working on something where I was required to write a delete query against few records in table. Now a days I am kind of habituated to use alias for tables whenever I write any query (mostly because of tool I am we are using for SQL development, which don’t have intellisence
Installing Silverlight Themes for Expression Blend 4
If you are working with Silverlight and don’t have good “designer’s eye”, or planning to begin new project or simply want to play around with Silverlight then you might want to try these Silverlight navigation themes from Microsoft. Currently there are four standard themes are available for download from MSFT Site JetPack, Accent Color, Windows
Silverlight Tools for Visual Studio 2010 fails to install
Just now due to my “experiments” OS and other stuff, I had to restore system image of my OS installation drive (it is more easy to restore image then formatting drives and reinstalling everything ). But unfortunately the image I took was a bit newer (or say more older) so it had only essential software
Peer Block … sucessor of age old Peer Guardian
If you know what is Peer Guardian, then you are know what I am writing about. Peer Guardian have been used by great number of users in past many years. I think it was the best tool available out there that gives you ability to prevent specific IP or range of IPs from connecting to