Microsoft® SQL Server 2012 Unleashed

Using the Provider

Using the SQL Server provider can be handy in navigating the system. Starting PowerShell from SSMS, DBAs can easily find their way through different objects as if working with files and directories.

When the SSMS is used to start PowerShell at the server level, the databases are down one level, and from there tables and users, for example, can also be easily accessed.

In the session shown in Figure 14.8, we navigated to a particular database and entered a dir Tables command. The output from the last command would scroll beyond the current screen, so only the first part of the output is displayed.

FIGURE 14.8 Navigating the SQL ...