Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. Extended properties are an useful but, under utilized feature in SQL server. In an earlier tip, we saw that you can add extended properties to databases and other objects.
Read More
Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. You might have seen several articles on the web discussing about the SQL database extended properties from a self-documentation point of view.
Read More
Shay LevyNote: This tip requires PowerShell 4.0 or above. In this great post, Tobias walked you through the process of hiding functions from the debugger.
Read More
Shay LevyNote: This tip requires PowerShell 3.0 or above. PowerShell’s tab completion just got better in v3. In addition to all its awesomeness, it is now capable of completing service or process names, event log names, module names and the list is long.
Read More
Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. Sometimes we need to know if a particular DB is available on a given instance before going ahead and making any configuration changes.
Read More
Hemanth C DamecharlaNote: This tip requires PowerShell 2.0 or above. In a previous tip, we checked out how to get the names of all databases to which a login is mapped and the username for that login in each database.
Read More