THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
in Search

Kevin Kline

Who's Administrating Sharepoint?

There's no question that Sharepoint is one of the fastest growing applications in Microsoft-centric IT shops.  I've visited lots and lots of clients who not only have a multitude of Sharepoint servers, it's been rolled out so rapidly and decentrally across the the company that they have no idea how many Sharepoint servers or sites thta they actually have in use.  At many of these sites, we then conduct a Sharepoint inventory and come to find out that there's often an order of magnitude more Sharepoint servers than the IT team originally guessed.

In some ways, the growth of Sharepoint in the enterprise reminds me a lot of the growth of SQL Server back when it was considered to be a mostly-departmental database.  Back then, every department with an independent budget might deploy a SQL Server application locally.  And because of SQL Server's reputation as a self-managing DBMS, they were often left completely unmanaged until they broke.  The same sort of thing is happening with Sharepoint.  Departments within the enterprise are popping up Sharepoint servers and sites to support local collaboration needs without any consideration for long-term administration, backup & recovery, or availability.

In some forward-thinking enterprises, Sharepoint (as a information repository) is becoming a management responsibility for DBAs.  After all, Sharepoint uses a SQL Server repository to manage its data.  In other shops, administration is falling to the network admins.  But more often than not, there's simply no one administrating and caring for the Sharepoint sites.

So, I'm curious - what, if anything, is your organization doing to support and administrate Sharepoint?  Please leave a post to let me know.

Many thanks,

-Kevin

 


Published Monday, December 11, 2006 2:57 PM by KKline
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

CrazyDBA said:

Kevin,

You have touched upon a topic that needs to be addressed. I believe you are correct in that many DBAs fell into Sharepoint administration because of the SQL backend, without any thought regarding all of the aspects of Sharepoint administration. In our shop we have struggled with who should be doing what, everything from deployment of custom web parts to who should be creating new sites and when to create new portals.

One thing that I firmly believe in is that there needs to be a clearly defined owner of the content for any site. This is the person that has to moderate the content that is allowed to be posted. Whichever business unit is looking to have a site, it has to be up to that unit to administer the content, and not anyone else.

If you simply allow anyone to post whatever they want to your Sharepoint sites at any time, you will end up with, well...the internet.
December 15, 2006 12:51 PM
 

George Mid said:

One of the main things in SharePoint administering is to keep your sites as secured as possible… I would look into <a href="http://www.microsoft.com/technet/forefront/serversecurity/sharepoint/default.mspx">forefront security</a> solution from microsoft for protecting SharePoint environment against viruses, worms and other such stuff. In addition highly recomended to set properly all permissions through the SharePoint site. In this case I would use some 3rd party tools, for example, new version of <a href="http://www.scriptlogic.com/products/security-explorer/sharepoint/">security explorer for Sharepoint</a> from scriptlogic works quite good.

August 7, 2007 9:36 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

About KKline

Kevin Kline is Technical Strategy Manager for the SQL Server business unit at Quest Software. Kevin was the original architect and dev manager for many of Quest's SQL Server tools. Prior to Quest, Kevin worked as an enterprise DBA for a variety of large corporations and government agencies.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement