Archives

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

Running Twice as Fast

This past Saturday I attended the first of four days of SQL Server Development Training. The instructor, Mike Hotek literally wrote the book on SQL 2008 Database Development. A fellow M2M Administrator asked me why I bothered because we are not yet on SQL 2008 and I thought it would make a good blog post. […]

Report Guidelines: Exporting Reports

This article is day four in a week of reporting articles.

Most users want to export reports to Excel so they can manipulate the data. If possible, set up the report for the cleanest exporting possible. This process starts when writing T-SQL. For example, one can extract only the date instead of a datetime value when […]

Report Guidelines: Know What Your User Wants and Your Target Number(s)

This article is day three in a week of reporting articles.

This seems like a no-brainer, but it is not as easy as you would think. Often your users will not know what they want and certainly not where to get it.

Don’t take direction from this guy.

Let’s say Milton, a purchasing […]

Reporting Guidelines: Standardize Your Layouts

This article is day two in a week of reporting articles.

Create standard layouts for both landscape and portrait reports and have them approved by management. Many larger companies have Corporate Identity Guidelines created by marketing experts with standards already defined for marketing and sales documents. Adhere to the standards religiously. If creating your […]

Never Underestimate Your User. Expect the Unexpected.

Never underestimate your opponent. Expect the unexpected.

Earlier this week, I was reminded of this post from some time ago. Yes I know I’ve already used that picture, but you can ever have enough Swayze. The company in question uses a 4-4-5 Calendar for accounting and this makes reporting more difficult. For […]

Why Doesn’t T-SQL Have a Date Conversion or a AllTrim() Function?

In all versions before 2008, SQL Server only supported a DateTime data type, not separate Date or Time types. Therefore, every date field in M2M is actually DateTime, and this can be inconvenient for reporting. Your CEO typically doesn’t care what time an invoice was processed, only which day. Therefore, one typically uses one of […]

Who Wrote This Crap?

“Did you ever notice that other peoples stuff is crap, but your crap is Stuff?” George Carlin

Last year I came across an article with the same title on Jeff Atwood’s “The Coding Horror.”

Whether I am looking at Made2Manage or another vendor’s code or code created by a […]

Solution to Encyclopedia Brown and the Case of the Data Corruption

This is a continuation from this previous post.

“It’s simple,” Encyclopedia said. “First I ran the following query against our database.”

SELECT SOM.fshipvia
FROM somast SOM
WHERE SOM.fsono = ‘123456’

“The value returned was UGB, which is the actual value for UPS Ground Bill in our database. So, I knew that the Ship Via […]

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