Do You Talk to Your SQL DBA?

March 18, 2008

SharePoint administrators have various backgrounds, and there are few who have managed SQL prior to SharePoint. But those who come from collaboration or web pages management sometimes do not realize how important SQL is to SharePoint, and see them as two different worlds. Recently, there have been some positive movements and resources start appear that will help SQL and SharePoint admins to collaborate:

  • Database Maintenance for SharePoint whitepaper by Bill Baer. Even if you are not managing SQL side of the house, be sure you read it and discuss with your DBA. It explains various maintenance tasks available in SQL and how they are relevant to your SharePoint performance and stability.
  • Several good governance sessions by Joel Oleson during the recent SharePoint Conference – if you have access to the My SharePoint Conference site, be sure to download the slide decks! I think sessions and blog posts like the What’s new for SharePoint in SQL Server 2008 and Windows 2008 are a great help for SharePoint admins to start thinking about SQL.
  • Another session at SharePoint Conference by Todd Klindt was supposed to be called “SharePoint Administrators, the Reluctant DBAs”, but was renamed to something more neutral last minute (anyone remembers the name?). Anyway, this was an introduction for SharePoint admins into the SQL world. I hope Todd will post the slides on his blog too – it was a really good overview of how SharePoint uses SQL and why do you care.

All this does not mean every SharePoint admin should start managing SQL databases, of course not. But all this highlights how SQL is vital for SharePoint. Failing to work closely with your DBAs on things like backup and recovery strategy, maintenance plans, availability and capacity planning can really hurt your SharePoint deployment in the future.

Technorati Tags:
, , ,

Advertisements

One Response to “Do You Talk to Your SQL DBA?”


  1. […] 11, 2008 I recently mentioned several good sessions I attended in Seattle conference in a blog post about importance of understanding the crucial role […]


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: