Categories
Virtual Meeting Announcement

May 2021 Meeting

The May meeting for the Ohio North Database Training user group will be on Tuesday, May 4, 2021. May the fourth be with you!* This will be a virtual event and our featured speaker will be Jeff Iannucci, a Data Platform community member from Arizona who presented at our last Cleveland SQLSaturday in 2020.

The online meeting will start at 5PM EST with a social hour. This is an unstructured hour where you can join us to catch up and meet other members of the group before the session starts.

Updates and announcements will commence at 6PM EST, with Jeff’s session starting after that. The title for Jeff’s session is titled Mastering Digital Communication – something that’s relevant for all of us right now! Please see the abstract below for more details.

We hope to see you there! *Start Wars attire optional.

  • Meeting RSVP (link to online meeting available after registration)

Session Abstract

“Excellent communication skills” shows up repeatedly as a job requirement, and yet all of us struggle with the technological tools we use to speak with others. For example, how many times have you sent an urgent email that didn’t get any replies? Have you put something important in a chat that confused your colleagues? Do colleagues seem disinterested when you speak during online meetings?

To remedy these frustrating situations, we’re going to examine the different types of digital communication we have available to us, when to use each type (hint: they’re not interchangeable), and also how to format and deliver your communication to get your point across quickly and clearly. You’ll leave with a stronger understanding of how to use these modern tools to communicate successfully, resulting in greater influence.

Speaker Bio

Jeff Iannucci is a Senior Database Administrator for DriveTime in Tempe, AZ. He has over 20 years of SQL Server experience as both a DBA and Developer in diverse environments such as health care, finance, retail sales, and government. He writes about solving problems for database professionals on both twitter (@DesertDBA) and his blog (desertdba.com), and has been chosen as an Idera ACE for 2021.

Categories
Virtual Meeting Announcement

April 2021 Meeting

The April meeting for the Ohio North Database Training user group will be on Tuesday, April 6, 2021. This will be a virtual event and our featured speaker will be Eugene Meidinger, a Data Platform community member from the Pittsburgh area. Eugene has also presented at our Cleveland SQLSaturday events multiple times.

The online meeting will start at 5PM EST with a social hour. This is an unstructured hour where you can join us to catch up and meet other members of the group before the session starts. Updates and announcements will commence at 6PM EST, with Eugene’s session starting after that.

The title for Eugene’s session is Visualization Fundamentals with Power BI – please see the abstract below for more details.

We hope to see you there!

Session Abstract

Simply adding descriptive data to Power BI reports is fairly easy. But how do you add context and business meaning? How do you make sure your reports are effective?

In this session, we’ll review the different types of reports consumers and their needs. Next, we’ll talk about some fundamentals of effective reporting and visualizations. Finally, we’ll see how you can use Power BI to take a spiral approach: starting at raw data and then layering in context, business logic, and interactivity.

Speaker Bio

Eugene Meidinger works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years. He also helps run the GroupBy online conference.

You can find Eugene on Twitter and LinkedIn.

Categories
Virtual Meeting Announcement

March 2021 Meeting

The March meeting for the Ohio North Database Training user group will be on Tuesday, March 2, 2021. This will be a virtual event and our featured speaker will be Peter Shore, a Data Platform community member from Columbus, OH who has also presented at our Cleveland SQLSaturday events.

The online meeting will start at 5PM EST with a social hour. Feel free to join us then to catch up and meet other members of the group! Updates and announcements will commence at 6PM EST, with Peter’s session starting after that.

The title for Peter’s session is A Query Runs Through It: An Introduction to the SQL Server Engine – please see the abstract below for more details.

We hope to see you there!

  • Meeting RSVP (you will receive the webinar link after RSVPing)

Session 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.

You can find Peter on Twitter and LinkedIn.

Categories
Virtual Meeting Announcement

February 2021 Meeting

The February meeting for the Ohio North Database Training user group will be on Tuesday, February 2, 2021. This will be a virtual event and our featured speaker will be Michael Swart, a Data Platform community member from Ontario, Canada who has previously spoken at our Cleveland SQLSaturday events.

The online meeting will start at 5PM EST with a social hour. Feel free to join us then to catch up and meet other members of the group! Updates and announcements will commence at 6PM EST, with Michael’s session starting after that.

The title for Michael’s session is How High Can We Scale SQL Server? – please see the abstract below for more details.

We hope to see you there!

Session Abstract

The world of online learning has been very, very busy in the past year. At my company D2L, we host websites for schools. We just experienced our busiest semester start ever pushing our infrastructure further than we’ve ever pushed it. I’d like to share my own experiences. I’ll describe how busy we got and the lessons we learned, both the ones we anticipated and the ones that took us by surprise.

And what about the future? What practical strategies are we adopting to evolve our database architecture to handle even more growth? I’d like to share the way we understand our scaling challenges and how we plan to tackle them.

Speaker Bio

Michael Swart is a passionate database developer and blogger specializing in SQL Server. He’s a Principal Software Developer at D2L and has the most fun when troubleshooting challenging client issues.

You can find Michael on Twitter (@MJSwart), and read more on his excellent blog.

Categories
Virtual Meeting Announcement

January 2021 Meeting

Our next meeting is Tuesday, January 5. It will be a virtual event featuring Andy Levy as our featured speaker as well as voting for the 2021 officer group.

We will sign on around 5pm for a social hour with the meeting kicking off right at 6pm.

We will open the main portion of the meeting with an update from the current board members.

Our featured speaker for the evening is Andy Levy who will be presenting Backup Basics with Powershell and dbatools. See below for details of the presentation.

We look forward to seeing you all there!

About the feature presentation:
As DBAs, one of our top priorities is keeping the organization’s data backed up and ready to be stored when needed. We also need to be prepared to answer questions about those backups. Do you have a standard backup process? Can you meet your recovery time requirements? Do you know the backups are good? Do you have documentation of your backup history and verification? Are you backing up your instance configuration as well as the databases themselves?

dbatools has a suite of versatile Powershell functions designed to help you answer those questions confidently and quickly. In this presentation filled with practical examples, we’ll take a tour of the core dbatools functions for creating, restoring, and monitoring your backups, whether you’re managing one instance or dozens of them.

About Andy:
Andy is a database administrator, Powershell fan, former developer, Open Source contributor, SQL Saturday organizer and user group leader. He’s worn a number of IT hats since 1999 before landing in database administration, including web server administration and development, systems integration, and database development. When he isn’t unraveling the mysteries of legacy code, he can be found helping out with his son’s Boy Scout troop, making BBQ ribs for his daughter, or planning the next family vacation with his wife.