This is when you need to focus on automation tools like Windows PowerShell. To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages.

Customizing PowerShell for SQL Server. 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.

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.

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