All posts by Ray

There is a problem you might encounter when restoring a database which has database users attached to it.  They will lose their mapping to their respective server login, and this … Continue reading Microsoft SQL Server Tips Series: Orphaned Users →

Here’s a message from one of our customers, and I thought it was a great idea: “I have discovered the problem. The database was full. Can I suggest that in … Continue reading Microsoft SQL Server Tips Series: Automatic database quota warning emails →

Here is a very unique error that customers might encounter when restoring their database: “The database principal owns a schema in the database, and cannot be dropped.” And so far, … Continue reading Microsoft SQL Server Tips Series: Database Ownership →

Some of our customers have already been working with Microsoft Office 365, but there hasn’t been an official guide on how to set it up to work at DiscountASP.NET until … Continue reading Configuring Microsoft Office 365 →

Sometimes our users make the mistake of restoring the wrong version of SQL Server to their database add-on.  It’s really an honest mistake to overlook, especially if you’re a developer … Continue reading Microsoft SQL Server Tips Series: Incorrect SQL Version →

I already provided some reasons why you see this error in the Control Panel in a previous blog post: so I won’t bore you with the details again.  Instead, I … Continue reading Microsoft SQL Server Tips Series: Database Size →

In this series of articles I hope to cover some of the common problems our customers face when backing up and restoring a database, centralize the information scattered throughout our … Continue reading Microsoft SQL Server Tips Series: One Data and Log File →