New 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 […]

Excel VBA to remove duplicates and merge cells

Excel 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 […]

What 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. […]

How 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 […]

Project 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 […]

cyber security advice

CYBER 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 […]

Is 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 […]

Parsing 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 […]

VBA Solutions - webpage scripting msxml

VBA solution: Scraping website information using MSXML, HTMLDocument, and getElementsByClassName

Summary An explanation of how to retrieve/scrape website data using MSXML and HTMLDocument but not using the InternetExplorer Application Object. The problem with the InternetExplorer.Application object I have a few blog entries demonstrating how to get web site data using InternetExplorer and the HTMLDocument object. However, there are a few problems with this: Microsoft is […]