DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
The Index You Can Turn Off: MySQL 8 Invisible Indexes
igornosatov_15 profile

The Index You Can Turn Off: MySQL 8 Invisible Indexes

#mysql #sql #webdev
Comments
4 min read
How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?
tbayramov profile

How to implement “CreatedAt” and “UpdatedAt” timestamps in Entity Framework Core?

#csharp #sql #database #dotnet
3
Comments
7 min read
Star Schema vs. Snowflake Schema: When to Use Each
alexmercedcoder profile

Star Schema vs. Snowflake Schema: When to Use Each

#architecture #database #dataengineering #sql
Comments
4 min read
Introducing the (experimental!) Stainless SQL SDK generator
cjav_dev profile

Introducing the (experimental!) Stainless SQL SDK generator

#sql #webdev #openai #database
Comments
6 min read
The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know
datatechbridge profile

The Ultimate Guide to Databricks Data Engineer Associate Exam: Everything You Need to Know

#dataengineering #learning #sql #tutorial
1
Comments
40 min read
COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere
baldwin_apps profile

COALESCE in SQL: the “Don’t Let NULL Win” Function You’ll Use Everywhere

#sql #database #programming #dataengineering
Comments
2 min read
Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”
sonia_bobrik_1939cdddd79d profile

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre
Comments
6 min read
Why SQL Makes You Stand Ahead of Most Candidates
tanushreep profile

Why SQL Makes You Stand Ahead of Most Candidates

#sql #analytics #database #datascience
Comments
2 min read
Part 3: Testing, Documentation & Deployment 🚀
abdelrahman_adnan profile

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial
Comments
5 min read
# Module 4 Summary - Analytics Engineering with dbt
abdelrahman_adnan profile

# Module 4 Summary - Analytics Engineering with dbt

#analytics #dataengineering #sql #tutorial
Comments
2 min read
Part 2: dbt Project Structure & Building Models 📁
abdelrahman_adnan profile

Part 2: dbt Project Structure & Building Models 📁

#data #dataengineering #sql #tutorial
Comments
4 min read
Machine Learning Starts With a WHERE Clause
brittany_37606c0775530a57 profile

Machine Learning Starts With a WHERE Clause

#dataengineering #datascience #machinelearning #sql
1
Comments
2 min read
Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination
sangwoo_rhie profile

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript
Comments
4 min read
Partial Indexes in PostgreSQL
mrpercival profile

Partial Indexes in PostgreSQL

#postgres #webdev #sql #postgressql
Comments
3 min read
Snowflake Data UI Guide - Choose the Right Tool for Every Analytics Use Case
tsubasa_tech profile

Snowflake Data UI Guide - Choose the Right Tool for Every Analytics Use Case

#snowflake #ai #sql #python
1
Comments
16 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.