Conventions

In this book, you will find a number of text styles that distinguish between different kinds of information. Here are some examples of these styles and an explanation of their meaning.

Code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles are shown as follows: "We can include other contexts through the use of the include directive."

A block of code is set as follows:

#set connection to mixed mode
#note that this authentication will fail if mixed mode
#is not enabled in SQL Server
$server.ConnectionContext.set_LoginSecure($false)

When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:

$server.Databases["AdventureWorks2014"].Tables |
Get-Member -MemberType "Property" |
Where-Object Definition -Like "*Smo*"

Any command-line input or output is written as follows:

(Get-Command -Module "*SQL*" –CommandType Cmdlet).Count

New terms and important words are shown in bold. Words that you see on the screen, for example, in menus or dialog boxes, appear in the text like this: "Open up your PowerShell console, PowerShell ISE, or your favorite PowerShell editor."

Note

Warnings or important notes appear in a box like this.

Tip

Tips and tricks appear like this.