This collection of articles explores topics such as securing services, improving workflows, and enhancing data analysis. It also delves into useful tools, software updates, and practical tips for better efficiency.
Ensuring Updated Files in Power Query Without Cache Conflicts
Learn how to bypass browser and server caching when fetching files in Power Query.
Two Handy Power Query Tricks for Custom Sorting and Error Handling
Learn the two advanced Power Query tricks: custom sorting using List.PositionOf to arrange categories in a specific order and an error-handling method to filter out non-date values.
Power Query Function to Find the Next Banking Day
Learn how to create a Power Query function that calculates the next available banking day by skipping weekends and holidays. This function is useful for financial reports, payment processing, and business workflows that require accurate working day calculations.
Python vs Power Query: Understanding Lists and Dictionaries/Records
Comparing the list and dictionary concepts in Python with the list and record concepts in Power Query, exploring how data structures are represented in both languages.
RTM vs. Todoist: A Free User's Perspective
A comparison of the free versions of Remember The Milk (RTM) and Todoist, highlighting their features, limitations, and usability for task management enthusiasts.
Additional Documentation for Hugo PaperMod Post Cover Image
Learn how to correctly configure a cover image in Hugo PaperMod when using page bundles, including handling relative paths to avoid 404 errors.
Hugo Automated Install and Update
This script automates the installation and update of Hugo Extended from GitHub, eliminating the need for manual downloads and ensuring you’re always running the latest version on Linux systems.
The True Cost of Cheap VPS
Opting for an affordable VPS provider may save you money, but it often comes with the frustration of managing cumbersome migrations, manual backups, and DNS changes—responsibilities that should be handled by the provider.
Linkding vs. Hoarder
A comparison of 2 bookmarking tools, focusing on their features, customization options, resource usage, and overall usability. Check out the highlights what makes each tool stand out.
Tailscale Accept DNS Settings
Learn how to disable Tailscale’s DNS settings on Linux and revert to local DNS configurations using a simple command.