SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: June 2011

[Speaking] Presenting at AITP Region 18 IT Con

The IT Con event this Saturday, June 18, is an event similar to SQL Saturday. It has three tracks, an IT Professional track, a Development track and a Career Development track. I'll be presenting two sessions in the IT Professional track.

Gather SQL Server Performance Data with PowerShell

We all… Read more

0 comments, 740 reads

Posted in Allen White on 16 June 2011

Use PowerShell to Add a Login to a Database Role in all Databases

Mark Freeman (@m60freeman) posted a question on Twitter using the #sqlhelp hashtag today, asking "Does anyone have a script to assign db_backupoperator for all databases in an instance to a login?" I looked and didn't really have anything that fit, but felt it'd be useful to understand the SMO process… Read more

0 comments, 3,849 reads

Posted in Allen White on 3 June 2011