By Joshua Jones 01/18/2010 To wrap up this series of PowerShell articles, let's take a look at a few tips and tricks for working with PowerShell in SQL Server on a regular basis.

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

PowerShell expert Chad Miller commented (on VisualStudioMagazine.com another site hosting my blog) that PowerShell is quite extensible and allows you to build your own object explorer and directed me ...

Use PowerShell to script objects on a schedule or in a special order. Use PowerShell if you need to switch between windows and SQL commands or even share data between the two.

PowerShell 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 ...

SQLSERVER:\SQL This provider houses all of the basic objects: databases, tables, stored procedures, views, etc. SQLSERVER:\SQLPolicy This exposes all of the SQL Server Policy Based Management objects.

Using this template we can configure settings to optimize our SQL Server on Windows by the help of powershell scripts. Configure-Windows-Firewall-SQL-Ports.ps1 is used to to Configure Firewall Rules ...

PowerShell vs. SQL Server Management Studio When I (along with many other people) had a lot of trouble trying to install SQL Server Management Studio in an attempt to switch from the SQL Server 2008 ...