Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Dec 19 '19

For the 1024 time – DateTime has no format!

#csharp #sql #database #datetime

2 min read

Dec 17 '19

ORM vs Query Builders vs Raw SQL

#discuss #orm #sql

2 min read

Hasura for Hasura

Dec 19 '19

GraphQL with Postgres views and materialized views

#graphql #postgres #sql #tutorial

5 min read

Dec 19 '19

6 Common Sequelize Queries Explained in SQL

#node #javascript #sql #database

4 min read

Dec 18 '19

How I passed 70-761 T-SQL exam

#sql #career #certification #microsoft

3 min read

Dec 15 '19

How to Load Data into an SQL database: From simple inserts to bulk loads

#sql #database #postgres #datascience

3 min read

Dec 15 '19

Does WordPress database architecture need improvement?

#discuss #wordpress #sql #database

1 min read

Chidiebere Ogujeiofor

Dec 13 '19

SQL Subqueries in action

#postgres #database #sql #subquery

8 min read

Dec 11 '19

Understanding MySQL Index Basics

#database #mysql #sql #developer

2 min read

Suresh Mohan for Syncfusion, Inc.

Dec 12 '19

8 Tips and Tricks for Writing the Best Queries in LINQ to Entities

#dotnet #csharp #sql #productivity

8 min read

Dec 10 '19

A more controllable random string generator function for SQL Server

#sql #database

3 min read

Ruairidh W McHardy

Dec 10 '19

Stop using offset pagination

#pagination #sql #database #data

3 min read

Lorraine for Next Tech

Dec 10 '19

Cleaning and Transforming Data with SQL

#sql #dataanalysis #beginners #tutorial

6 min read

Rob Reid

Dec 9 '19

CockroachDB Demo Locations

#database #sql #cockroachdb

3 min read

Rob Reid

Dec 9 '19

Geo-partitioning. No column? No problem!

#database #sql #cockroachdb

3 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.