
Tame Beastly Data with Summary Tables
anagers loved Eddie; he always had the answers on-hand. Eddie was a production supervisor in the pre-computer era. He received comprehensive hourly production reports on paper. He also received urgent

anagers loved Eddie; he always had the answers on-hand. Eddie was a production supervisor in the pre-computer era. He received comprehensive hourly production reports on paper. He also received urgent

“Document Your Code! Document Your Code!!” This is one of those lessons hammered into most Computer Science majors about three days into their first code class–and one quickly forgotten by

ADOSPCode is a template driven program for generating VB code from SQL Server stored procedures. With this program you can Open/Edit connection to reach your SQL-Server database and display list

fficient coding practices are hard to develop and even harder to maintain. Most likely, your coding process suffers from one of two problems: Your code throws an exception or otherwise

onsider the scenario in which you are building a Web application that displays events or appointments for different dates. If you want your users to remember this event within their

ecently I encountered a couple of Oracle-tuning projects that required me to evaluate the performance of PL/SQL and SQL code. I had to generate a substantial amount of data from

QL Server provides many sophisticated functions to calculate dates. But knowing how to use them can often be a challenge. Suppose you want to calculate when a package is due

ErrReport provides an easy way to add centralized error reporting capabilities to applications written in Visual Basic. ErrReport has the following features: (a) Thorough diagnostic information. In addition to the

Windows only permits 1024 active bitmap/icon handles to be in use at any time. The UniPicture control provides a method to store data for more than 1024 Bitmaps/Icons without depleting