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.
Renaming a column in SQL Server, and what it quietly breaks
woodfiresam profile
Sam

Renaming a column in SQL Server, and what it quietly breaks

#sql #sqlserver #database #refactoring
Comments
4 min read
Your price alert may be a store switch in disguise
dataspryva profile

Your price alert may be a store switch in disguise

#datascience #python #analytics #sql
Comments
7 min read
MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying
tbson87 profile

MySQL ALTER TABLE: Which Changes Lock the Table, and How to Make One Fail Instead of Copying

#mysql #database #sql #devops
Comments
11 min read
I built a Windows SQL client where an LLM drafts the query and you stay in control
mirinai_ai profile

I built a Windows SQL client where an LLM drafts the query and you stay in control

#showdev #sql #database #abotwrotethis
Comments
2 min read
CREATE UNIQUE INDEX terminated because a duplicate key was found
woodfiresam profile
Sam

CREATE UNIQUE INDEX terminated because a duplicate key was found

#sql #sqlserver #database #dba
Comments
4 min read
How to Mask Sensitive Data in SQL: Make a Safe Database Copy
roxana_haidiner profile

How to Mask Sensitive Data in SQL: Make a Safe Database Copy

#sql #database #software #programming
2
Comments
7 min read
How to Build an IT Asset Lifecycle Management System with Node.js and PostgreSQL
arbaz_mr profile
Arbaz

How to Build an IT Asset Lifecycle Management System with Node.js and PostgreSQL

#node #postgres #sql #tutorial
Comments
10 min read
SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High
kailas_warade_d2a15d1ef8a profile

SQL CASE WHEN: How to Categorize Employee Salaries into Low, Medium, and High

#sql #database #programming #tutorial
Comments
2 min read
Goravel belongs to relationships and foreign keys
krishankumar01 profile

Goravel belongs to relationships and foreign keys

#go #database #sql #tutorial
Comments
10 min read
Goravel has many relationships and N+1 queries
krishankumar01 profile

Goravel has many relationships and N+1 queries

#go #database #performance #sql
Comments
9 min read
Equality deletes have no address, and that's why your Iceberg reads crawl
kyien profile

Equality deletes have no address, and that's why your Iceberg reads crawl

#dataengineering #iceberg #sql #flink
Comments
7 min read
Six predicates in this codebase are written twice, once in TypeScript and once in SQL
daniel_pertu profile

Six predicates in this codebase are written twice, once in TypeScript and once in SQL

#sql #postgres #typescript #testing
Comments
7 min read
Database Transaction là gì? Phân biệt Transaction và SQL thông thường
nddev_18 profile

Database Transaction là gì? Phân biệt Transaction và SQL thông thường

#backend #database #interview #sql
Comments
5 min read
Your city chart can name a filter that never took effect
dataspryva profile

Your city chart can name a filter that never took effect

#datascience #python #analytics #sql
Comments
6 min read
Defining revenue for an SQL agent, one row at a time
panditshivam profile

Defining revenue for an SQL agent, one row at a time

#sql #database #ai #python
Comments 1
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.