SQL Server Management Studio tip: use the Template Browser to help you write SQL

Unless you work daily with SQL and SQL Server management, it might be easy to forget the exact syntax of various SQL commands. For example, to backup a database, create a trigger and enable audits are commands that you might need less often, but are nonetheless important.

SQL Server Management Studio (SSMS) contains a nifty hidden feature called Template Browser that contains dozens of ready-written SQL statements for many different needs. You just need to fill in the blanks.

Be sure to check the Template Browser out. You can access it through the View menu.