-
Normalization, Unions, Joins, and Locking in Microsoft SQL
What is a normalized database? Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. What is a SQL union/join? Unions combine rows. Joins combine columns. UNION combines the results…
-
Creating Custom Views in Microsoft SQL
In part 3 I continue building on the table structure I learned about in part 2 of my training on How to Use Microsoft SQL by learning about creating custom views. Creating the Tables To learn how to setup a custom view in Microsoft SQL, we setup a second table so that we could join…
-
Microsoft SQL Primary Keys
I’m in the process of learning SQL and in so doing have started learning Microsoft SQL using Microsoft’s SQL Management Studio. It’s a free program that’s used to open, manage, and edit Microsoft SQL databases stored on a server running Microsoft SQL (quick note: SQL is a database language used to store data in tables…
-
Self-Hosting Tips for WordPress
Thinking about hosting your own WordPress domain on your own server? Here are a few things to consider. If you use our hosting you are using a linux-based server running WordPress on a SQL database. If you hosted it yourself you would still have to have a linux server with access to a SQL database…