• IDPA-DSM - H. Ross Reed "SQL Server on AWS RDS The Other Cloud Alternative"

    The Des Moines branch of the Iowa Data Professionals will meet as usual on the second Monday of the month, July 12, 2021.

    **This meeting will be 100% online, there will be no in person meeting **

    Join us at 5:30 PM Central Time (22:30 UTC) we will meet for discussion and networking with announcements at 5:50PM.

    At 6:00 PM Central Time (23:00 UTC) H. Ross Reed will present "SQL Server on AWS RDS The Other Cloud Alternative."

    The presentation information follows:

    Meeting Topic: 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 differences between running SQL Server on RDS versus SQL Server on Premise.

    Speaker Bio: 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.

  • IDPA-DSM - "A Query Runs Through It: An Introduction to the SQL Server Engine"

    ** IDPA-Des Moines will meet virtually in June 2021. There will be no meeting in-person until it is safe again after COVID-19 **

    Join us at 17:30 CDT/22:30 UTC (aka 5:30 PM in Des Moines, IA) for social discussion, networking, etc.

    A technical presentation by Peter Shore will follow at 18:00 CDT/23:00 UTC (6:00 PM)

    Title: A Query Runs Through It: An Introduction to the SQL Server Engine
    Level: 200

    Summary:
    A query is executed, results are returned. Have you ever wondered what happens behind the scenes once the query is started? Pull back the curtain with this introduction to SQL Server internals.

    Abstract:
    Have you ever wondered what happens inside SQL Server when you execute that query you wrote? This session will serve as an introduction to what is going on under the hood, commonly called SQL Server Internals. Whether writing queries or tuning them, SQL Server internals knowledge is highly valuable in Azure VMs or SQL DB, AWS, GCP, and on-premises as the SQL Server engine is the same. Together we will dip into why data types matter, ponder pages, sample the storage engine, and ponder the query processor as we see what happens when your query runs.

    Speaker Bio:

    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.

    1
  • IDPA-Des Moines May 2021 Meeting

    Online event

    ** IDPA-Des Moines will meet virtually in May 2021. There will be no meeting in-person until it is safe again after COVID-19 **

    Join us at 17:30 CDT/22:30 UTC (aka 5:30 PM in Des Moines, IA) for social discussion, networking, etc. A technical presentation by Deepthi Goguri will follow at 18:00 CDT/23:00 UTC (6:00 PM)

    "Don't try it, Own it - Query Store feature on your Servers!"

    Are you facing performance issues due to the parameter sensitive queries? Are many plans being generated for your queries and you cannot control choosing the plan best for your query?

    Come learn in this session how we can capture the different plans generated for those queries and decide which plan you can force for better performance using the Query Store feature.

    Query Store feature introduced in SQL Server 2016 and has advanced its features introducing Wait stats per Query plan and Automatic Plan correction feature in SQL Server 2017 and Azure SQL database which will force the plans and resolve the issues automatically for you. Sound’s amazing, right?

    Join Deepthi to know all about the Query Store feature and its advancements in detail so you can implement them to take advantage of this Awesome feature!

    Speaker Biodata:

    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.

    1
  • IDPA-Des Moines April Meeting - Intro to Azure Synapse Analytics

    *** IDPA-Des Moines will meet virtually in April 2021. There will be no meeting in-person until it is safe again after COVID-19 ***

    Join us at 17:30 CDT/22:30 UTC (aka 5:30 PM in Des Moines, IA) for social discussion, networking, etc.

    A technical presentation by Jean Joseph will follow at 18:00 CDT/23:00 UTC (6:00 PM)

    Abstract:

    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 server-less moreover how to Integrate with pipelines, and monitor Azure Synapse Workspace.

    Bio:

    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.

    2
  • IDPA-Des Moines March Meeting - Intro to Query Store

    *** Due to COVID-19, until further notice, IDPA-Des Moines will hold only Virtual Meetings. No in-person attendance. ***

    The virtual meeting link will be active at 5:30PM CST to allow for fellowship and announcements prior to 6PM CST when we introduce our speaker.

    Topic: Intro to Query Store

    Description: In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse in 2016.

    Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

    In this session, we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016, 2017, and 2019.

    Speaker: Tracy Boggiano is currently a Data Platform MVP, PASSion 2020 Award winner, and works as a Senior Database Administrator for DocuSign. Tracy has worked on SQL Server since 6.5. She has spoken at numerous local user groups and SQLSaturdays, virtual groups, Data Relay, and Summit. She is currently a co-leader of the Triangle SQL Server User Group in Raleigh, NC. Tracy tinkered with databases in middle school to keep her sports card collection organized and got an early start on databases. (https://tracyboggiano.com/about-me/)

    1
  • Advanced PowerShell for the DBA (night 1 of three) - Des Moines

    Ben Miller will present Advanced PowerShell for the DBA February 8-10, 2021. One night for each of the three Iowa SQL User Groups!

    Please join us at 5:30 PM Central Time (23:30 UTC) for conversation and local group announcements. The technical presentation will start at 6:00 PM Central Time [masked]:00 UTC)

    ----

    Night 1: Modules Deep Dive (DBAtools, DBAchecks, SqlServer, ImportExcel, PoshRSJob, PendingReboot)

    PowerTools for the DBAs

    Getting the PowerTools

    Diving in Deep Water (PowerShell is Blue)

    Abstract: Have you been using PowerShell doing DBA work for a while? Have you wanted to take it to the next level? This session will take you through the tools and things you really want to know so you can get the most out of PowerShell as DBA. I will introduce you to the tools that you will learn and may even already use. We will discuss how to get them, even if you are not on the latest PowerShell version. Then we will go deep into setting up your environment to get you productive in a short amount of time. All this will set up the next session to go further.

    1
  • Des Moines PASS (IASSUG) Virtual Meeting - January 11, 2021

    Title: "SQL Server Internals and Architecture"

    Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Cache in SQL Server, Relational Engine, Storage engine and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer choose the plans. We will also cover what happens under the covers during read and write operations within SQL Server. This session also has Demos showing how components of SQL Engine works for queries.
    Deepthi will show you how the SQL engine thinks – enabling you to think like it!

    Speaker: Deepthi Goguri

    Deepthi is a Database administrator with 7 years of experience.She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter: https://twitter.com/dbanuggets

    4
  • Des Moines PASS (IASSUG) Virtual Meeting - December 7, 2020

    *** Due to COVID-19, until further notice, IASSUG will hold only Virtual Meetings. No in-person attendance ***

    Title: Think like the Cardinality Estimator

    Description:

    SQL Server uses a phase during query optimization, called cardinality estimation (CE). This process makes estimates bases on the statistics as to how many rows flow from one query plan iterator to the next. Knowing how CE generates these numbers will enable you to write better TSQL code and, in turn, influence the type of physical operations during query execution.

    Based on that estimated rows, the query processor decides how to access an object, which physical join to use, how to sort the data. Do you know how the CE generates these numbers? What happens when you have multiple predicates, range predicates, variable values that are 'NOT KNOWN' to the optimizer, or you have predicate values increasing in ascending order? Do you know what will happen if your predicate is using a value that is outside of the histogram range?

    In this session, I will show you how CE estimates in all these scenarios, and you will walk out better equipped to tackle those nasty, hard to solve query plans.

    Taiob Ali, Database Solutions Manager GMO LLC
    Taiob Ali, MVP Data Platform, is an accomplished technical leader with a proven record of success. For 14 years, he has worked with the Microsoft Data Platform and MongoDB both on-premise and cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare. Taiob has hands-on experience in managing large database projects, massive data migration, intricate process design, testing and deployment, performance tuning, long term capacity planning.
    Taiob is currently working at “GMO LLC” as a Database Solution Manager, focusing on cloud migration, automation, improving, and streamlining operational workflow. He is a regular speaker at local and virtual PASS chapters, SQL Saturdays, and Azure conferences.

  • Des Moines PASS (IASSUG) Virtual Meeting - November 16, 2020

    *** Due to COVID-19, until further notice, IASSUG will hold only Virtual Meetings. No in-person attendance ***

    Topic: "Show and Tell from PASS Summit Virtual 2020"

    Whether you attended PASS Virtual Summit or not, join us. We will discuss, recap, and share what we learned at Virtual Summit 2020!

    Discussion Leader will be Juan Moya, Des Moines PASS (IASSUG) Local Group Primary Leader.

  • Des Moines PASS (IASSUG) Virtual Meeting - October 12, 2020

    Presentation: "The Psychology of Better Power BI Reporting"

    Description: In this course, we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.

    Presenter Bio: Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and enjoys traveling the country teaching about Business Intelligence and SQL Server. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQL Saturday Atlanta, Atlanta BI, and Pensacola.

    4