In order to check the number of connections currently running on your DB or debug an issue where application not closing SQL connections properly, simply execute the following command.
One of the cool SQL trick to update/delete/insert record is by using the MERGE function in SQL.
I created upgrade script for SQL project and often times, I get the following error:
I have a database project on Visual Studio. When I create an upgrade script. I will need to connect to the database to run the script.
I installed a SQL Express 2012 instance. I can login just fine with windows authentication using SQL Server Management Studio.
