tSQLt - Database Unit Testing for SQL Server
Database Unit Testing for SQL Server
Data Modeling - Relational Databases (SQL) vs Data Lake (File Based) - Confessions of a Data Guy
Data Modeling is a topic that never goes away. Sometimes I do reminisce about the good ol’ days of Kimball-style data models, it was so simple, straightforward, just the same thing for years. Then Big Data happened, Spark happened. Things just changed. There is a lot of new content coming out around Data Lakes and […]
Add or connect a database with WSL
Learn how to set up MySQL MongoDB, PostgreSQL, SQLite, Microsoft SQL Server, or Redis on the Windows Subsystem for Linux.
Databases
How to Create a Handy SQL Server Backup Database Script
Learn how to backup your databases regularly, whether a full or differential backup, by creating handy SQL server database backup scripts in this tutorial!
THE DATA ENGINEERING COOKBOOK
Introduction
Data Engineering Wiki
Obsidian Publish!
The Top 20 Data Engineering Tools Used by Growing Tech Companies
Top 20 Most Commonly Used Data Engineering Tools 2021
What is a (Data) Lakehouse?
Evolution of Data Warehouse Architecture (Pic source: Databricks) With the evolution of scalable cloud technology and exponential growth of digital technologies, the preferred Data Warehouse (DW) a…
Benchmark - top 5 data modeling tools
Find the best data modeling tools available on the market. What they do, and don't do.
ETL Database - a guide to ETL/ELT for data engineers and data analysts
ETL database is an introductory guide to ETL. Learn about ETL process, types of transforms, common ETL challenges, and much more.