How to avoid SharePoint sprawl - Tech Management - Techguide

How to avoid SharePoint sprawl

 

Summary

When SharePoint launches in an enterprise, it typically heats up quickly, with enthusiastic users acting like kids with Lego. Here are some tips for keeping growth under control.

Events

Echelon 2012
June 11 and 12, 2012

University Cultural Centre, National University of Singapore

Startup Asia Jakarta 2012
June 7 and 8, 2012

12th Floor, Annex Building, Wisma Nusantara Complex, Jl. M.H. Thamrin No. 59 Jakarta 10350, Indonesia

MMA Forum Singapore
April 23-25, 2012

Grand Hyatt Singapore

It must be awkward for Microsoft, having a product out there that people use too much and too often; more awkward still, that this overuse is so ubiquitous that the IT industry has given it a name.

Yet almost anyone who uses SharePoint will nod knowingly when they hear any mention of "SharePoint sprawl". If your organization uses SharePoint as its intranet and hasn't been afflicted with this problem, it may be occasion for a hint of pride; there's some admirable self-discipline going on. But far more often than not, a SharePoint deployment will take on a life of its own.

Why this should be so is not hard to puzzle out. In SharePoint, Microsoft has given us a machine not unlike those physics-defying contraptions in Dr. Seuss books, bristling with levers and gears, that glop out some odd, scary commodity at the touch of a button. That's SharePoint in a nutshell: push a button, make a Web site. Not a Web page, a Web site, with all the Dr. Seuss machinery.

Need a team site for your current project? Click. Want your own personal site on the intranet? Click. Want to dump all your files into the CMS in one scoop? Click. Whole lotta clicking going on, and it's easy to see how many organizations end up creating messes greater than the ones they intended to be cleaning up.

Why does this happen?

Ease of deployment. Creating Team Sites, or MySites, or new libraries or lists (a list is, under the hood, a SQL table of arbitrary complexity) really is push-button simple. There is little cost or consequence to creating new sites or associated objects, even on a whim. When SharePoint is made available, this sort of usage is generally encouraged, to get the workforce interested. That's a two-edged sword, of course, for obvious reasons.

Experimenting in production. Since it's so easy to create things in SharePoint, a mindset quickly settles in: let's try out this new idea in SharePoint! Why not? It's quick and easy and cheap. The end result of this mindset is, of course, that you've created a sandbox the size of Texas - in production.

The Windows Explorer View. This clever, convenient fake-out utility--a window you can invoke within a document library that allows you to copy files and folders to and from the NTFS--was intended as a transitional tool, to make file handling as familiar as possible while users settle into the SharePoint paradigm. Boy, did it backfire! Rather than weaning users off the file folder system, it gave them an excuse to cling to it.

And so we have sprawl, runaway sprawl. The CMS rapidly clutters up, increasing access latency; and where we once had network shares ridden with endless useless, unmanaged files, we now have an intranet ridden with endless useless, unmanaged sites. Security becomes a nightmare; compliance, if an issue, becomes far harder to achieve than it was before.

Ordering the chaos

The silver lining in being an industry cliché is that with so many organizations falling victim to sprawl, we have lots of survivor tales to inform our remediation efforts. Or, better yet, to guide us around sprawl altogether. Here are some tricks that have worked for others.

Ecumenical governance. The biggest reason business resources slip into an unmanaged state is that those using the resources lose focus on the objectives and priorities to which the resources are supposed to be dedicated. SharePoint needs governance, the highest-quality governance you can manage, to maintain that focus. But even more, that governance needs to include all voices; those dispensing the governance won't stay on track if they don't understand fully why the user community is pulling things off track. Fully understanding the needs of the community and the potential of the resource is a matter of listening to everyone, not just the high-level decision-makers.

No Windows Explorer View. This may be the single toughest fix; once people learn how to drag-and-drop into SharePoint, they never want to stop--and they never learn the far more efficient and flexible style of file management that SharePoint is intended to cultivate. So don't show them in the first place.

Keep the experiments in the lab. SharePoint really is the ultimate sandbox for users. The let's-try-it-out factor is irresistible for good reason: it works. We can't reasonably ask people not to do this, because the alternative is to take back that sandboxing function into IT, and that defeats the purpose of SharePoint (making users more self-reliant). Try this, instead: stand up SharePoint in UAT, not just for the application work, but for Team Sites and content reorganization. Give the user community access to the Team Sites / MySite corner of UAT and let them go nuts - then promote the good stuff to production.

Archive the old. One great way to push back against the endless creation of SharePoint sites is to establish an archiving policy that limits lifespan. Got a team site? Great! You can have it for (90 days, six months, a year, whatever works in your world). Then it's getting archived.

Implement quota management. At the site collection level, SharePoint offers a hedge against sprawl, and it's an effective one. Sprawl persists largely because few organizations bother to use it. It's called quota management, and it puts a limit on the number of sites that can be created within a collection, as well as a maximum size (storage-wise) for each individual site. Controlling growth in two dimensions from this single point is enormously effective--if you take the trouble to do it.

There may be a concern that taking these measures might spoil everybody's fun. But most organizations that have gone this direction have found that this extra layer of policy and process leaves plenty of room for running and jumping and climbing.

Scott Robinson is a writer and speaker in the IT and social media fields. His eclectic career includes a decade as a systems engineer doing design work for NASA and the U.S. Departments of Energy and Defense, more than a decade designing software for business and industry, and years of teaching and speaking, research in neuropsychology and social psychology, and music journalism. His work has appeared in publications ranging from the Wall Street Journal to Rolling Stone.

Talkback

Add your opinion

In order to post a comment, you need to be registered. (Sign In or register below)

Post your comment

ZDNet Asia Live

Alibaba seeks $2.3B from shareholders for Yahoo deal http://t.co/ySyCwLvJ via @zdnetasia

Rise in Chinese-funded acquisitions could trigger more hurdles: By Ellyne Phneah , ZDNet Asia on May 22, 2012 (6... http://t.co/L4QzDq3H

Kodak loses patent ruling against Apple, RIM - ZDNet Asia http://t.co/O7P8U2Ya

Rise in Chinese-funded acquisitions could trigger more hurdles - ZDNet Asia http://t.co/WJCfhWLs

Kodak loses patent ruling against Apple, RIM. http://t.co/N1j7aZ6o

#radio Radio Serbia by EnjoyIT 1.0 http://t.co/nGQFvX2E

Rise in <b>Chinese</b>-funded acquisitions could trigger more hurdles http://t.co/0pXBS1HR

Rise in Chinese-funded acquisitions could trigger more hurdles: By Ellyne Phneah , ZDNet Asia on May 22, 2012 (6... http://t.co/W3SOdw2c

RT @zdnetasia: CFOs increasingly involved in IT investment decisions. http://t.co/8QrfwOSb

CFOs increasingly involved in IT investment decisions http://t.co/XD1LerFq via @zdnetasia #PrivateCloud #SC2012 #CAPEX

Rise in Chinese-funded acquisitions could trigger more hurdles. http://t.co/VC3G3m3o

RT @zdnetasia: Rise in Chinese-funded acquisitions could trigger more hurdles. http://t.co/VC3G3m3o

So much as we know , MTK6575 extremely integrated frequency1GHz ARM Cortex-A9 processor, the superiority of 3G / HSPA Modem, and help the...

2 hours ago by y15822137359 on 5 SaaS adoption speed bumps to avoid

Rise in Chinese-funded acquisitions could trigger more hurdles - ZDNet Asia: Rise in Chinese-funded acquisitions... http://t.co/bZaAQnRL

Rise in Chinese-funded acquisitions could trigger more hurdles http://t.co/mIsuZjnU http://t.co/erFX4aVv #arcavir

http://t.co/VNaZtseV Rise in Chinese-funded acquisitions could trigger more hurdles: "Cash r... http://t.co/N0gZZEdR http://t.co/wiqY9ktt

I reckon your view: "CRM is strategy, not software", if a company replicating the approach uses in ERP implementation into CRM, what they...

1 day ago by wykoong on Gartner: Mobile CRM gives better ROI than social

This video will teach you about the Excel fill handle but also provide you with a workook to download... http://www.youtube.com/watch?v=...

1 day ago by TradeBrother on A quick fill handle trick for Microsoft Excel

waiting...

3 days ago by eapete on What should count in a company's market value?

Boy, you've opened a can of worms now.

Wait for the rants & raves.

3 days ago by eapete on What should count in a company's market value?

I was puzzling before this whether to replicate the success formula we executed for a financial institute, and come out with a standard s...

4 days ago by wykoong on Drop the egos, copy ideas, then innovate