sql-connection

Opening the database connection once or on every databaseaction?

Im currently creating a webportal with ASP.NET which relies heavily on database usage. Basically, every (well almost every :P ) GET query from any user will result in a query to the database from the webserver. Now, I'm really new at this, and I'm very concerned about performance. Due to my lack of experience in this area, I don't reall...

What port is a remote SQL Server 2005 running on?

How do I find what port is my remote SQL Server 2005 running on? ...