SQL create index

CREATE CLUSTERED INDEX [IX_DT]
ON [Historical] ( [dt] DESC )

northwind sql sample database install for SQL express 2012

http://businessimpactinc.com/install-northwind-database/

udl file for testing database connection string

http://johnnycoder.com/blog/2010/06/12/database-connectivity-test-with-udl-file/

Create a new file and name it anything as long as it has the .udl extension. Open the file, choose a provider:

ASP.NET web.config SQL connection string for local

Install SQL express on local, then change connection string below, so when you register a user. it is same.

You can import from Azure sql db to local sql server (after you migrate the localdb to Azure SQL server) 

<connectionStrings>

   <add name="DefaultConnection" connectionString="Data Source=(local);Initial Catalog=RegMSW_db;Persist Security Info=True;User ID=xx;Password=xxxxx" providerName="System.Data.SqlClient" />

 </connectionStrings>