Category: SQL 2012

TSQL Aggregation Strategies and Aggregating Data

This weeks training as part of the Free SQL Training for the 70-461 certification course is now available on YouTube. This week we covered Aggregating Data and Aggregation strategies.  For more information on sessions, take a look at the Free

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

Free SQL Server Training

I have been asked to help a development team with training so that they can all take and pass the SQL Queries 70-461 Microsoft certification. After looking it over and understanding all the topics needed for the 70-461 SQL Queries certification,

Posted in SQL 2012, SQL 2014 Tagged with: ,

SSMS Results In A Separate Tab

At the end of my SQL Saturday presentation today on Advanced Common Table Expressions, which is about the 12th time I have presented on CTEs, I was asked a question that I have been asked many times after I present.

Posted in SSMS 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:

End of June Summary

June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being CTE Month at to mark the release of my Common Table Expressions book. CTE

Posted in CTE, CTE Book, Database Health, SQL 2012 Tagged with: , , , , , , , ,

Allowing Inbound Connections to SQL Server on Windows Server 2012

A three and a half minute video showing how to configure SQL Server 2012 on Windows Server 2012 to allow for inbound connections on the default port of 1433. Steps: Configure SQL Server to use TCP connections. Allow inbound connections

Posted in SQL 2012 Tagged with: , , ,

T-SQL: A Simple Example Using a Cursor

For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. In SQL Server the cursor is a tool that is used to iterate over a result set, or to loop through each

Posted in SQL 2008, SQL 2012, SQL 2014, SQL 2016, SQL 2017, TSQL 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: , , , , , , , , , , ,

Select Favorite SQL Server 2012 Articles

The following articles are a collection of my favorite SQL Server related posts over the last 6 months. 3 Steps to Work More Efficiently in SSMS. Posted 2/17/2013 Recently the 3 Steps to Work More Efficiently in SSMS article was one of

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