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.
Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI
danielfavour profile

Connecting an App Service to Azure SQL Database and Storage Account using Azure CLI

#azure #sql #storage
21
Comments
12 min read
Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!
findlyai profile

Thrilled to share with you all our AI Chatbot tool for data warehouses: Findly.ai!

#saas #ai #sql
2
Comments
1 min read
Unwrap Oracle Home .plb
franckpachot profile

Unwrap Oracle Home .plb

#oracle #troubleshooting #sql #database
17
Comments
2 min read
Handling NULL in the DBs
irinabezgina profile

Handling NULL in the DBs

#database #dataengineering #sql
5
Comments 1
2 min read
Use Chance.js and Fony.js in your SQL queries😎
loiclefevre profile

Use Chance.js and Fony.js in your SQL queries😎

#javascript #backend #database #sql
Comments
20 min read
Learning SQL? Here's a grab bag of links.
virtualandy profile

Learning SQL? Here's a grab bag of links.

#sql #postgres #mysql #postgressql
3
Comments 5
3 min read
“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures
franckpachot profile

“Multi-AZ” in Amazon RDS and how it may differ from High Availability or resilience to failures

#sql #database #resilience #availability
18
Comments
12 min read
How to Deploy and configure servers and database for Azure SQL
sipsdaoracle profile

How to Deploy and configure servers and database for Azure SQL

#cloudcomputing #sql #database #azuresql
2
Comments
4 min read
Comand Line Tools to Export SQL Server Query to CSV
jfraziz profile

Comand Line Tools to Export SQL Server Query to CSV

#sql #database #productivity #tooling
7
Comments
5 min read
The power of MERGE in PostgreSQL 15
rozhnev profile

The power of MERGE in PostgreSQL 15

#sql #postgres #tutorial
Comments
3 min read
BigQuery deduplication strategies
sagnikbanerjeesb profile

BigQuery deduplication strategies

#bigquery #sql #googlecloud #data
4
Comments
5 min read
Understanding SQL Joins: A Beginner's Guide
katerinamykhailyk profile

Understanding SQL Joins: A Beginner's Guide

#sql #beginners #database #programming
Comments
5 min read
A Simple Guide to Graph Databases for Beginners.
chidera profile

A Simple Guide to Graph Databases for Beginners.

#apacheage #postgres #sql
4
Comments
2 min read
Creating a database with Azure SQL database.
keneojiteli profile

Creating a database with Azure SQL database.

#azure #sql #learning #cloud
2
Comments
2 min read
TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable
franckpachot profile

TiDB: Distributed MySQL with Foreign Key (not production ready) and not Serializable

#distributed #sql #database #tidb
Comments
5 min read
🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀
franckpachot profile

🦦 What OtterTune hates the most in PostgreSQL🐘 is solved in YugabyteDB🚀

#postgres #yugabytedb #distributed #sql
9
Comments
10 min read
Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries
m4rcxs profile

Cypher: How to Determine Degree Centrality and Rank Nodes by Influence Using Cypher Queries

#apacheage #postgres #sql
3
Comments
2 min read
How ACID is Citus? (compared to YugabyteDB)
franckpachot profile

How ACID is Citus? (compared to YugabyteDB)

#distributed #sql #database #yugabytedb
8
Comments 3
4 min read
From Zero to Database Hero: A Beginner's Journey into SQL
jr_shittu profile

From Zero to Database Hero: A Beginner's Journey into SQL

#sql #database #beginners #datascience
Comments
5 min read
Tutorial for Middle/Senior Level Developer: General Query Solution
intersystemsdev profile

Tutorial for Middle/Senior Level Developer: General Query Solution

#tutorial #programming #sql
Comments
19 min read
Using KNN Algorithm for Player Matching in Online Games
fabianosalles profile

Using KNN Algorithm for Player Matching in Online Games

#machinelearning #tutorial #sql #gamedev
1
Comments
4 min read
The old MySQL bug (detective story)
rozhnev profile

The old MySQL bug (detective story)

#sql #mysql #bug
1
Comments 1
2 min read
When To Use SQL vs NoSQL: An Expert Guide to Databases
domfive profile

When To Use SQL vs NoSQL: An Expert Guide to Databases

#sql #database #datascience
2
Comments
11 min read
AI tool to automatically write, optimize, edit, and debug SQL
getlogicloop profile

AI tool to automatically write, optimize, edit, and debug SQL

#sql #ai #datascience #database
10
Comments
2 min read
pl/sql tutorial for beginners
realnamehidden1_61 profile

pl/sql tutorial for beginners

#sql #plsql #database
5
Comments
1 min read
loading...