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… Read More »TSQL Aggregation Strategies and Aggregating Data
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… Read More »Free SQL Server Training
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,… Read More »SSMS Results In A Separate Tab
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… Read More »Introducing the Joes2Pros Academy
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… Read More »End of June Summary
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… Read More »Allowing Inbound Connections to SQL Server on Windows Server 2012
For more information on cursors, also take a look at the free SQL query training provided by Steve Stedman. Cursors are a feature of SQL Server… Read More »T-SQL: A Simple Example Using a Cursor
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… Read More »DATEFROMPARTS function in TSQL
SQL Server 2012 adds many new features to Transact SQL (T-SQL). One of my favorites is the Rows and Range enhancements to the over clause.… Read More »Rows and Range, Preceding and Following
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… Read More »Select Favorite SQL Server 2012 Articles