sqlHow 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
sqlDatabase 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
sqlHow 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
sqlHow 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
sqlHow 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
sqlThe 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
sqlHow 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
sqlHow 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
sqlA 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
sqlFirst 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
sqlWhen 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
sqlPreventing 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
sqlDatabase 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