idpa-quadcities

Event link at our Meetup page.

5:30 PM Networking
6:00 PM Meeting

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

Advanced PowerShell for the DBA (night 3 of three)

Night 3: All about DOING the work, not learning about HOW to do the work. Abstract: Learning is so fun, especially when it comes to PowerShell. But this session is ALL ABOUT DOING THE STUFF, not just learning about it. I will take you on a journey that will make you want to reach for the keyboard instead of the mouse. I will not be teaching you how to replace SSMS, but how to get more done with PowerShell and leave the visual stuff to SSMS. Join me in the final installment of PowerShell for the DBA that you won’t want to miss. Let’s use the TOOLS in your TOOLBOX and you won’t look at PowerShell in the same way again.All about DOING the work, not learning about HOW to do the work.

Abstract: Learning is so fun, especially when it comes to PowerShell. But this session is ALL ABOUT DOING THE STUFF, not just learning about it. I will take you on a journey that will make you want to reach for the keyboard instead of the mouse. I will not be teaching you how to replace SSMS, but how to get more done with PowerShell and leave the visual stuff to SSMS. Join me in the final installment of PowerShell for the DBA that you won’t want to miss. Let’s use the TOOLS in your TOOLBOX and you won’t look at PowerShell in the same way again.

Please join us for Night 1 and 2, as well!

Monday, Feb 8 – 5:30 PM Networking, 6:00 PM Presentation

Tuesday, Feb 9 – 5:30 PM Networking, 6:00 PM Presentation

---

Event link at our Meetup page.

5:30 pm Networking
6:00 pm Meeting

Understanding Statistics in SQL Server

Are you new to performance tuning and confounded by statistics? Do you wonder where these statistics come from, and how the optimizer gets the estimates from statistics? Join me as we dive deep into cardinality estimation, how SQL Server uses statistics to build execution plans, where to find information about how statistics got used and why managing statistics is vital to performance. This session will have awesome demos showcasing practical examples of how the optimizer uses statistical information for all those crazy queries you write.

Deepthi Goguri, SQL Database Administrator Intone Networks Inc

I am a SQL Server Database Administrator with 7 years of experience in Administering SQL Servers. I am a Microsoft Certified Trainer and professional with an Associate and Expert level Certification in Data Management and Analytics. I did my Masters in Computer Technology at Eastern Illinois University. I blog for DBANuggets.com

---