I haven't posted anything for awhile due to being busy with my ecommerce project. Recently, I have just started to deploy the project up onto Windows Azure for testing. I had held back deploying until I could deploy on SQL Azure more easily. Previously, you could only execute commands to SQL Azure via a query window and you had to create tables manually via a new query. The good news is, there's ... [More]

To be able to do the above you will need to install SQL Server Management Studio Express or SQL Server Management Studio (the not so free version), SSMS. The following describes the steps necessary to execute a script called createDatabaseAndTablesTest.sql:  Connect to the SQL Express Server from SSMS. Usually the SQL Express Server is located at <COMPUTERNAME>/Express. Attach the *.mdf... [More]