Trim Your SQL DBs Log Remotely

The SQL Log records transaction made into database. These log-entries can be used later to check the actions with database. It also used to ensure database integrity in the event of a system restore, includes but not limited to database queries, updating/insertion/deletion of the records. They are just like a temporary location where SQL Server engine temporary store transactions and at final commits the transaction to the database. To clear the disk space and clean the database log, we need to truncate/trim the database log frequently specially for a very active database. Many times the SQL log file grow very large and consume too much space over server. This might also cause to slow performance of a busy database. Here are steps to trim the SQL log remotely. Learn More
Tags: , , , , , | Posted under Internet | Leave a comment

nopCommerce Tips: How to Remove “Powered by nopCommerce”

The nopCommerce team has put thousands of hours into this flexible, extensible and robust application; feature for feature, it’s the best open-source .Net e-commerce application I’ve ever found. However, it’s not got the same name recognition as some other open-source e-commerce solutions; the way the developers have chosen to overcome this issue is to add “Powered by nopCommerce” as a part of their UI content. They have however, provided a way to remove this for those who wish to keep their branding consistent. We’ll cover how to do that today. Learn More

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

How to Set the Default Page in web.config

On most hosted sites the vendor does not allow you to directly make changes to IIS, instead they normally give you some sort of control panel or user interface to do all that you need. The down side is that you normally have to go to each tab or screen make the change and then wait or restart IIS to see the changes. Although this is fine in most cases there are times when you constantly make the same changes to each site you deploy. Until IIS 7 you were hard pressed to do anything other than contact provider to make the changes for you.

Along came IIS 7 with the distributed configuration options. This allows you to make changes to the server without having permission to directly effect IIS. If you put these settings into a web.config file that runs on something less than IIS 7 the server will ignore these setting so you will be fine. Learn More

Tags: , , , , , , , , | Posted under ASP .NET 3.5, ASP .NET 4.0, cPanel Tutorials, DotNet/Windows Hosting | Leave a comment