The Arizona SQL Server Users Group
Welcome to first Microsoft SQL Server user group to serve the Phoenix, Arizona metropolitan area. Our group focuses on the business and technical aspects of deploying and administering Microsoft's premier database and business intelligence system. Guided and often presented by our membership, meeting content is designed to enlighten the audience and provide timely insight.
Meetings and membership are free to anyone interested in learning more about Microsoft SQL Server and related products and technologies. We're continuing to grow! You too can be an insider to the many upcoming advances for SQL Server and related Microsoft technologies. Get plugged in!
If you have any questions, comments or suggestions drop us a line: AZSSUG@sqlpass.org . Our new twitter feed is @azssugsqlpass, #azssugsqlpass. We would love to hear from you!
- Garage parking is $1.50 per 30 minutes or $12 for 4 hours or more. They accept cash, check, Visa, Mastercard, and Discover. They do not accept American Express.
- There are parking meters in front of the building. The cost is 25¢ per 10 minutes, and may be paid in increments of 80 minutes at a time.
- There are light rail and bus stops at Mill and 3rd Street. After arriving at the stop, walk north on Mill for two short blocks. Microsoft is on the NE corner of Mill and Rio Salado in the Hayden Ferry Lakeside building. For further information and direction, please visit www.valleymetro.org.
- We are approximately a ¼ mile walk from Tempe Beach Park, where there is limited free parking. Please be aware that we cannot guarantee availability.
We meet on the second Wednesday of every month (with a few exceptions) and run from 4:30 to 6:00pm. Our group meets at the Phoenix Microsoft Offices at 60 E. Rio Salado Parkway, 12th Floor, in Tempe (at Tempe Town Lake).
The meeting calendar for 2015 is as follows:
June 30th - WVAZSSUG ( West Valley Arizona SQL Server Users Group) First meeting ever ! Details will follow.
July 8th - Improve SQL Server Performance Management with Extended Events - Jason Brimhall
July 7th - West Valley - Overview of DB Design & Coding Implementations - Jason Brimhall
August 12th - Matt Smith - What’s coming in SQL Server 2016?
September 9th - Martin Schoombee
October 14th - Josh Sivey
November 11th - Joe Barth SQLPASS Summit 2015 experience
December 9th - Holiday Party
We do not provide parking validations for attendees.
Event Type: In-Person
Online Meeting URL: None
RSVP URL: http://www.meetup.com/Arizona-SQL-Server-User-Group/
Hope everyone is having an awesome summer , come and join us at AZSSUG!
UTC : Wed, Sep 09 2015 23:30 - 01:00
Event Time : Wed, Sep 09 2015 16:30 - 18:00 (UTC-07:00) Arizona
Your Local Time: Wed, Sep 09 2015 23:30 - 01:00
60 E Rio Salado Parkway, 12th Floor
Martin Schoombee, Senior Lead Developer Catapult Systems
Running totals are a lot easier with the SQL Server 2012 (and later) T-SQL syntax, but making it perform over large data sets still remain a challenge. This demo-heavy session will explore the good, the bad and the ugly when it comes to calculating running totals.
Our main focus however, will be a method coined by Jeff Moden as the "quirky update". This method produces lightning-fast results when calculating running totals...sometimes the only option if you're dealing with large volumes and high performance requirements.
Microsoft-based Business Intelligence solutions have been my passion and focus for the past 10+ years.
Although I prefer (and have used) Kimball methodologies and design principles in the majority of my projects, finding the best solution is always my first priority. Thinking outside of the proverbial box is something I am used to while seeking feasible solutions to complex scenarios.
I have been responsible for building numerous data warehouses/marts from the ground up, and very comfortable leading all stages of the development lifecycle of BI projects...including the architecture, delivery and management thereof.
I consider my expertise to be in the areas of dimensional modeling, ETL development (and automation) and optimization of BI processes.
In addition to my Business Intelligence skills I also have some experience in web development (ASP; ASP.NET; HTML; COM+; VB Script) as well as limited exposure to Business Objects and Cognos.