Skip to content

Commit 95394ec

Browse files
author
stevestein
committed
organizing
1 parent 90b213c commit 95394ec

4 files changed

Lines changed: 22 additions & 39 deletions

File tree

‎docs/powershell/TOC.md‎

Lines changed: 16 additions & 21 deletions
Original file line numberDiff line numberDiff line change
@@ -1,26 +1,21 @@
11
# [Install SQL PowerShell module](download-sql-server-ps-module.md)
2-
# Overview
3-
## [SQL Server PowerShell](sql-server-powershell.md)
4-
# Concepts
2+
# [SQL Server PowerShell overview](sql-server-powershell.md)
53
## [SQL Server PowerShell Provider](sql-server-powershell-provider.md)
64
## [Query Expressions and Uniform Resource Names](query-expressions-and-uniform-resource-names.md)
7-
# Quickstarts
8-
# Tutorials
9-
# How-to guides
10-
## [Access SQL Server Objects](navigate-sql-server-powershell-paths.md)
11-
## [Load the SMO Assemblies in Windows PowerShell](load-the-smo-assemblies-in-windows-powershell.md)
12-
## [Run PowerShell in SSMS](run-windows-powershell-from-sql-server-management-studio.md)
13-
## [Run PowerShell with SQL Server Agent](run-windows-powershell-steps-in-sql-server-agent.md)
14-
## [Work With SQL Server PowerShell Paths](work-with-sql-server-powershell-paths.md)
15-
## [SQL Server Identifiers in PowerShell](sql-server-identifiers-in-powershell.md)
16-
### [Specify Instances in the SQL Server PowerShell Provider](specify-instances-in-the-sql-server-powershell-provider.md)
17-
### [Encode and Decode SQL Server Identifiers](encode-and-decode-sql-server-identifiers.md)
18-
### [Escape SQL Server Identifiers](escape-sql-server-identifiers.md)
19-
## [Manage Authentication in Database Engine PowerShell](manage-authentication-in-database-engine-powershell.md)
20-
## [Manage Tab Completion (SQL Server PowerShell)](manage-tab-completion-sql-server-powershell.md)
21-
# Reference
22-
## [Sqlserver module reference](https://docs.microsoft.com/powershell/module/sqlserver/?toc=/sql/powershell/toc.json)
23-
## [Sqlps module reference](https://docs.microsoft.com/powershell/module/sqlps/?toc=/sql/powershell/toc.json)
5+
# [How to access SQL Server Objects](navigate-sql-server-powershell-paths.md)
6+
# [How to load the SMO Assemblies in Windows PowerShell](load-the-smo-assemblies-in-windows-powershell.md)
7+
# [How to run PowerShell in SSMS](run-windows-powershell-from-sql-server-management-studio.md)
8+
# [How to run PowerShell with SQL Server Agent](run-windows-powershell-steps-in-sql-server-agent.md)
9+
# [How to manage authentication](manage-authentication-in-database-engine-powershell.md)
10+
# [How to manage tab completion](manage-tab-completion-sql-server-powershell.md)
11+
# [Work With SQL Server PowerShell Paths](work-with-sql-server-powershell-paths.md)
12+
# [SQL Server Identifiers in PowerShell](sql-server-identifiers-in-powershell.md)
13+
## [Specify Instances in the SQL Server PowerShell Provider](specify-instances-in-the-sql-server-powershell-provider.md)
14+
## [Encode and Decode SQL Server Identifiers](encode-and-decode-sql-server-identifiers.md)
15+
## [Escape SQL Server Identifiers](escape-sql-server-identifiers.md)
2416
# Resources
2517
## [New and updated articles](new-updated-powershell.md)
26-
## [SQL Server PowerShell License Terms](sql-server-powershell-license-terms.md)
18+
## [SQL Server PowerShell License Terms](sql-server-powershell-license-terms.md)
19+
# Cmdlet reference
20+
## [SqlServer cmdlets](https://docs.microsoft.com/powershell/module/sqlserver/?toc=/sql/powershell/toc.json)
21+
## [SQLPS cmdlets](https://docs.microsoft.com/powershell/module/sqlps/?toc=/sql/powershell/toc.json)

‎docs/powershell/download-sql-server-ps-module.md‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -60,5 +60,5 @@ To use a specific version of the module, you can import it with a specific versi
6060
The versions of the **SqlServer** module in the PowerShell Gallery support versioning and require PowerShell version 5.0 or greater.
6161

6262
* [SqlServer module in the PowerShell Gallery](https://www.powershellgallery.com/packages/Sqlserver)
63-
* [SqlServer module reference](https://docs.microsoft.com/powershell/module/sqlserver)
64-
* [SQLPS module reference](https://docs.microsoft.com/powershell/module/sqlps)
63+
* [SqlServer cmdlets](https://docs.microsoft.com/powershell/module/sqlserver)
64+
* [SQLPS cmdlets](https://docs.microsoft.com/powershell/module/sqlps)

‎docs/powershell/run-windows-powershell-from-sql-server-management-studio.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -22,7 +22,7 @@ ms.workload: "On Demand"
2222
# Run Windows PowerShell from SQL Server Management Studio
2323
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
2424

25-
You can start Windows PowerShell sessions from **Object Explorer** in [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)]. [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] launches Windows PowerShell, loads the **sqlps** module, and sets the path context to the associated node in the **Object Explorer** tree.
25+
You can start Windows PowerShell sessions from **Object Explorer** in [!INCLUDE[ssManStudioFull](../includes/ssmanstudiofull-md.md)]. [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] launches Windows PowerShell, loads the **SqlServer** module, and sets the path context to the associated node in the **Object Explorer** tree.
2626

2727

2828
> [!NOTE]

‎docs/powershell/sql-server-powershell.md‎

Lines changed: 3 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -59,19 +59,7 @@ Use the **Convert-UrnToPath** cmdlet to convert a Unique Resource Name for a [!I
5959
Query expressions are strings that use syntax similar to XPath to specify a set of criteria that enumerate one or more objects in an object model hierarchy. A Unique Resource Name (URN) is a specific type of query expression string that uniquely identifies a single object. For more information, see [Query Expressions and Uniform Resource Names](query-expressions-and-uniform-resource-names.md).
6060

6161

62+
## Cmdlet reference
63+
* [SqlServer cmdlets](https://docs.microsoft.com/powershell/module/sqlserver)
64+
* [SQLPS cmdlets](https://docs.microsoft.com/powershell/module/sqlps)
6265

63-
## SQL Server PowerShell Tasks
64-
65-
|Task Description|Article|
66-
|----------------------|-----------|
67-
|Installing Microsoft® Windows PowerShell Extensions for Microsoft [!INCLUDE[ssCurrent](../includes/sscurrent-md.md)]. The PowerShell modules are installed by default when installing [!INCLUDE[msCoName](../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)]. You can manually install the PowerShell Extensions for SQL Server 2016 by installing the following components from the Microsoft® SQL Server® 2016 Feature Pack:<br/> Microsoft® System CLR Types for Microsoft SQL Server® 2016 (SQLSysClrTypes.msi)<br/>Microsoft® SQL Server® 2016 Shared Management Objects (SharedManagementObjects.msi)<br/> Microsoft® Windows PowerShell Extensions for Microsoft SQL Server® 2016 (PowerShellTools.msi)|[Microsoft® SQL Server® 2016 Feature Pack](https://www.microsoft.com/en-us/download/details.aspx?id=52676). |
68-
|Describes the preferred mechanism for running the [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] PowerShell components; to open a PowerShell session and load the **sqlps** module. The **sqlps** module loads in the [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] PowerShell provider and cmdlets, and the SQL Server Management Object (SMO) assemblies used by the provider and cmdlets.|Import the SQLPS Module](https://docs.microsoft.com/en-us/sql/powershell/import-the-sqlps-module)|
69-
|Describes how to load only the SMO assemblies without the provider or cmdlets.|[Load the SMO Assemblies in Windows PowerShell](load-the-smo-assemblies-in-windows-powershell.md)|
70-
|Describes how to run a Windows PowerShell session by right-clicking a node in **Object Explorer**. [!INCLUDE[ssManStudio](../includes/ssmanstudio-md.md)] launches a Windows PowerShell session, loads the **sqlps** module, and sets the SQL Server provider path to the object selected.|[Run Windows PowerShell from SQL Server Management Studio](run-windows-powershell-from-sql-server-management-studio.md)|
71-
|Describes how to create SQL Server Agent job steps that run a Windows PowerShell script. The jobs can then be scheduled to run at specific times or in response to events.|[Run Windows PowerShell Steps in SQL Server Agent](run-windows-powershell-steps-in-sql-server-agent.md)|
72-
|Describes how to use the [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] provider to navigate a hierarchy of [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] objects.|[SQL Server PowerShell Provider](sql-server-powershell-provider.md)|
73-
|Describes how to specify [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] delimited identifiers that contain characters not supported by Windows PowerShell.|[SQL Server Identifiers in PowerShell](sql-server-identifiers-in-powershell.md)|
74-
|Describes how to make SQL Server Authentication connections. By default, the SQL Server PowerShell components use Windows Authentication connections using the Windows credentials of the process running Windows PowerShell.|[Manage Authentication in Database Engine PowerShell](manage-authentication-in-database-engine-powershell.md)|
75-
|Describes how to use variables implemented by the SQL Server PowerShell provider to control how many objects are listed when using Windows PowerShell tab completion. This is particularly useful when working on databases that contain large numbers of objects.|[Manage Tab Completion &#40;SQL Server PowerShell&#41;](manage-tab-completion-sql-server-powershell.md)|
76-
77-

0 commit comments

Comments
 (0)