Menu

database

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