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.
Multiple SQL Inserts and Transactions with Objection Js

Multiple SQL Inserts and Transactions with Objection Js

12
Comments
4 min read
PostgreSQL Pro Tip: Beware of BETWEEN

PostgreSQL Pro Tip: Beware of BETWEEN

12
Comments 2
1 min read
SELECT beginner FROM all;

SELECT beginner FROM all;

6
Comments
5 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
NoSql but with SQL

NoSql but with SQL

5
Comments
1 min read
Would you like to have better XML support in SQL Server?

Would you like to have better XML support in SQL Server?

5
Comments
1 min read
SQL: Timestamps

SQL: Timestamps

41
Comments 4
2 min read
Building Dynamic React Apps with Database Data

Building Dynamic React Apps with Database Data

23
Comments
9 min read
Working with JSON in an RDBMS – Part 1, MS SQL Server

Working with JSON in an RDBMS – Part 1, MS SQL Server

11
Comments 2
12 min read
Why is My SQL Server Query So Slow

Why is My SQL Server Query So Slow

13
Comments 1
6 min read
What are SQL Indexes and how to create one? (For Beginners)

What are SQL Indexes and how to create one? (For Beginners)

15
Comments 4
1 min read
The SQL Savant: Inner Joins in SQL

The SQL Savant: Inner Joins in SQL

32
Comments 4
5 min read
Database normalization may be harmful to efficiency on large scale analytics projects.

Database normalization may be harmful to efficiency on large scale analytics projects.

12
Comments 2
2 min read
SQL and the Soup Kitchen

SQL and the Soup Kitchen

6
Comments 1
1 min read
Creating a C# Repository in .NET Core using RepoDb

Creating a C# Repository in .NET Core using RepoDb

14
Comments 7
5 min read
Simple Queue in PostgreSQL

Simple Queue in PostgreSQL

14
Comments 2
2 min read
An Example to Demonstrate The Vulnerability of SQL Injection and Its Prevention in Oracle

An Example to Demonstrate The Vulnerability of SQL Injection and Its Prevention in Oracle

9
Comments
3 min read
Using Single and Multiline Comments

Using Single and Multiline Comments

8
Comments 2
1 min read
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
CockroachDB Demo Locations

CockroachDB Demo Locations

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

Geo-partitioning. No column? No problem!

5
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

12
Comments 4
3 min read
Purpose of Indexing in Database

Purpose of Indexing in Database

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

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

11
Comments
2 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
loading...