LA Data Platform UG

Today is the day - Converting 3500+ tests from one version to another using AI by Chrissy LeMaire (WED, DEC 17 @ 7PM PST) More info: https://buff.ly/gH4cRoN #ladataplatform #dbatools #ai #artificalintelligence #powershell #automation #claude #pester

Thank you for attending our last meeting, and thank you to Douglas McDowell for a great presentation! (0820) More info: https://buff.ly/kJunLg6 #ladataplatform #usergroup #finops #CapEx #OpEx #cloudcomputing #cto

Our favorite content for this week (1114)! KB2878968 - FIX: Nonclustered index corruption may occur when you run a complex UPDATE statement together with a NOLOCK hint against a table in SQL Server https://lnkd.in/gr5udjXR SQL ConstantCare® Population Report: Fall 2025 by Brent Ozar https://lnkd.in/gBvXtWZK SQL Server Management Studio 22 New Features Explained by daniel Calbimonte https://lnkd.in/ghgMhcvk Considerations For Paging Queries In SQL Server With Batch Mode (Don't Use OFFSET/FETCH) by Erik Darling https://lnkd.in/g_yp3eZn SQL Server 2025 GAs Today by Steve Jones https://lnkd.in/gV_B7AAY More info: https://buff.ly/ZqpSjn9 #ladataplatform #sqlserver2025

Our favorite content for this week (1107)! To Kill a SPID or Not To Kill a SPID - SQL Server Consulting by warren departee https://buff.ly/vod7cdE SQL Strategies for Comparing Sets of Data by Louis Davidson https://buff.ly/lXope95 Breaking Changes & Migration Risks in SQL Server 2025 by Rebecca Lewis https://buff.ly/dQ8bOtL Scooby Dooing Episode 10: The Case of the Copy-and-Paste Consultant by Monica Morehouse https://buff.ly/x86czvi How To Forecast Database Disk Capacity If You Don’t Have A Monitoring Tool by Edwin M Sarmiento https://buff.ly/F1cT7Rw More info: https://buff.ly/1i5u8Ec #ladataplatform #sqlserver #strategy #consulting #breakingchanges #forecasting

Our favorite content for this week (1031)! Hyper-V and SQL Server Best Practices: What We Wish You by Mike Walsh https://lnkd.in/g_V_3_gY Skip the Full Snapshot: Add a Single Article to SQL Replication Fast! by Chris Woods https://lnkd.in/gfHjhETC The Version Store Won't Clear If ANY Database Has Open Transactions by Brent Ozar https://lnkd.in/gn4HC3mH SQL Server Bulk Insert: Dynamic vs. Static Methods by Richard Dobson https://lnkd.in/eZCysD7c Extract JSON Data in SQL: A Complete Guide by Hristo Hristov https://lnkd.in/e-f-Rjfu More info: https://buff.ly/0oXPUWh #sqlserver #virtualization #best practices #sqlreplication #versionstore #json #sql #data #bulkinsert

Our favorite content for this week (1024)! SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information by Suresh Raavi https://buff.ly/YDrYtDL The TOP (N) Trick: Short Circuit Your SQL Server Counts for Massive Speed Gains by Chris Woods https://buff.ly/rd2f2Rk Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server by Stephen Planck https://buff.ly/UArha9n Concatenating values as character data in SQL Server 2025 by Louis Davidson https://buff.ly/z4PlxIy Everything you need to know about TDE key management for database restore by Pieter Vanhove https://buff.ly/MlBkqrv Trace Flag 1448 - Lessons from a Technical Interview by Garry Bargsley https://buff.ly/RaK4aUj Index Usage Across SQL Server Availability Groups by Aaron Bertrand https://buff.ly/O3NdQFc Have You Considered Not Using SQL Server High Availability? by Chrissy LeMaire https://buff.ly/eiwcS5b So, you want to use MERGE, eh? by Aaron Bertrand https://buff.ly/odikqfe When 1,000+ Partitions in SQL Server Becomes an Anti-Pattern by Stephen Planck https://buff.ly/1HB9tLE More info: https://buff.ly/3QR60id #ladataplatform #sqlserver #topcount #hadr #sqlserver2025 #tde #interview #indexing #consideration #merge #designpatterns

Our favorite content for this week (1017)! The Journey to PostgreSQL (or anything) by Steve Jones https://buff.ly/S7faKcd SQL Index Usage Across Availability Groups Aaron Bertrand https://buff.ly/bEzmVi2 Smarter SQL Server Automation with Ansible Handlers: Restart Only When Needed by Luke Campbell https://buff.ly/OAn5DWO Optimizing Semantic Models for Copilot: Best Practices and Why They Matter by Jen Beiser https://buff.ly/r9qnwOX Auto Seeding vs. Manual Seeding for AG Secondary Replicas in SQL Server by Stephen Planck https://buff.ly/UArha9n Git Best Practices and Hard Lessons Learned by Amy Abel https://buff.ly/p42kCzv How It Works: SQL Server (NUMA Local, Foreign and Away Memory Blocks) https://buff.ly/3l8Sfg9 Why the Optimizer Doesn't Use Buffer Pool Knowledge by Paul Randal https://buff.ly/JiVRVJQ The SQL Server DBA’s Guide to Windows Server Failover Clustering: The Engine Under the Hood – Part 1 by Edwin M Sarmiento https://buff.ly/RPN5czV More info: https://buff.ly/g5T5g3A #posgres #indexing #automation #sqlserver #copilot #hadr #git #numa #optimizer #failover

Thank you very much to Angela Henry and @Itzhak David for awesome presentations as well as to those who attended our last User Group meeting. Session #1 - Data Modeling Session #2 - SQL Server 2022 & Azure More info: https://buff.ly/nlXqQRu #ladataplatform #datamodeling #sqlserver2025

Happening today (WED, OCT 15): Data Modeling by Angela Henry & SQL Server 2022 & Azure SQL by David Itzhak More info: https://buff.ly/YHezaMZ #ladataplatform #datamodeling #sqlserver2025 #azuresql

Our favorite content for this week (1010)! In-Place Upgradation vs Side-by-Side Migration in SQL Server by Sanjay Humania https://buff.ly/fJDyWHG How to Install DBeaver and Connect to a PostgreSQL Instance by Garry Bargsley https://buff.ly/dBWshS2 Which Should You Use: VARCHAR or NVARCHAR? by Brent Ozar https://buff.ly/sy7KY51 Technological Dinosaurs or Social Dinosaurs? by Grant Fritchey https://buff.ly/6vrvg58 SQL Server Bulk Insert: Dynamic vs. Static Methods by Ricardo Dobson https://buff.ly/Z2LD3AB More info: https://buff.ly/zNtwzmM #ladataplatform #upgrade #dbbeaver #pgsql #datatype #innovation #changes #bulkinsert