Menu

sql

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