IIS HTTP Error 503. The service is unavailable

This error might happen if the application pool for the web site account password is changed and not updated,

Open the IIS Manager

Go to Application Pools

Select the Application Pool related to the website.

Right Click and select Advanced Settings

under Process Model Select Identity

Click on ... button next to the the user name

Click on "Set"

Enter the user name and new password

Click Ok and close the popup windoos

Start the application Pool

Not able to drop sql server database

Error Message:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot drop the database '' because it is being used for replication. (Microsoft SQL Server, Error: 3724)


Resolution:
  Execute the following command then drop the database. 

sp_removedbreplication ''

Improving Sql Server Performance

How to create Missing Indexes based on the DMV values

http://blogs.msdn.com/b/bartd/archive/2007/07/19/are-you-using-sql-s-missing-index-dmvs.aspx

How to Identify missing Indexes based on DMV values

http://msdn.microsoft.com/en-us/magazine/cc135978.aspx

How to know when the database is last restored

 SELECT [rs].[destination_database_name], 
[rs].[restore_date], 
[bs].[backup_start_date], 
[bs].[backup_finish_date], 
[bs].[database_name] as [source_database_name], 
[bmf].[physical_device_name] as [backup_file_used_for_restore]
FROM msdb..restorehistory rs
INNER JOIN msdb..backupset bs
ON [rs].[backup_set_id] = [bs].[backup_set_id]
INNER JOIN msdb..backupmediafamily bmf 
ON [bs].[media_set_id] = [bmf].[media_set_id] 
ORDER BY [rs].[restore_date] DESC
 

Learning resources

C# Fundamentals: Development for Absolute Beginners

 

http://channel9.msdn.com/Series/C-Sharp-Fundamentals-Development-for-Absolute-Beginners 

 

Check the videos in the given order. A good location to start learning C#.Net