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.
#SQL30 Day 11: Soft Deletes

#SQL30 Day 11: Soft Deletes

8
Comments
3 min read
Manipulating arrays with PostgreSQL

Manipulating arrays with PostgreSQL

13
Comments 2
3 min read
#SQL30 Day 10: Random Sampling

#SQL30 Day 10: Random Sampling

7
Comments 1
3 min read
Generate dummy data with Postgres

Generate dummy data with Postgres

6
Comments 2
2 min read
Le comportement particulier des autoincrement dans les tables MySQL InnoDB

Le comportement particulier des autoincrement dans les tables MySQL InnoDB

6
Comments
3 min read
Using GraphDbs to Visualize Code/SQL dependencies

Using GraphDbs to Visualize Code/SQL dependencies

7
Comments
4 min read
How to use Query Objects to refactor Rails SQL-queries

How to use Query Objects to refactor Rails SQL-queries

11
Comments
6 min read
Import data from S3 to Redshift in minutes using Dataform

Import data from S3 to Redshift in minutes using Dataform

7
Comments
4 min read
#SQL30 Day 8: Deleting Duplicates

#SQL30 Day 8: Deleting Duplicates

9
Comments
3 min read
Advanced PHP Interview Questions 2020

Advanced PHP Interview Questions 2020

9
Comments 1
2 min read
#SQL30 Day 6: Supermarket Sales

#SQL30 Day 6: Supermarket Sales

6
Comments 1
3 min read
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types in Enterprise

7
Comments
11 min read
Our 25 Favorite Data Science Courses From Harvard To Udemy

Our 25 Favorite Data Science Courses From Harvard To Udemy

63
Comments
15 min read
10 Amazing Articles On Python Programming And Machine Learning

10 Amazing Articles On Python Programming And Machine Learning

60
Comments
4 min read
SQL Server’s identity column misconceptions

SQL Server’s identity column misconceptions

8
Comments
3 min read
#SQL30 Day 3: Weather Data

#SQL30 Day 3: Weather Data

20
Comments 4
5 min read
How to get the list of all the affected columns in a SQL query

How to get the list of all the affected columns in a SQL query

7
Comments 1
1 min read
#SQL30 Day 1: Wildfires

#SQL30 Day 1: Wildfires

46
Comments 8
2 min read
#SQL30 Day 2: Stock Price Variance

#SQL30 Day 2: Stock Price Variance

8
Comments 5
3 min read
Use the right tool to get identity values back after an insert

Use the right tool to get identity values back after an insert

13
Comments 2
3 min read
Hadoop Vs Relational Databases

Hadoop Vs Relational Databases

73
Comments 1
7 min read
LDAP Directory & SQL Database - Syncing the Unsyncable?

LDAP Directory & SQL Database - Syncing the Unsyncable?

13
Comments
11 min read
Configuring Entity Framework Core into Asp.Net Core

Configuring Entity Framework Core into Asp.Net Core

9
Comments 1
3 min read
SQLAlchemy Cascading Deletes

SQLAlchemy Cascading Deletes

19
Comments 3
4 min read
PostgreSQL Foreign Data Wrappers

PostgreSQL Foreign Data Wrappers

19
Comments
5 min read
Choosing a Database Manager. SQL or Nah?

Choosing a Database Manager. SQL or Nah?

9
Comments 5
3 min read
Building a SQL Development Environment for Messy, Semi-Structured Data

Building a SQL Development Environment for Messy, Semi-Structured Data

7
Comments
5 min read
Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips

Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips

8
Comments
9 min read
Coding Abomination: Conway's Game of Life in TSQL

Coding Abomination: Conway's Game of Life in TSQL

5
Comments 1
3 min read
Grafana Time-Series Dashboards with the Rockset-Grafana Plugin

Grafana Time-Series Dashboards with the Rockset-Grafana Plugin

5
Comments
5 min read
Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries

Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries

9
Comments
5 min read
Blockbuster Movie Trends

Blockbuster Movie Trends

15
Comments
4 min read
A simple user permission model for sophisticated systems

A simple user permission model for sophisticated systems

15
Comments
14 min read
Tales from Technological Backwaters

Tales from Technological Backwaters

6
Comments
3 min read
Need help with sql (*_*) !

Need help with sql (*_*) !

7
Comments 2
1 min read
What is your favorite SQL viewer/tool

What is your favorite SQL viewer/tool

6
Comments 9
1 min read
The “Natural order” misconception

The “Natural order” misconception

5
Comments
2 min read
Difference between varchar, nvarchar in sql server ?

Difference between varchar, nvarchar in sql server ?

21
Comments 1
1 min read
Analyzing Healthcare Data With SaturnCloud.io and BigQuery

Analyzing Healthcare Data With SaturnCloud.io and BigQuery

13
Comments
6 min read
SQL: ROLLUP Like A Boss

SQL: ROLLUP Like A Boss

52
Comments 5
6 min read
Random strings. Generate on the fly, or select from a pre-populated table?

Random strings. Generate on the fly, or select from a pre-populated table?

7
Comments
3 min read
Dynamic Schema name in SQL View

Dynamic Schema name in SQL View

4
Comments
1 min read
How To Work With Memory Optimized Objects in SQL Server

How To Work With Memory Optimized Objects in SQL Server

7
Comments
6 min read
Raw SQL Migrations Library

Raw SQL Migrations Library

4
Comments
2 min read
SQL Access To Mainframe Data

SQL Access To Mainframe Data

5
Comments
7 min read
Python Tkinter-sql

Python Tkinter-sql

5
Comments
1 min read
The do’s and don’ts of dynamic SQL for SQL Server 

The do’s and don’ts of dynamic SQL for SQL Server 

12
Comments
2 min read
Understanding SQL Server Deadlocks

Understanding SQL Server Deadlocks

82
Comments 1
5 min read
SQL Server Locking

SQL Server Locking

14
Comments
3 min read
SQLAlchemy Performance Anti-Patterns and Their Fixes

SQLAlchemy Performance Anti-Patterns and Their Fixes

64
Comments 4
5 min read
15 Of The Best Machine Learning Courses On Coursera For Free

15 Of The Best Machine Learning Courses On Coursera For Free

64
Comments 1
10 min read
Let's discuss about databases?

Let's discuss about databases?

8
Comments 5
1 min read
SQL Server Transactions and Isolation Levels

SQL Server Transactions and Isolation Levels

19
Comments
3 min read
Name your Constraints

Name your Constraints

20
Comments 1
2 min read
Methods for Running SQL on JSON in PostgreSQL, MySQL and Other Relational Databases

Methods for Running SQL on JSON in PostgreSQL, MySQL and Other Relational Databases

8
Comments
4 min read
Tips on Designing a Million Dollar Dashboard

Tips on Designing a Million Dollar Dashboard

203
Comments 9
7 min read
Tricks for Postgres and Docker that will make your life easier

Tricks for Postgres and Docker that will make your life easier

39
Comments
4 min read
Dynamically generating SQL queries using Node.js

Dynamically generating SQL queries using Node.js

119
Comments 26
6 min read
Why we need data structures because we're storing all the datas in database

Why we need data structures because we're storing all the datas in database

4
Comments
1 min read
Server-Side Pagination With Limit/Offset

Server-Side Pagination With Limit/Offset

15
Comments 2
3 min read
loading...