What does BACKUP WITH NAME do? It simply names your backup, and you can then find that name in the msdb backupset table. Here is a quick example.
Get Column Names From a Specific Table – SQL in Sixty Seconds #083
One of the most popular question I receive is usually about How to get column names from a specific table in SQL Server?
SQL Server – How to Get Column Names From a Specific Table?
How do you get the column names of a specific table in SQL Server? Here are several methods, from INFORMATION_SCHEMA.COLUMNS to my preferred sys.columns query.
SQL SERVER – Simple Query to List Size of the Table with Row Counts
A simple query I run at customer sites to list every table with its size in MB and Row Counts, including used and unused space.
SQL SERVER – How to Find Row Count of Every Table in Database Efficiently?
How do you find the row count of every table in a database without a cursor? An interview question, answered with a fast query instead of a loop.
SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup
I broke my own SQL Server by editing startup parameters. Here is how the ERRORLOG helped me fix error 17113, error opening master.mdf at startup.
Special Icon on System-Versioned Table in SQL Server 2016 – Interview Question of the Week #101
Expanding tables in WideWorldImporters in SSMS 2016, you see an icon like a watch. It marks a System-Versioned table, also known as a temporal table.