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

9
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

47
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

16
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

20
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

18
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
Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

Build a simple blog with GraphQL, Node.js, SQLite and (VUE, Angular Or ReactJS)

36
Comments 2
2 min read
Azure SQL Database: What We've Learned About Automatic Tuning and Performance Recommendations

Azure SQL Database: What We've Learned About Automatic Tuning and Performance Recommendations

8
Comments
8 min read
The R.A.G (Redshift Analyst Guide): What is Redshift?

The R.A.G (Redshift Analyst Guide): What is Redshift?

38
Comments 2
7 min read
Bulk Insert in Dapper into MS SQL

Bulk Insert in Dapper into MS SQL

7
Comments 8
1 min read
What is a SQL query you are proud of?

What is a SQL query you are proud of?

6
Comments 13
1 min read
My Journey

My Journey

5
Comments
1 min read
Master of Data Science... but I'm a graphic designer

Master of Data Science... but I'm a graphic designer

8
Comments 2
1 min read
How do I make paging with ordering by different columns ?

How do I make paging with ordering by different columns ?

6
Comments
1 min read
How to make APIs fast & secure, plus tips for REST APIs

How to make APIs fast & secure, plus tips for REST APIs

62
Comments
2 min read
Having trouble understanding wide column stores like Cassandra. Can someone explain?

Having trouble understanding wide column stores like Cassandra. Can someone explain?

3
Comments
1 min read
A Day in the Life: Catherine Zhou, Codecademy Data Scientist

A Day in the Life: Catherine Zhou, Codecademy Data Scientist

12
Comments
6 min read
The Interview Study Guide For Software Engineers

The Interview Study Guide For Software Engineers

2415
Comments 92
12 min read
ASP.NET MVC 5 LinQ to SQL

ASP.NET MVC 5 LinQ to SQL

7
Comments 1
5 min read
KISS my blog! (part 1)

KISS my blog! (part 1)

6
Comments 1
3 min read
Azure Storage, conhece? [PARTE 1]

Azure Storage, conhece? [PARTE 1]

11
Comments 1
8 min read
A Critical Look on Relational Databases and SQL

A Critical Look on Relational Databases and SQL

20
Comments 2
7 min read
Using DataLoader to batch SQL queries

Using DataLoader to batch SQL queries

14
Comments
7 min read
We’re not all DBAs: Indexes For Developers

We’re not all DBAs: Indexes For Developers

30
Comments 1
5 min read
The True Guide to True and False in PostgreSQL

The True Guide to True and False in PostgreSQL

10
Comments
2 min read
SQLite, json et dénormalisation

SQLite, json et dénormalisation

5
Comments 7
7 min read
Working with BigQuery Analytic Functions

Working with BigQuery Analytic Functions

6
Comments
5 min read
Querying data using raw SQL & Stored Procedures in Entity Framework Core

Querying data using raw SQL & Stored Procedures in Entity Framework Core

3
Comments
4 min read
Finding the Top N per Group with SQL

Finding the Top N per Group with SQL

3
Comments
7 min read
How to ace coding interviews; and scaling tips from Netflix & Shopify

How to ace coding interviews; and scaling tips from Netflix & Shopify

123
Comments
2 min read
Data Science Interview Study Guide

Data Science Interview Study Guide

231
Comments 2
12 min read
Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

Using Tableau with Kafka: How to Build a Real-Time SQL Dashboard on Streaming Data

9
Comments
6 min read
An Introduction to Oracle SQL

An Introduction to Oracle SQL

3
Comments
1 min read
When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

When it comes to Data, the customer is always wrong - The Four Horsemen of the Assumption Apocalypse

25
Comments 3
2 min read
How i learned flask in one week by building

How i learned flask in one week by building

11
Comments 3
2 min read
pandas #1: Getting started with pandas

pandas #1: Getting started with pandas

46
Comments 2
4 min read
DynamoDB vs. Hadoop vs. MongoDB

DynamoDB vs. Hadoop vs. MongoDB

48
Comments
8 min read
#SQL30 Day 12: Greatest Discount

#SQL30 Day 12: Greatest Discount

6
Comments
3 min read
loading...