Menu

database

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
Taking 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
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
6 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
Converting 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
Server-side pagination vs client-side pagination
Pagination is a vital UI/UX element that is usually overlooked by many developers. It makes navigating through data easier, but it comes at
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
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