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.
Our 25 Favorite Data Science Courses From Harvard To Udemy

Our 25 Favorite Data Science Courses From Harvard To Udemy

64
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

15
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?

14
Comments 1
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

22
Comments 4
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
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?

9
Comments 8
1 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

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

Coding Abomination: Conway's Game of Life in TSQL

6
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

22
Comments
14 min read
Tales from Technological Backwaters

Tales from Technological Backwaters

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

What is your favorite SQL viewer/tool

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

Need help with sql (*_*) !

7
Comments 2
1 min read
loading...