October 12, 2022 Meeting

Event link at our Meetup page.

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

DBATools: Migrating Database Servers

Times past SQL Server Instances were migrated using various scripts and checklists. While Checklists are always a good idea DBATools has made it easier using a few commands.

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.

September 14, 2022 Meeting

Event link at our Meetup page.

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

DevOps & CI/CD for Azure Synapse Analytics

DevOps is not just for developers.  If you are working with Data in the Cloud you need to understand how DevOps works for data.  In this demo heavy session we will set up a DevOps Repository, create a Dev Azure Synapse Analytics environment, link it to our Repository, create build & release pipelines, create our QA from an ARM template, and deploy our Dev changes to QA.  The goal of this session is to walk through the process from start to finish.

Bradley Ball

Bradley Ball is a Sr. Azure Engineer for the Azure FastTrack CXP PG at Microsoft, and uses his knowledge of data platforms to help onboard customers to Azure while working with Product Groups to refine Azure’s Data Services.  He is the FastTrack Service Lead working with the Azure Synapse Analytics, SQL Server PG’s.  He’s done some cool things like working as a Defense contractor for the U.S. Army and the Executive Office of the President of the United States for the Obama Administration.  Prior to joining Microsoft he was a Data Platform MVP.  He has presented at many SQL Saturdays, for Microsoft Data Platform User Groups across the US from California to Florida to New Hampshire and Puerto Rico.  A frequent presenter at conferences and community events, author of two books and many articles on SQL Server, and Co-Host of the Tales from the Field Streaming show.   He is passionate about enabling anyone using data to achieve greatness.

August 17, 2022 Meeting

Event link at our Meetup page.

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

A Practical Starter Guide to SQL Notebooks

Have you been hearing about SQL Notebooks in Azure Data Studio but haven’t worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you?

Let’s jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work! We will start by looking at the different options that are available to us in SQL Notebooks. Then we will examine real world scenarios and create notebooks for them. Finally, we will learn how we can share the notebooks with our coworkers.

When you leave, you will have the practical knowledge and comfort level to use SQL Notebooks in your day-to-day work.

Deborah Melkin

Deborah Melkin has been working as a database professional with SQL Server for over 20 years. She spends her days helping coworkers with all aspects of database design, queries, performance, documentation, and deployment. In 2016, she began her blog, Deb the DBA. Soon after that, she began speaking at SQL Saturdays and user groups. Deborah is a board member of the New England SQL Server User group (NESQL). She was named as an IDERA ACE Class of 2020, is a Friend of Redgate, and won Speaker Idol at PASS Summit 2019. Deborah is also a Microsoft MVP for the Data Platform.

In her spare time, Deborah can usually be found doing something musical or doing something geeky with her husband, Andy, and dog, Sebastian.

July 13, 2022 Meeting

Event link at our Meetup page.

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

Check Out My Tools!

Calm down, these are software tools and are probably all G Rated!

This is a quick and breezy introduction to the tools that I use regularly. It does not cover any of these tools in depth, it is intended as a glimpse into my toolbag to give you ideas, not a deep dive into using any or all of the tools I use regularly. This is a quicker, more light-hearted overview of a previous presentation titled Tips, Toys, and Tricks.

A few of these tools are purchased. A handful are services which vary in cost from free to OMG. The majority of the tools in this presentation are freeware or shareware (where you contribute if you like a product, especially if you want more features).

Depending on time, we may explore some tools in more depth after the presentation. If you have tools that interest you, feel free to ask about them in the Q&A.

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.

March 9, 2022 Meeting

Event link at our Meetup page.

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

Introducing SQL Server 2022 (Pre-recorded session)

Bob Ward – Principal Architect, Microsoft


SQL Server 2022 is here! In this session, I’ll go over all the new capabilities in SQL Server 2022 including how to connect with Azure for disaster recovery, near real-time analytics, and security. I will show you innovations in the database engine for security, performance, and availability including SQL Server Ledger. You will learn about enhancements to Query Store and the next generation of Intelligent Query Processing allowing you to gain performance with no code changes. You will love the demo for this one! I’ll also show you new extensions for the T-SQL language including data virtualization object storage, JSON functions, and time-series. Experts from the SQL Server engineering team will join me live to answer all of your questions. This is the session you won’t want to miss at the PASS Data Community Summit to learn about SQL Server 2022.


February 9, 2022 Meeting

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

So, you want to become a Cloud DBA?

You are a DBA and your company is planning to move all on-prem SQL Servers to Azure. You heard this plan from the management, got really excited but at the same time nervous about not knowing what will happen to your DBA job once moved to the cloud. Come join the session as you are going to learn how moving to the cloud will actually expand your responsibilities and career opportunities from an on-prem DBA to Cloud DBA. We will be having demos of how to create a Virtual Network, Virtual machine, Azure SQL database, different types of network securities available and how they differ from each other, and many more.

Deepthi Goguri

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification on Data Management and Analytics. Deepthi blogs for DBANuggets.com. Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is a Volunteer for Data platform Women in Technology user group. She is a Friend of Redgate. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.


December 21, 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.


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.