Azure SQL Database – Overview

Abstract: In this session, we will learn about the different options for SQL deployments in Azure. After this session, you should be able to understand the key differences between SQL Server On-Premises, SQL in an Azure VM (IaaS), and using Azure SQL DB (Single database, Elastic Pools, and Managed Instances.) In addition, we will evaluate different service tiers within Azure SQL DB to determine different workloads and business requirements. (Serverless, Hyperscale, General Purpose, and Business Critical.)

Speaker: John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a Data Customer Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

When: Sep 14th – 6:PM EST

Microsoft Teams Link : https://teams.microsoft.com/dl/launcher/launcher.html?type=meetup-join&deeplinkId=e3ce3074-ff0c-44be-8ed0-4d7b59428d08&directDl=true&msLaunch=true&enableMobilePage=true&url=%2F_%23%2Fl%2Fmeetup-join%2F19%3Ameeting_Mzk1Nzg0NDMtNzE4OS00NmViLWFjZTQtYzVhYjI5MTAyMjZk@thread.v2%2F0%3Fcontext%3D%257b%2522Tid%2522%253a%252272f988bf-86f1-41af-91ab-2d7cd011db47%2522%252c%2522Oid%2522%253a%2522af70c7c4-b3b9-4396-9f98-804640f6bdb4%2522%257d%26anon%3Dtrue&suppressPrompt=true

May Meet up (18th May) – Enable Real-time Analytics with Azure Stream Analytics

Abstract: As Organizations are looking to transform into data driven organizations. Stream analytics has emerged as an integral part of Enterprise Data platform architectures along with batch ETL. Stream analytics help to gain maximum value from user-interaction events, applications and machine logs. Ingesting, processing, and analyzing these data streams quickly and efficiently is critical in fraud detection, click stream analysis, sentiment analytics, online recommendations and IOT Scenarios among many examples. In this session we will look at options available in azure for real-time analytics and deep dive into Azure Stream Analytics. Build streaming jobs that can blend and aggregate data as it arrives to drive live Power BI dashboards. Plus, we’ll explore how a complete lambda architecture can be created when combining stream and batch data together and finally how it integrates with Azure ML.

Speaker Bio: Sriharsh Adari is a technology strategist and Cloud BI Architect. He has around 16 years of experience helping customers with setting up Data Platforms focused on Microsoft BI. He has helped multiple global customers across different industry verticals set up enterprise data platforms using the Microsoft Data Platform and Business Intelligence stack. Over the past few years, he has been helping customers migrate on-premise data workloads onto Cloud Data Platforms – Azure, AWS, and set up new data platforms on cloud. Sriharsh is passionate about all things related to data, big data and Business Intelligence.

April Meet Up – DB Design and Tuning for Azure Synapse DB

Abstract: Microsoft’s Synapse DB is based on a Massively Parallel Processing (MPP) architecture.  When your DB is designed right, all that compute and parallel workload can get answers to your queries fast.  Designed wrong and a lot of that MPP power is used compensating for our design mistakes.  This session will have an overview of the MPP architecture and how it influences design decisions around table types and storage type.  Then we will review some best coding practices for Synapse DB and see how for large Upserts a CTAS (create table as select) and partition switch is the way to go. Lastly, since despite our best efforts we will write some poor performing code, we will take a look at troubleshooting and tuning techniques and how they were used in some real world examples.

Speaker Bio: Ted Tasker is a Data Architect at Insight Digital Innovations.  Ted started working with SQL Server 4.21 in 1993 and has had a career centered on SQL Server ever since.  The release of SQL 7 / OLAP shifted Ted’s focus  to data warehousing and he led a team in deploying Disney Online’s first DW and OLAP reporting solution.  After years of leading DW and BI teams, Ted joined Microsoft and was the technical lead for the first sale in the world of Microsoft’s PDW (Parallel Data Warehouse).  He returned to consulting with a focus on Microsoft’s MPP database platforms and continued to work with PDW as it became APS, then Azure SQL DW and now the relational db platform for Azure Synapse.

Event Details:

Monday, April 13, 2020 – 6:00 PM to 7:00 PM EDT

https://www.meetup.com/Central-Ohio-Azure/events/blcjqrybcgbrb/?rv=ea2_v2&_xtd=gatlbWFpbF9jbGlja9oAJDI1MzBiNmNlLTJmOGQtNDI5My1iMGU5LTgwNTM3MDQ4NjJkMw

March Meetup – Azure Automation and Log Analytics

For the March 9th meetup we welcome a long-time member of the group, Matt Richardson.

Please RSVP for the meetup so we can best plan for food and drinks!

Title: Azure Automation and Log Analytics

Abstract: Nobody loves supporting a system that is a complete black box where every issue is a detective story to figure out what is going on and a stressful engineering effort to re-learn how to recover. Discover how to use Azure Automation, Log Analytics, and related services to monitor, maintain, and remediate issues in your Azure cloud environment. Developers will gain a deeper understanding of how they can build observability and resiliency through automated remediations into their systems. Operations will learn how to use those same tools to achieve a comprehensive understanding of what’s happening under the covers and generally rely on the system taking care of itself, or build out new automated remediations as new scenarios are uncovered.

Speaker Bio: Matt is the Lead Cloud Architect for Re:Sources with 28 years of IT experience. Re:Sources is a subsidiary Publicis Groupe. Publicis Groupe is the 2nd largest Advertising company in the world, based out of Paris, France. Matt started his cloud journey in 2010 with AWS. Since then, he has done major datacenter consolidations by migrating virtual servers and related resources to Azure, as well as managing and championing the transformation to serverless for his company. Today, Matt’s main focus is cloud enablement and helping subsidiaries of Publicis Groupe migrate workloads to the cloud.

February 10th Meetup

For the Monday, February 10th meetup we will welcome Corry Watson. Corry will be discussing building conversation bot applications in Azure. These are very popular and in-demand applications these days, so join us to get the scoop!

Please RSVP for the meetup so we can best plan for food and drinks!

Title: Who’s turn is it anyway?

Abstract: Bot Framework has seen some significant changes in the past few years that allows developers to build robust conversational flows that can be applied to a multitude of conversation outlets. In this talk we’ll dive into Bot Framework v4 specifically, peek under the hood of how everything comes together when it comes to building automated conversational flows. Our focus will be diving into some code as well as delving into the various Azure services/configurations that are needed to get a Bot running in Azure. We’ll cover controllers, adapters and dialog components. With building conversational flows, the ability to understand what the user interacting with the bot is trying to say is paramount to the bot’s success, enter LUIS (Language Understanding Intelligent Service). We’ll take a look at how LUIS can be leveraged to help the Bot determine the intent of the user interacting with the Bot. We’ll also dive into Azure to see how the Bot’s are deployed and how multiple channels can be configured in order to interact with the Bot’s through various interfaces (Slack, Twilio, etc). Within Azure, we’ll discuss the other various services that can be leveraged while building out Bots (App Insights, Cosmos DB, Sentiment Analysis, etc). We’ll get hands on with code throughout this talk to demonstrate how bot’s are planned, configured, built and ultimately deployed.

Speaker Bio: My name is Corry Watson. I was born and raised in Columbus, Ohio. I attended Bishop Ready High School on the west of Columbus (Westside Best Side!). I then attended The Ohio State University where I studied computer and Information Science. After college, I started my career as a developer working for Cardinal Solutions (Now Insight). From there I did my stint in the enterprise world, working for Nationwide Insurance for 6 years. Since then, I have made my way back home to Insight (formerly Cardinal) and am enjoying my time back! My wife Liz and I have been married for 4 years, we live in the UA/Hilliard area, just west of the Scioto River. We are expecting our first child this coming June, so if you hear any Dad jokes during the talk, just know that I am getting myself prepared for fatherhood.

Central Ohio Azure – 2019 Holiday Party

Join us and other technology user groups for our annual combined holiday party.

When:

Friday, December 20th from 6-8pm

Where:

Improving Enterprises

One Easton Oval, Suite 175 · Columbus, OH

RSVP:

Central Ohio Azure – 2019 Holiday Party

Friday, Dec 20, 2019, 6:00 PM

Improving Enterprises
One Easton Oval, Suite 175 Columbus, OH

2 Members Attending

Join us and other technology user groups for our annual combined holiday party. Activities: Good times with fellow geeks – think Ping Pong, Board Games & more. Giveaways? Yes, thanks to our sponsors, we’ll have some sweet raffle prizes. Giving Back: In the spirit of the holidays, we’ll be hosting a food drive to support the Mid-Ohio Food Bank. Plea…

Check out this Meetup →

Activities:
Good times with fellow geeks – think Ping Pong, Board Games & more.

Giveaways?
Yes, thanks to our sponsors, we’ll have some sweet raffle prizes.

Giving Back:
In the spirit of the holidays, we’ll be hosting a food drive to support the Mid-Ohio Food Bank. Please refer to their guidelines of what items of donation are acceptable. We will do raffle tickets to draw prizes – as you walk in, you get a raffle ticket. And each item you donate earns you another additional ticket, thus increasing your chances of winning. We appreciate your help towards a good cause.

Anything to Eat/Drink?
Glad you asked. Good food & beer .. it’s the Holidays after all.

Who’s Coming:

Our community is combining with these outstanding sister groups to put on this event.

October 14th Meetup

For Monday, October 14th meetup we will once again welcome Sriharsh Adari. Sriharsh joined us in March and we’re excited to have him return to COAzure! Sriharsh will be sharing guidance related to two very popular topics – data and security. This is sure to be another great session with a lively discussion!!

Please RSVP for the meetup so we can best plan for food and drinks!

Title: How to Implement Azure Data Platform security

Abstract: One of the major concerns customers have when setting up cloud based data platforms is security. 84% of organizations believe that traditional security doesn’t work for cloud. In this session, we will review how key Azure Data Platform resources can be secured when setting up an Enterprise Data Platform in Azure. We will review questions regarding network security, open ports, secure client connections, firewall, and limitations around VNET rules and Azure Active Directory across services. In the process, we will also review SQL security features like threat detection, vulnerability assessment, and encryption options. You will leave this session with a good understanding of detailed security options available for Azure data Platform components.

Speaker Bio: Sriharsh Adari is a Cloud & BI Architect & Evangelist. He has around 16 years of experience helping customers with setting up Data Platforms. Over the past few years he has been helping customers to migrate on-premise data workloads onto Cloud Data Platforms – Azure, AWS. Sriharsh is passionate about all things related to Data, Big Data and Business Intelligence.

July 8th Meetup

For the Monday, July 8th meetup we will conduct a hands-on solution architecture meetup! COAzure has held these a few times over the past couple of years, and the feedback continues to be very positive. As Azure is an ever-changing platform, there are many new services to explore. Therefore, it is time to do it again!

Please RSVP for the meetup so we can best plan for food and drinks!

The goal of this meeting’s activity will be to learn more about the various Azure services, and how to use them together to architect a solution in Azure. We’ll provide a few technical case studies and application/system requirements, and then you’ll work as teams to research various Azure services and decide how to use those to propose an architecture for the system.

Each team will have a little over an hour to come up with its solution architecture, drawing them up on large sheets of paper. We’ll have experienced Azure architects available to answer questions and provide guidance. Bring your laptop so you can research the many available services. We’ll end the meeting with each team sharing its solution with the whole group, and then review the actual architecture that was implemented in Azure.

You do not have to be experienced with all the Azure services, just interested in learning.

June 10th Meetup

For Monday, June 10th meetup we will welcome Michael Timmers from Pivotal Software. As a Platform Architect at Pivotal Software, Michael will provide insights on how large organizations are able to leverage the combined strengths of Pivotal Cloud Foundry and Azure. If you’ve ever been curious about Pivotal Cloud Foundry and Azure, this is your chance to learn!

Please RSVP for the meetup so we can best plan for food and drinks!

Title: Running Pivotal Cloud Foundry with Azure
Pivotal Cloud Foundry (PCF) is a software based PaaS that is powering some of the largest organizations in the world such as Comcast, Liberty Mutual, Kroger, and many others. Please join us as we explore how extending PCF capability into Azure will significantly broaden its value by taking advantage of Azure native services. Through the partnership between Microsoft and Pivotal, a service broker has been developed to allow for seamless implementation to realize immediate value. Some of the services available through PCF include:

* Azure Storage
* Azure Redis Cache
* Azure DocumentDB
* Azure Service Bus
* Azure Event Hubs
* Azure SQL Database
* Azure SQL Database Failover Group (preview)
* Azure Database for MySQL (preview)
* Azure Database for PostgreSQL (preview)
* Azure CosmosDB

Speaker Bio: Michael Timmers – Experienced Platform Architect – Transforming How The World Builds Software – by working with teams in large enterprises adopting a cloud native approach.

https://www.linkedin.com/in/timmers/

May 13th Meetup

For Monday, May 13th meetup we review many of the exciting Azure-related announcements from the recent Microsoft Build conference.  While we will not be able to cover everything, we do plan to discuss many topics, such as Azure Functions, AKS, Bots & Cognitive Services, and IoT.  If there is something you found especially interesting and would love to share it with the group, please let us know and we’ll get you a slot at this meetup.

We will look forward to seeing everyone and discussing all the excitement from Build!!

Please RSVP for the meetup so we can best plan for food and drinks!