Category Archives: Technology

For all posts related to technology including programming and web development.

T-SQL Fundamentals Chapter 2

In Itzik Ben-Gan's book, Microsoft® SQL Server® 2008 T-SQL Fundamentals, Chapter 2 introduces the SELECT statement focusing on queries against a single table. This chapter describes logical query processing including the series of logical phrases involved in producing the correct result set of a given SELECT query. Elements of the SELECT Statement 1. The purpose…
Read more

T-SQL Fundamentals Chapter 1

In Itzik Ben-Gan's book, Microsoft® SQL Server® 2008 T-SQL Fundamentals, Chapter 1 teaches some good basics for understanding database architecture: 1. SQL Server can contain multiple databases. The setup program creates several system databases that hold system data serving internal purposes. After installation, you can create user databases that hold application data. (p. 14) 2.…
Read more

SQL – A Look Back

Recently, I was asked to share my SQL experience with an interested professional. Since it has almost been three years since this coursework, I struggled to remember the training received. I have been out of school now for over two years. My last SQL class was Spring term 2012. This class was an Advanced SQL…
Read more

Installed Mojo Marketplace WordPress Theme

With the limited time I had tonight, I installed this Mojo Marketplace WordPress Theme to support my efforts to create a personal biography webpage. The theme is very slick. It will take some time to replace the default images with my own that will fit the style. At least I got the theme installed this…
Read more