Category Archives: MSSQL

Setting up Connection String with IIS Manager

On a previous article I discussed how to properly configure the database connection string after deploying the application. However this way required to edit the web.config and sometimes users had issues …

Tags: , , , , , , , , , , , , , , , , , , , , , | Posted under ASP .NET 2, ASP .NET 3.5, DotNet/Windows Hosting, DotNetPanel Administration, MSSQL, Web Deploy, WebsitePanel Tutorials, Windows Server Admin | Leave a comment

Using Excel to Update SQL Data

The other day a co-worker was trying to figure out how to help a client update a lot of individual fields in a SQL table.  He did not want to grant …

Tags: , , , , , , , | Posted under MSSQL, Programming/Coding | Leave a comment

How to Backup All MSSQL Databases on a VPS at Once

Have you ever wondered if you can back up all your databases at once? In this post I will discuss how to do this with one script. A separate file …

Tags: , , , , , , | Posted under MSSQL | Leave a comment