The project uses SQL Server SMO and Powershell to extract objects from SQl Server and store then in a local file repository. Each object is stored in a seperate file Objects are stored under a Folder ...

Open up new reporting options for your SQL Server with these PowerShell tips.

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

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

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

PowerShell gives DBAs a reason to begin using SMO for real, so now we'll find out about all the gory details ...

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.

Stuff in use: Windows Server 2008 R2 and a just-installed instance of SQL Server 2014. Now, when I installed it, it asked me if I wanted to use Windows Authentication only, to which I said, "sure ...