SQLServerCentral - Latest News and Information
Technology Pulse
EMAIL DIGESTS
Daily
Every morning
Weekly
Tuesday recap
EMAIL DIGESTS
Daily
Every morning
Weekly
Tuesday recap
Even with SQL Server’s 2026 security enhancements, the built‑in sa account remains a critical attack vector. Attack tools still assume sa exists and brute‑force its password, giving adversaries immediate sysadmin control. Because sa bypasses many modern access controls, compromising it enables ransomware, data exfiltration, and audit disabling. Best‑practice guidance now recommends disabling sa, switching to Windows authentication, and implementing break‑glass or just‑in‑time privileged accounts.
The article demonstrates how to use the sqlpackage command‑line utility to detect schema drift between Azure SQL databases by comparing a DACPAC file against a target database and generating a delta script. It outlines a lightweight, scriptable workflow that avoids...
Redgate hosted a webinar titled "Compliance Without Compromise: Test Data Management That Finally Fits," highlighting how modern test data management can meet strict compliance requirements without slowing development. Speakers Kellyn Gorman, Redgate’s Multiplatform Database/AI Advocate, and Product Manager James Hemson...
Liquid Clustering is a Delta‑Lake layout strategy that dynamically groups rows by query‑driven columns instead of static folder partitions. By continuously reorganizing files, it makes file‑level statistics more useful, enabling stronger data skipping and smaller scan footprints. Engineers enable it...
The article shows how to locate and list duplicate rows in a SQL Server table using a Common Table Expression (CTE) that groups all columns and counts occurrences. It presents two queries: one that returns only unique rows (order_count = 1) and...
The article argues that AI readiness starts with robust SQL Server schema design, not with machine‑learning models. It highlights that stable, non‑recycled primary keys, preserved historical records, and clear audit columns are essential for future feature engineering. By separating raw...
SQL Server Central’s engineers built a custom email‑queue using plain SQL Server tables and a lightweight .NET sender to replace an expensive third‑party service. By inserting newsletters and user addresses into an EmailNewsletter table, they processed batches of 500 rows,...
