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.
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.
AutoRecover Settings in SSMS: Protect Your Unsaved Queries
The AutoRecover settings in SSMS decide how often unsaved work is copied to disk and how long the copies are kept. This post shows where to find the two options, what they can and cannot protect, how to test them once, and which habit still matters more than any setting.
Rename a Column or Table in SQL Server Safely
To rename a column in SQL Server, call sp_rename with the table and column name, the new name and the word COLUMN. This post tests the rename on a demo database and shows what it leaves behind: a broken view, an old constraint name and permissions that stay. It ends with a safe way to swap two column names.
SQL SERVER – Changing Default Installation Path for SQL Server
Tired of moving MDF and LDF files after you create a database? Change the default installation path in server properties so new databases go where you want.
SQL SERVER – Copy Data from One Table to Another Table – SQL in Sixty Seconds #031 – Video
Many developers still use a cursor to copy data from one table to another. This SQL in Sixty Seconds video shows INSERT INTO SELECT and SELECT INTO instead.
Finding the Error Log Folder and Other Paths From T-SQL
Pasted a server path into File Explorer and found nothing? The folder is on the server, not your laptop. Here are the queries that tell you where.