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.
Answer: SQL Server - How to lock a table until a stored procedure finishes

Answer: SQL Server - How to lock a table until a stored procedure finishes

6
Comments
1 min read
Importing geo-partitioned data… the easy way

Importing geo-partitioned data… the easy way

3
Comments 1
1 min read
Avoiding Hard Coding and Magic Strings in code and databases

Avoiding Hard Coding and Magic Strings in code and databases

38
Comments 1
3 min read
Popular SQL interview question met in practice

Popular SQL interview question met in practice

10
Comments
3 min read
λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

λ➕ Sum Types in relational databases: Yet another (IMO pretty neat) way to model them in SQL

8
Comments
3 min read
Working with JSON in an RDBMS – Part 2, PostgreSQL

Working with JSON in an RDBMS – Part 2, PostgreSQL

7
Comments
9 min read
How to deploy project local to production server using gulp?

How to deploy project local to production server using gulp?

6
Comments 1
1 min read
What is an execution plan?

What is an execution plan?

5
Comments
1 min read
MySQL reserved words checker for Laravel migrations on PhpStorm

MySQL reserved words checker for Laravel migrations on PhpStorm

4
Comments
1 min read
Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

Loose Typings in GraphQL for Dynamic Grouping and Aggregation Queries

10
Comments
6 min read
Query optimization: from a few weeks to 24 hours

Query optimization: from a few weeks to 24 hours

16
Comments
4 min read
Use Sequelize to Manipulate Databases

Use Sequelize to Manipulate Databases

12
Comments
3 min read
Introduction to Relational Database and SQL

Introduction to Relational Database and SQL

7
Comments
1 min read
14 SQL Query Performance Tuning Tips

14 SQL Query Performance Tuning Tips

10
Comments
9 min read
nodejs feat Seqeuelize Course

nodejs feat Seqeuelize Course

6
Comments
1 min read
Transform SQL Query into MongoDB Query

Transform SQL Query into MongoDB Query

7
Comments
1 min read
New Formatting Profiles in SQL Complete v6.3

New Formatting Profiles in SQL Complete v6.3

7
Comments
2 min read
Sequelize, your favorite database library

Sequelize, your favorite database library

7
Comments
3 min read
MySql? What is it?

MySql? What is it?

8
Comments
3 min read
Angular 8 Button disable?

Angular 8 Button disable?

4
Comments 2
1 min read
How to Group in C# Like in SQL

How to Group in C# Like in SQL

5
Comments
1 min read
SQL is Insecure

SQL is Insecure

6
Comments 31
2 min read
Makers Week 4: Databased on a True Story

Makers Week 4: Databased on a True Story

6
Comments
2 min read
What do you need to know to get into Data Science as a Beginner?

What do you need to know to get into Data Science as a Beginner?

71
Comments 8
1 min read
Display records from Database one at a time

Display records from Database one at a time

5
Comments 1
2 min read
How did I reduce the load time of my application?

How did I reduce the load time of my application?

16
Comments 2
1 min read
SQL: Union Operator

SQL: Union Operator

22
Comments
2 min read
Error-logging Patterns and Practices

Error-logging Patterns and Practices

66
Comments
6 min read
SQL, NoSQL and modern data practices

SQL, NoSQL and modern data practices

53
Comments
2 min read
Query PDFs with SQL

Query PDFs with SQL

9
Comments
1 min read
SQL: Inner Join

SQL: Inner Join

23
Comments 4
2 min read
Getting Started with Microsoft SQL Server on Mac and Windows in 2020

Getting Started with Microsoft SQL Server on Mac and Windows in 2020

13
Comments
1 min read
SQL vs NoSQL

SQL vs NoSQL

8
Comments
2 min read
Jumpstarting Applications with ActiveRecord

Jumpstarting Applications with ActiveRecord

12
Comments 1
7 min read
Vectorized SQL in CockroachDB

Vectorized SQL in CockroachDB

9
Comments
1 min read
View and Read SQL Server Transaction Log Data

View and Read SQL Server Transaction Log Data

5
Comments 1
1 min read
Learning about how to connect a Database

Learning about how to connect a Database

7
Comments 2
1 min read
Creating a Postgres database + user

Creating a Postgres database + user

5
Comments
1 min read
Starting my journey!

Starting my journey!

5
Comments 2
1 min read
Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

Rintagi Low-Code Generated ReactJS Applications: The Future is Reactive

2
Comments
2 min read
#SQL30 Day 16: Dev Badges

#SQL30 Day 16: Dev Badges

7
Comments
4 min read
#SQL30 Day 15: Fuzzy Matching

#SQL30 Day 15: Fuzzy Matching

10
Comments
3 min read
#SQL30 Day 14: UFO Sightings

#SQL30 Day 14: UFO Sightings

6
Comments
2 min read
#SQL30 Day 13: Permutations

#SQL30 Day 13: Permutations

8
Comments
2 min read
That's how I came back in time

That's how I came back in time

2
Comments
2 min read
#SQL30 Day 7: Grouping Sets

#SQL30 Day 7: Grouping Sets

6
Comments 1
3 min read
#SQL30 Day 9: Longest Span

#SQL30 Day 9: Longest Span

9
Comments
3 min read
#SQL30 Day 4: Video Game Sales

#SQL30 Day 4: Video Game Sales

7
Comments 1
3 min read
SQL In The Real World: Setting Expectations For Your First Job

SQL In The Real World: Setting Expectations For Your First Job

14
Comments
4 min read
My SQL5.5: Reasons for being World’s Most Popular Opensource Database

My SQL5.5: Reasons for being World’s Most Popular Opensource Database

4
Comments
2 min read
Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

Devart Greatly Enhanced its Flagman Solution — dbForge SQL Complete

5
Comments
2 min read
Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

Updated dbForge Studio for PostgreSQL Helps Standardizing SQL Code

3
Comments
2 min read
JOINs on JOINs on JOINs

JOINs on JOINs on JOINs

14
Comments
3 min read
When SQL & Serverless aren't the right choices

When SQL & Serverless aren't the right choices

38
Comments
3 min read
How to Install MySQL on Mac

How to Install MySQL on Mac

6
Comments
2 min read
dbForge Transaction Log – A New Tool Made by Devart

dbForge Transaction Log – A New Tool Made by Devart

3
Comments
2 min read
How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

How to generate random IDs that are not individually unique, but unique across 2 fields (columns) in a MySQL database table?

8
Comments 8
1 min read
Query to get Primary Key & Foreign Key columns

Query to get Primary Key & Foreign Key columns

4
Comments
1 min read
MySQL- Indexing Basics

MySQL- Indexing Basics

7
Comments
1 min read
Todo List App Using Flask and SQL-Alchemy

Todo List App Using Flask and SQL-Alchemy

7
Comments
1 min read
loading...