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.
Syncing Azure SQL Databases Across Subscriptions Using OpenShift CronJob (Without ADF)

Syncing Azure SQL Databases Across Subscriptions Using OpenShift CronJob (Without ADF)

Comments
3 min read
Inline Stopwords, Exceptions, and Wordforms
Cover image for Inline Stopwords, Exceptions, and Wordforms

Inline Stopwords, Exceptions, and Wordforms

Comments
7 min read
Code is the execution. Thinking is the strategy.
Cover image for Code is the execution. Thinking is the strategy.

Code is the execution. Thinking is the strategy.

1
Comments
1 min read
Your ML Model Is Training on the Future
Cover image for Your ML Model Is Training on the Future

Your ML Model Is Training on the Future

Comments
7 min read
Go Database Fundamentals: SQL or NoSQL for Your Next Project?

Go Database Fundamentals: SQL or NoSQL for Your Next Project?

2
Comments
9 min read
Data Engineer Career Progression: A Practical Roadmap (SQL Modern Analytics Engineering)
Cover image for Data Engineer Career Progression: A Practical Roadmap (SQL Modern Analytics Engineering)

Data Engineer Career Progression: A Practical Roadmap (SQL Modern Analytics Engineering)

Comments
5 min read
What Are the Best SQL IDEs for MySQL Database Development? Choosing the Right MySQL IDE

What Are the Best SQL IDEs for MySQL Database Development? Choosing the Right MySQL IDE

Comments
2 min read
Recommended GUI clients for easily switching between MySQL databases

Recommended GUI clients for easily switching between MySQL databases

Comments
1 min read
SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF
Cover image for SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF

SQL Normalization vs Denormalization Explained with 1NF, 2NF, and 3NF

Comments
2 min read
SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers

SQL Server vs PostgreSQL: A Practical Comparison for Modern Developers

Comments
3 min read
From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery

From Messy JSON to Health Insights: Building a Modern ETL Pipeline with DBT and BigQuery

1
Comments
3 min read
Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale
Cover image for Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

Building a Smart Bible Reading Reminder System - Personalized Push Notifications at Scale

Comments
12 min read
Generating AWR Reports in an Active Data Guard using RMF(12.2)

Generating AWR Reports in an Active Data Guard using RMF(12.2)

Comments
4 min read
3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

3 SQL Queries to Find Hidden WordPress Backdoors (When Plugins Fail)

1
Comments
3 min read
Automatic Flashback (or PITR) Standby

Automatic Flashback (or PITR) Standby

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