Workflow automation solutions. Document assembly (contracts, reports, proposal systems, letters, emails) – all driven by your data. We’ve built solutions for insurance, legal, manufacturing, and entertainment.
Continue readingDatabase & Application Development
We build custom applications and databases. Mobile, Web, and Desktop. Providing solutions that connect your team, your customers, your partners, and more to your business.
Continue readingData Analytics and Digital Dashboards
Your data means something. We help it speak to you. Better business intelligence, decision support, exception reporting, and visibility to the challenges, and more importantly, the opportunities your data is telling you about.
Continue readingUsing SQL Server Express for Your Microsoft Access Projects
Summary: Some of the reasons why you should use SQL Server (or SQL Server Express) to store data for your Microsoft Access projects. Plus, code to simplify connecting to SQL Server and attaching tables without manual linking. The Access DB is miserable but awesome! Can we be honest. It’s slow, clumsy to move around, inherently […]
Continue readingMS Access – Passing a Variable and Unknown Number of Parameters to SQL Server
Summary How to avoid VBA errors with single quotes in a string being passed to a SQL Insert or Update Error. Includes how to passing parameters for an unknown or variable number of variables. Technologies Microsoft Access, SQL Server, ADO Something funny I hadn’t used this in a few years. When I ran across the […]
Continue readingHow to Create a Default Website Image for Facebook Sharing Using Google Drawings
Whew!!! Long title. I published a simple tutorial on how to create the image below with the text overlay and semi-transparent background. Google Drawings is a FREE app that comes as part of your Gmail address or with your GSuite subscription. Benefits FREE! Cloud-based: any computer, any location, no software to install Allows collaboration: Team […]
Continue readingUsing Excel VBA to Automate SQL Server Data Migration
Data Migration Sucess Some simple concepts to help you with more successful conversion and migration projects. Front-load the Automation Automation requires more work at the start – on the front-end of a project. Create simple data connection and output tools immediately. Doing so will give your team the confidence to defer to the automation tool […]
Continue readingNew Prospecting and Sales Call Software – Hyper Call Q
Los Angeles, CA – Pulse Infomatics Streamlines the Sales Call and Prospecting Process Pulse Infomatics is preparing to release it’s flagship Sales Prospecting and Call Center software, Hyper Call Q, for limited custom release in January 2017. Hyper Call Q provides a simplified, single-screen and push-button actions, for almost all call resolutions. Additionally, sales reps […]
Continue readingEmbedding Google Forms on WordPress
If you run a wordpress site and want to include simple poll questions or other specialized input forms on your pages or blog posts, consider the Google Forms plug-in from Mike Walsh. I’ve used it for years and it combines the power of Google Forms with WordPress. In your WordPress console, add & activate the […]
Continue readingExcel Automation for Data Analysts
Should you learn VBA? Note: A very simple sample file and code can be downloaded just above the video. A lot of “real” programmers dismiss VBA and Visual-basic in general. This is short-sighted for a number of reasons. Building solutions should be about effective solutions, not a myopic focus on the “most powerful tool.” When […]
Continue readingWhat is server virtualization and why do you care?
Let’s start with the, “Why do you care?” question. Short answer: You don’t! You’re a business owner or manager, not a computer tech/system engineer. But… you might care, if you knew a little bit about it. And by that I mean, knowing what it is and more importantly, how it benefits the business using it. […]
Continue readingHow to migrate SQL Server instances with permissions to a new server
We recently virtualized a client’s server environment. We’ll write more about virtualization, general concepts, at a later date. As part of that, we had to migrate 3 SQL Server instances to a new server. This was made significantly simpler with a Powershell Script. DBATools – Powershell Scripts to Migrate SQL Instances Download and install the […]
Continue readingProject and Collaboration Tools rundown – G Suite, Asana, Glip, Slack, and more
A friend and business coach, Bill Hart, asked the following question on Facebook: “Q: how do you manage your calendar, tasks and projects?“ In the future I’ll write a bit more about how your responses to online questions or emails you send can be turned into content for your social media. This is one of […]
Continue readingCYBER SECURITY BASICS – aka: The advice I know you’ll ignore
Summary: I provide a summary of some things you SHOULD do to improve your digital security. I then explain each in a little detail. Then, I admit that most people will ignore the advice. But.. here you go. We want security but not really Most people freak out about things like Facebook privacy settings and […]
Continue readingIs your SAGE 50 Accounting too slow? Virtualization and Terminal Server
Technologies Sage 50 Accounting 2017 & 2018 Windows 2016 Hyper-V Windows 2016 Remote Desktop Server (Terminal Server) Dell Poweredge T330 Server Sage 50 Performance Sage has performance issues going back to its Peachtree roots. It is inefficient on a network and has poor utilities for purging and compressing data. My client was at their wits […]
Continue readingParsing Quickbooks Customer (CustomerRet) Response using XML (DOMDocument)
As I indicated in my Quicbbooks Part 1 of never post, I would post some Microsoft Access and other Quickbooks source code and blog entries, rather than do a more detailed step by step explanation. I hope this is helpful. Quick Explanation You can parse Quickbooks response using a ICustomerRetList – and I may post that […]
Continue reading