This is another excellent video that shows the power of powershell in SQL administration. I love this video because it’s a very common scenario and keeps you from writing a SQL cursor. This is one of my favorites.
Grant Schema Permissions in Powershell
