- IASSUG August Meeting!
Data Huggers Unite! Join us on Monday, August 12th, at HST for Food, Fun, and networking! Mark Murphy and Rubrik will be sponsoring. Register here: https://www.eventbrite.com/e/iassug-august-meeting-tickets-67021480051 Meeting Topic: Optimizing Microsoft Access with SQL Server SQL Server DBA’s are often asked to take over a Microsoft Access application that has become mission-critical, the conversation usually goes like “You’re a DBA and Access is a database, so take over this system and upgrade it to SQL Server...”, but simply moving the data over may not guarantee better performance and can even make matters worse. The reality is Access can be much faster with SQL Server, allowing many more users, improving stability and safeguarding your data over a regular Access database. In this session, Juan Soto, the only Access MVP in Illinois, will discuss how to avoid pitfalls with performance, the proper method to designing tables for Access and how to leverage stored procedures and views with pass-through queries. Speaker Bio: Juan Soto is a frequent speaker at SQLSaturdays.com and prolific author of articles at the official Microsoft Access blog, including being the only Access developer to be profiled on the site. He’s also the founder of AccessUserGroups.org, a worldwide organization of user groups that meet virtually online to discuss Access topics each month in multiple languages and countries. When he’s not presenting he’s managing one of the largest practices of Access consulting in the world at AccessExperts.com. I hope to see you there!
- 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!
- 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!
- 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!
- 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!
- 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
- 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.