sql

How to Use json_build_object in PostgreSQL to Aggregate Data
PostgreSQL’s `json_build_object` is your go-to when you want to return structured JSON data from SQL queries, especially for APIs or for log
Database Normalization: 2NF Explained
Okay, buckle up. We're diving into the world of database normalization, specifically hitting up **Second Normal Form (2NF)**. It sounds scar
How to Handle Deadlocks in SQL Server and How to Prevent Them
Deadlocks in SQL Server can bring your application to a grinding halt, frustrating users and potentially causing data integrity issues. Th
How to Reset Your Forgotten PostgreSQL Password on Windows
Forgetting the default root password that you set up 6 months ago in your PostgreSQL database installation is a part of being a developer. I
How to Handle Emoji Storage in SQL Server
If you’ve ever run into the dreaded ?? problem, this guide will walk you through how to properly configure your database to store emojis and
The transaction log for database 'tempdb' is full due to ACTIVE_TRANSACTION error
The error message "The transaction log for database 'tempdb' is full due to 'ACTIVE_TRANSACTION'" typically occurs when the transaction
How to check the size of your SQL Server Database tables
If you're running your web applications on a shared server, then you know all too well that often times there is a limit on the storage spac
How to connect a SQL Server database to a Node.js application: A beginner's guide
When you think of a Node.js project you typically think about either a PERN stack or a MERN stack implementation. Meaning you are either wor
A simple database schema for your next user system
The following is a relatively standard schema for a User table in a database. You can use this as a guide for when creating your own cutom a
First Impressions of Microsoft SQL Operations Studio
Microsoft recently unveiled their new Microsoft SQL Operations Studio (in preview) application for Windows, Linux, and Mac. SQL Operations
When To Use Code Vs When To Use SQL
Just recently I spent a few hours attempting to make an overly complex SQL query into a reality. From the beginning, it didn't really feel
Preventing SQL Injections With Parameterized Queries
In my previous post I wrote about a few steps that you can take to better secure your website. One of those steps, probably the most import
Database Normalization Is Good And Bad
Every developer does it subconsciously nowadays. We create a database schema and we normalize it without thinking about it. At least I hope