sql

Posted on: 8/20/2020 - 5 min read

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...read more

Posted on: 12/1/2017 - 5 min read

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...read more

Posted on: 3/6/2017 - 5 min read

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 ...read more

Posted on: 4/2/2015 - 4 min read

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...read more

Posted on: 10/8/2014 - 5 min read

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...read more