You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: docs/powershell/sql-server-powershell.md
+5-5Lines changed: 5 additions & 5 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -48,7 +48,7 @@ This section applies to scripts executed from PowerShell and not the SQL Agent.
48
48
49
49
The **SqlServer** module comes with:
50
50
51
-
-[PowerShell Providers](/powershell/module/microsoft.powershell.core/about/about_providers), which enables a simple navigation mechanism similar to file system paths. You can build paths similar to file system paths, where the drive is associated with a SQL Server management object model, and the nodes are based on the object model classes. You can then use familiar commands such as **cd** and **dir** to navigate the paths similar to the way you navigate folders in a command prompt window. You can use other commands, such as **ren** or **del**, to perform actions on the nodes in the path.
51
+
-[PowerShell Providers](/powershell/module/microsoft.powershell.core/about/about_providers), which enables a simple navigation mechanism similar to file system paths. You can build paths similar to file system paths, where the drive is associated with a SQL Server management object model, and the nodes are based on the object model classes. You can then use familiar commands such as **cd**(alias for Set-Location) and **dir**(alias for Get-ChildItem) to navigate the paths similar to the way you navigate folders in a command prompt window. You can use other commands, such as **ren**(alias for Rename-Item) or **del** (alias for Remove-Item), to perform actions on the nodes in the path.
52
52
53
53
- A set of cmdlets that support actions such as running a **sqlcmd** script containing Transact-SQL or XQuery statements.
54
54
@@ -60,13 +60,13 @@ SQL PowerShell cmdlets can be used to manage instances of Azure SQL Database, Az
60
60
61
61
## SQL Server identifiers that contain characters not supported in PowerShell paths
62
62
63
-
The **Encode-Sqlname** and **Decode-Sqlname** cmdlets help you specify SQL Server identifiers that contain characters not supported in PowerShell paths. For more information, see [SQL Server Identifiers in PowerShell](sql-server-identifiers-in-powershell.md).
63
+
The **Encode-Sqlname**(alias for ConvertTo-EncodedSqlName) and **Decode-Sqlname** (alias for ConvertFrom-EncodedSqlName) cmdlets help you specify SQL Server identifiers that contain characters not supported in PowerShell paths. For more information, see [SQL Server Identifiers in PowerShell](sql-server-identifiers-in-powershell.md).
64
64
65
65
Use the **Convert-UrnToPath** cmdlet to convert a Unique Resource Name for a Database Engine object to a path for the SQL Server PowerShell provider. For more information, see [Convert URNs to SQL Server Provider Paths](/powershell/module/sqlserver/Convert-UrnToPath).
66
66
67
-
## Query Expressions and Unique Resource Names
67
+
## Query Expressions and Uniform Resource Names
68
68
69
-
Query expressions are strings that use syntax similar to XPath to specify a set of criteria that enumerates 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).
69
+
Query expressions are strings that use syntax similar to XPath to specify a set of criteria that enumerates one or more objects in an object model hierarchy. A Uniform 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).
70
70
71
71
## SQL Server Agent
72
72
@@ -105,4 +105,4 @@ Import-Module -Name SqlServer
105
105
106
106
-[Download SQL Server PowerShell Module](download-sql-server-ps-module.md)
107
107
-[SQL Server PowerShell cmdlets](/powershell/module/sqlserver)
108
-
-[Use PowerShell with Azure Data Studio](../azure-data-studio/extensions/powershell-extension.md)
108
+
-[Use PowerShell with Azure Data Studio](../azure-data-studio/extensions/powershell-extension.md)
0 commit comments