(605) SQL Server User Group

Meeting: Tue, Mar 14 2017

March 2107 Meeting

605 SQL will be meeting tomorrow at First Bank & Trust to discuss our upcoming SQL Saturday, which will be happening in August this year. Your feedback and support is important to planning another great event, so please come with ideas and let us know if you are willing to join the planning committee. At this meeting we will also be watching a 2015 PASS presentation by Itzik Ben-Gan, which is a great topic for any query writer. 605 SQL will be providing food and drinks, so be sure to RSVP using the link above.

Run, Total, Run!

There’s so much more to running totals than meets the eye. You can apply windowed running aggregate calculations and their variants (windowed ranking calculations) to solve a variety of T-SQL querying tasks elegantly and efficiently. This session shows you how. Some solutions that rely on running total calculations are downright beautiful and inspirational.

 

Speakers

We need speakers and topics for our meetings. If you are willing to present or have a topic you would like to discuss, please email 605 SQL.

 

Topics for Discussion

If you have a topic or question you would like to discuss, please submit your suggestion here or email 605sqlusergroup@sqlpass.org if you have questions.


When:

Tue, Mar 14 2017 Event Time: 17:30 - 19:00 Central Daylight Time
Your Local Time: Tue, Mar 14 2017 22:30 - 00:00
iCal


RSVP: https://www.surveymonkey.com/r/92F8DRK


Where:

2300 W 57th St - Sioux Falls, South Dakota (map)

None



Featured Presentation

SQLSaturday Discussion & Webcast

Speaker: Itzik Ben-Gan, T-SQL Trainer SolidQ

Summary: 605 SQL will be meeting tomorrow at First Bank & Trust to discuss our upcoming SQL Saturday, which will be happening in August this year. Your feedback and support is important to planning another great event, so please come with ideas and let us know if you are willing to join the planning committee. At this meeting we will also be watching a 2015 PASS presentation by Itzik Ben-Gan, which is a great topic for any query writer. Run, Total, Run! There’s so much more to running totals than meets the eye. You can apply windowed running aggregate calculations and their variants (windowed ranking calculations) to solve a variety of T-SQL querying tasks elegantly and efficiently. This session shows you how. Some solutions that rely on running total calculations are downright beautiful and inspirational.

 

About Itzik: Itzik Ben-Gan is a mentor and Co-Founder of SolidQ. A Data Platform Microsoft MVP (Most Valuable Professional) since 1999, Itzik has delivered numerous training events around the world focused on T-SQL querying, query tuning and programming. Itzik is the author of several books including T-SQL Fundamentals Third Edition and T-SQL Querying. Itzik’s speaking activities include SQLPASS, SQLBits, SQL Nexus, SQLU, SQLTeach and various user groups around the world. Itzik is the author of SolidQ’s Advanced T-SQL Querying, Programming and Tuning, and T-SQL Fundamentals courses, along with being a primary resource within the company for their T-SQL related activities.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids