SQL Server Nuggets

CREATE DATABASE [Contoso 1M] ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQL2019\MSSQL\DATA\Contoso 1M.mdf'), (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL15.SQL2019\MSSQL\LOG\Contoso 1M_log.ldf') FOR ATTACH;

OBJECT TRANSACT-SQL https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-exec-describe-first-result-set-transact-sql?view=sql-server-ver16