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

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.

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

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.

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 ...

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

Microsoft will remove PowerShell 2.0 from Windows starting in August, eight years after announcing its deprecation and ...