Category Archives: MSSQL

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

nopCommerce Tips: How to Access Your Live nopCommerce Database

nopCommerce has a very robust and extensive administration panel, but every now and again, you’ll find that data needs to be updated or corrected in a way that’s not supported …

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