Look before you delete. This SQL in Sixty Seconds video shows one script to select duplicate records and another to delete them while keeping the latest row.
Writing T-SQL With an AI Assistant: What to Check Before You Run It
Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.
SQL Server Agent Basics
SQL Server Agent basics covers jobs, steps, schedules, proxies, and history so a first useful job runs with a clear owner and failure path.
A Calendar Table With Holidays for Date Math
Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.
SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video
A sixty second video on how to concat strings in SQL Server, from the plus sign to the SQL Server 2012 CONCAT function that needs no casting.
SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies
Which tables does a procedure use, and which procedures use a table? sys.sql_expression_dependencies answers both, with referenced and referencing objects.
Why Opening an MDF File Directly Goes Wrong
Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.