• IASSUG July Meeting!
    Data Huggers Unite! Join us Monday, July 9th, at the Helpful Smiles Technology building from 6-8 p.m. for food, drinks, and networking. HST 3801 S. James St. Suite 400 Grimes Iowa 50111 Register here: https://www.eventbrite.com/e/iassug-july-meeting-tickets-47577089355 Be there or be square! Session Title: T-SQL Window Functions and Performance Presenter: Kathi Kellenberger T-SQL window functions, introduced in 2005 with enhancements in 2012, are great additions to the T-SQL language. Kathi will explain what you need to know to get good performance when using these functions. Kathi Kellenberger is the Editor of Simple Talk and a Microsoft Data Platform MVP. She has worked with SQL Server for almost 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. More details to follow!

    HST

    3801 South James Street · Grimes

  • IASSUG June Meeting!
    Welcome Data Huggers! Beat the Heat on Wednesday, June 27th, from 6-8 p.m. at the HST Center in Grimes where our own Jana Bagwell will be presenting! Our sponsors are Signature Consultants and Hy-Vee. Register here: https://www.eventbrite.com/e/iassug-june-meeting-tickets-46639065701 Space is limited, so please register only if you will attend. I hope to see you there!

    HST

    3801 South James Street · Grimes

  • IASSUG April Meeting!
    Welcome Data Huggers! Our next meeting will be Wednesday, April 18th, from 6-8 p.m. at the HST Center in Grimes for food, drink, and sharing and general tom-foolery. Our sponsors are offering some gift cards for dinner for two at Rube's Steak House to a user group member who would like to do a presentation on a topic of your choice! I need one for this meeting, as well as some more for future meetings. Please email me promptly at [masked] if you are interested in presenting. Register here: https://www.eventbrite.com/e/iassug-april-meeting-tickets-44861791827 Pure Storage and Rubrik will be sponsoring again this month. Anthony Counsell, Systems Engineer, Pure Storage and Mark Murphy, Systems Engineer, Rubrik, will be present to answer questions and tweak our palettes. Presentation: It's a Mystery! Space is limited, so please register only if you will attend. I hope to see you there!

    HST

    3801 South James Street · Grimes

  • IASSUG March Meeting!
    Welcome Data Huggers! Our next meeting will be March 29th, from 6-8 p.m. at the HST Center in Grimes for food, drink, and knowledge. I am offering a gift card for dinner for two at Rube's Steak House to a user group member who would like to do a presentation on a topic of your choice! Please email me at [masked] if you are interested in presenting. Register Here:https://www.eventbrite.com/e/iassug-march-meeting-tickets-44341026203 Pure Storage and Rubrik will be sponsoring. Anthony Counsell, Systems Engineer, Pure Storage and Mark Murphy, Systems Engineer, Rubrik, will present on Optimizing SQL performance, deployment environments and data protection with Pure Storage and Rubrik. Our second presenter could be one of you! If not, we will have a troubleshooting forum for anyone with an issue. Space is limited, so please register only if you will attend. I hope to see you there!

    3801 S James St #400

    3801 South James Street · Grimes

    1 comment
  • IASSUG December Meeting
    Happy Holidays!! I apologize for the lapse in meetings as things were a little hectic for a few months. That said, I'm happy to announce a new location for our meetings at the new Google-esque Hy-Vee Helpful Smiles Technology building just west of the Toyota dealership on 141 in Grimes, IA. Come and join me for an evening of SQL Server and pizza! Hy-Vee will be sponsoring and will give us all a tour of some of the facilities like Madison Square Gardens, the gym and workout areas, the gaming area, and possibly Sheldon's living room from the Big Bang Theory! We will conduct our meeting in the 'Master Chief' meeting room so our registrations will be limited to 30 people. Microsoft MVP Ed Leighton-dick, will be presenting. Ed leads I-380 PASS, the Iowa City chapter of the Professional Association for SQL Server (PASS) and organize s our local SQL Saturday events. He is also a frequent volunteer with PASS in other capacities, including Midwest Regional Mentor. He speaks frequently at local, regional, and national events, including user groups, SQL Saturdays, Iowa Code Camp, and the PASS Summit. Topic: SQL Server: Now It’s Everywhere You Want to Be (SQL Server on Linux) Have you heard the news? SQL Server is coming to Linux! What? That can’t be right… or can it? With the release of SQL Server 2017, Microsoft really is bringing SQL Server to the Linux platform. They’ve also added support for running SQL Server in Docker containers. How does it work? And how well does it work? In this session, we’ll answer these questions (and more!), and we’ll talk about how this enables some interesting new possibilities for DevOps. We are limited to only 30 attendees so Register Now below: https://www.eventbrite.com/e/iassug-december-meeting-finally-tickets-40913618735

    3801 S James St #400

    3801 South James Street · Grimes

    2 comments
  • IASSUG July Meeting
    Data Huggers Unite! Join us Thursday, July 13th, downtown at Country Club Office Plaza - Monterey Building (7780 Office Plaza Drive, Suite 140, West Des Moines, IA 50266 - That is the building at the west end of the circle and the entrance is on the west side) from 6-8 p.m. for food, drinks, and networking. REGISTER HERE: https://www.eventbrite.com/e/iassug-july-meeting-tickets-35545997034 Be there or be square! IASSUG and SentryOne and Signature Consultants are sponsoring. Session Title: T-SQL Tips & Tricks to Make Your Life Easier Presenter: Andy Yun Andy is a Senior Solutions Engineer at SentryOne and Chapter Leader of the Chicago Suburban SQL User Group Do you spend your days slinging T-SQL code? Want to improve your T-SQL game? If you answered yes, then this session is for you. This demo-intensive session will showcase a collection of my favorite beginner and intermediate level tips and tricks. We will explore how to identify and fix some common T-SQL anti-patterns, my favorite SSMS productivity tricks, and clever solutions to some common but not easily-coded challenges. This session targets both developers and DBAs; the only prerequisites are the desire to write better T-SQL code and aim of living an easier life! Drinks and food provided by IASSUG and SentryOne.

    Country Club Office Plaza

    7780 Office Plaza Drive South, Suite 140 · West Des Moines, IA

  • IASSUG May Meeting!
    Data Huggers Unite and help celebrate Spring! Join us Thursday, May 25th, downtown at Gravitate (206 6th Avenue, 3rd Floor, Des Moines, IA 50309) from 6-8 p.m. for food, drinks, and networking. Register here: https://www.eventbrite.com/e/iassug-may-meeting-tickets-34596838074 Be there or be square! IASSUG and EMC is sponsoring. Our own Arthur Daniels will be presenting! Session Title: Murphy's Database Session Description: If you've ever deployed code that broke something in Prod, welcome to the club! Murphy's Law states that anything that can go wrong, will go wrong. We'll take a look at some of the settings and code in your database that can catch you by surprise. Take the checklist from this session and see how many warning signs your environment has

    Gravitate

    206 6th Avenue · Des Moines, IA

  • IASSUG February Meeting
    Data Huggers Unite! Join us Thursday, February 23rd, downtown at Gravitate (206 6th Avenue, 3rd Floor, Des Moines, IA 50309) from 6-8 p.m. for food, drinks, and a presentation on 'Execution Planning for Success' by our own Arthur Daniels! Register here: https://www.eventbrite.com/e/iassug-february-meeting-tickets-31833115706 Be there or be square! IASSUG and EMC is sponsoring. Session Title: Execution Planning for Success Presenter: Arthur Daniels Arthur Daniels is a Database Administrator at TMG, a group service provider in West Des Moines. Arthur has worked on SQL Server for three years, two years as a Business Intelligence Developer and one year as a Database Administrator. He has experience in SSRS, SSIS, query optimization, and the SQL Server Engine. Execution plans are one of the best ways to learn how SQL Server is interpreting your T-SQL. We'll discuss execution plan internals, what SQL Server is hiding, and some of the best ways to identify pain points within your system. Drinks and food provided by IASSUG and EMC.

    Gravitate

    206 6th Avenue · Des Moines, IA

  • IASSUG January Meeting
    Data Huggers Unite! Join us Wednesday, January 18th, downtown at Gravitate (206 6th Avenue, 3rd Floor, Des Moines, IA 50309) from 6-8 p.m. for food, drinks, and a presentation on 'SQL Server SSIS' by our own Kristeen Sellers! Register here: https://www.eventbrite.com/e/issug-january-meeting-tickets-30736322167 Be there or be square! HortonWorks and EMC is sponsoring. Session Title: SQL Server SSIS Presenter: Kristeen Sellers Kristeen Sellers has been working in the database field over 20 years in the areas of ETL, Database Administration and Analysis. Her background includes the industries of Finance, Health/Life Insurance, Utilities, Manufacturing and Healthcare (clinical, administrative and information technology) She has a deep passion for the BI space and has seen this space develop and mature over the years. Her experience in this space has a foundation in SQL Server, ETL, Reporting and Data Warehousing. Topic: Hadoop Presenter: Bill Preachuk 2+ decades of experience doing all forms of data-related work - Development, Database Administration, Kimball methodology Data Warehousing, Server/Security Assessments, Performance Tuning, System Architecture. Current focus is on Hadoop with a specialization in the "meat & potatoes" of the ecosystem: Hive, Pig, Sqoop, Flume, NiFi, Data Movement, ETL Offload and Data Archival. Bill particularly enjoys educating and presenting on Hadoop, Data, and DBA-related topics to the wide variety of User Groups he's been associated with. These include Analytics, Database (PASS) & Hadoop User Groups https://www.linkedin.com/in/billpreachuk Drinks and food provided by HortonWorks and EMC. Gift Card Raffle will be held afterwards.

    Gravitate

    206 6th Avenue · Des Moines, IA

  • IASSUG December Meeting
    Data Huggers Unite! Whether you've been naughty or nice - Join us Thursday, December 15th, downtown at Gravitate (206 6th Avenue, 3rd Floor, Des Moines, IA 50309) from 6-8 p.m. for food, drinks, and a presentation on 'Making SQL Server Easy Peasy' by me, Fred Botts from Aureon. Register here: https://www.eventbrite.com/e/iassug-december-meeting-tickets-29656733087 Be there or be square! EMC is sponsoring. Session Title: Making SQL Server Easy Peasy Presenter: Fred Botts I'll be showing you things to make your life easier inside of management studio, as well as a few free tools you can get to help out also. Drinks and food provided by EMC. Gift Card Raffle will be held afterwards.

    Gravitate

    206 6th Avenue · Des Moines, IA

    3 comments