Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition

Today I came across an issue with uninstillation of SQL 2008 R2 on my DEV box. It was so hectic and I was too much frustrated (obviously I am not the SQL guy). But finally I got a life saver..an awesome article on by: Aaron Bertrand

Fun with software : uninstalling SQL Server 2008 R2 Evaluation Edition

Copy SQL Server permissions with ease‏

	SQL permissions extractor is Idera’s new, FREE tool that extracts and copies permissions from objects in SQL Server. Copying logins from one server to another or duplicating a login on the same server can be time consuming and a little painful.SQL permissions extractor makes it fast and easy -
	1. Select any SQL Server  2. Select a login  3. Generate a permissions script  4. Edit and apply changes to any selected target
	All from an easy-on-the-eyes graphical interface. Don a pair of dark sunglasses and refer to yourself as “The Extractinator.” The possibilities are endless. GET IT FREE!
	Once you’ve extractinated it, dig into it.SQL secure shows you who has access to what, and how permissions are granted. Identify vulnerabilities and harden security across your SQL Servers. Give it a free go to see how easy managing permissions can be.

The following users do not have email address specified

Problem Description:
Unable to set alert on a List for single or multiple users

Error Message:
The following users do not have email address specified: <Username>

Probable cause:
The user’s profiles are not updated in SharePoint even though everything is setup up correctly in Active Directory and in Exchange.