See Wiki Index for more on Install and UI details. App using TreeView Control that Reads/Saves as a Table/Dictionary via MessagePack to and from a file. This app is a port of DBWorkshop a code ...

A few years ago a new pair of Profiler events was added for Power BI Import mode datasets (and indeed AAS models): the Job Graph events. I blogged about them here but they never got used by anyone ...

In my recent article I've reported about a nice free alternative to manage SQL databases, which, from the same UI can manage also MySQL databases. I thought that it might be a good idea to actually ...

A tool which treats CSV and JSON files as SQL tables, performs SQL SELECT queries on them, and stores the result into CSV and JSON files. Many tools and systems can export their data to CSV. Typical ...

Azure Data Studio is a new cross-platform desktop environment for data professionals using the family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Previously released under ...

A very common scenario for SQL Server users is that they simply want to take a .txt or .csv file and import it to their SQL database as a table. As much as we love the ever reliable Import and Export ...

In my last two articles, I looked at the Django Web application framework, written in Python. Django's documentation describes it as an MTV framework, in which the acronym stands for model, template ...

With most Excel spreadsheets, you enter data manually into cells and then use formulas or other functions to analyze it or perform calculations. If you have a large data source, such as an Access ...