We have been discussing about PowerShell in a regular interval. In such a way, this is another tip for you about PowerShell. Using PowerShell is as easy as it presents you with things as drives. If you wish to use C drive, you can use “CD C:” in PowerShell as you do in DOS. Moreover, if you wish to access your registry, you can do it by typing “CD HKLM:”. If you wish to access SQL Server via PowerShell, it is required to type “CD SQLSERVER:”. Now, let’s try connecting to a SQL Server and to a specific DB. If you wish to do so, you can simply type the following command.
>cd SQLServer:\SQL\ServerName\Default\Databases\DBName
As you’ve clearly understood the structure of PowerShell, you can easily switch between servers, databases or any other objects as you’ve to replace the name of the objects and leave the rest the same. Now, let’s have a look about the different drives with you can work. The command we’ve provided is “psdrive” and it is required to type it as follows in the PowerShell Prompt.
>psdrive
