June 2011 - Posts

• [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 Read More... Posted Thursday, June 16, 2011 11:44 AM by AllenMWhite | 0 Comments

• 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 Read More... Posted Friday, June 03, 2011 2:09 PM by AllenMWhite | 5 Comments Filed under: Database Administration, PowerShell, SMO