LA Data Platform UG

Thank you to Dustin for a great session and for attending our last meeting! (0319) Session #1 - Incremental data loading with Azure Databricks by Dustin Vannoy More info: https://lnkd.in/gg3sn_Ga #ladataplatform #azure #databricks #dataload

Our favorite content for this week (0321)! Troubleshoot SQL Always On Availability Groups with SQL LogScout by Edwin M Sarmiento https://lnkd.in/enehDFcb Azure Private DNS Zone Change You Want To Make by Denham Cherry https://lnkd.in/g3iHewBF Managed Instance link with SQL Server 2017 is now GA by Djordje Jeremic https://lnkd.in/gJrMddrR Oracle Back to Basics : What is an Undo Record? by Gustavo René Antúnez https://lnkd.in/gBHjQPUj Understanding the Logical Functions IIF and Choose in SQL Server 2022 by – SQLServerCentral https://lnkd.in/gNEiWkup How to Recover a Deleted Table in a SQL Server Database by Mithilesh Tata https://lnkd.in/gX5Hrch4 100 Things I Hate About Views: Undeclared Data Types in Columns by Kendra Little 🏳️🌈 https://lnkd.in/ghS6sbAS Ola Hallengren’s SQL Server Maintenance Solution in AWS | Microsoft Workloads on AWS https://lnkd.in/gWJuZJRn More info: https://lnkd.in/ggx-MDZN #ladataplatform #sqlserver #alwayson #azuredns #azuresqlmi #oracle #sqlserver2022 #recovery #views #aws

Join LA Data Platform UG today (Wednesday, March 19, 2025 at 7PM PDT) Incremental data loading with Azure Databricks by Dustin Vannoy Abstract There has been an increasing push to load data incrementally throughout the day, sometimes within minutes. For example, you may replicate data for analytics from an application database using Change Data Feed. Apache Spark and Delta Lake are great options for doing this on a large scale. Using Azure Databricks for this type of processing gives us the power of Apache Spark and Delta Lake, plus added benefits like auto-loader and Delta Live Tables. In this session, you will learn best practices for incremental data processing and see several techniques for building these data pipelines using Azure Databricks. Speaker Bio Dustin Vannoy is a Data Engineering Consultant experienced in solving business problems with analytics and big data solutions. He is passionate about all aspects of data engineering, especially building data platforms and streaming data pipelines. He currently focuses on building data platforms and pipelines in Apache Spark / Databricks, Kafka, Python, and Scala. He co-founded the Data Engineering San Diego meetup and encouraged others to grow their data skills by making tutorials, mentoring others, and speaking at events. RSVP here https://lnkd.in/g8H6uSfN

Get ready for SQL Saturday Orange County 2025 ! 📅 Date: Saturday, May 3, 2025 📍 Location: Quest Software | Aliso Viejo Join us for a FREE one-day training event tailored for SQL, data, and IT professionals, developers, and students eager to expand their skills! 🔹 Event Details: https://lnkd.in/gVgS9X8F 🎤 Call for Speakers – Now Open! Have insights to share? Submit your session proposal and contribute to the community. 🔗 https://lnkd.in/gZ6tY7Fs 🤝 Call for Sponsors – Now Open! Support the event while showcasing your brand to a highly engaged audience of database and tech professionals. 🔗 https://lnkd.in/gGpTr75d Don’t miss a full day of learning, networking, and community at #SQLSATOC! 🎟 Register Now: https://lnkd.in/gWeUWDzQ #SQLSaturday #SQLSaturdayOC #DataCommunity #SQLServer #DataAnalytics #Database #MicrosoftSQL #Azure #AI #MachineLearning #BigData #DevOps #CloudComputing #SQL #DataEngineering #PowerBI #Azure #CloudSecurity #WomenInTech #DataExperts #SQLSATOC

Our favorite content for this week (0314)! Get access to SQL Server when you don't have the SA password by Vlad Drumea https://lnkd.in/gY8ikxQ3 Improving Azure SQL Database reliability with accelerated database recovery in tempdb by Dimitri Furman https://lnkd.in/gjtPjQav What the Decline of Sql Server Quality means for Developers and DBAs by Kendra Little 🏳️🌈 https://lnkd.in/g7Ak2vyi GitHub - microsoft/mssql-python https://lnkd.in/ggP2pAeA What are the top data and analytics trends for 2025? by Thom Carter https://lnkd.in/d4wFVRmE More info: https://lnkd.in/gGQ_QHGv #ladataplatform #sqlserver #azuresqldb #dba #python #dataanalytics #trends

Our favorite content for this week (0307)! Understanding 'ALTER TABLE SWITCH statement failed' errors 4907, 4908, and 4912 by Eitan Blumin https://buff.ly/gKoPFHY Dangerous SET options stored procedure inherits from your session by Vlad Drumea https://buff.ly/WaD4Hhh AI will eliminate DBA Jobs faster than you think by Kendra Little 🏳️🌈 https://buff.ly/NMWHQYt Eliminating Unnecessary DELETE Operations by Monica Rathbun https://buff.ly/FciFNLY SQL Server Availability Groups - Restoring a database into a secondary replica manually by Kevin Lewis https://buff.ly/BdcZ5cv Detecting and Resolving Deadlocks in SQL Server 2019 by Sanjay Humania https://buff.ly/IopBRln Real time Issues and Alerts in SQL Server by Sanjay Humania https://buff.ly/ZVSeKoX More info: https://buff.ly/oYiN3Ic #ladataplatform #altertable #storedprocedure #ai #dba #crud #availabilitygroups #deadlock #alerts

FabCon Vegas is more than just sessions about Microsoft Fabric.  It has Database tracks with over 40 sessions covering Databases, SQL Server 2025, Azure SQL, Optimization, the SQL Engine, SQL in Fabric, and more. Learn more at https://aka.ms/db-fabcon Register now with the code SQLINSIDER for Microsoft Fabric Community Conference and save $400 off registration Why a database professional shouldn’t miss FabCon Vegas 2025: INNOVATIVE SQL SOLUTIONS: Explore the cutting-edge integration of SQL databases in Fabric, designed to enhance your data architecture with high-volume transaction support and seamless analytics integration. SQL SERVER 2025 INSIGHTS: Get an exclusive look at the newest features and capabilities of SQL Server 2025. Engage with the Microsoft product team and gain hands-on experience. EXPERT-LED SESSIONS: Shireesh Thota, Priya Sathy, and Bob Ward unveiling the future of SQL Server Workshops and sessions from the Microsoft Product Group including Erin Stellato, Pam Lahoud, Muazma Zahid, Drew Skwiers-Koballa, Argenis Fernandez, and Davide Mauri. Sessions from SQL Community members and Data Platform MVPs like Denny Cherry, Joey D’Antoni, Grant Fritchey, Monica Rathbun, Karen Lopez, John Morehouse, and more! ENHANCE YOUR SQL KNOWLEDGE: · Pick one of 3 intensive SQL-focused workshops · Attend dedicated tracks on SQL in Fabric and SQL Server 2025 · Benefit from 1:1 problem-solving sessions with Microsoft engineers and MVPs Register now with the code SQLINSIDER for Microsoft Fabric Community Conference and save $400 off registration  https://fabricconf.com/#!/

Our favorite content for this week (0228)! Trust is a Funny Thing by Steve Jones https://buff.ly/4il0IDG Copilot in SSMS is Kinda Like IE in SSMS by Brent Ozar https://buff.ly/4ieKDPC SQL Agent Job Output Options for Troubleshooting by Jim E. https://buff.ly/3EUnmEk Shrink Database With Low Priority by Melody Zacharias https://buff.ly/4khpd6v The Curious Case of... setting up a server for DBCC CHECKDB by Paul Randal https://buff.ly/4h0jfnz More info: https://buff.ly/4hZRJb7 #ladataplatform #trust #ssms #sqlagent #shrinkdb #dbcc #checkdb #sqlserver #microsoft

Our favorite content for this week (0221)! Is It Time to Say Goodbye to Data Engineers? https://buff.ly/3QrSi1i Migrate the sa password to another instance without knowing it by Vlad Drumea https://buff.ly/4hObS3M Modernise OS and Shape of your Oracle Base Database Systems with Data Guard using Refreshable PDBs by Amalraj P https://buff.ly/430sj8J DBA Horror Stories by Terri Hurley https://buff.ly/41cIqgX Storage Engine In SQL Server Part 1 by Süleyman Essa https://buff.ly/43d7zKO Understanding the “mssqlsystemresource” (Resource) Database in SQL Server by Stephen Planck https://buff.ly/4hM16ew More info: https://buff.ly/4ib23gm #ladataplatform #dataengineer #sapassword #oracledb #dbahorror #storageengine #sqlserver #systemdatabase

Thank you to our speakers and to those who attended our last meeting! (0219) Session #1 - Microsoft Fabric by Eugene Meidinger Session #2 - SQL on Linux by Andrew Pruski More info: https://buff.ly/4i7fJZt #ladataplatform #usergroup #februarymeeting