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.
CockroachDB via Crystal ... In under 50 lines

CockroachDB via Crystal ... In under 50 lines

7
Comments
6 min read
RepoDb - a hybrid ORM library for .NET.

RepoDb - a hybrid ORM library for .NET.

9
Comments 4
2 min read
Elasticsearch Comrade Part #1 - SQL Queries

Elasticsearch Comrade Part #1 - SQL Queries

9
Comments
1 min read
When to use/not use an ORM

When to use/not use an ORM

10
Comments 6
1 min read
🐢 7 Steps to SQL Optimizationn Mastery

🐢 7 Steps to SQL Optimizationn Mastery

7
Comments
3 min read
jOOQ - a short guide

jOOQ - a short guide

16
Comments
8 min read
Codeigniter custom helper functions which will increase your productivity

Codeigniter custom helper functions which will increase your productivity

23
Comments 2
2 min read
Updating a table from another table

Updating a table from another table

8
Comments 3
1 min read
Understanding SQL Server Isolation Levels through example

Understanding SQL Server Isolation Levels through example

11
Comments
6 min read
For the 1024 time – DateTime has no format!

For the 1024 time – DateTime has no format!

11
Comments 2
2 min read
GraphQL with Postgres views and materialized views

GraphQL with Postgres views and materialized views

6
Comments
5 min read
6 Common Sequelize Queries Explained in SQL

6 Common Sequelize Queries Explained in SQL

6
Comments
4 min read
ORM vs Query Builders vs Raw SQL

ORM vs Query Builders vs Raw SQL

27
Comments 8
2 min read
How I passed 70-761 T-SQL exam

How I passed 70-761 T-SQL exam

10
Comments 2
3 min read
How to Load Data into an SQL database: From simple inserts to bulk loads

How to Load Data into an SQL database: From simple inserts to bulk loads

45
Comments
3 min read
Does WordPress database architecture need improvement?

Does WordPress database architecture need improvement?

5
Comments 4
1 min read
SQL Subqueries in action

SQL Subqueries in action

21
Comments 3
8 min read
Understanding MySQL Index Basics

Understanding MySQL Index Basics

9
Comments 5
2 min read
8 Tips and Tricks for Writing the Best Queries in LINQ to Entities

8 Tips and Tricks for Writing the Best Queries in LINQ to Entities

66
Comments 2
8 min read
A more controllable random string generator function for SQL Server

A more controllable random string generator function for SQL Server

8
Comments
3 min read
Stop using offset pagination

Stop using offset pagination

9
Comments
3 min read
Architecture of a high performance GraphQL to SQL engine

Architecture of a high performance GraphQL to SQL engine

10
Comments
6 min read
Cleaning and Transforming Data with SQL

Cleaning and Transforming Data with SQL

17
Comments
6 min read
Geo-partitioning. No column? No problem!

Geo-partitioning. No column? No problem!

5
Comments
3 min read
CockroachDB Demo Locations

CockroachDB Demo Locations

6
Comments
3 min read
The Data Processing Holy Grail? Row vs. Columnar Databases

The Data Processing Holy Grail? Row vs. Columnar Databases

13
Comments
12 min read
SQL Vs NoSQL – Which Is Best For You?

SQL Vs NoSQL – Which Is Best For You?

55
Comments 3
3 min read
Airbnb’s Airflow Versus Spotify’s Luigi

Airbnb’s Airflow Versus Spotify’s Luigi

73
Comments
7 min read
Creating a materialized view with SQL procedures

Creating a materialized view with SQL procedures

8
Comments
3 min read
QuestDB - fast relational time-series DB, zero GC java

QuestDB - fast relational time-series DB, zero GC java

22
Comments 5
1 min read
Whats WITH CTE

Whats WITH CTE

20
Comments 4
9 min read
SQL: Outer Joins

SQL: Outer Joins

76
Comments 10
4 min read
Types of Indexing in Databases

Types of Indexing in Databases

53
Comments 2
2 min read
Bulk Insert With Dapper - with Table Type Parameter

Bulk Insert With Dapper - with Table Type Parameter

11
Comments 4
3 min read
Postgres: How to display multiple values from a sub-query

Postgres: How to display multiple values from a sub-query

10
Comments
2 min read
Purpose of Indexing in Database

Purpose of Indexing in Database

14
Comments
3 min read
JavaScript Dates in SQL

JavaScript Dates in SQL

48
Comments 2
1 min read
Database Storage

Database Storage

10
Comments
2 min read
Angular + CData API Server: Data-Driven Dynamic Web Apps

Angular + CData API Server: Data-Driven Dynamic Web Apps

6
Comments
8 min read
The Good, The Bad, The Ugly: Microsoft's three significant impacts on the world of Data.

The Good, The Bad, The Ugly: Microsoft's three significant impacts on the world of Data.

41
Comments 1
3 min read
A New Way to Monitor Your SQL Server Instances

A New Way to Monitor Your SQL Server Instances

8
Comments
3 min read
The R.A.G (Redshift Analyst Guide): Understanding the Query Plan (Explain)

The R.A.G (Redshift Analyst Guide): Understanding the Query Plan (Explain)

27
Comments 2
7 min read
Performance of a Database Application

Performance of a Database Application

15
Comments 9
3 min read
The R.A.G (Redshift Analyst Guide): Troubleshooting process

The R.A.G (Redshift Analyst Guide): Troubleshooting process

20
Comments 5
3 min read
The R.A.G (Redshift Analyst Guide): Data Types and Compression

The R.A.G (Redshift Analyst Guide): Data Types and Compression

20
Comments
7 min read
The R.A.G (Redshift Analyst Guide): Things to avoid / Best Practice

The R.A.G (Redshift Analyst Guide): Things to avoid / Best Practice

17
Comments
7 min read
Just in CASE

Just in CASE

9
Comments 3
9 min read
Automated Data Replication (Salesforce) with SQL SSIS and BIML

Automated Data Replication (Salesforce) with SQL SSIS and BIML

7
Comments
9 min read
General and Unconventional Pagination Techniques in Postgres

General and Unconventional Pagination Techniques in Postgres

11
Comments
4 min read
The R.A.G (Redshift Analyst Guide): Sorting & Zone Maps

The R.A.G (Redshift Analyst Guide): Sorting & Zone Maps

22
Comments 1
7 min read
Simplify BigQuery ETL jobs using SQLAlchemy

Simplify BigQuery ETL jobs using SQLAlchemy

18
Comments
8 min read
The Challenges of Writing Business Apps/Tools

The Challenges of Writing Business Apps/Tools

4
Comments 2
3 min read
The R.A.G (Redshift Analyst Guide): Distribution

The R.A.G (Redshift Analyst Guide): Distribution

18
Comments 1
7 min read
A quick tip for dynamic SQL

A quick tip for dynamic SQL

11
Comments
1 min read
How to Paginate (the right way) in SQL

How to Paginate (the right way) in SQL

19
Comments
4 min read
Making it Easier to Manage a Production PostgreSQL Database

Making it Easier to Manage a Production PostgreSQL Database

7
Comments
4 min read
Why learning SQL is so relevant to Developers

Why learning SQL is so relevant to Developers

59
Comments 12
2 min read
Building Dynamic React Apps with Database Data

Building Dynamic React Apps with Database Data

20
Comments
9 min read
Business Logic of an Application - My Experience as Newbie Programmer

Business Logic of an Application - My Experience as Newbie Programmer

7
Comments
3 min read
The R.A.G (Redshift Analyst Guide): How does it work?

The R.A.G (Redshift Analyst Guide): How does it work?

18
Comments
6 min read
loading...