(Page 2/7)

Using PowerShell to discover information about your Microsoft SQL Servers

I’m an infrastructure guy who supports many different products at multiple datacenters in an enterprise environment. One of those products…

Read More

#PSTip Deleting extended properties on database objects using SMO

Note: This tip requires PowerShell 2.0 or above. In earlier tips, we looked at how to add, read and update…

Read More

#PSTip Updating extended properties on database objects using SMO

Note: This tip requires PowerShell 2.0 or above. In an earlier tip, we saw how we can read extended properties…

Read More

#PSTip Reading extended properties on database objects using SMO

Note: This tip requires PowerShell 2.0 or above. Extended properties are an useful but, under utilized feature in SQL server. In…

Read More

#PSTip Creating extended properties on database objects using SMO

Note: This tip requires PowerShell 2.0 or above. You might have seen several articles on the web discussing about the…

Read More

#PSTip Validate is a database is available on a SQL instance

Note: This tip requires PowerShell 2.0 or above. Sometimes we need to know if a particular DB is available on…

Read More