Forem

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.
MySQL Command Notes

MySQL Command Notes

4
Comments
1 min read
Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

Distributed SQL Tips and Tricks for PostgreSQL and Oracle DBAs – Sep 9, 2020

6
Comments 1
5 min read
What is a Database Query? SQL and NoSQL queries explained

What is a Database Query? SQL and NoSQL queries explained

17
Comments
7 min read
Guide to Cyber Security: learn how to defend your systems

Guide to Cyber Security: learn how to defend your systems

17
Comments
10 min read
How to find SQL Server database Restore and Recovery time ?

How to find SQL Server database Restore and Recovery time ?

6
Comments
1 min read
Database Version Control With Liquibase

Database Version Control With Liquibase

6
Comments
4 min read
Synchronize Databases with Only Five Lines of Code

Synchronize Databases with Only Five Lines of Code

65
Comments 3
2 min read
SQL Server Service Broker for Asynchronous Applications

SQL Server Service Broker for Asynchronous Applications

8
Comments
7 min read
Replicating Azure SQL DB Instances on the fly for SaaS apps

Replicating Azure SQL DB Instances on the fly for SaaS apps

1
Comments
2 min read
The Easy Way to Find Customers Likely to Churn

The Easy Way to Find Customers Likely to Churn

23
Comments
4 min read
Important TIPs for SQL Database Design

Important TIPs for SQL Database Design

7
Comments 2
7 min read
Practical Azure SQL Database for Modern Developers

Practical Azure SQL Database for Modern Developers

14
Comments
4 min read
How to Measure Cohort Retention using BigQuery

How to Measure Cohort Retention using BigQuery

9
Comments
5 min read
Postgres concat_ws() function

Postgres concat_ws() function

1
Comments
1 min read
[PT-BR] Join SQL, quando usar?

[PT-BR] Join SQL, quando usar?

52
Comments 12
2 min read
SQL Tips & Tricks: Counting Rows

SQL Tips & Tricks: Counting Rows

5
Comments
5 min read
Machete MySQL(Cheatsheet) level 1

Machete MySQL(Cheatsheet) level 1

7
Comments
3 min read
Reading a datetime with miliseconds into an Oracle DATE

Reading a datetime with miliseconds into an Oracle DATE

6
Comments
2 min read
MySQL Commands You Need To Know To Create A New User

MySQL Commands You Need To Know To Create A New User

10
Comments 1
2 min read
SQL Practice Problem to Help You Pass Your Interview

SQL Practice Problem to Help You Pass Your Interview

18
Comments 5
3 min read
Switching the offset for a UTC date in SQL Server

Switching the offset for a UTC date in SQL Server

2
Comments
2 min read
Reports performance improvement

Reports performance improvement

7
Comments
1 min read
First impressions of PopSQL’s collaborative SQL editor

First impressions of PopSQL’s collaborative SQL editor

44
Comments 1
4 min read
Getting to know SQL Server Extended Events

Getting to know SQL Server Extended Events

26
Comments
7 min read
How to ace coding interviews. The ultimate guide.

How to ace coding interviews. The ultimate guide.

80
Comments
14 min read
loading...