Welcome

Welcome to the Iowa SQL Server Users Group!

Iowa SQL Server Users Group have been meeting once a month, normally on the second Wednesday. Please check out our new Meetup group at dsmsql.com.  Events will be posted there as well as here with any changes or added details updated  at dsmsql.com.

Learn tips and tricks from the professionals.  No sales pitch, just a bunch of Data Huggers getting together to learn something new!

If you have not registered with the Professional Association of SQL Server (PASS), please register here for free: http://www.sqlpass.org/.

 

 Next Meeting

Next Meeting: Mon, Sep 12 2016

IASSUG September Meeting

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/iassug-september-meeting-tickets-27261213022

Eventbrite - IASSUG September Meeting

Data Huggers Unite!

Join us Monday, September 12th, from 6-8 p.m. for food, drinks, and a presentation on Hive 2.0 at a new location:

Aureon

7760 Office Plaza Drive South

West Des Moines, IA 50266

(Wynnfield Building - West of Jordon Creek Parkway, behind the Marriott - Use the entrance on the East Side)

Be there or be square!

HortonWorks and Aureon are sponsoring.

Modern enterprises run on data. Open and Connected Data Platforms from Hortonworks enable an organization to manage all data, data-in-motion and data-at-rest to empower actionable intelligence for your organization whether the data is in the data center or in the cloud.

Aureon, the new name for the INS Family of Companies, is a business solutions provider who connects possibilities to productivity by providing unique and scalable business support services for organizations — small and large. Headquartered in the heart of the Midwest, and serving clients nationally with a presence in 48 states, Aureon offers a comprehensive suite of support services, with a focus on Technology, HR and Contact Center services. Aureon’s unique combination of talent, technology and tools enable clients to focus on their core business. For more information, visit www.Aureon.com.

 

Session Title: Hive 2.0: ACID and sub-second SQL latency with LLAP

Presenter: Scott Shaw

Track: Application & Database Development

Level: Beginner

Abstract: Hive has transformed over the years from a slow but scalable batch processing engine to an interactive, fully-featured SQL query tool. The next phase in Hive takes processing even further by providing an in-memory processing engine as well as ACID compliance providing insert, update, and delete capabilities. This presentation will explore the present and the future of Hive and provide you a roadmap into this fast-changing technology.

 

Scott Shaw has over a decade experience in data management. He is a frequent speaker at local and national community events with experience in ETL design, data warehouse modeling, and Hadoop architecture.  He has co-authored two books on T-SQL and is currently working on a book titled "Practical Hive” to be published by Apress publishing. He lives in Saint Louis and is a Sr. Solutions Engineer for Hortonworks.

 

Drinks and raffle afterwards.

When

iCal
UTC : Mon, Sep 12 2016 23:00 - 01:00
Event Time : Mon, Sep 12 2016 18:00 - 20:00 Central Daylight Time
Your Local Time: Mon, Sep 12 2016 23:00 - 01:00

Where



Direction: None

Featured Presentation

Hive 2.0: ACID and sub-second SQL latency with LLAP

Speaker: Scott Shaw, Sr. Solutions Engineer Hortonworks

Summary: Hive has transformed over the years from a slow but scalable batch processing engine to an interactive, fully-featured SQL query tool. The next phase in Hive takes processing even further by providing an in-memory processing engine as well as ACID compliance providing insert, update, and delete capabilities. This presentation will explore the present and the future of Hive and provide you a roadmap into this fast-changing technology.

About Scott: Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled "Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.

Attachments

 Announcements

Upcoming PASS Events

PASS Summit 2016 - Seattle

Join Us in Seattle, October 25-28, 2016 at the world’s largest gathering of SQL Server and BI professionals! Register here: http://www.sqlpass.org/summit/2016/RegisterNow.aspx and use code LC15JDL9 to save $150 off your registration.

Group Announcements

Join our meetup at dsmsql.com and become a Data Hugger!

We will post meeting details there as well as on LinkedIn and here so we can better enhance your IASSUG experience!

 

Strata + Hadoop World, happening September 26-29 is where cutting-edge science and new business fundamentals intersect and merge. It's a deep dive into emerging techniques and technologies. You'll dissect case studies, develop new skills through in-depth tutorials, share emerging best practices in data science, and imagine the future. Save 20% with discount code USRG. Check out the impressive agenda and speaker lineup.
http://www.oreilly.com/pub/cpc/20493

PASS Community News - July 2016 

 

Upcoming SQL Saturdays

 

SQLSaturday #548 - Kansas City - September 24, 2016

SQLSaturday #552 - Lincoln - November 19, 2016

 


 Future Meetings

We will post meeting information as soon as we receive confirmation on speaker and Microsoft Meeting Room reservation.