talk-data.com

Please register at: https://www.eventbrite.com/e/the-cloud-workshop-for-the-sql-professional-tickets-894045453017

Use promo code SUMMERBLUES to get $75 off the admission price through September 9th, 2024.

Are you thinking, exploring, migrating, or have migrated from SQL Server to Azure? This workshop will provide you with a technically driven approach to translating your knowledge and skills from SQL Server to Azure SQL. You will experience an immersive look at Azure SQL including hands-on labs with no Azure subscription required. This includes topics such as Azure networking, deployment, configuration, security, performance, availability, management, and monitoring. This workshop is designed to teach you Azure based on your existing SQL Server knowledge all led by the engineering team at Microsoft that works on both SQL Server and Azure SQL. This workshop is not intended to "sway" you to use Azure. It is designed for those wanting to learn about Azure, those who are migrating some or all SQL Server instances to Azure, or those who have migrated to Azure and want to optimize their investment. You don't even need to be a DBA to gain benefits from this workshop. Just bring your existing SQL Server knowledge and come learn Azure SQL!

Prerequisites - Attendees must have a basic knowledge of SQL Server and bring their own laptop for hands-on labs. Instructions will be provided later for what software to install. - No Azure subscription is required

Things to know: A significant part of the workshop will be dedicated to hands-on labs.

nstructor:

Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL Edge to Cloud. Bob has worked for Microsoft for 30+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2022 including Azure SQL. Bob is a well-known speaker on SQL Server and Azure SQL, often presenting talks on new releases, internals, and specialized topics at events such as SQLBits, Microsoft Build, Microsoft Ignite, PASS Summit, DevIntersection, and VS Live. You can also learn Azure SQL from him on the popular series https://aka.ms/azuresql4beginners. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux, SQL Server 2019 Revealed, Azure SQL Revealed and SQL Server 2022 Revealed available from Apress Media.

Co-presenter: Taiob Ali, Microsoft MVP - Data Platform Taiob is an accomplished technical leader with a proven record of success. For the past 17 years, he has worked with the Microsoft Data Platform and MongoDB on-premises and in the cloud. His experience includes all three major business sectors: finance, e-commerce, and healthcare.

Taiob works at GMO LLC as a database solutions manager, focusing on cloud migration, automation, and improving and streamlining operational workflow. He regularly speaks at local and international conferences, SQL Saturdays, and Azure conferences. He is a board member of the New England SQL Server User Group, founder of the Database Professionals Virtual Meetup Group, and organizer of Boston SQL Saturday.

Agenda:

8:00 AM - 8:30 AM Registration and Continental Breakfast 8:30 AM - 12 PM Morning Session with a 15-minute coffee break 12 pm - 1 PM Lunch 1 pm - 5 PM Afternoon session with a 15-minute snack and drinks break

CGI hosts our in-person meetup on 5th of September. The location is CGI's headquarters in Pitäjänmäki, Helsinki (Karvaamokuja 2 D).

Agenda: - 17:00 - 18:00 Building custom AI applications in Fabric by Swati Choudhary - 18:00 - 18:30 Food sponsored by CGI - 18:30 - 19:30 Data Modeling and Data Warehouse Automation by Tero-Matti Kinanen and Annina Malin - 19:30 - 20:30 Warehouse in Microsoft Fabric: Architecture Deep Dive by Oskari Heikkinen

Tero-Matti will present introduction to DSharp Studio 5.0. In addition, Tero-Matti and Annina will co-present Case Metsähallitus: Mennäänkö datalla metsään?

Oskari's presentation description is as follows: Warehouse Architecture includes VertiPaq, SQL Server Query Optimizer, and the new version of Polaris. How has Polaris evolved since Azure Synapse Analytics' Serverless SQL Pool? How has transaction support been added? What is V-ORDER's relevance to the Parquet file format, and how does it improve performance with VertiPaq? During this session, Oskari will demonstrate these functionalities, and you will better understand how the Warehouse works under the hood.

Would you like to speak at the next event? Please do get in touch with either Vesa Tikkanen, Oskari Heikkinen or Heini Ilmarinen.

Agenda 18:00 - 18:45 - Pizza and networking

18:45 - 19:35

Take Control of your Azure SQL Managed Instance Migration using the Log Replay Service This session covers the Log Replay Service (LRS), a new free of charge Azure service for migrating databases to SQL managed instance. Learn when you would use it over existing migration methods, like the Data Migration Service (DMS), to solve some migration challenges. And I'll show how I used it in a recent customer project to customise the migration of multi-terabyte databases to SQL managed instance using a combination of full, differential and log backups within a strict downtime window.

I'll also introduce you to some features we implemented post-migration, like Intelligent Query Processing and Data Virtualization, that resulted in the huge improvements in batch processing times in SQL managed instance. Rob Carrol Principal Data Platform Consultant, Coeo I've been working with SQL Server for over 20 years, firstly as a DBA and now as a consultant. I joined Coeo as a Consultant in 2021 providing advice and guidance to customers modernising their SQL Server platforms. I previously worked for Microsoft as a Premier Field Engineer (PFE) and as an independent database consultant, working across various sectors including Financial Services, Retail and Defence. When I'm not working with SQL Server, I'm a keen runner and enjoy spending time with my family.

19:35 - 19:45 - Bio Break

19:45 - 20:35

How Can Microsoft Fabric Have an Impact on Your Business?

All this talk about Data-Ware-Lake-Delta-Beach-House-Lakes (or some combination of that) and Data, Yarn, Fabric integration, everything has got a bit… Meshy! Yes, my friends. The beat of the technology drum is certainly relentless. And with no limits cloud scale and huge innovations from the biggest brains. Two years, it seems, has become the benchmark for tools to live and die by. Reach three years and you almost have a mature product. That said, Microsoft Fabric, the latest offering from global software giant is no exception. But what does this mean for the real world. For the data analysts, engineers and scientists that need to continue answering everyday problems to inform business decisions. In this session we will firmly ignore the hype and focus on the reality. With the pragmatic view of an experienced architect. The problem of gaining insights from our data hasn’t changed. So, what does this mean if implemented using Microsoft Fabric. What, why and how is the tooling going to change our daily deliverables in the short term, medium and long term. Join me for these answers and more as we explore the impact of Microsoft Fabric-Server, erm, Power. Resource. Thing!

Paul (AKA @mrpaulandrew) is the Founder & CTO of Cloud Formations, a specialist data consultancy based in the UK. With nearly 20 years’ experience designing and delivering Microsoft data architectures, Paul leads a passionate team of engineers, supporting businesses small and large with scalable cloud platforms. Business value delivered through data insights. Over the years, covering a breadth of design patterns and industry leading concepts, including Lambda, Kappa, Delta Lake, Data Mesh and Data Fabric. Paul is also a Microsoft Data Platform MVP, director for the Data Relay conference, East Midlands user group leader, book author and mentor. In addition to the day job(s), Paul is a father of three, husband, foodie, runner, blood donor, geek, Lego, and Star Wars fan! Lastly, Paul confesses to enjoying a Ramstein playlist when given half a chance to do some coding for a customer project.

We have our first in-person meetup of the autumn season on 14th of September. This time the location is CGI's headquarters in Pitäjänmäki, Helsinki (Karvaamokuja 2 D).

Agenda:

- 17:00 - 18:00 Vishal Sinha: Leveraging large scale generative AI models using Azure OpenAI Service

- 18:00 - 18:30 Food sponsored by CGI

- 18:30 - 19:00 Oskari Heikkinen: Power BI Direct Lake performance

- 19:00 - Community discussion: Let's share our first experiences with Microsoft Fabric. We hope that everyone who has played around with the service would join the discussion and share their thoughts so far. Discussion will be led by Vesku\, Heini and Oskari.

Would you like to speak at the next event? Please do get in touch with either Vesa Tikkanen, Oskari Heikkinen or Heini Ilmarinen.