The SQL Training was a lot of fun this week we covered Top, Ranking, NTILE, and Analytic functions in preparation for the Microsoft 70-461 exam. Next week Aaron Buma and I will be presenting Set Operators, Derived Tables and CTEs. The live …
SQL Query Training – Next Week – Set Operators, Derived Tables and CTEs Read more »
Based on this weeks Free SQL Server training on Aggregation, I have created a crossword puzzle with terms in the Aggregation session. Download the Printer friendly PDF Version: SQL Server Aggregation Crossword.pdf
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 …
TSQL Aggregation Strategies and Aggregating Data Read more »
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 …