Los Angeles Data Platform

### Session #1

Abstract
Learn about Azure Arc-enabled data services and SQL Server: Leveraging cloud benefits for your on-prem SQL Server with Sam Mesel at the Microsoft Data and AI South Florida (DataAISF) user group. This session is about using Azure Arc-enabled data services and SQL Server to leverage cloud benefits for your on-prem SQL Server. The Azure Arc-enabled data services enable access, monitoring, data security, and data workloads residing on-premises, cloud, or edge.
Everyone knows the cloud benefits and what it means for your SQL Server workloads. But what if a SQL workload cannot be moved to the cloud yet?
This session will cover Azure Arc-enabled data services and how you connect an on-prem SQL Server to the cloud to benefit from Inventory, Defender for SQL, Best Practices Assessment, and more

Speaker Bio
Sam Mesel has been working with SQL Server since the early 90s. Joined Microsoft as Premier Field engineer in 2012 and became part of the Global Black Belt organization in 2022.

### Session #2

Abstract
So many buzzwords of late: Data Lakehouse, Data Mesh, and Data Fabric. What do all these terms mean and how do they compare to a modern data warehouse? In this session, I’ll cover all of them in detail and compare the pros and cons of each. They all may sound great in theory, but I’ll dig into the concerns you need to be aware of before taking the plunge. I’ll also include use cases so you can see what approach will work best for your big data needs. And I’ll discuss the Microsoft version of the data mesh.

Speaker Bio
James works at Microsoft as a big data and data warehousing solution architect where he has been for most of the last eight years He is a thought leader in the use and application of Big Data and advanced analytics, including data architectures such as the modern data warehouse, data lakehouse, data fabric, and data mesh. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 35 years of IT experience. He is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of major events including SQLBits, PASS Summit, Data Summit, and the Enterprise Data World conference. He is the author of the book “Reporting with Microsoft SQL Server 2012”.

Abstract

Speaker Bio

Abstract

Migration to Azure Managed instances

Speaker Bio

Gilda graduated from the University of Central Florida with MIS and Computer Science degrees. She is currently a Senior Manager at Skytouch technology and has over a decade of experience in Enterprise Information Technology for several Fortune 500 companies. She has specialized in database design, implementation, and optimization, emphasizing high availability, business continuity, and migrations. Experience working on multi-million dollar projects for IBM, Disney, the IRS, the US Federal Defense Agency, Marriott, Deloitte, and others. It is her passion to promote technical and leadership education in her community. In addition to leading the information technology committee of ALPFA (Association of Latino Professionals for America in Orlando), she is a Chapter Leader for PASS (Professional Association of SQL Server). These associations have allowed her to bridge the gap in IT Technical skills in the Latino community and mentor many Latino women in technology.

Abstract

There is often a time when DBA or Developers need to know why the SQL Database server is performing slower than usual and in this session, we will talk about how to find the root cause in a minute and remediation. Most of the time (90% of the time) following points are reasons: 1) Expensive Query or Stored Procedure with complete parameter details 2) Deadlock, Blocks 3) Disk latency 4) High IO Usage 5) Where are the waits We will see those reports quickly without running any manual T-SQL scripts so that things are simple and straight to point using a Free tool called SQL Planner. The textual version of this article is available here: https://mssqlplanner.com/finding-sql-server-root-cause-in-a-minute/

Speaker Bio

I 'Chandan Sahu' am a SQL Server Lead developer with 13 years of experience mainly in the SQL Server development area. By education, I have done Master's in Computer Application degree and Microsoft certified professional. I am a co-founder and Product manager of the SQL Planner monitoring tool and love to make database-related automation tools. I love Go-cart, and roaming new places. I am reachable at chandansahu@mssqlplanner.com | Twitter at @chandansql