Category: TSQL 2012

Using The TSQL EOMONTH Function

Here is a quick video training on how to use the T-SQL EOMONTH function on SQL Server. This was originally part of my free SQL query training for the 70-461 certification exam. The EOMONTH function returns the last day of a given

Posted in 70-461 Training, TSQL 2012 Tagged with: , , , , , ,

Introducing the Joes2Pros Academy

The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Students can interact with other students and instructors

Posted in Academy, DBA, SQL 2012, TSQL 2012 Tagged with:


SQL Server 2012 adds a new function called DateFromParts.  This new function simplifies the creating of a DATE type in TSQL over the older ways of doing it. The information here has been extracted from my SQL Saturday presentation on Whats New in

Posted in 70-461 Training, SQL 2008, SQL 2012, SQL 2014, TSQL, TSQL 2012 Tagged with: , , , , , , , ,

Rows and Range, Preceding and Following

SQL Server 2012 adds many new features to Transact SQL (T-SQL).  One of my favorites is the Rows/Range enhancements to the over clause. These enhancements are often times referred to as the windowing functions. Overview: ROWS PRECEDING, FOLLOWING, UNBOUNDED, refers

Posted in Analytic TSQL, SQL 2012, TSQL, TSQL 2012 Tagged with: , , , , , , , , , , ,

T-SQL 2012 Procedure sp_describe_first_result_set

SQL Server 2012 adds a new stored procedure called sp_describe_first_result_set.  This new procedure returns metadata for the result set returned from a query. The metadata is information about what the results will look like.  sp_describe_first_result_set is an alternative to sp_columns, and appears

Posted in SQL 2012, SQL Saturday, TSQL, TSQL 2012 Tagged with: , , , , , , , ,

Happy Birthday SQL Server 2012

It has been a year since SQL Server 2012 released. There were some fun posts on Twitter about the SQL Server 2012 birthday or anniversary. For instance: and another anniversary query (which doesn’t actually run): 1 year out since SQL

Posted in SQL 2012, TSQL, TSQL 2012 Tagged with: , , , , , , ,

Using a SEQUENCE object to generate letters.

SQL Server 2012 introduces a new T-SQL object used to generate numbers, a SEQUENCE, similar to an identity column. You can think of a sequence as a take a number object, you just ask it to give you a number, and you get

Posted in TSQL, TSQL 2012 Tagged with: , , , , , , ,

SQL Server 2012 IIF Statement

SQL Server 2012 introduces the IIF statement. It is very similar to the IIF statement in MS Access. I have extracted the IIF part of my presentation on Whats new in SQL Server 2012, and turned it into a video

Posted in SQL 2012, TSQL 2012 Tagged with: , , , , , , ,

Home after Seattle (Redmond) Code Camp 2012

What a great day at  Code Camp today. Click here to download the slides and sample code from the presentations. The first presentation that I attended was  Accelerating your Development Workflow presentation by Ian Davis.  What a great presentation, it touched

Posted in Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012 Tagged with: , , ,

Code Camp in Redmond Today—

I am headed to Code Camp in Redmond WA today.  I ended up with 3 sessions that I will be presenting, and I am really looking forward to the day. I am looking forward to attending the Accelerating your Development Workflow presentation

Posted in Analytic TSQL, Classes, Code Camp, CTE, TSQL 2012 Tagged with: , , , , , , , ,