CACTUSS Central Monday 11/19 and CACTUSS North Tuesday 11/20

Eric Cox will be presenting this month on T-SQL Window Functions

Window Functions 101
What are they and why should I care?


If I had to name one concept in standard SQL that I thought was the most important one...
I'd say window functions, hands down, without a doubt.
-- Itzik Ben-Gan

My goal is for everyone to leave with both the knowledge and passion to use window functions in your current projects. Since most people haven't upgraded to 2012 all the examples will be in SQL Server 2008 R2.
We won't begin to cover all the nuances and syntax but rather will focus on a few simple and useful examples with broad application.

Note:  In a future talk I'll expand on this to discuss SQL Server 2012's additional functions and the syntax variations.

Eric Cox is a Microsoft Certified Software Developer with over 20 years experience building data driven solutions.
His work experience has included a large range of solutions:
-- Geography: Texas, Florida, Ohio, California, Alaska (North Slope), Washington DC, Germany
-- Industries: Healthcare, Government, Defense, Petroleum, Non-Profit, Bio-medical Research
-- Tools: C#, SQL Server 2008 R2, Java and Oracle
-- Types: From video game development to commercial application to multi-year, enterprise data migrations to data warehousing

CACTUSS CENTRAL:
We meet every third monday at the Experis Austin offices
www.bing.com/maps/

The meeting starts at 6:00 PM with the main presentation starting at 6:30 PM

Address:
Experis IT
301 Congress Avenue, Suite 360
Austin, TX 78701

PARKING: Upon arriving at Experis, you may part on the street for free after 5:30PM CST. We will not validate parking in the building garage.

CACTUSS NORTH:

We meet every third Tuesday at the Microsoft South Central District offices.
www.bing.com/maps/

The meeting starts at 5:30PM CST with food and a QA session. Main presentation is at 6:00PM CST.

Address:
Quarry Oaks II
10900 Stonelake Blvd., Suite 225
Austin, TX 78759
Phone: (512) 795-5300
Fax: (512) 343-8498

PARKING: Upon arriving at Quarry Oaks II, you may park on the surface lot in the front of the building or in parking garage at the back of the building.