Professional Tips: 19 - Detailed Analysis

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

tejaswipandava

Oct 15

Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases

#architecture #database #sql

2 min read

Mahir Faysal

Oct 15

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

#mysql #sql #database #beginners

9 min read

Gowtham Potureddi

Oct 15

Design object storage (Amazon S3): the system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design a recommendation system: the ML system design interview walkthrough

#designsystem #interview #dataengineering #sql

17 min read

Gowtham Potureddi

Oct 15

Design a distributed job scheduler: the system design interview walkthrough

#designsystem #sql #interview #dataengineering

17 min read

Mete Kahyagil

Oct 15

PCAD-31-02 in Code: Validation Checks and Safe sqlite3 Queries Behind 30 of the 48 Items

#python #sql #datascience #tutorial

9 min read

Uptime Architect

Oct 14

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

#oracle #database #performance #sql

9 min read

Ravindu Thaksara

Oct 15

How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

#sql #database #mysql #devchallenge

4 min read

Kausar Raza

Oct 14

There Is Already an Object Named 'X' in the Database: What EF Core Is Really Telling You

#dotnet #csharp #database #sql

9 min read

Null

Oct 14

A patched SQL Server cluster stops syncing. The failure is identity, not the patch.

#sql #database #sqlserver #devops

3 min read

peter muriya

Oct 14

Subquery vs CTE in SQL: When and How to Use Each

#sql #postgres #database #beginners

3 min read

peter muriya

Oct 14

Primary Key vs Foreign Key in SQL: How Tables Connect

#sql #postgres #database #beginners

3 min read

Daniel Pertu

Oct 14

Our free plan hides creators with a window function, and the locked count is the same predicate with a "not" in front

#postgres #sql #typescript #saas

5 min read

Makori Nyachaki

Oct 18

Advanced SQL Analytics for Data Analysis.

#sql #postgressql #dataengineering #datascience

14 min read

Stacy Mumbi

Oct 18

Exploring Hospital Data: Window Functions, Joins, CTEs and Subqueries

#database #sql #tutorial

8 min read

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

DEV Community

select * from SQL

Optimistic Locking vs. Pessimistic Locking — Handling Concurrent Updates in SQL Databases

MySQL GROUP_CONCAT with ORDER BY, SEPARATOR and DISTINCT (Tested on 8.4)

Design object storage (Amazon S3): the system design interview walkthrough

Design a recommendation system: the ML system design interview walkthrough

Design a distributed job scheduler: the system design interview walkthrough

PCAD-31-02 in Code: Validation Checks and Safe sqlite3 Queries Behind 30 of the 48 Items

You Deleted 99% of the Rows. The Full Scan Didn't Get Any Faster.

How to Set Up SQL Server Management Studio (SSMS) on a Windows PC

There Is Already an Object Named 'X' in the Database: What EF Core Is Really Telling You

A patched SQL Server cluster stops syncing. The failure is identity, not the patch.

Subquery vs CTE in SQL: When and How to Use Each

Primary Key vs Foreign Key in SQL: How Tables Connect

Our free plan hides creators with a window function, and the locked count is the same predicate with a "not" in front

Advanced SQL Analytics for Data Analysis.

Exploring Hospital Data: Window Functions, Joins, CTEs and Subqueries