Replacing Profiler traces with Extended Events starts with the question, a focused event session, and a bounded target that avoids needless load.
Standard DBA Reports You Can Write in T-SQL
Standard DBA reports can use T-SQL to show backup age, database sizes, job failures, login changes, and errors in one weekly review.
SQL SERVER – Fix Error 9803. Invalid data for type “numeric” – Data Type Mapping
My present article talks about an error that you will encounter when connecting to Oracle database using OPENQUERY. Let us learn about how to fix error 9803.
Reading the SQL Server Support Lifecycle
Read the SQL Server support lifecycle for your exact release, distinguish mainstream and extended support, and plan before coverage ends.
LEFT Boundaries: Zero, Oversized Length and Missing Text
LEFT boundaries keep empty prefixes separate from missing values. Eight short Unicode cases expose zero, oversized and missing lengths. A separate invalid request shows why negative lengths need validation.
DATEFROMPARTS: Build Dates With Explicit Components
DATEFROMPARTS avoids ambiguous text assembly. Preserve year, month and day inputs while separating missing components from invalid calendar dates.
What Is a Database Backup? Full, Differential, Log
A database backup comes in three kinds and they work together. Measured sizes for full, differential and log, why the recovery model decides everything, and the restore order that cannot be improvised.