Noshin Nawar NehainLearning DataAn Exploratory Data Analysis using MySQL to find the perfect AirbnbFinding the perfect Airbnb that suits your budget and preferences.7h ago
Laurin HeilmeyerinTowards Data ScienceDenormalisation: Thoughtful Optimisation or Irrational Avant-Garde?Perspective on Performance Optimisation and Data Quality5d ago5
Matt BentleyHow We Doubled the Performance of Our App When Using GUID/UUID Primary Keys in SQLA walkthrough of performance considerations when using GUID/UUIDs for database Primary Keys, including code optimizations and benchmarks.Aug 811Aug 811
Kevin SeelyQuick & Easy Snowflake .csv to table in less than 15 lines of SQLUse SnowSQL or Snowsight to load .csv files using system-defined functions in 3 quick & easy steps1d ago1d ago
Leo GodininData Engineer ThingsNo, Data Engineers Don’t NEED dbt.But It Sure Does Solve a Lot of ProblemsJul 199Jul 199
Noshin Nawar NehainLearning DataAn Exploratory Data Analysis using MySQL to find the perfect AirbnbFinding the perfect Airbnb that suits your budget and preferences.7h ago
Laurin HeilmeyerinTowards Data ScienceDenormalisation: Thoughtful Optimisation or Irrational Avant-Garde?Perspective on Performance Optimisation and Data Quality5d ago5
Matt BentleyHow We Doubled the Performance of Our App When Using GUID/UUID Primary Keys in SQLA walkthrough of performance considerations when using GUID/UUIDs for database Primary Keys, including code optimizations and benchmarks.Aug 811
Kevin SeelyQuick & Easy Snowflake .csv to table in less than 15 lines of SQLUse SnowSQL or Snowsight to load .csv files using system-defined functions in 3 quick & easy steps1d ago
Leo GodininData Engineer ThingsNo, Data Engineers Don’t NEED dbt.But It Sure Does Solve a Lot of ProblemsJul 199
Vishal BarvaliyainData EngineerCount(*) vs Count(1) in SQL.If you’ve spent any time writing SQL queries, you’ve probably seen both `COUNT(*)` and `COUNT(1)` used to count rows in a table. But what’s…Mar 929
Vishal BarvaliyaCHAR vs VARCHAR in SQLWhen working with SQL, especially when designing databases, one of the most common decisions you'll face is whether to use CHAR or VARCHAR…7h ago
Laurin HeilmeyerinTowards Data ScienceExploring the Right Fit: Choosing Primary Keys for Your DatabaseA practical example of navigating key selection trade-offs in a real-world scenarioJul 166