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.
What's your experience with text IDs in SQL database?

What's your experience with text IDs in SQL database?

16
Comments 9
1 min read
Reports performance improvement

Reports performance improvement

7
Comments
1 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
SQL Practice Problem to Help You Pass Your Interview

SQL Practice Problem to Help You Pass Your Interview

18
Comments 6
3 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
Code-First ORM For Go: GORM

Code-First ORM For Go: GORM

9
Comments
3 min read
Distributed SQL Tips and Tricks – Aug 17, 2020

Distributed SQL Tips and Tricks – Aug 17, 2020

2
Comments
4 min read
SQL Cheatsheet - Most Common Commands

SQL Cheatsheet - Most Common Commands

18
Comments 1
13 min read
Don't ever use LIMIT again!!!

Don't ever use LIMIT again!!!

6
Comments 1
5 min read
Convince me to use SQL

Convince me to use SQL

29
Comments 17
1 min read
Alembic: setting a column to nullable=False if it already has data in it

Alembic: setting a column to nullable=False if it already has data in it

7
Comments 1
2 min read
Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

Doing the Impossible, using ASSISTANT to make a SQL Linter (and how you can make it lint whatever you want)

48
Comments 1
7 min read
Azure SQL for Beginners - Video Playlist

Azure SQL for Beginners - Video Playlist

28
Comments
1 min read
SQL Server Profiler, underused and undervalued

SQL Server Profiler, underused and undervalued

8
Comments
5 min read
Why SQLite is simple to use!

Why SQLite is simple to use!

6
Comments 2
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.