Skip to main content
Advanced Search
Search Terms
Content Type

Exact Matches
Tag Searches
Date Options
Updated after
Updated before
Created after
Created before

Search Results

12 total results found

Analytics

IT/tech tooling for all things related to analytics.

HomeLab

Miscellaneous

DuckDB

The free and open source column based OLAP embedded database.  Single exe with no dependencies and blazing fast.  https://duckdb.org/

Metabase

Powerful open-source BI tool.  Free to use if self-hosted.  

bi
reporting

DBA to Databricks

This book gives the perspective of a (SQL Server) DBA making the transition to databricks.Databricks is a loud based data platform for lakehouse in the big three (Azure, Amazon, GCP).  Based on the open source Delta table format.About me: briandill.com (opens ...

Miscellaneous

Collection of random pages that aren't enough to warrant their own book.

Cookbook Recipes

DuckDB

Glossary

DBA to Databricks

Glossary of Terms associated with databricks ADLS2 - Azure Data Lake Storage Gen2; hierarchical namespace–enabled blob storage used for analytics.autoloader - Databricks feature that incrementally ingests new files from a cloud storage path.autoscaling - auto...

Bookstack code markdown

Miscellaneous

Bookstack Markdown Languages These languages are available to use for bookstack code blocks Language Keyword(s) you can use after ``` SQL sql JavaScript javascript, js, node JSON json HTML html Python python, py ...

Baby Names - SSA database

DuckDB Cookbook Recipes

Social Security Administration's baby names database In this cookbook recipe, you will: Download the full babynames_yob data from the Social Security Administration website.  ingest all the CSV files at once using DuckDB. Create and populate rank and pop...

How To Install DuckDB

DuckDB

Installing DuckDB is fairly quick and easy since it is a single ~30MB file with no dependencies. Installing the command line in Windows The direct download link for x64 and arm64 is on the duckdb.org website Unzip the duckdb.exe file and put it in C:\DuckDB...