FORMAT is a function that is used return a NVARCHAR data type from a date/time or number. You can still use CAST or CONVERT for these and all other conversions. FORMAT is just another option that was introduced in SQL...
Database stuck in “Restoring” state
Find the modified date of SQL Server Agents Jobs
PING all the Linked Servers and get a status report
Script to Check TempDB Speed
Total Server Memory and Target Server Memory
Moving the tempdb database
SQL Server buffer pool
Log shipping Alerts failing to send emails
View queries waiting for memory grant