David Stein

Archives

Trust No One

Something happened at work this week, which put a fine point on the current theme of most of my articles, which is preparedness; being able to recover from a disaster.

I currently support two different business units which use M2M, each separated by approximately 1400 miles. Yesterday morning we started getting reports of computers at [...]

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 [...]