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.
A Quick Review of SQL Window Functions with Examples
luca1iu profile

A Quick Review of SQL Window Functions with Examples

#sql #database #tutorial #beginners
24
Comments 6
4 min read
Semantic search with Azure MS SQL and EF Core
chsami profile

Semantic search with Azure MS SQL and EF Core

#azure #vectordatabase #sql #efcore
Comments 1
2 min read
How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL
tigerdata_dev profile

How to Build an IoT Pipeline for Real-Time Analytics in PostgreSQL

#postgres #dataanalysis #datavisualization #sql
Comments
16 min read
Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables
seanmdrew profile

Efficient Temporary Storage in SQL: Ditching Cursors for Table Variables

#sql #sqlserver
Comments
3 min read
From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers
seanmdrew profile

From Chaos to Clarity: A Journey Through Random SQL Code: Practical Examples for Developers

#sql #sqlserver
Comments
14 min read
Crossing the Line before the Finish Line. Also the line before that.
gitmcmillan profile

Crossing the Line before the Finish Line. Also the line before that.

#python #flask #backenddevelopment #sql
Comments
2 min read
One-to-Many and Many-to-Many Relationships in Python with SQLite
kelseyroche profile

One-to-Many and Many-to-Many Relationships in Python with SQLite

#python #sql #beginners #backend
Comments
3 min read
Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️
op3ratordec profile

Database Tools 🛢️🔧 in 2024: A Year in Review 🗓️

#database #tooling #productivity #sql
106
Comments 4
3 min read
Optimizing Performance using Efficient LINQ queries
devesh_omar_b599bc4be3ee7 profile

Optimizing Performance using Efficient LINQ queries

#dotnet #api #performance #sql
2
Comments
2 min read
Choosing the Right Database: A Simplified Guide
mohammad-reza-mahdiani profile

Choosing the Right Database: A Simplified Guide

#database #sql #nosql #mongodb
7
Comments
4 min read
PostgreSQL table partitioning
ashish15 profile

PostgreSQL table partitioning

#postgres #sql #tutorial #softwaredevelopment
Comments
7 min read
Practice SQL using Cricket Dataset (Moneybowl)
il3ven profile

Practice SQL using Cricket Dataset (Moneybowl)

#showdev #sql
2
Comments 3
1 min read
Understanding the Differences Between NoSQL and SQL Databases
574n13y profile

Understanding the Differences Between NoSQL and SQL Databases

#nosql #sql #database #devops
1
Comments 1
2 min read
Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server
seanmdrew profile

Understanding SQL Transactions: Implicit vs Explicit and the nuances of transaction management in SQL Server

#sql #sqlserver
2
Comments
5 min read
MySQL vs SQLite أيهما أفضل ؟
saad711t profile

MySQL vs SQLite أيهما أفضل ؟

#sql #mysql #sqlite #database
3
Comments 2
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.