I do my development work primarily on a late 2012 Macbook Pro Retina Display. It’s a fantastic machine, more powerful than anything else I’ve used before. But sometimes development can push it to the extremes. I run Parallels on my machine, with Windows 8.1, which I primarily use for Quicken 2012 and Steam and, Read More

The first step in creating a table is determining what type of data  you are storing. In many cases, the information you want to store is better held in multiple tables.  For example, you might have a single table for customers, a table for orders and a table for employees who take orders.  A, Read More

The first objective described on Microsoft’s 70-461 Querying Microsoft SQL Server 2012 exam is creating database objects.  Note that the SQL 2014 exams aren’t out as of yet, but the format will likely stay pretty close. So we’ll get started with the basic building blocks of a database. About tables Create and alter tables, Read More

I’ve been working on getting familiar in more detail with the new features of SQL Server 2014, and the first thing I discovered is that I’m woefully out of date on all matters SQL.  I’ve worked extensively with versions 7 though 2008, less so with 2012 and none (so far) with 2014. So, my, Read More