02-AREAS

If you're a Python developer, then you're probably aware that match/case statement got introduc...

The assignment operator - or walrus operator as we all know it - is a feature that's been in Python for a while now (since 3.8), yet it's still ...

Python's list comprehensions (and generators) are an awesome feature that can greatly simplify your code. Most of the time however, we only use them to...

Every Python developer is familiar with the self argument, which is present in every* method declaration of every class. We...

Out-of-the-box, Python standard library ships with many great libraries some of which provide commandline interface (CLI), allowing us to do many cool ...

Python's magic methods - also known as dunder (double underscore) methods - can be used to implement a lot of cool things. Most of the time we u...

Python is known to come with "batteries included", thanks to its very extensive standard library, which includes many modules and functions that...

Beautiful, cross-platform & open-source tools for debugging, testing and building with HTTP(S), on Windows, Linux & Mac.

Automatically generate R package skeletons from application programming interfaces (APIs) that follow the OpenAPI Specification (OAS). The skeletons implement best practices to streamline package development.

I've recently jumped on the Obsidean bandwagon and absolutely love it. Though in time, researching the best way to get the most out of the application, I came across a few other Personal Knowledge...

up:: [[Home]] tags:: #map # LYT Kit MOC This is the "Map of Content" for the LYT Kit. Here you can: - Learn about the LYT Framework. - Learn about how MOCs literally re-write the game. - Create livi…

Johnny.Decimal is a system to organise projects (or your life, or anything else)

Source code used in dbadailystuff.com blog. Contribute to josepmv/dbadailystuff development by creating an account on GitHub.

List all Ole DB Providers in Powershell

This simple VBA function will check the user's registry and return the latest OLE DB provider from a list of supported providers that you can customize.

This simple VBA function will check the user's registry and return the latest ODBC driver from a list of supported drivers that you can customize.

This function will jump-start the process of converting long descriptions into meaningful abbreviations. It's great for creating "Code" columns in lookup tables.

Building Your LibraryThirteen years ago, I chose to maintain a folder of text files rather than a single Access database library. I’ve never once regretted that decision.No Longer SetMike WolfeThe Dependency TrainLet’s torture a train metaphor to illustrate the dangers of dependency chaining.No Longer SetMike WolfeCreating

This simple function overcomes the lack of a hidden attribute editor for PredeclaredId values in the VBA development environment.

Python Enhancement Proposals (PEPs)

None

Tool that draws VBA structure of your MS Excel file.

This quick tutorial will have you writing custom events in VBA in no time.

Move over Rubberduck VBA and MZ-Tools. The next great VBE addin is going to be built with twinBASIC. Here are step-by-step instructions to get you started.

Without the knowledge, it can be challenging to write queries that retrieve the data you need in the format you need. An Excel and ...

In this master guide, you will learn about Openpyxl which is an open-source library that helps Excel automation using python.

Fully illustrated Excel tutorial + 300 examples. 100% free.