Bytes and Bites of Internet
Archive for September, 2011
Managing Orphaned database users in SQL Server
Sep 26th
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 we call Orphan Users, these database users are there in database but there is no login associated with it. In other words they are just useless and will create various issues related to authorization if an application or users are using it.
There are many cases when you may need to manually map SQL Server Logins with database users. For example it is possible that you have different logins created in SQL Server and you wanted to use these new logins with existing users Or you might even have same logins but since they are on different machines it is very likely that they will have different SIDs (Security Identifiers) Or simply some users has left an organization and you want to assign new user existing login (which I think is more easy by use of ROLES rather than directly assigning a user) Or wanted to have different user name then server login.
For all of these condition there is a system stored proc called “sp_change_users_login“ which can be used to manually assign logins to database users. I have created a simple demo to display the concept and process of mapping existing users to new logins.
Truncate Vs Delete in SQL Server
Sep 17th
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 one line that,
When you use DELETE to delete records, information is stored in transaction log and hence it can be rolled back. And when you use TRUNCATE, no information is stored in log and so you can’t it rollback.
But technically it is wrong. I mean it is true that when you use TRUNCATE it doesn’t gets logged into transaction log, but it simply wrong to say that truncate will not let you rollback your operation. Code below can explain this operation,
And finally it is here !!
Sep 13th
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 finest of windows ever (but I don’t want to hold my breath on it after my experience with Vista 
) but by looking at all snapshots on net and presentation videos I am sure that it will be a bit different.
Since introduction of that tiny square computing machine (ahem …. iPad) the computing trend has sort of shifted towards portable computing devices called Tablets. And this new OS of Windows is said to be designed to specifically for those devices (or devices that supports “Touch”).
I am kind of more interested in laying my hand on Metro UI (famous UI that is being used in newer Windows Phones). I’ve played with it on Windows Phones (I personally like to live free, so I am using Android 
) and I really liked it. The look is really refreshing. And I would like to see how they have implemented navigation of this UI to devices which don’t have touch support (laptops and desktops). And of course built in AV and Hyper-V are also feature that I would like to test.
Change default port in Apache
Sep 8th
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 not because I am MSFT technology user but just because I am working with Apache just as sort of self improvement project and most of the time I will want have to work with IIS. So I need to change default port of Apache listen to some other number then 80, which is very simple process.
All you need to do is to locate “httpd.conf” file and look for section where it mentions about listening port. Something similar below,
SSRS 101: Deploying Reort in BIDS–Part II
Sep 3rd
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 need to know URL for report server. In my case it is “http://localhost/reportserver”.
Settings can be setup for deployment in project property.
 |
1) Property of SSRS Report Project 2) Setup Target Server URL with your report server URL |
