SQL Server
I was moving a lot of databases from one SQL Server to another, and my applications were giving me errors saying "Login failed for <user>". The user was already in the database with appropriate rights to allowed objects in the database. I tried mapping the user to the database and that's when I got this message: "User Already Exists in the Current Database"... I googled and found this very useful post about orphaned users when moving databases. These are the steps you should take to fix this...
A nice post about handling DateTime fields and indexing. http://itknowledgeexchange.
Microsoft has released a trial version of SQL Azure DB. Get more details here
Again a nice arctile by Don Jones, where he talks about different SQL Server backup options and disaster recovery plans...a good read. SQL Server Disaster Recovery by Don Jones
A good article about types of SQL Server Indexes and how to optimize them when they go bad... Optimizing SQL Server Indexes by Don Jones