Autocomplete and code formatting save time and prevent mistakes when they are set up well. This post covers the IntelliSense features in SSMS, the reasons they stop working, a simple formatting style, and a tested look at what formatting changes in the plan cache.
SQL SERVER – TRIM Function to Remove Leading and Trailing Spaces of String – SQL in Sixty Seconds #040 – Video
SQL Server has no TRIM function, and calling it gives error Msg 195. This SQL in Sixty Seconds video shows how to remove leading and trailing spaces without it.
SQL SERVER – Send Email From SQL Server – Configure Database Mail – SQL in Sixty Seconds #039 – Video
SQL Server is not mass mailing software, but it does need to send job alerts. This video shows how to configure Database Mail and send email quickly.
SQLCMD Mode in SSMS: Variables, :CONNECT and :r Includes
Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.
SQL Server – Using SSMS Command Line Parameters
My friend Vinod Kumar shows how SSMS Command Line parameters can save you a few clicks every time you open Management Studio and connect to a server.
SQL SERVER – Wrap SQL Code in SSMS – SQL in Sixty Seconds #038 – Video
Horizontal scrolling makes code hard to read. In this SQL in Sixty Seconds video I show how to wrap SQL code in SSMS without changing anyone’s formatting.
Take a Database Backup in SSMS: Step by Step
To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.