BLOG

Location Services: what this means for improved operations?

What other benefits might there be to these types of technologies? What business operations might you be able to streamline, or what kind of business feedback might you be able to act on with these services?

Read More

How Expert Software Solutions can Empower Your Business

When I broke into this industry so many years ago, I was appalled to learn that – depending on the report one looked at – the failure rates for IT-related projects was somewhere between 65% and 78%. Worse is that these numbers are generally…

read more

How to Parse JSON with VBA (MS Access/Excel)

We work with JSON a fair amount (and honestly I can't say I care for it too much for anything outside of the JavaScript realm), and when it comes to VBA, there's next to no support for it. Tim Hall has a great set of tools in his github repo, one in specific called...

read more

Integrating 3rd Party Services: What to Know Before you Go

Often times when looking into software solutions, we may consider building a complete solution from the ground up versus making use of 3rd party services to cover the basic requirements in conjunction with some possible custom integration(s) between those services....

read more

The Smart Way to Handle your Data Generation Needs

I always hate having to generate test data... even with tools like Red Gate's SQL Data Generator (which I use liberally when I need to do such tasks), there's always a bunch of screwing around that needs to be done to get everything as tied up as neatly as possible,...

read more

Web Work with VBA

It seems like a good portion of the posts zinging my radar over at UA these days are people asking how to deal with a) web service calls in general, and b) JSON.  As usual, I get tired of writing the same replies for generic answers, and wind up writing a blog post....

read more

Keeping Secure Info from Source Control

(more self-reference stuff, notably in visual studio, but the process is similar regardless of platform - this is a various collection of resources not meant to be used all at the same time) Basic steps (not considering more advanced setups such as Azure deployment,...

read more

.NET COM Interop

Mostly as notes to myself, I'm posting my general practices for COM interop. General notes: 1) Create VS Solution with (typically) two or more projects: one for the actual .NET stuff, another to act specifically as the COM interface. Core logic, etc stays in the...

read more

Azure Series: 05 – Database Performance

Database Performance Gaining acceptable performance with client applications against a remote backend involves somewhat of a paradigm shift compared to how we're used to developing desktop applications in local client/server environments. This latest post in the Azure...

read more

Async Processing in Access

I've been wondering for a while how to go about running async tasks within Access.  The lack of multi-threading support has always been something I wished was available, but not until relatively recently when dealing with Azure backend databases...

read more