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 does the in-memory database bring memory’s advantage into play?

How does the in-memory database bring memory’s advantage into play?

Comments
12 min read
A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

A Worthy Sequel: An Overview of Next-Gen NoSQL Databases

2
Comments
4 min read
Deploying an App Service in Azure and Connecting to SQL Database

Deploying an App Service in Azure and Connecting to SQL Database

6
Comments
3 min read
SQL Case Study 2: Human Resources

SQL Case Study 2: Human Resources

2
Comments 1
4 min read
Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

Open-source SPL Eliminates Tens of Thousands of Intermediate Tables from Databases

5
Comments
8 min read
7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

7 Bad Practices to Avoid When Writing SQL Queries for Better Performance 🚀

32
Comments 4
4 min read
Building a Node.js Server with Microsoft SQL Database Integration

Building a Node.js Server with Microsoft SQL Database Integration

1
Comments
2 min read
How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

How to Query 1st, 2nd, or Nth Largest attribute in SQL Table

Comments
3 min read
Postgres Concurrency : What could go wrong (part 1)

Postgres Concurrency : What could go wrong (part 1)

9
Comments
4 min read
How to Survive Phase III of Flatiron School

How to Survive Phase III of Flatiron School

1
Comments
4 min read
How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

How to access the ERD (Entity-Relationship Diagram) of your database schema in MySQL Workbench

53
Comments 1
2 min read
SAS Function setDateByNumberBDays

SAS Function setDateByNumberBDays

2
Comments
1 min read
SAS Function isBrHolidayworkingDaysBetweenDates

SAS Function isBrHolidayworkingDaysBetweenDates

2
Comments
1 min read
SAS Functions previous and next BusinessDay

SAS Functions previous and next BusinessDay

Comments
1 min read
Create Stored Procedures using Embedded Python

Create Stored Procedures using Embedded Python

2
Comments
5 min read
MySQL Basic Select challenges

MySQL Basic Select challenges

Comments
2 min read
Managing Calendar Availability in Supabase with SQL generate_series

Managing Calendar Availability in Supabase with SQL generate_series

3
Comments
3 min read
SQL Constraints 101: Ensuring Data Accuracy and Integrity

SQL Constraints 101: Ensuring Data Accuracy and Integrity

1
Comments 4
6 min read
SAS Function isBrHoliday

SAS Function isBrHoliday

2
Comments
1 min read
SAS Function isBusinessDay

SAS Function isBusinessDay

2
Comments
1 min read
pg_hint_plan in views? No. But in UDFs, Yes

pg_hint_plan in views? No. But in UDFs, Yes

3
Comments
10 min read
MySQL 8.0: Invisible Columns

MySQL 8.0: Invisible Columns

3
Comments
2 min read
Introduction to SQL set operators

Introduction to SQL set operators

11
Comments 1
5 min read
Generate Random Text Strings in PostgreSQL

Generate Random Text Strings in PostgreSQL

3
Comments
1 min read
How to build a music player part 2: Introduction MySQL database

How to build a music player part 2: Introduction MySQL database

2
Comments
3 min read
loading...