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 change a foreign key constraint in MySQL
mcgurkadam profile

How to change a foreign key constraint in MySQL

#mysql #database #tutorial #sql
29
Comments 1
3 min read
Intro to SQL for Election Results Analysis
kenhudak519 profile

Intro to SQL for Election Results Analysis

#sql #analytics #beginners #datascience
3
Comments
5 min read
Combining SQL and Astronomy
karenkathryn profile

Combining SQL and Astronomy

#sql #astronomy #blog
4
Comments 5
1 min read
Business logic in Stored Procedures?
eugeneogongo profile

Business logic in Stored Procedures?

#database #sql #data #design
6
Comments 1
2 min read
Insert multiple parents with multiple children in a single stored procedure (SQL Server)
peledzohar profile

Insert multiple parents with multiple children in a single stored procedure (SQL Server)

#sql #database
9
Comments 1
3 min read
How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging
galwaycoder profile

How to Inspect the SQL Generated by Entity Framework Core using .NET Core's built in Logging

#csharp #sql #dotnet #entityframeworkcore
31
Comments 17
2 min read
Azure Functions (Serverless) + Entity Framework Core y SQL Azure
ebarrioscode profile

Azure Functions (Serverless) + Entity Framework Core y SQL Azure

#dotnet #sql #efcore #azure
5
Comments 2
8 min read
entity2sql
antdimot profile

entity2sql

#dotnet #sql #opensource
7
Comments
2 min read
Embedded database vs Client-Server database (on the same host) performance?
patarapolw profile

Embedded database vs Client-Server database (on the same host) performance?

#discuss #sql #database
3
Comments
1 min read
Fuzzy Searching with PostgreSQL
kaleman15 profile

Fuzzy Searching with PostgreSQL

#postgres #database #sql #webdev
80
Comments 4
6 min read
Tips and tricks for SQL Server database (table) design?
katenaylo profile

Tips and tricks for SQL Server database (table) design?

#sql #sqlserver #database #crud
4
Comments 1
3 min read
Data Engineering 101: Automating Your First Data Extract
seattledataguy profile

Data Engineering 101: Automating Your First Data Extract

#sql #python #database
101
Comments
7 min read
Making GraphQL Magic with Sqlmancer 🧙🔮✨
danielrearden profile

Making GraphQL Magic with Sqlmancer 🧙🔮✨

#showdev #graphql #sql #node
9
Comments
6 min read
Basic DB Using SQL Server (Part 7) - Set Operations in SQL
rinsama77 profile

Basic DB Using SQL Server (Part 7) - Set Operations in SQL

#sql
6
Comments
6 min read
Basic DB Using SQL Server (Part 6)
rinsama77 profile

Basic DB Using SQL Server (Part 6)

#database #sql
6
Comments
5 min read
Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!
fullstackchris profile

Introducing the Full Stack Typing Boilerplate: Once You ORM, You Can't Go Back!

#typescript #sql #framework #api
8
Comments 3
13 min read
We used CosmosDB instead of a relational database, here's what we went through and learned.
neil445 profile

We used CosmosDB instead of a relational database, here's what we went through and learned.

#database #nosql #sql
9
Comments 2
4 min read
Dark theme in SQL Server Management Studio
rishabk7 profile

Dark theme in SQL Server Management Studio

#showdev #sql #codenewbie #webdev
11
Comments 1
2 min read
Hacker-rank SQL Median calculation
elitenomad profile

Hacker-rank SQL Median calculation

#sql #beginners
8
Comments
1 min read
Learn SQL Injection by hacking a bank app
duomly profile

Learn SQL Injection by hacking a bank app

#beginners #sql #tutorial #webdev
95
Comments 4
7 min read
My Back-end Adventures - Setting up a local database (Postgres)
qarunqb profile

My Back-end Adventures - Setting up a local database (Postgres)

#node #javascript #sql
9
Comments
4 min read
SQL for dummies
yelmartinezseo profile

SQL for dummies

#sql #beginners #database #mysql
10
Comments
5 min read
My Back-end Adventures - Intro
qarunqb profile

My Back-end Adventures - Intro

#node #javascript #sql
37
Comments 5
2 min read
Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)
yorek profile

Dapper .NET: Custom Type Handling (aka: solve the Impedance Mismatch)

#beginners #csharp #tutorial #sql
10
Comments 2
4 min read
SQL injection for developers
omerxx profile

SQL injection for developers

#devops #security #sql
128
Comments 5
12 min read
loading...