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.
JavaScript Dates in SQL

JavaScript Dates in SQL

49
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
SQL, NoSQL and modern data practices

SQL, NoSQL and modern data practices

53
Comments 1
2 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)

28
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): Data Types and Compression

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

25
Comments
7 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): Things to avoid / Best Practice

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

19
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

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

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

23
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

22
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...