In the current environment where data is king, making sure that your data is consolidated and validated on a regular basis is an important part of the day, just like that first cup of coffee. Once the consolidation and validation has finished, usually something happens with that data. It could be that reports or spreadsheets are generated, notifications for both valid data and data exceptions are sent out, or employees use the data to continue a business process.

As with anything in IT, there are many ways to do this and most of them would actually work. …


In every office environment there are, what we call ‘swivel chair integrations’. These are the activities that require a user to swivel their chair, or their mind, from one system to another system or application to copy information. Sometimes these activities are batched up into an administrative responsibility, where some lucky person gets to do the swivel chair activity over and over. Other times they are performed “mid-task”, where people engaged in a value-add activity have to pause what they are doing to swivel their chair and grab the required information. Not only is this an interruption in the completion…


When most people hear the term “Large Database” they assume it is an aggregation of mostly static data that is being mined and searched. But, there are also databases full of scientific calculations and rules. These large databases that are used heavily for calculations pose a specific set of challenges when trying to achieve maximum throughput and multiple users. There have been several projects where we have been brought in to assist or evaluate procedural code because the required or expected performance was not being achieved. Most projects wait until the end of the development cycle to do heavy performance…


Every developer that I know hates to test his or her code. We know we are good enough that once the code compiles it has to be correct, right?

Well not so fast…..

What if I could show you a way to improve the quality of your deliverable code and have piece of mind that the code you just wrote or changed did not break other code in the system.

Interested now?

By employing a Test Driven Development (TDD) method to simplify and automate the testing of SQL Procedural code, you can have proven code-quality in both functionality and syntax…

Keith Miller

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store