August 2010 - Posts

• Scripting Database Mail Configuration with Powershell and SMO

  Setting up Database Mail in SQL Server 2005 and 2008 is a common task that is performed post server setup. However, if you just took over a fairly large environment and faced having to configure Database Mail on dozens, maybe hundreds of servers, SQL Read More... Posted Monday, August 23, 2010 9:36 AM by Jonathan Kehayias | 7 Comments Filed under: Powershell

• Creating a Database Role to Allow Users to Script Object Definitions

  In the past month I’ve answered a couple of questions similar to: Is there a database role I can assign (other than dbo) that will allow a user to "see" stored procedures.  As it is, I have granted the user db_datareader so, from SSMS, Read More... Posted Wednesday, August 04, 2010 11:47 PM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, Security

• There is no such thing as a “Small Change” to a production database

  It seems like every week I get hit up with some kind of “Its a view only for this specific report,” or “It is a simple change that the vendor would have made if they had access” type of request related to SQL Server.  If you’ve never dealt with me, Read More... Posted Tuesday, August 03, 2010 10:50 PM by Jonathan Kehayias | 9 Comments Filed under: Database Administration, Miscellaneous