Iowa SQL Server User Group

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  Events will be posted there as well as here with any changes or added details updated  at

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:


Next Meeting

Next Meeting: Wed, Jul 13 2016

How to Maximize Your Use of Power BI

Language: English
Event Type: In-Person
Online Meeting URL: None

Come join us for a night of fun, food, and drink on July 13th from 6-8 p.m. at Exile Brewery!

Pyramid Analytics is sponsoring and presenting on How to maximize your use of Power BI.

Register here to attend:


UTC : Wed, Jul 13 2016 23:00 - 01:00
Event Time : Wed, Jul 13 2016 18:00 - 20:00 Central Daylight Time
Your Local Time: Wed, Jul 13 2016 23:00 - 01:00


Direction: None

Featured Presentation

How to Maximize Your Use of Power BI

Speaker: Andrew Mauch, Director of Sales-North Central, Midwest Pyramid Analytics

Summary: Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique: • A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis • A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise • The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision • Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content • Merging advanced visuals and powerful analytics provides real-world utility, and gives users the power to answer challenging organizational questions. Hear about these unique capabilities as well as Pyramid's integration with Power BI.

About Andrew: Andrew Mauch is a results oriented sales and management professional striving to help companies unlock the power of their data. Andrew has spent several years managing a consulting organization that built custom BI solutions from the Microsoft platform. Seeing how companies struggled with BI and complex builds, led him to join Pyramid Analytics where BI is made simple, putting the power of BI in the end users hands with the governance of IT.

Functions Every SQL User Should Know

Speaker: Pete Halaczkiewicz, SQL DBA/Developer R&R Realty Group-West Des Moines, IA

Summary: We will cover real world uses for functions that can help you compile and analyze data. First, we will go over the CONCAT and STUFF functions. Knowing how to use these functions can really help you simplify your queries, making them easier to read and manage. Then we will cover uses for some Ranking Functions, specifically, examples of DENSE_RANK, NTILE, RANK, and ROW_NUMBER and how they can help you analyze your data.

About Pete: Pete has over 10 years of SQL experience, specializing in application support, reporting and data analysis. Pete’s current job role at R&R Realty Group includes maintaining the database environment, creating ETL processes, report development, optimization, and front end application support. He previously worked at DLL in Johnston as a Tier 3 production support analyst supporting SQL production environments globally including Dynamics. His role there included front end and database support, deployment, testing, and development as well as acting as team lead for an application support team in India. He has previously worked at Wells Fargo as an Analytics Consultant specializing in process improvement, data analysis, and reporting process development.



Group Announcements

Join our meetup at and become a Data Hugger!

Attending PASS Summit?

Anyone who registers for PASS Summit 2018 using the discount code below will be granted a $150 USD discount off the registration price! 

The unique discount code for the Iowa SQL Server User Group is:




Upcoming Events

Our next meeting will be on July 9th.  Stay tuned for more details.

Future Meetings

We will post meeting information as soon as we receive confirmation on speaker and location. 










Back to Top