SQL Server Recovery Models and Backup Types

This is the fourth of a series of articles discussing backup and recovery for M2M businesses.

Once again, I’m giving you a very high level overview of these concepts and I am not going to cover every option available, only those which are important to companies that use M2M. If you want to dig […]

Compressing and Encrypting Your Backups

In the last article in this series, I discussed the commonly used options for Backup options and stressed that off-site backup were critical for disaster recovery. However, I also pointed out that the size of your backups combined with how many past backups you need to retain can be cost prohibitive. In this article, I’ll […]

M2M Permissions. Please Provide Some Input

In my free time, I’ve been working on the permission problem I wrote about a few weeks ago. I’ve managed to get the permissions to output correctly and created a system to report from them in Integration and Reporting Services (more on that in a later article).

I’d like your input on it before it’s […]

Disaster Recovery Options for Small/Medium Sized Businesses

This is the second of a series of articles, regarding disaster recovery for the small/medium sized businesses which are the typical customers of Made2Manage. All of these articles will be at a high level with links to more in depth articles where you can read about all the gory details.

What are we trying to […]

That's it man, game over man, game over! What the &%$ are we gonna do now?

I regularly receive questions about backup and recovery. A particularly troubling message I received recently prompted me to create the polls on database backup and recovery. I decided to create a short series of articles on disaster recovery for the small/medium sized businesses that typically use Made2Manage. This article is a true story […]

What's in Your Backup?

I’ve been speaking with a fellow M2M Admin and helping him get up to speed. I was shocked when he admitted to me that he had no backups. He explained that they were using Raid 5, and therefore didn’t need any. If you’re in this situation, don’t feel bad. Most of us work for small […]

Profuse Perpetual Pointless Pernicious Permission Problems

I’ve been working with M2M for nearly 12 years, and they’ve made very little progress with permissions. I’ve placed several change requests regarding permissions, which have gone unheeded. Smaller companies with only a few M2M users will probably not relate to some of these issues, but they become major problems when you administer 40+ users […]

M2M Tech Support Gaffes

As a follow up to my last post in which I said that you need to be careful following the free advice given by another customer; you should also be wary of what M2M Tech Support tells you. They can and do make mistakes. I can’t tell you how many times they’ve given […]

Pop Quiz

Dennis Hopper – Speed

You get a frantic phone call at 3am on a Sunday. It’s your boss, and there’s been a fire. The server room, and perhaps the whole building, is still smoldering. He asks you the following questions:

Is our data safe?
Is it off site? Is it […]

Made2Manage Lacks Referential Integrity

I was surprised that some of the software packages I was recently testing for database comparison and writing faster queries failed to work properly with Made2Manage. When I investigated further, I realized why they wouldn’t work. M2M, to the best of my knowledge, completely lacks referential integrity.

What is referential integrity?
Referential integrity is the […]