Name: Chicago Data Professionals December 8th Meeting
Start: 2022-12-08T23:45:00.000Z
End: 2022-12-09T02:45:00.000Z
Location: 200 E Randolph St

Join us once again for our end-of-year Christmas Special extravaganza in which we aim to educate and entertain in equal measure with our final session of 2022!

We will be joined by a team of experts who will present their Lightning Talks (10 minutes each) on their chosen topic, and then you (the audience) will get the chance to go head-to-head with them in our (in)famous Technology and General Knowledge Quiz Bowl where you can become the Hybrid Virtual Group Champion 2022.

**Schedule**

* Lightning talks
* Quiz Bowl

**Lightning talks**
*Session 1:* Paginated Reports just got easier! by Laura Graham-Brown (Data Platform MVP)
With a change of license requirements and a fast way to make a simple report now is the time to get you head around paginated reports. 10 minutes I'll get you started.

*Session 2:* New TSQL functions in SQL Server 2022 by Tomaž Kaštrun (Data Platform MVP)
With SQL Server 2022 there are also new functions and enhancements to T-SQL language for working with JSON, Date formats, Window functions, improved string_split, TRIM and others. This lightning talk will be a 100% demo on new functions.

*Session 3:* The 10 commandments of ETL by Martin Schoombee (Chief Data Wrangler at 28twelve consulting)
In this session I will share the 10 basic principles I follow when developing ETL processes, and also show how the different choices can affect performance. Following these simple guidelines have resulted in many successful projects and happy customers. I'm sure it will work for you too!!

*Session 4:* Top 3 Tips for Managing Security in Power BI by Melissa Coates (Data Platform MVP)
Melissa will share her top 3 things that are essential for you to understand in order to manage security effectively in the Power BI Service.

**Quiz Bowl**
Our Quiz Bowl will use Kahoot\*1 and questions will be technology focused with some general knowledge rounds. You can play along at home and prove to the world that you know more than the experts!

**Speaker Bios**
*Laura Graham Brown* is a Microsoft Business Applications MVP and has over 20 years of experience at being passionate about training, solving problems, and loving a new challenge. I have worked with household names and clients very few will know, from the huge corporations to the small businesses, helping them make SharePoint, Flow, PowerApps, Power BI and Office solve their business needs.

*Tomaž Kaštrun* is a SQL Server developer and data scientist with more than 15 years of experience in the fields of business warehousing, development, ETL, database administration, and query tuning. He holds over 15 years of experience in data analysis, data mining, statistical research, and machine learning. He is a Microsoft SQL Server MVP for data platform and has been working with Microsoft SQL Server since version 2000. He is a blogger, author of many articles, a frequent speaker at the community and Microsoft events. He is an avid coffee drinker who is passionate about fixed gear bikes. In 2018 he co-authored book "SQL Server 2017 Machine Learning Services with R".

*Martin Schoombee* is Chief Data Wrangler at 28twelve consulting he helps people make sense of their data, using Microsoft technologies.

*Melissa Coates* is a data architect and the owner of Coates Data Strategies. Her professional focus is on Power BI governance, deployment, security, and administration. Melissa is the principal author of Microsoft's "Power BI Adoption Roadmap" and "Power BI Implementation Planning" guidance. Melissa is also the original creator of the comprehensive Power BI Deployment and Governance online course. She’s a big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. When Melissa steps away from the keyboard, you can probably find her hanging out with her dog, paddle boarding, or playing in the garden.

\-\-\-
\*1 Thank you to our kind friends at Capgemini for providing this capability

Hybrid Virtual Group

Mark Broadbent

Mikael Wedham

Riz mo

2022 Christmas Special (& special guests) with Lightning Talks and Quiz Bowl

Online event

5:30 Networking
6:00 Presentation

**Review of PASS Summit 2022**

We will have a recap of the PASS Summit and then enjoy a bit of social time to celebrate the holidays.

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

Quad City Microsoft Data Platform (SQL Server) User Group

Sheila

Kris

Tony Drews

Quad Cities Data Professionals - December 7, 2022 Meeting

In the SQL Server world, you're responsible for every facet of business continuity including taking backups, testing and performing restores, and setting up and monitoring high availability and disaster recovery. Now you're moving to Azure SQL, and you need to know what you need to know. In this session, you'll learn how backups in Azure SQL Database work and how you can perform restores; how high availability is built in; and your options for setting up disaster recovery. I'll share best practices for ensuring your applications have the continuity they need.

Speaker Bio: Jes Schultz

Jes Schultz is a data nerd with a passion for community. She currently works as a Senior Program Manager for SQL Experiences at Microsoft, building the best user experiences for SQL. Her career started with SQL Server 2005 and has evolved as a DBA, performance consultant, and software engineer focusing on the Azure Data stack. When not being a data nerd, she loves drinking coffee, hiking, running long distances, and eating great food.

*Note: Jes will be speaking live in-person for this event. The meeting will NOT be streamed.*

Sponsor: TEKsystems
TEKsystems has been a long-time valued supporter of the Louisville Data Technology User Group and as we attempt to come back to in-person they are helping to provide the venue, along with food and drinks. We thank them so much for their continued support.

Furthermore, TEKsystems has continued to push the boundaries of possible while providing exceptional service to their customers and consultants. Your future isn't waiting for an invitation so if you are looking for what's next, make sure to contact one of their fantastic recruiters.

Louisville Data Technology Group

John Morehouse

Joshua Higginbotham

John Madison

Azure SQL Database Business Continuity

TEKSystems

E se tivesse um comando que migrasse todos os objetos de banco de uma vez só de um servidor para outro, seria muito interessante né?
Vou dizer pra vocês que com o DBATools isso é possível! É só escolher o comando certo, ou os comandos certos.

Nesta sessão vamos conversar um pouco sobre o DBATools e alguns de seus comandos que podem ser usados para migração de Bancos de dados e outros objetos.

Data RS

Marina Benedetto

Oberdan Schaider

Tiago Crespi

Como migrar seu banco usando o DBATools

**This will be a Hybrid Event:**

**Members are encouraged to attend in person by registering at :**
[Attend in Person](https://www.eventbrite.com/e/chicago-data-professionals-december-8th-meeting-tickets-476665889507?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=escb)

**To Attend Online Click on Link Below:**
[Attend Online](https://teams.microsoft.com/l/meetup-join/19%3ameeting_YTc5ZjllMDYtYjc0Yy00MjQ0LThjMTUtZTI0YzE0ZTQxMzZl%40thread.v2/0?context=%7b%22Tid%22%3a%22b4c9f32e-da17-4ded-9c95-ce9da38f25d9%22%2c%22Oid%22%3a%22c93c8bdf-9986-4d7f-8325-00d81192601c%22%7d)

**Ground Control to Major Tom: Azure SQL Migration Extension for Azure Data Studio - Jared Karney**
The move from on-premises to the cloud has accelerated exponentially over the past several years. This has presented Database Administrators and other data stakeholders to figure out the easiest way to migrate their SQL Servers into one of the many offerings in the cloud with a minimal amount of downtime. In this session, Jared Karney will introduce you to Microsoft's preferred migration tool: Azure SQL Migration Extension for Azure Data Studio. You will learn what it is and how you can easily migrate your on-premises SQL workloads into Azure.

J﻿ared Karney Bio - Jared is a Sr. Cloud Solution Architect at Microsoft - Azure Data Services and he is also co-president of the Chicago Data Professionals User Group.
5:45 to 6:00 PM
Members can ask questions, do networking, discuss SQL Server related issues currently facing, and get advice from the chapter leaders and from other members. Also, report if you have job openings or looking for a job.
6:00 to 7:00 PM
The feature presentation of the day
7:00 to 7:30 PM
Members can ask questions of the speaker and network with each other.

Chicago Data Professionals

H. Ross Reed

Jared Karney

Eric Howell

Chicago Data Professionals December 8th Meeting

200 E Randolph St

Azure Data Tech Groups

Search {networkName}

Groups

{PRO_NETWORK_NAME} is on Meetup Pro with more than {PRO_MEMBER_COUNT} members across {PRO_GROUP_COUNT} Meetups worldwide. Meetup Pro is the professional tool for organizing and communicating a network of users, partners, contributors and members.

Azure Data Tech Groups

Join the Azure Data community

Azure Data Tech Groups

Who we are

Search Azure Data Tech Groups

Upcoming events