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
Log shipping Alerts failing to send emails
Script to Check TempDB Speed
Moving the tempdb database
SQL Server buffer pool
View queries waiting for memory grant