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
And finally it is here !!
Yes, after month of speculations and rumors (and news of fake torrents) finally long awaited Windows 8 is here. Though MSFT has already mentioned somewhere that “Windows 8” is not the final name of OS for now it is known as Windows 8 to all of us. It has been said that it will be
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
SSRS 101: Deploying Reort in BIDS–Part II
Ok, in first part we walked though creating basic report for SSRS using Business Intelligence Development Studio (BIDS),which was kind of an easy process I guess . Next step is every easier, which is deploying that report to report server so others (those who have permission) can access it. For deployment of report you will
SSRS 101: Creating Basic Report in BIDS–Part I
Ok, so after some initial struggling of setting up whole environment for SSRS to work smoothly and after getting some sample data I am finally ready to begin my epic journey to SSRS (it is epic for me because most of the stuff that I am going to learn will be myself and I will
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