View source for Developing with MS SQL

==Full Title==
Helpful hints on using MS SQL on a development machine.
==Context==

==Issues==
===SQL Server Express LocalDB===
* [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql-server-2017 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.

==References==

[[Category:Best Practice]]