Author: hemanthc

#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

#PSTip Finding all roles a particular login is mapped to in all databases

Note: This tip requires PowerShell 2.0 or above. In a previous tip, we checked out how to get the names…

Read More