- Robb Schiefer - Monitoring Azure App Service like a pro!
Details Azure App Service is a platform as a service (PaaS) offering for hosting/operating web applications in Azure. PaaS offerings are managed services which means OS updates/patches are all managed by the cloud provider. The downside to this is you don't have remote access to the instances like you do with virtual machines. So you have to learn how to monitor/troubleshoot the services/apps differently. In this talk we will cover some Azure App Service basics and then dig deeper into all the ways you can monitor/troubleshoot the App Services using a real-world application. We will look at App Service metrics, Application Insights and advance diagnostics features. Registration Link - Please RSVP to Birmingham .NET Meetup October Meeting for this online meeting - https://www.meetup.com/Birmingham-NET-Meetup/events/273134673/
- Anthony Nocentino: Deploying SQL Server in Kubernetes
Session Details: Are you thinking about running SQL Server in Kubernetes and don’t know where to start? Are you wondering what you really need to know? If so, then this is the session for you! When deploying SQL Server in Kubernetes key considerations include data persistency, Pod configuration, resource management, and high availability/disaster recovery scenarios. In this session, we’ll look closely at each of these elements and learn how to run SQL Server in Kubernetes. Learning Objectives - Deploying SQL Server in Kubernetes Allocating Persistent Data Storage and configuring advanced disk topologies SQL Server Specific Pod Configuration Near zero-downtime upgrades High availability and Disaster Recovery Scenarios Speaker Details: Anthony is the Founder and President of Centino Systems as well as a Pluralsight Author and a Microsoft Data Platform MVP. Linux Expert and Corporate Problem Solver. Anthony designs solutions, deploys the technology, and provides expertise on business system performance, architecture, and security. Anthony has a Bachelors and Masters in Computer Science with research publications in high performance/low latency data access algorithms and spatial database systems.
- Eric Flamm - Introduction to Azure Data Studio
Session Details - Azure Data Studio is a cross-platform database tool for data professionals using the Microsoft family of on-premises and cloud data platforms on Windows, MacOS, and Linux. Azure Data Studio offers a modern editor experience with Intellisense, code snippets, source control integration, and an integrated terminal. It is engineered with the data platform user in mind, with built-in charting of query result sets and customizable dashboards. Built on the Electron framework, Azure Data Studio is highly extensible and offers a large library of community-authored extensions as well as access to many of the extensions available for Visual Studio Code. Speaker Details - Eric Flamm is the principal consultant with Flamm Consulting, which provides Business Intelligence and Data Engineering consulting services to a range of small and medium-sized businesses. His clients have included Pactiv Corp (formerly Tenneco Packaging), Colography Group, Principia Partners, and Tillster, Inc (formerly Snapfinger.com), along with a range of smaller clients and projects. Eric graduated from Stanford and the Booth School at U of Chicago. Eric has volunteered with SQL Saturday Atlanta since the first event (SQL Saturday #13 in 2009). He has presented to SQL Saturdays in Atlanta, Chicago, and Columbus (GA), Azure Data Fest (Atlanta), the Atlanta Power BI chapter, and the Kennesaw (GA) Amazon Web Services Meetup group.
- Matt Gordon: Turn Runbooks Into Notebooks: Handling Maint/Emerg with Azure DS
Matt Gordon presents Turn Runbooks Into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio Abstract: On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks. Bio: Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group and a frequent domestic and international community speaker. He's an IDERA ACE alumnus and 2020 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real-world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs.
- Samir Behara - What's new in SQL Server 2019
Session Details - Come learn the new capabilities of SQL Server 2019 that have rocked the industry including Intelligent Query Processing, Apache Spark and HDFS in the box, Big Data Clusters, enhanced Polybase connectors to help avoid ETL, Security Features, T-SQL with Java, and enhancements for SQL Server on Linux, Docker Containers, and Kubernetes. SQL Server 2019 is the new unified data platform allowing you to keep your data where it is located, build your own data lakes, and enable new container based solutions never before possible. Speaker Details - Samir is a Solution Architect with EBSCO Industries and builds software solutions using cutting edge technologies. He is a Microsoft Data Platform MVP with over 14 years of IT experience working on large-scale enterprise applications involving complex business functions, web integration, and data management in various domains like Insurance, Manufacturing and Publishing. Samir is a frequent speaker at conferences such as PASS Summit, IT/Dev Connections, CodeStock, SQL Saturdays and CodeCamps. He is the Co-Chapter Lead of the Steel City SQL Server UserGroup, Birmingham, AL. Meeting Location - Samford University 800 Lakeshore Drive Room 311, Thomas Russell D Hall Homewood, Alabama 35229
- Mohammad Darab - Big Data Clusters for the Absolute Beginner
Session Details: Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level. Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters. Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts Speaker Details: Mohammad Darab is a Microsoft Data Professional, speaker and blogger with over 19 years of IT professional experience, 10+ years of that working with SQL Server. Some areas of his focus are the database engine, HA/DR, and security. He is currently an MCITP, MCP, as well as an IDERA ACE Class of 2019. Meeting Details: Room 311. Thomas D. Russell Hall As always the meeting will begin at 6:00pm with a 30 minute networking session in conjunction with the Birmingham .NET Meetup group with the presentation beginning at 6:30. Food and beverages will be provided. This will be a remote session.
- Ed Watson - The Psychology of Better Power BI Reporting
Session Details: 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. Speaker Details: Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is also a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Although he started as a programmer, he later saw the light and began working in data as a DBA before finally making the jump to the Business Intelligence paradigm. He currently lives in Atlanta and is active with the Atlanta MDF and BI user groups. Meeting Details: Room 311. Thomas D. Russell Hall As always the meeting will begin at 6:00pm with a 30 minute networking session in conjunction with the Birmingham .NET Meetup group with the presentation beginning at 6:30. Food and beverages will be provided.
- Matt Gordon - High Availability and Azure - Scaling SQL Server to the Cloud
SteelCity SQL Monthly Meeting
Session Details: Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database, and how those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss real world case studies covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night. Speaker Details: Matt is a Microsoft Data Platform MVP and has worked with SQL Server since 2000. He is the leader of the Lexington, KY PASS local group, a frequent community speaker, and speaker at PASS Summit 2017 and 2018. He's an IDERA ACE and 2019 Friend of Redgate. His original data professional role was as a database developer, which quickly evolved into query tuning work that further evolved into being a full-fledged DBA in the healthcare realm. He has supported several critical systems utilizing SQL Server and managed dozens of 24/7/365 SQL Server implementations. He currently utilizes that real world experience as a data platform consultant helping clients design solutions that meet their ever-changing business needs. ** Matt will be presenting to SteelCity UserGroup remotely.
- Sven Aelterman - The New Tool in Your Kit: Azure Data Studio
Session Details: Azure Data Studio is a newer tool in the database developer and DBA's toolkit. It's a cross-platform and extensible application for connecting to on-premises and cloud data. Does it replace SSMS? How is it different? Can it really check if my Diet Coke needs replenishing? Come and find out in this demo-driven session, that will hopefully have you convinced to install Azure Data Studio before 60 minutes are up. Speaker Details: Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Meeting Details: Room 311. Thomas D. Russell Hall As always the meeting will begin at 6:00pm with a 30 minute networking session in conjunction with the Birmingham .NET Meetup group with the presentation beginning at 6:30. Food and beverages will be provided. Sponsor Details: We would like to THANK all our sponsors for their generous support. We could not have done without them! https://www.meetup.com/SteelCitySQL/sponsors/