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.
Building a SQL Development Environment for Messy, Semi-Structured Data
shawn profile

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

#sql #database
7
Comments
5 min read
Kentico 12: Design Patterns Part 14 - DocumentQuery and ObjectQuery Tips
seangwright profile

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

#kentico #sql #csharp #dotnet
9
Comments
9 min read
Coding Abomination: Conway's Game of Life in TSQL
barrettotte profile

Coding Abomination: Conway's Game of Life in TSQL

#tsql #sql #python #gameoflife
6
Comments 1
3 min read
Outside Lands, Airbnb Prices, and Rockset’s Geospatial Queries
shawn profile

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

#serverless #sql #database
9
Comments
5 min read
Blockbuster Movie Trends
williamhuybui profile

Blockbuster Movie Trends

#python #datascience #sql #database
15
Comments
4 min read
A simple user permission model for sophisticated systems
dillonsadofsky profile

A simple user permission model for sophisticated systems

#sql #cpp #mysql
26
Comments
14 min read
Tales from Technological Backwaters
bugmagnet profile

Tales from Technological Backwaters

#javascript #sqlserver #sql
7
Comments
3 min read
What is your favorite SQL viewer/tool
levivm profile

What is your favorite SQL viewer/tool

#discuss #sql #database
6
Comments 9
1 min read
Need help with sql (*_*) !
mahendrachoudhary profile

Need help with sql (*_*) !

#help #database #sql #rails
7
Comments 2
1 min read
The “Natural order” misconception
peledzohar profile

The “Natural order” misconception

#sql #misconceptions
6
Comments
2 min read
Difference between varchar, nvarchar in sql server ?
twostepdeveloper profile

Difference between varchar, nvarchar in sql server ?

#sql #database #bestpractice #datatype
21
Comments 1
1 min read
Analyzing Healthcare Data With SaturnCloud.io and BigQuery
seattledataguy profile

Analyzing Healthcare Data With SaturnCloud.io and BigQuery

#python #sql #database
13
Comments
6 min read
SQL: ROLLUP Like A Boss
griffinator76 profile

SQL: ROLLUP Like A Boss

#sql #database #cube #dataanalysis
54
Comments 5
6 min read
Random strings. Generate on the fly, or select from a pre-populated table?
peledzohar profile

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

#sql #random
7
Comments
3 min read
How To Work With Memory Optimized Objects in SQL Server
erikwhiting88 profile

How To Work With Memory Optimized Objects in SQL Server

#database #sql #sqlserver
7
Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.