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.
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 2: dbt Project Structure & Building Models 📁
abdelrahman_adnan profile

Part 2: dbt Project Structure & Building Models 📁

#data #dataengineering #sql #tutorial
Comments
4 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
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
What happens when SQL Server PAGE gets corrupted ?
abeamar profile

What happens when SQL Server PAGE gets corrupted ?

#database #sql #tutorial #learning
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.