Shaun Geisert 
I’m not sure why Microsoft sets “Import Query” as the default when creating new Power BI connections, but the tyranny of the default led me to create charts using that option. Weeks later I realized I didn’t want to manually refresh my reports and sought to switch the query mode to be direct instead. Here’s … Read more
Quick Background Recently I was contacted by a university staff member who needed to access the Gravity Form entries of a specific form on one of our sites. Though this was a trusted user, they worked outside our Division, so I thought the best thing to do was the following (to ensure they could only … Read more
Recently I was asked by a client how she could track which recipients were opening her e-mail messages (without using a read receipt). It turned out to be a pretty easy process, after finding this article: http://dyn.com/blog/tracking-email-opens-via-google-analytics/. As a note of caution, Apple at least offers Mail Privacy Protection which blocks this ability. Anyways, as … Read more
After recently being tasked with moving around 100 sites (some multisite, some not), I thought it worth the effort to create migration scripts. Now, instead of potentially hours worth of work, running these scripts typically takes less than 1 minute. I chose to split the scripts up, one to place on the source server, and … Read more
A Go-Daddy backed security company analyzed over 25k infected websites and 4,426,795 cleaned files to determine that the WordPress content management system accounted for 90% of all hacked websites in 2018 (increasing from 83% in 2017). The top three tactics for attacks included backdoors (68%), malware (56%), and SEO spam (51%).
One of the nice things about WPBakery is that you can easily link to and open a specific tab out of the box. Hopefully Elementor will add this feature in the future, but until they do, here’s some JS code to make it happen, using the tab, toggle, or accordion titles as the anchor links … Read more
Learning about SEO Beginner’s Guide to Search Engine Optimization Ultimate WordPress SEO Guide for Beginners On-Page Search Engine Ranking Factors 15 Ways To Promote Your Site On-Page SEO: The Definitive Guide Tools 30 SEO Tools SEO Optimization with Yoast (if you don’t have Yoast on your site, contact your web developer) Google’s search results are … Read more
In the following tutorial, we’ll be reading a Google Sheet (https://docs.google.com/spreadsheets/d/1-6XeX59-zgqi_z5Bm8dqYyO1z37tfi8Ur7o5mxmmVKo/edit?usp=sharing), porting it into an ASP.NET web site. Create a new Visual Studio ASP.NET C# project (Ctrl + Shift + N) Create a new empty web site Create a new master page, naming it site.master, and a new content page, default.aspx Visit https://developers.google.com/sheets/api/quickstart/dotnet and enable … Read more
MS Access has fallen out of favor many years ago, especially for use on the web, but it’s still being used by offices to capture data internally. When recently asked whether that data could be exposed on a website, I thought I’d put together the following ASP.NET code to be able to do so relatively … Read more
The following PowerShell script sends a text message and e-mail whenever any user RDPs into a Windows machine (obviously you would only want to do this in limited, critical instances). This script is a bit of a work in progress, but got the job done for our purposes. Note, much of this code, and the … Read more