OLE DB provider names are now suggested for OPENROWSET and OPENQUERY
XML methods suggestion XQuery
CREATE TYPE .. AS TABLE
CREATE TYPE .. FROM
SET DATEFORMAT
SEND ON CONVERSATION
CREATE QUEUE
CREATE AGGREGATE
CREATE ASSEMBLY FROM
DBCC CLONEDATABASE
Jump between BEGIN/END - Navigate through the whole block while matching BEGIN/END statements.
Jump between COLUMNS and VALUES in INSERT statements - Helps you easily find the corresponding values of specified columns in INSERT statements. The command will highlight the matching column and value.
Execution warnings - Shows a warning message that may cause data loss when executing UPDATE or DELETE statements without a WHERE clause, as well as TRUNCATE.
CRUD generator - Generates a result script for SELECT, INSERT, UPDATE, and DELETE statements to a new SQL document.
Run scripts on multiple databases - Executes a script on several databases via the connection you choose.
Execution notifications - When a query execution is completed, a notification that includes name of document and duration is diplayed.
Transaction reminder - Alerts users that a transaction has not been completed.
Find in Results Grid - Highlights all matches either by case, or whole words, or regular expressions in the results grid.
Copy Results Grid Headers - Copy selected column names and/or types to CSV, XML, HTML, and JSON data formats.
Grid Aggregates - Selecting two or more rows in one column automatically opens an aggregate grid that displays calculations on the SSMS status bar.
Named Regions - Parse named and unnamed regions automatically, as well as wrap and unwrap regions.
Find Invalid Objects - Search for objects that refer to other, nonexistent objects in the database.
Formatting Profile Quick Select - Quickly switch between active formatting profiles.