Archives for Software Dev - Page 2
VBA for applications in Excel for Office 365?
Not to worry. VBA is still present in Office 365's version of excel. All you have to do is enable it (enable Developer Tools). Files --> Options --> Customize Ribbon…
UAT and PRODUCTION data – mirrors?
Should UAT data be a copy of production? This isn't a hard NO - but a maybe. Things to consider: How is the The last production database backup restored over…
Calendly Review – after 3 years of paid subscription
Top two concerns with Calendly events - my review after 3 years of use. Concern 1 - Mostly no show registrations There isn't a way to filter out real versus…
Extracting the Private Key and the Cert Bundle from a PFX file
You've been handed a PFX file and asked to get the .key file (the private key) and a new cert bundle (.crt) out of it Step 1 Install OpenSSL on…
WordPress deceptive themes and elementor fraud
Elementor Kits that require Pro Subscription - Won't know till you purchase They will show you amazing live demos of their elements kit. What they will not tell you that…
Crypto Exchange Complaints?
Often, with foreign / Chinese based crypto exchanges, one doesn't really have access to a Better Business Bureau type of complaint channel. I ran into this - and tried Zendesk.…
Using git desktop with VS Code
Git Desktop with Visual Studio Code Step 1. In git desktop, open the url to the git repo. You will need to provide a local folder for git to work.…
HTTP2 advantages
Http had a serious limitation in the number of HTTP connections allowed between a browser and the HTTP Server. HTTP addressed several limitations and also provided enhancements over HTTP HTTP…
SQL Basics
Inner Join (requires a matching criteria) SELECT * FROM A INNER JOIN B ON = Cross Join - No Criteria Required CROSS JOIN operation will return the Cartesian product of the…
Domain Name Registrars
These are some registrars that our company has encountered issues with. Non responsiveness, renewal without prior warnings or notification, inability to transfer out domains. Namecheap Cons - Upcoming Renewals and…