December 15, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

Virtualization Performance Tuning

Our featured Speaker, David Klee, will present the third of a three-part series that he is doing for the Iowa groups. Each presentation stands on its own, but also builds on the previous presentations in the series.

Series Overview:

12-13DSMData Platform
12-14I-380Infrastructure
12-15QCVirtualization Performance Tuning

David Klee

David Klee is a Microsoft MVP and VMware vExpert with a passion for the convergence of data, cloud, and infrastructure. David spends his days handling performance and HA/DR architecture of mission-critical SQL Servers as the Founder of Heraflux Technologies. His areas of expertise are virtualization and performance, datacenter architecture, and risk mitigation through high availability and disaster recovery. You can read his blog at davidklee.net, and reach him on Twitter at @kleegeek.

David speaks at a number of national and regional technology related events, including the PASS Summit, VMworld, IT/Dev Connections, SQL Saturday events, SQL Cruise, PASS virtual chapter webinars, and many SQL Server User Groups.


November 17, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

Backup Options in Azure

Database backups are the foundation of data protection in SQL Server. In Azure, backups for Azure SQL Database are managed, but there are options for both short- and long-term retention. Backups for SQL Server databases running on Azure VMs can be backed up using SQL Server Agent jobs. Alternately, these databases can be backed up using Azure Recovery Vault. Join me for this session to learn about these options, including demonstrations of set up and administration.

Frank Gill

Frank Gill is a Senior Data Engineer at Concurrency   With 19 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.


October 13, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

SQL Server Lockdown: Options for High Security Scenarios

We will cover options for high security scenarios in SQL Server.

Ed Leighton-Dick

Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including roles as regional mentor, chapter leader of I-380 PASS SQL Server User Group, and organizer of SQLSaturday Iowa City. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit. 


September 15, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

Introduction to Azure Data Studio


As days go by Azure Data Studio is becoming more and more powerful. This session will provide a high level overview of Azure Data Studio and highlight some of the differences from SQL Server Management Studio. We will cover saved connections, how to get both the actual and estimated Execution plans, workspaces and one of my favorite features, Notebooks. We also go over what an extension is and why I would want to use them.


David Bland

Manager of Database Administrators, Stericycle

Over 20 years of SQL Server experience that includes being a DBA, BI development and Application development using VB.NET. Dave currently is the Manager of the DBA team at Stericycle. Dave is a Friend of Red-Gate for 2019. He is a frequent presenter at SQL Saturday events and user groups around the country. Has been teaching SQL Server since version 2000 and is the SQL Server instructor at Harper College in Palatine, IL. Current certifications include: Microsoft Certified Trainer; MCTS: SQL Server 2008, Implementation and Maintenance; MCTS: SQL Server 2008, BI Development and Maintenance; MCSA: SQL Server 2008; MCSA: SQL Server 2016; MCSE: SQL Server 2016 – BI; MCDBA: SQL Server 2000; MCSD; MCSE: Data Management and Analytics.teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit. 


August 11, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

SQL and Authentication and Permissions, Oh My!

The fundamentals of SQL security can be confusing even for people who have used them for years. There are many combinations, but they are built on simple building blocks that fit together in concrete ways. Like DNA the combinations are almost endless, but the rules are few and easy to remember.

Pat Phelan

Pat Phelan joined a user group (DECUS) in High School, and many more since then. Pat was paid for his first program before he got his driver’s license. After many jobs (with some great stories) in High School and College, Pat worked over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team.  Involta builds, owns and operates world class colocation datacenters and provides managed services and support staff to clients.


July 14, 2021 Meeting

Event link at our Meetup page.

  • 5:30 pm Networking
  • 6:00 pm Meeting

SQL Server on AWS RDS The Other Cloud Alternative

SQL Server on Amazon Web Services (AWS) Relational Database Services (RDS) is Amazon’s PaaS offering for SQL Server. In this session you will learn how to create an SQL Server Instance, know the difference between running SQL Server on RDS versus SQL Server on Premise.

H. Ross Reed

H. Ross Reed is a Lead Database Administrator for the Options Clearing Corp. He has been a database administrator for over 20 years. He’s Co-Organizer of the Chicago Data Professionals User Group, and a frequent presenter.


June 9, 2021 Meeting

Event link at our Meetup page.

5:30 pm Networking
6:00 pm Meeting

Secrets of the Plan Cache

You have heard of a query plan, right?  Perhaps even looked at one somewhere a long the way.  Have you ever wondered what information might be buried in the plan cache, the courses of action having that additional information might lead you to?  Perhaps you have wondered what plans in cache would benefit from those missing indexes or contemplated your cost threshold of parallelism, among other questions.  This session is designed to answer just that.  We will look at query plans without the pretty node icons and from there we will interrogate the plan cache thus putting its secrets to work for us.

Peter Shore

Peter is a seasoned IT professional with over 25 years of experience, a frequent speaker at SQL Saturday, User Groups, and other conferences.  He took the accidentally intentional DBA plunge in 2013 and has discovered that he loves to find the stories the data has to tell.  Peter is comfortable working with both physical and virtual servers where he tries to apply best practices to attain performance improvements.  He is also adept at bridging the gap between technical and business language in order to bring technology solutions to business needs.

Additionally, Peter is the president of CBusPASS in Columbus, Ohio and co-organizer of SQL Saturday Columbus.


Dev Intersections 2021

Save $100 off registration – Use code QCDP100

Your registration gives you access to all three conferences.

 June 2021 (Hybrid: Attend virtually or in person)
 Location: Walt Disney World Swan and Dolphin Resort
 Dates: June 8-10, 2021 (Workshops June 6, 7 & 11)
 Discount Code: Use QCDP100 to save $100 off of registration! 
 Register Today! https://bit.ly/AzureSQL_June_Register 
 December 2021 (Attend in person)
 Location: MGM Grand, Las Vegas
 Dates: December 7-9, 2021 (Workshops December 5, 6 & 10)
 Discount Code: Use QCDP100 to get $100 off the registration! 
 Register Today! https://bit.ly/AzureSQL_DEC_Register   

May 5, 2021 Meeting

Event link at our Meetup page.

5:30 pm Networking
6:00 pm Meeting

Back to the Future with Temporal Tables

Back to the Future is the greatest time travel movie ever. I’ll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean. We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favorite: auditing. There’s even a bit of In-Memory OLTP. This is a demo-heavy session.

Randolph West

Randolph West (they/them) is an actor, author, and Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, you can see them acting on the stage and screen, or doing voices for independent video games. Randolph is available for mentoring, and talks on SQL Server and technology in general. Do not trust Randolph around chocolate.


April 14, 2021 Meeting

Event link at our Meetup page.

5:30 pm Networking
6:00 pm Meeting

Intro to Azure Synapse Analytics

I will introduce briefly Azure Synapse architecture and features, demonstrate how to Create and setup a Synapse workspace, extract data from azure data lake or azure SQL Databases then analyze the data with dedicated SQL pools, and serverless moreover how to Integrate with pipelines, and monitor Azure Synapse Workspace.

Jean Joseph

Jean Joseph is a Data Engineer/DBA, highly experienced in Traditional Database, and Big Data technologies with a history of successes in designing, implementing complex technical projects for diverse businesses in various stages of their development. Acknowledged as a leader capable of mentoring teams of different backgrounds and talents moreover inspiring individual efforts to deliver.