Developing with MS SQL

Full Title

Helpful hints on using MS SQL on a development machine.

Issues

SQL Server Express LocalDB

• SQL Server Express LocalDB is installed with Visual Studio to make it easier to bring up a test environment without worrying much about the database. It will look like this in the SQL Server Object Explorer tab on Visual Studio
• (localdb)\MSSQLLocalDB(SQL Server...)

Warning, this simple instance may work well with a simple ASP.NET development, but will not work will with more complex configurations. Check the above link for details.

SQL Server Express

On the other hand SQL Server Express is free and has most of the necessary functions for a medium scale deployment and can work well in a development environment.