databaseHow 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
databaseHow 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
databaseA 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
databaseHow 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
databaseDatabase fundamentals every programmer should know
If you are new to working with databases, then this article is for you. In this post I will break down what databases are, how they are
databaseHow 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
databaseHow 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
databaseTaking a look at 1st Normal Form (1NF): Database design
In the world of database creation, normalization is a very important process that ensures the efficiency, integrity, and organization of dat
databaseHow 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
database6 Beginner tips when working with databases
At some point in your programming career, you are going to have to work with a database. You might need to modify a schema, or to add a reco
databaseConverting SQL Server to MongoDB in 2021
Just recently I wrote about why you might want to consider using a NoSQL database like MongoDB over the more traditional relational model of
databaseDatabase 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