Using Insert, Update, “Upsert”, and Merge to Manipulate FastForms Fields.

Yesterday I explained the basics of how FastForms deals with SQL Server. Today I’ll discuss the skills they don’t teach you in M2M classes; how to manipulate SQL directly and save your company thousands in manual data entry.

How do I automatically populate my extension table?

Continuing our hypothetical situation from yesterday, our employees at Acme Inc. […]

The T-SQL Implications with FastForms Customizations

In this article I’ll focus on the T-SQL component of a successful FastForms customization involving extension tables. I tend to demonstrate things in very small steps, and often work that way as well. This would be a good time to repeat my standard disclaimer:

Important: All information on this site is provided “as is” for […]

Can You Farm?

”As a comedian, I always get into situations where I’m auditioning for movies and sitcoms, you know? As a comedian, they want you to do other things besides comedy. They say “alright you’re a comedian, can you write? Write us a script. Act in this sitcom.” They want me to do shit that’s related to […]

BI Ethics

The ethics of business intelligence is a touchy subject that many people don’t want to talk about. However, more attention in the past several years has been given to this subject mostly due to ethics scandals at huge companies such as Enron, Tyco, and WorldCom. The Sarbanes-Oxley Act came about because of such […]

Amazed by the Wrong Things

I love this chart, which I borrowed (stole) from Coding Horror. A major project that I completed recently reminded me of it. I created a sales order auditing system that included scheduled SQL jobs, multiple triggers, VBA for M2M, and Crystal Reports. The project took me a long time to complete and […]

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: Report Approval and Deployment

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

Create and follow standard procedures for report deployment. The actual procedure depends greatly on the report method. Since I often use Crystal Reports Server and SQL Reporting Services (SSRS) for my report presentation, I have a Testing folder where all finished reports go prior to […]

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