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
Month: September 2011
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