Category: SQL

Use supported T-SQL changes at the publisher and let transactional replication propagate compatible schema changes to subscribers.

Identify the exact SQL Server instance and engine version behind an SSMS query window before troubleshooting unsupported syntax.

Enable the Microsoft JDBC driver bulk-copy path for compatible prepared batch inserts and measure the result safely.

Grant the SQL Server Database Engine service identity access to a UNC share before running BACKUP DATABASE from SSMS or a maintenance plan.

Use SQL Server conditional aggregation to return ticket counts and sales totals per day and point-of-sale terminal without a fragile PIVOT query.

Set a finite SQL Server JDBC socket timeout and align pool validation settings so silently dropped network connections cannot consume application threads forever.

Use CREATE OR ALTER in its own SQL Server batch so a deployment script can create a new procedure or update an existing one safely.

Understand what SESSION_TIMEOUT changes, why a disconnected replica is not by itself an automatic failover trigger, and what to monitor.

Search SQL Server Query Store plan XML for an index name, then limit results to plans with executions in a selected time window.

Monitor SQL Server snapshot backup suspension time and automatically thaw a server-level freeze when the storage workflow fails to finish.