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

Continue reading

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

Continue reading

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

Continue reading
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 […]

Continue reading