Using User Defined Functions to Pre-Format Fields

Some DBAs would cringe at what I’m about to tell you, but I often use T-SQL to format my data prior to presenting it in a report. Many experts feel that data formatting should always be done in the presentation layer. There are a couple of reasons why I do this.

I re-use as much code […]

Top Ten Sessions for M2M Administrators at the 24 Hours of Pass

If you are a M2M Administrator, you should be studying SQL Server. I encourage anyone who works with M2M to study the SQL programming language, how SQL Server works, advanced reporting techniques, etc. In my opinion, if you don’t have at least a basic understanding of all things SQL, you cannot effectively administer M2M. […]

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

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

Removing Null Country Values From the Syaddr Table

Unfortunately M2M does not automatically populate the Country field on many screens when a US State is selected. This can cause problems in reporting when an executive wants sales broken down by country and many of them are grouped under Null.

Anyway, if you want to see how many addresses are missing “United States” you […]

Let’s Play the Orphaned Records Game

In the past couple of weeks, I have discussed the problems of orphaned records in the M2M Database and promised to provide a script to find them. So, I’ve decided to turn it into a game.

If you’d like to play, paste the following script into your Query Analyzer or SQL Server Management Studio and […]

More Data Corruption Problems with M2M. Orphan Quote Records

Brief Summary – M2M orphans records in the Quote Master and Quote Items tables when the quotes are in the Cancelled status.

As I mentioned last week, I came across a problem with orphaned records in my addressing tables. Rather than address my orphaned record problems piecemeal, I decided to create a script to check […]

Orphaned Records and Technical Hypochondria

I found more orphaned records recently when querying a M2M table with an order by clause. Once again, this occurs because in my opinion the M2M database is not properly designed. Here’s a quick walk-through on how I found it. Incidentally, the screen shots are from TOAD using M2M’s practice database.

A manager tasked me with […]

Using User Defined Functions to Suppress "Blank" Dates

As long as I have been working with the M2M Database I had always wondered one thing. Why on earth does M2M use 1/1/1900 dates? It’s fairly obvious that it was an artificial date when one wasn’t applicable, but why? Why not just allow your date fields to be null and be done with it?

For […]