We are a group of professional users of Microsoft SQL Server dedicated to sharing knowledge with each other. We aim to increase the knowledge level of each member of the group and to increase the usefulness of the product for each member.
Windows Functions first emerged with the 2005 release – and were enhanced in 2012. They provide a window over the result set and the ability to access data other than the current row. This means that somethings that may - at first - seem like they need row-by-row processing can be done in one single set-based query. The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis. Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient – and cleaner – queries.
About the presenter:
Martin is a Consultant with SQL Masters Consulting in Brisbane, with close to 20 years of experience on the SQL Server Platform. He volunteers as a PASS Regional Mentor and speaks at many SQL Saturday events around Australia and New Zealand.
Martin started his IT career as a software developer, later becoming a database developer, a dba and more recently working across the entire Microsoft Data Platform
Connect with Martin:
LinkedIn :- http://www.linkedin.com/in/martincatherall
The information for the online event will be provided shortly.