Go to Top
  • No products in the cart.

Blog

Find all queries that use a particular table

We just completed a massive 39 database conversion to SQL Server for a client in Tennessee which was quite challenging, we had to not only upsize all the tables, but switch the system from importing/exporting between databases to using linked tables instead. At times we needed to find which queries was using a table, so we used the following code to quickly find a table in all of the queries: …Read More

Insert CreatedBy and CreatedOn in any missing tables

When we design Access with SQL Server solutions we almost always add CreatedBy and CreatedOn to all of our tables, allowing our clients to see who created records in the Access frontend. Script to add CreatedBy and CreatedOn Automatically to tables Many times we inherit SQL databases and we need a quick way to add both fields to all tables in the database. To that end we use the following …Read More

Count all the objects in your database

The other day our company was tasked to convert a lot of Access databases to multiple SQL Server backends. To get a sense for the tasks involved, we needed a way to count all the tables, queries, forms and macros in each database. I did a quick Internet search but did not like any of the code snippets, so I created my own little program that will print out the …Read More

Reporting more granularly than usual

Typically, when we do reporting, we usually do it at a higher granularity. For example, clients commonly wants a monthly report of sales. The database would store the individual sales as a single record, so it’s no problem summing up the figures to the month each. Ditto with year, or even going from a sub-category to category. But suppose they need to go down? More likely, the answer will be …Read More

How to Do Test Cases and Ensure Software Quality

Software quality is an subject that has become more prominent in the software development industry over time because companies have placed more importance on offering quality products to different types of customers in the market. Nowadays software vendors place more attention on software testing and thus invests and puts more effort into planning and test cases. Test cases are nothing more than the individual parts of a test plan designed …Read More

Effective Communication Using FogBugz

Effective communication between team members is of utmost importance when it comes to achieving quality software; however, the quality of the software is almost never perfect. For this reason, it is common for clients to report errors in applications to its suppliers, expose aspects that need improvements or request the addition of new functionalities, which creates a request for the development team responsible for the project. The request is where …Read More