Another good example is adding user permissions to all the schemas in a database. You can code this in T-SQL, but T-SQL requires the inclusion of unsafe dynamic SQL code inside a cursor. You can ...

Getting ready for COLLABORATE 2012? If Security and Identity Management are top of mind for you, then we have some recommendations for you. To get a head start on your compliance and security program, ...

But not everyone has VB skills, and writing SMO (SQL Server Management Objects) is neither easy nor intuitive. PowerShell allows you to script a database in just 21 characters of code and schedule it ...