
SQL Server Management Studio 22.7 introduced a built-in T-SQL query formatter accessible via right-click or the Ctrl+K, Ctrl+Q shortcut. The formatter is highly configurable through Tools > Options > SQL Formatter, with extensive control over newline placement and other style preferences. Settings can be exported as JSON to share with teammates. Users can update to the latest SSMS via Help > Check for Updates.
Nguồn: https://www.brentozar.com/archive/2026/06/how-to-format-your-queries-in-ssms. 8sync News chỉ tóm tắt và dẫn link; bản quyền nội dung thuộc tác giả và nguồn gốc.

Brent Ozar explains why enrollment for his live SQL Server Mastering classes closes on July 12th. The change is driven by a structured rotation system designed to ensure students take classes in the correct order, preventing newer students from jumping into advanced material before completing prerequisites. The first rotation runs from July through October, covering Fundamentals, Index Tuning, Query Tuning, and Server Tuning. Season Pass holders get access to recordings and the next rotation if they miss sessions.
Brent Ozar hosts an outdoor Q&A session filmed at Seljalandsfoss waterfall in Iceland, answering community-voted DBA questions. Topics include whether AI will make junior DBAs obsolete, migrating to a 3-node Availability Group with minimal downtime, whether Googling basic syntax makes you underqualified, using MCP servers for DBA tasks, investigating root causes after Query Store plan forcing, risks of shrinking a 2TB database before migrating to Azure Managed Instance, and performance testing queries with table-valued parameters.
EF Core lacks a native method for mirroring a list to a database table. The hand-rolled diff-and-apply pattern (load, classify, insert/update/delete, SaveChanges) works but loads all rows into the change tracker, scales poorly, and is error-prone. Entity Framework Extensions (EFE) provides BulkSynchronize, which stages the source list in a temp table and runs a server-side MERGE to insert new rows, update changed rows, and delete rows absent from the source — all in one transaction without materializing existing rows in .NET memory. The key configuration option is ColumnSynchronizeDeleteKeySubsetExpression, which scopes the delete branch to a specific slice of the table (e.g., by SupplierId or TenantId) to avoid accidentally removing unrelated rows. Benchmarks show BulkSynchronize is 4–5x faster than the hand-rolled approach at 100K rows. The post covers four practical scenarios (API cache sync, reporting table refresh, reference table mirror, per-tenant sync), important production gotchas (change tracker staleness, FK constraints, interceptors not firing), and an honest assessment of when the paid EFE license is justified.