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.
Import file in SQL Server

Import file in SQL Server

Comments
2 min read
Uncertain number but regular column to row conversion:From SQL to SPL#5

Uncertain number but regular column to row conversion:From SQL to SPL#5

5
Comments
2 min read
Understanding Views in Databases: A Complete Guide πŸ§ πŸ’‘

Understanding Views in Databases: A Complete Guide πŸ§ πŸ’‘

1
Comments
5 min read
Bulk Insert/Update task

Bulk Insert/Update task

Comments
3 min read
Change SQL Server into an Application Server with "TSQL.APP"

Change SQL Server into an Application Server with "TSQL.APP"

Comments
6 min read
13 Basic Terms In SQL That Basically Ask in Interview.

13 Basic Terms In SQL That Basically Ask in Interview.

Comments
4 min read
Know your tools

Know your tools

2
Comments 2
2 min read
How to build multi-tenancy in PostgreSQL for developing SaaS applications?

How to build multi-tenancy in PostgreSQL for developing SaaS applications?

Comments
4 min read
Implementing Triggers in SQL - Automating Database Actions

Implementing Triggers in SQL - Automating Database Actions

1
Comments
3 min read
Stop Being Afraid of Databases

Stop Being Afraid of Databases

Comments
3 min read
Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Migrating from MySQL to PostgreSQL Key Query Differences and Considerations

Comments
3 min read
Like IDE for FlinkSQL: Support Pycharm! FlikSQLHelper v2025.1.0 released

Like IDE for FlinkSQL: Support Pycharm! FlikSQLHelper v2025.1.0 released

Comments
1 min read
Basics of Animal Tracking Databases

Basics of Animal Tracking Databases

Comments
4 min read
Using IRIS and Presto for high-performance and scalable SQL queries

Using IRIS and Presto for high-performance and scalable SQL queries

Comments
10 min read
Postpone and Prosper: Make your life easier with deferring SQL constraints

Postpone and Prosper: Make your life easier with deferring SQL constraints

1
Comments
3 min read
Backup Posts Dev.to to SQLite

Backup Posts Dev.to to SQLite

Comments
5 min read
esProc SPL, the challenger of SQLite

esProc SPL, the challenger of SQLite

5
Comments
10 min read
Code analysis with SQL projects

Code analysis with SQL projects

Comments
6 min read
Explaining self-join in SQL

Explaining self-join in SQL

Comments
1 min read
Handling Dates and Times in Oracle Database

Handling Dates and Times in Oracle Database

1
Comments
3 min read
Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

Calculate based on the records within the group and fill the result into the first record:From SQL to SPL #4

5
Comments
3 min read
Uses of Snowflake Schema

Uses of Snowflake Schema

Comments
3 min read
Why Successful Companies Don't Have DBAs

Why Successful Companies Don't Have DBAs

Comments
4 min read
Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Like IDE for SparkSQL: Support Pycharm! SparkSQLHelper v2025.1.1 released

Comments
1 min read
Introduction to SQL

Introduction to SQL

Comments
3 min read
loading...