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.
HackTheBox - Writeup Drive [Retired]
mrtnsgs profile

HackTheBox - Writeup Drive [Retired]

#sql #hackthebox #cybersecurity #owasp
Comments 1
15 min read
How to automate the process of enabling TCP/IP of a sql express server using Power shell scripting
noob_jeffrey profile
JEFF

How to automate the process of enabling TCP/IP of a sql express server using Power shell scripting

#sql #sqlexpress #powershell
1
Comments
1 min read
SQL Interview Questions.
gateru profile

SQL Interview Questions.

#sql #database #tutorial
1
Comments 2
6 min read
How to track Cloudtrail API calls from all Organizations AWS accounts using Athena
almeidamatheus profile

How to track Cloudtrail API calls from all Organizations AWS accounts using Athena

#aws #athena #cloudtrail #sql
5
Comments
3 min read
🏁🐘Winning Race Conditions With PostgreSQL
mistval profile

🏁🐘Winning Race Conditions With PostgreSQL

#sql #javascript #softwareengineering #database
44
Comments 2
10 min read
Unlocking the Power of Databases: A Brief Overview of SQL
adriandalion profile

Unlocking the Power of Databases: A Brief Overview of SQL

#database #sql
3
Comments
9 min read
SQL Server Management Studio (SSMS)
appliedk profile

SQL Server Management Studio (SSMS)

#sql #sqlserver #tsql #ssms
1
Comments
5 min read
Laravel API - Import 1 million records with validation in few seconds.
adityar15 profile

Laravel API - Import 1 million records with validation in few seconds.

#laravel #sql #database #api
14
Comments
8 min read
How to Connect MSSQL with Node.js
y2j_0_0 profile

How to Connect MSSQL with Node.js

#node #sqlserver #sql #javascript
2
Comments
2 min read
Troubleshooting Database Issues Like a Pro
adammetis profile

Troubleshooting Database Issues Like a Pro

#sql #postgres #performance #programming
Comments
11 min read
Is SQL a declarative language
esproc_spl profile
Judy

Is SQL a declarative language

#sql #opensource #devops #esproc
13
Comments 5
5 min read
SQL Database Normalization with Easy Examples
tommyc profile

SQL Database Normalization with Easy Examples

#sql #normalization #database #tutorial
2
Comments
2 min read
Exploring LEAD(): Enhancing SQL Data Comparing And Analysis
moh_moh701 profile

Exploring LEAD(): Enhancing SQL Data Comparing And Analysis

#sqlserver #beginners #database #sql
Comments
2 min read
Using SQLAlchemy to transfer tables to and from IRIS
intersystemsdev profile

Using SQLAlchemy to transfer tables to and from IRIS

#python #sql #programming #beginners
Comments
7 min read
Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL
shiviyer profile

Enhancing Write Performance: Key Strategies for Optimizing the InnoDB Buffer Pool in MySQL

#mysql #dba #sql
Comments
3 min read
Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?
shiviyer profile

Strategies for Adaptive Hash Indexing in MySQL: To Enable or Disable?

#mysql #sql #postgres
Comments
2 min read
What is SQL and SQLite?
chryzcode profile

What is SQL and SQLite?

#webdev #database #sql #programming
Comments
3 min read
Introduction to SQL Server
appliedk profile

Introduction to SQL Server

#sql #sqlserver
Comments
4 min read
Laravel: whereIn() vs whereIntegerInRaw() vs find()
ahmedsabry1996 profile

Laravel: whereIn() vs whereIntegerInRaw() vs find()

#laravel #sql #performance #eloquentorm
1
Comments
1 min read
Machine-learning life-cycle management using MLflow
honeybadger_staff profile

Machine-learning life-cycle management using MLflow

#python #sql #machinelearning
3
Comments
29 min read
SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices
mainulspace profile

SQL vs NoSQL: Choosing the Right One, Future Trends & Best Practices

#sql #nosql #database #datamanagement
6
Comments
11 min read
Why should you replace your PostgreSQL with 2000 SQLite databases?
hanshoi profile

Why should you replace your PostgreSQL with 2000 SQLite databases?

#webdev #go #turso #sql
Comments
3 min read
How to write Database Procedures
ayokunle profile

How to write Database Procedures

#database #sql #programming #oracle
Comments
4 min read
Mastering Common Database Objects - Series 1 .. n
ayokunle profile

Mastering Common Database Objects - Series 1 .. n

#database #sql #programming #awsbigdata
Comments
1 min read
Utilizando o Prisma com TypeScript e SQLite: Um Guia PrĂĄtico
vitorrios1001 profile

Utilizando o Prisma com TypeScript e SQLite: Um Guia PrĂĄtico

#prisma #typescript #node #sql
10
Comments
4 min read
How To Create One-to-Many Relationships in SQL
domfive profile

How To Create One-to-Many Relationships in SQL

#sql #sqlrelationships #tutorial #sqlserver
1
Comments
23 min read
SQL for Beginners
sohrab09 profile

SQL for Beginners

#sql #sqlserver #query #development
Comments
2 min read
SQL antipatterns: Diplomatic Immunity
victorhazbun profile

SQL antipatterns: Diplomatic Immunity

#sql #antipatterns #bestpractices
Comments
9 min read
Distributed Data and NoSQL
mercykiria profile

Distributed Data and NoSQL

#distributedsystems #nosql #sql #programming
Comments
4 min read
Diving Into Data: Understanding SQL and GraphQL for Junior Developers
mochafreddo profile

Diving Into Data: Understanding SQL and GraphQL for Junior Developers

#sql #graphql #database #api
2
Comments
2 min read
SQL Column Deletion Techniques
dbvismarketing profile

SQL Column Deletion Techniques

#sql #delete
Comments
2 min read
BigQuery Machine Learning
cmcrawford2 profile

BigQuery Machine Learning

#bigdata #machinelearning #googlecloud #sql
2
Comments
5 min read
Introduction to PL/SQL
pinky057 profile

Introduction to PL/SQL

#database #sql #plsql #oracle
2
Comments
2 min read
Como manipular variĂĄveis locais utilizando SQL Server
tiagoeuzebiocordeiro profile

Como manipular variĂĄveis locais utilizando SQL Server

#sql #sqlserver
Comments
2 min read
Tips and Tricks for Tuning PostgreSQL Thread Cache Performance
shiviyer profile

Tips and Tricks for Tuning PostgreSQL Thread Cache Performance

#postgres #sql #mysql #database
1
Comments
3 min read
New Database IDE
webdbapp profile

New Database IDE

#database #opensource #sql #nosql
1
Comments
3 min read
Inner Join in SQL: A Comprehensive Guide
dbvismarketing profile

Inner Join in SQL: A Comprehensive Guide

#sql #join
Comments
10 min read
OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services
sabareh profile

OLAP Cubes and Multidimensional Modeling with SQL Server Analysis Services

#sql #database #datascience
3
Comments
8 min read
Partitioning and Clustering on BigQuery
cmcrawford2 profile

Partitioning and Clustering on BigQuery

#dataengineering #sql #googlecloud
3
Comments 1
3 min read
How come there are tens of thousands of tables in a database
esproc_spl profile
Judy

How come there are tens of thousands of tables in a database

#programming #sql #esproc #development
7
Comments 1
5 min read
Get list of tables in mysql
caresle profile

Get list of tables in mysql

#sql #database #mysql #mariadb
Comments
1 min read
Ruby Database Setup & Common Commands & CRUD
marywebby profile

Ruby Database Setup & Common Commands & CRUD

#ruby #sql #crud #notes
1
Comments 1
3 min read
I have optimized my work with text-to-SQL translator improved with vector search
zakharsmirnoff profile

I have optimized my work with text-to-SQL translator improved with vector search

#ai #sql #go #python
8
Comments
3 min read
Basics of RAG with pgVector and Langchain
muyiwexy profile

Basics of RAG with pgVector and Langchain

#ai #sql #flutter #tutorial
13
Comments
13 min read
Crafting DDL Statements for an Online Food Ordering Service Database
bshadmehr profile

Crafting DDL Statements for an Online Food Ordering Service Database

#sql #database #programming
2
Comments
2 min read
Will Python replace Stored Procedures?
luca1iu profile

Will Python replace Stored Procedures?

#discuss #sql #python #programming
1
Comments
2 min read
A Practical Guide to Caching: What to Cache and When
readyset profile

A Practical Guide to Caching: What to Cache and When

#caching #database #postgressql #sql
Comments
14 min read
Designing Database Tables for an Online Food Ordering Service
bshadmehr profile

Designing Database Tables for an Online Food Ordering Service

#sql #database #programming
27
Comments
2 min read
Explorando Funçþes de Agregação no SQL: SUM, MAX, MIN, AVG
nathalia_friederichs profile

Explorando Funçþes de Agregação no SQL: SUM, MAX, MIN, AVG

#beginners #programming #sql #database
1
Comments
5 min read
Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys
bshadmehr profile

Mastering Table Relationships in Relational Databases: The Role of Primary and Foreign Keys

#database #programming #sql
6
Comments
3 min read
API completa em Golang - Parte 7
wiliamvj profile

API completa em Golang - Parte 7

#go #braziliandevs #sql #api
49
Comments 5
22 min read
UUID in PostgreSQL
franckpachot profile

UUID in PostgreSQL

#postgres #sql #database
65
Comments 7
5 min read
To UUID, or not to UUID, that is the primary key question
mcadariu profile

To UUID, or not to UUID, that is the primary key question

#postgres #sql #database #performance
13
Comments
9 min read
PySpark & Apache Spark - Overview
ramakrishnan83 profile

PySpark & Apache Spark - Overview

#python #pyspark #dataengineering #sql
Comments
3 min read
Unveiling the Power of Window and Ranking Functions in SQL
ridhiarora profile

Unveiling the Power of Window and Ranking Functions in SQL

#discuss #sql #productivity #learning
6
Comments
4 min read
Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack
kwan profile
KWAN

Elasticsearch: An Introduction To The Database And Heart Of The Elastic Stack

#elasticsearch #nosql #sql
1
Comments 1
4 min read
Understanding and Optimizing Parallel Queries in PostgreSQL
namsi profile

Understanding and Optimizing Parallel Queries in PostgreSQL

#database #postgres #sql #data
Comments
2 min read
Database .NET Review
gamesover profile

Database .NET Review

#database #sql
1
Comments
5 min read
SQL Notebook I Wish I Had Crafted Sooner in My Coding Path
dplata profile

SQL Notebook I Wish I Had Crafted Sooner in My Coding Path

#sql
1
Comments
1 min read
Shift Left For DevOps: Enhancing Service Ownership in Databases
adammetis profile

Shift Left For DevOps: Enhancing Service Ownership in Databases

#sql #monitoring #devops #postgres
Comments
8 min read
loading...