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