Old but still my favorite: DBCC SQLPERF(logspace) to monitor transaction log space growth, saved with the time of each snapshot. Plus a puzzle for you.
SQL SERVER – Powershell – Importing CSV File Into Database – Video
PowerShell expert Laerte Junior shows importing CSV file into database tables with PowerShell, with a video, building on my SQL in Sixty Seconds post.
XACT_ABORT: Why a Half-Done Transaction Can Survive an Error
Use XACT_ABORT to prevent partial writes, inspect transaction state after an error, and build a TRY CATCH pattern with reliable rollback.
Finding the Right Answer in SQL Server Documentation
Use SQL Server documentation with the right version and platform selected, read syntax carefully, and keep useful reference material offline.
Building a Reference You Will Actually Use Again
Build a personal reference of dependable SQL examples with problem-based names, clear prerequisites, dated validation, and regular review.
SQL SERVER – Video – Beginning Performance Tuning with SQL Server Execution Plan
Performance tuning is a long journey, and the Execution Plan is its map. A video on how to begin tuning queries with SQL Server execution plans.
An Error Handling Template for Stored Procedures With THROW
Build an error handling template with XACT_ABORT, XACT_STATE, durable error logging, and THROW, then test a forced procedure failure.