Ahmed Ammar

Awesome SharePoint-powered Sites

2012-02-17T22:18:00.000-08:00

Great article from TopSharePoint awesome list of SharePoint-based websites that really stand out.

SharePoint : Choose Cloud or On-Premises?

2012-02-17T15:40:00.000-08:00

Determining whether to use SharePoint Online instead of on-premises SharePoint can be complicated.Here’s a simple set of questions to help determine if SharePoint Online makes sense

Question	Yes	No
Are you already using custom-coded SharePoint solutions, such as third-party tools or in-house Visual Web Parts?	0	3
Are you free from strict geographic control and accountability for your SharePoint content ?	4	0
Do you already have SharePoint engineers on staff?	0	3
Do you have a limited IT capital budget, but significant IT operating budgets?	1	0
Do you have a mature, on-premises installation of SharePoint 2010?	0	3
Do you have access to dedicated SharePoint developers?	0	2
Do you have as many or more users outside your corporate network as you do inside the firewall?	3	0
Do you need to downsize or eliminate physical servers and data centers used with SharePoint?	3	0
Do you need to migrate off a legacy installation of SharePoint 2007 or Windows SharePoint Services 3.0?	3	0
Do you need to rapidly set up a pilot or proof-of-concept SharePoint site, independent of any current usage?	3	0
Do you project growth to a very large content pool over the next year (500GB or more)?	0	2
Do you use or need to use SharePoint-hosted business intelligence solutions such as Performance Point?	0	2

Add up your scores, and see how you match up:
32: You are probably already on SharePoint Online or Office 365.

24-31: You are a strong candidate for SharePoint Online. Study carefully and understand some of the functional tradeoffs of the platform. SharePoint Online doesn’t support the following:

Deployment of custom solutions that require direct access to the server, such as Visual Web Parts. It does support sandboxed solutions, however.
PowerPivot
SQL Server Reporting Service Integration
Business Connectivity Services (originally this was a blanket restriction, but a slipstream release in 2011 added support for access to web services-based remote data in O365 BCS).
FAST Search Server Integration
Web Analytics
Site collections greater than 100GB

10-23: You are somewhere in between. Understanding the platform advantages and tradeoffs is essential to figuring out your cloud strategy. Odds are good that you may use a hybrid approach in which parts of your SharePoint world remain on premises, with other aspects living on Office 365.

0-9: If SharePoint is already living in your data center, it’s probably in the right place.

Office 365 and SharePoint Online lack features relative to on-premises SharePoint, this isn't expected to be a permanent situation. If we project forward through the next release of SharePoint, we can forecast a time when the on-premises and cloud versions of SharePoint provide nearly identical functions.
What will make it really interesting comes after that – when new features start showing up in the cloud before they are bundled into the next major SharePoint on-premises release. A cloud-hosted SharePoint offering with better functions and simplified ease of operation will be a hard combination to deny for many current on-premises users.

Project Management Process Interactions, PMBOK 4th

2012-02-12T08:58:00.000-08:00

My Profile, Microsoft SharePoint Forum :)

2012-02-11T15:42:00.000-08:00

Large List Throttling over 5000 items in SharePoint 2010

2012-02-11T15:25:00.000-08:00

If you are planning to upgrade from SharePoint 2007 to SharePoint 2010 -
you might want to consider your users that have list view lookups of over 5000 items and/or data column lookups of over 8 lookup columns. In SharePoint 2007, it was recommended not to go over 2000 list items to prevent poor performance on your farm.

In SharePoint 2010 throttling is enabled by default (This is configurable however in Central Administration). Throttlng is set to not display list view lookups of 5000 items or lists that have over 8 lookup columns.

The reason for this out of the box throttle is that if you are doing a lookup in SQL on less than 5000 rows, SQL executes a row level lock. If you execute a lookup with over 5000 items SQL executes a table lock which can potential impact all your site collections in that one ContentDB.

Here is a clever a SQL script to help audit your farms for these large lists and over 8 lookup columns - so you can warn your customers if they have any lists that will be throttled after you deploy SharePoint 2010.

SELECT

t3.fullurl [WEBURL],

t1.tp_title [LISTNAME],

COUNT(t1.tp_id) [ITEMCOUNT],

ISNULL(MAX(t4.lookupCount),0) [lookupCount]

FROM DBO.alllists t1

JOIN DBO.alluserdata t2 ON t2.tp_listID = t1.tp_id

JOIN DBO.webs t3 ON t3.id = t1.tp_webid

LEFT JOIN

(

SELECT siteID,listID,COUNT(listID) [lookupCount] FROM dbo.AllLookupRelationships

GROUP BY siteID,listID HAVING COUNT(listID) >= 8

) t4 ON t4.listID = t1.tp_id

WHERE t1.tp_title != 'User Information List'

GROUP BY t1.tp_id,t3.siteid,t3.fullurl,t1.tp_title

HAVING (COUNT(t1.tp_id) >= 5000 OR MAX(t4.lookupCount)>= 8)

ORDER BY 1;

SharePoint 2010 Chart Web Part

2012-02-11T13:07:00.000-08:00

To get started, first you need an Enterprise version of SharePoint 2010. Assuming, you do have an Enterprise key, you then need to activate the SharePoint Server Enterprise Site Collection Features.

This adds the chart web part (among other things). Then edit any page and add a Chart Web Part. You can find it under Miscellaneous

When you add it to the page, it uses some dummy data and displays a simple bar chart.

At this point, you might be asking yourself “What kind of data can I bind this to?”. By clicking Data & Appearance, you will see the following screen which leads you to links to customize the appearance or bind to data.

We’ll start by going to Connect Chat To Data. Look at these great options we have to choose from.

We can connect to another web part, a list, an external content type (looks like they need to update the BDC wording they have there), and to Excel Services.

What I did is I created a new custom list to contain Sales information. I used an External Data field to allow the user to pick a product from the external content type and enter in some sales data in a field.

This is the list we are going to use on our chart. On the next step of the wizard, we are allowed to pick a list. Note that it also allows you to choose other sites in the collection as well.

The next step allows you to filter your data first if you are so inclined.

The Chart Web Part has a ton of configurable options. On this last step is where you will start seeing some of them. The main thing to set here is your X and Y fields. You can also specify something to group by as well.

Once you finish this last step, you’ll get something that looks like this.

So, what we have here is a chart bound to data coming from a database (via external content type) and a SharePoint list. Pretty cool, right? I think so. It gets better though. What if your boss doesn’t like bar charts? No problem. There are tons of chart types to choose from. Just click on Data & Appearance again and then Customize Your Chart. Look at all of these built in chart types you have.

On the next step, you can further customize the chart you choose. It has some nice pre-built color themes and you can customize the size and what not. It also gives you a live preview as you change settings.

Here is what my new chart looks like.

Forrester’s latest Wave for Enterprise Social software

2012-02-09T23:50:00.000-08:00

Forrester has just published their latest research on Enterprise Social software systems. The Wave chart shown here indicates that Jive, IBM, NewsGator and Telligent lead the list of vendors. You can get the entire report at forrester.com.
In analyzing the top four leaders in the Enterprise Social Software space, Forrester says:

Jive SBS: “… continues to drive to establish and lead “social business” as a new software category.”
IBM Connections: “… continues to move fast and exploit early bets on social. The company is now actively integrating Connections with its broader portfolio — including its portal, content, and business intelligence product lines”
Telligent Enterprise: “… maintains a razor-sharp focus on analytics, a platform designed from the ground up for extension, and a growing and impressive stable of partners.”
NewsGator Social Sites 2.0: “…takes SharePoint’s social offering to higher levels through its close partnership with the software giant. “

Office 15 video demo

2012-02-09T12:03:00.000-08:00

What’s NEW in SharePoint 15

2012-02-04T10:24:00.000-08:00

Microsoft is, not surprisingly, not commenting. Anyone who is a member of the Technical Preview is, as Hough points out, under non-disclosure. So the answer is: wait and see.

Hough’s post included a thankfully short chunk of standard language: “Office 15 will help people work, collaborate, and communicate smarter and faster than ever before.”

You don’t have to be a rocket scientist to recognize the trends in the market, some of which Hough indicates in his post, including mobile devices, and the blurring of public and private cloud services and on-premise servers and clients.

Social and search are clearly hot, and Microsoft has demonstrated its commitment to investing in these spaces over the years.

Microsoft always works to improve scalability and manageability, and the features of SQL Server 2012 and Windows 8 Server certainly point to significant improvements in those areas, as well as redundancy and recoverability.

You’ve got to assume these features will feed up the “stack” into SharePoint’s capabilities.
There are also rough spots and gaps in functionality in the current versions of the product, and Microsoft has proven over the years that it does recognize many of those and fills them as the products evolve.

So there’s a lot of incredible opportunity for Microsoft to hit it out of the park with Office 15. My hope is that, for the enterprise, the impact of Office 15 could be as significant and valuable as what we’re seeing with the potential of Windows 8 in the client and consumer space.
It’s going to be a very interesting ride, and I look forward to reporting developments to you as Microsoft releases information.

2012-02-04T10:21:00.000-08:00

WHEN will Office 15 release?

The Technical Preview milestone means that select customers can access the products now, or very soon. These customers typically have a tight support relationship with Microsoft during the preview.
While most customers will work with the product in non-production environments, my experience has been that some push the envelope and the limits of “bleeding edge.” Either way, when something goes wrong, Microsoft works to understand the problem, to support the customer, and to gain in-the-field experience with customer usage and product performance, to improve the product before releasing it as a public beta.

The Office 14 technical preview launched in July of 2009 and the public beta was announced at the SharePoint Conference and made available in November of 2009. That’s approximately four months of technical preview.
If I were a marketing wiz at Microsoft, I’d look at the calendar and spot TechEd North America and Europe in June—four months away—as a great place to pull back the curtain on such a significant overhaul of Microsoft’s lineup of non-OS products.

Doing the math, and looking at the calendar, I can certainly make educated guesses. I’d expect Microsoft to have ambitious targets, but to maintain its traditional public stance of “it’s ready when it’s ready.” Mary Jo Foley reports that her contacts peg the release by the end of the calendar year.
In any event, it’s clearly going to be in Microsoft’s next fiscal year, which runs July 1, 2012 to June 30, 2013.
It’s also obvious that, regardless of the exact product release date, the SharePoint Conference in Las Vegas will be well enough into the product release cycle to be chock-a-block with Wave 15 information.

HOW can I get my hands on it?

Right now, you cannot, unless you or your company are members of the Technical Preview, which according to Hough is already full. Keep in mind that Technical Preview used to be called Beta 1.
The product is not meant to be production ready at this stage, and Microsoft’s goal with the preview is to incorporate customer feedback into the product.

Office 15 Technical Preview

2012-02-04T10:08:00.000-08:00

Microsoft announced the launch of the Office 15 Technical Preview on January 30. There’s some big news in the short announcement made on the Office Team Blog. Let’s dissect the announcement and get answers to the questions that I hear from people about the next version of Office and SharePoint.
As announced by PJ Hough, the Corporate Vice President of the Microsoft Office Division, Office 15 reached the Technical Preview milestone on Monday. As word spread like wildfire, the most common questions are these: What’s Office 15? When will it be released? How do I get my hands on it? and, of course, What’s new?

WHAT is Office 15?

“Office 15” is the code name for the next versions of Microsoft Office products and services, just as “Office 14” was the code name for what became Office 2010, SharePoint 2010, and Visio 2010. Of course, the name of the product will likely change and I can’t imagine Microsoft straying from the decade-old trend of branding the product with the year—for example “Office 2012” or “Office 2013.” But, for now, it’s “Office 15” and you’ll hear its components referred to with the 15 moniker for coming weeks and months: SharePoint 15, Outlook 15, Visio 15.
‘Softies regularly refer to this new generation as “Wave 15.” And “wave” might be an understatement: tsunami is more like it. Microsoft’s ambitions are huge, as reported by Hough:
"With Office 15, for the first time ever, we will simultaneously update our cloud services, servers, and mobile and PC clients for Office, Office 365, Exchange, SharePoint, Lync, Project, and Visio."
Read this statement again folks: Microsoft is publicly saying it will update cloud services (Office 365), servers (SharePoint, Exchange and Lync), mobile and PC clients simultaneously. Unified communications (Lync/Exchange), Office apps, and collaboration, all at once. Holy upgrade, Batman! That’s huge!
There had been buzz about Microsoft releasing one side or the other (on-premises versus in the cloud) “first.” You might remember that Office 365 launched a full year after the on-prem version of SharePoint.
Not so this time around. Looks like Microsoft is delivering on its promise to be “all in” with the cloud this time around.

Community Webcast with SharePoint Director Jared Spataro

2012-02-03T13:38:00.000-08:00

2012 Community Webcast with SharePoint Director Jared Spataro from Dux Raymond Sy on Vimeo.

SharePoint Implementation Checklist: Aligning People, Technology & Process

2012-01-16T13:25:00.000-08:00

By Dux Raymond Sy
SharePoint adoption in the enterprise is growing at a rapid pace, but many organizations are still struggling to achieve the proper mix of “people,” “technology” and “process.” In the midst of just trying to figure out the technology side of SharePoint, many organizations overlook the people and process side of an implementation.
Pushed even further to the backburner are the “business value” considerations of SharePoint.
What is the purpose of implementing SharePoint in the first place?
How will SharePoint improve operations and drive overall business results?

Here’s a 30-point checklist that covers the business, people, technology and process components of a SharePoint implementation. Use this checklist to make sure that you have all of the correct elements in place during the planning phase of your SharePoint implementation which can apply to a brand new rollout, migration or even custom solution development. If you have already implemented SharePoint, you can use this list to uncover possible gaps and identify areas in need of improvement.

30-Point SharePoint Checklist

Business Drivers

What are the quantifiable top 3-5 objectives of the implementation? This means defining the value and scope for which all other questions will be framed.
Does the implementation have a sponsor from senior leadership that will champion the objectives mentioned above? Is there enough support at the right level to prevent starts/stops/restarts?
Will the implementation be funded out of IT or through the departments or divisions receiving the technology? Are there other major stakeholders that can change scope?
Is there a critical target date that cannot be missed? What resource costs will be involved to reach the target date?

People

Who will define and steer the SharePoint platform as a service? How will this implementation impact other stakeholders and sustain the direction/funding for the project?
How many potential users will be using the system? Estimate by periods over time such as 200 Q1, 800 Q2, 5000 Q4, etc. to help project support resource needs.
What support model does the company currently use (e.g. help desk, train power users, online knowledge bases, etc.)?
How much excess capacity/budget is available for adding SharePoint to the current support mix? What is the resource bandwidth availability and required augmentation?
Do you have IT professionals in Microsoft Windows Server, Web technologies, Microsoft SQL Server, e-mail, network load balancing, etc.? What additional training or augmentation might be needed?
Do these IT professionals have sufficient bandwidth for the early peak of activity? Will they be able to sustain the system long-term? Do you need to add personnel for the peak of activity?
Is organizational change a managed process? If so, is there bandwidth for promotion, training, etc., to make the implementation successful in the organization? Are additional contract resources needed to help with the rollout?
How are IT policies enforced? More time might be needed to align security if enforcement mechanisms aren’t in place.
Have you done a stakeholder analysis to understand the change effort? How much time will need to be spent to convince opponents of the implementation?

Technology

Is your organization already running 64bit hardware/software in your data center? What possible hardware/software costs exist?
Are your environments virtual and/or full hardware based? Will hardware need to be purchased if the farm needs to expand beyond projections?
Is this implementation planned to offset current file storage? If so, what does current storage size look like in projection against SP storage (e.g. "we plan to move fileserver based storage to SP to take advantage of versioning and document/record management aspects and today we have 2TB of file shares which we want to condense to 1TB through use of this technology")?
Thinking about the objectives, what would the number of page visits look like after one year? How many times a day would someone access the system and how many files/lists would they interact with? This projects the farm configuration.
What SharePoint services are being projected to be used in the first year (Excel Services, PerformancePoint, InfoPath, Access Services, etc.)? This might increase the amount of support and training required.
Is there sufficient storage and server capacity to support this implementation for at least one year (2-3 years would be preferable)?
Is the Microsoft stack of products currently well used in the environment (Start-up, training, support costs)?
If Microsoft Office is currently being used on the desktop, what version(s) are supported and will there be a desktop rollout component?
Will there be non-Microsoft computing platforms used with this implementation (e.g. Mac, iPad, Android devices, non-Microsoft smart phones, etc.)? If so, how knowledgeable are your current development/branding resources in supporting multiple browsers (support, UI development and training costs)?

Process

If this implementation is to enhance current processes, how stable and defined are those processes (how crisp will workflows or custom code be defined)?
Has a gap analysis been done to map the processes to the technology to see if customization will be required? What is the potential amount of custom development?
Is branding important for this implementation (look and feel customization)?
Will this implementation support custom programming (multiple environments and lifecycle processes)?
How does this implementation fit into your current data security and disaster recovery processes? Will you need additional offline storage and recovery?
Will there be external company resources that will need to access this implementation (firewall and additional environments and security considerations)?
Are there compliance regulations that must be met (SOx, HIPAA, etc.)? This can add additional levels of configuration complexity.
Are there IT Audit requirements? Will there need to be additional storage for logs to support the detail required?

5 SharePoint 2010 Configuration Mistakes

2012-01-11T04:11:00.000-08:00

#1: Using Virtualized Microsoft SQL Server

Virtualization isn't bad. But virtualization allows administrators to make mistakes on a much grander scale. Take virtualizing SQL Server. In the context of SharePoint, this process can be especially painful. The main mistake I see when virtualizing SQL Server is overcommitting the host, be it through RAM, CPU, or drive space. Because everything in SharePoint is stored in SQL Server, if SQL Server is slow, SharePoint is slow.
If you can't get a physical SQL Server box, then at the very least ensure that your virtualized SQL Server has a fighting chance. First, make sure that its virtual drives aren't thin provisioned. I/O is one of the areas in which virtualized SQL struggles the most, and thin-provisioned drives exacerbate that problem. Also try to put the SQL Server guests' virtual drives on their own spindles on the host. Doing so should improve I/O by preventing SQL from fighting other guests for time with the drives. Finally, you shouldn't allow the virtualization host to overcommit its RAM. If the host must swap to meet its RAM obligations, then it's slowing down SQL Server.
Brent Ozar has recorded a brilliant video on how best to virtualize SQL.

#2: Using the Farm Configuration Wizard

Using the Farm Configuration Wizard was a pretty common mistake when SharePoint 2010 first came out but thankfully has diminished as our familiarization with SharePoint 2010 has increased.
First, and maybe most heinous, is that all the databases that the wizard creates have nasty globally unique identifiers (GUIDs) at the end of their names. The wizard also creates a content web app, at http://servername, that just doesn't scale well. To add insult to injury, the wizard creates your My Site host on that same web app, at http://servername/my.
Finally, the wizard encourages you to create service applications that you might not actually use. It's tough to resist the siren song of those check boxes, I know.
The Farm Configuration wizard leaves its dirty handprints all over SharePoint, and it can be a challenge to clean up all of them. However, a few places can be easily fixed.
Start with your web apps. Create a web app for My Site and give it a Fully Qualified Domain Name (FQDN), such as mysites.company.com. Create a My Site host at the web app's root. Use the Windows PowerShell cmdlet Move-SPSite to move any My Site to one content database, and then attach that content database to your new web app. You'll also need to adjust your User Profile Service and tell it about your new My Site location.
Next, clean up your service applications. Go through your list of service applications and delete any that you aren't using. You gain no benefit from having a service application that you aren't going to use for another six months. After you've deleted unnecessary service applications, stop the associated service instances (also called services on server) that power them. If possible, remove the GUIDs from the service application database names. The technique for completing these tasks varies among service application; the Microsoft article "Rename or Move Service Application Databases (SharePoint Server 2010)" has directions for all the service applications. Of course, take good backups before doing any of this.

#3: Using One Account for Everything

Security is complicated, and SharePoint doesn't necessarily make it any easier. Using just one account -- maybe even the coveted Domain Administrator account -- is so easy. We've all done it, even though it's a bad idea. When you use an existing account, you open up SharePoint to several security issues. Anyone who knows the account password can do anything in SharePoint, so you can't separate duties. You also lose the ability to audit who made which changes. And if that common account password is compromised or needs to be changed. Even if you use one dedicated account for SharePoint, you leave yourself vulnerable to attack. If that account is compromised via a security exploit, the bad guys will have access to everything in SharePoint.
To fix this mistake, Add the sp_webapps and sp_serviceapps accounts as managed accounts.
You can change the default content access account for the Search service application at the Search Service Application page. Under Central Administration, Security, Configure Service Accounts, you can change the accounts that other processes use as well. (You can even change the Farm Account there. I've done so in test environments but haven't been brave enough to do it in production.) If you're using the User Profile Service, make sure that your new sp_userprofile account has the correct permissions in Active Directory (AD), and recreate your AD connection in the User Profile Service.
You can also use the steps that I describe in "How to create a SharePoint 2010 admin account and stop using sp_farm" to give an account the correct permissions to administrate SharePoint, without needing to use another highly privileged account.

#4: Keeping Default SharePoint Database Settings

When SharePoint creates its multitudes of databases, it makes some bad assumptions. Take the autogrow settings: The database files grow by 1MB at a chunk, almost ensuring that they're going to autogrow with every upload. Not only does this slow down SQL Server (which slows down SharePoint), but it also results in database files that are spread all over your drives in itty-bitty 1MB chunks.
SharePoint also creates most of its databases, notably the Config and Content databases, with the recovery model set to Full. Although this is great if you want to recover data, you must manage the process correctly or those sneaky .ldf files will slowly, methodically fill your hard disk. If you think users get upset when SharePoint is slow because of fragmented databases, you should see how angry they get when SharePoint stops completely because the SQL Server drives are full.
To fix this mistake, set your databases' autogrow settings in such a way that they don't need to grow frequently.
For most farms, I recommend changing the 1MB autogrow to something like 500MB or 1GB. Autogrow should also be a last resort. Someone, either the SharePoint administrator or a dedicated DBA, should pregrow your databases so that autogrow is unnecessary.
Your recovery model setting needs to be consistent with your disaster recovery plans. If you need your transaction logs, make sure you're performing routine log backups to keep those .ldf files in check. If you don't need your transaction logs, then consider switching your databases to the simple recovery model. Doing so will keep your .ldf files from swelling up like a nasty bee sting.

#5: Not Installing a PDF iFilter

Most organizations have a tremendous number of PDF files in their SharePoint farms, and those files represent a wealth of information. End users want to be able to discover that information by using SharePoint Search. Getting users excited about SharePoint Search is a great way to get them excited about SharePoint in general.
Installing a PDF iFilter is fairly easy. Adobe has a free PDF iFilter that you can install. You can find the download link and detailed installation instructions in the Microsoft article "SharePoint 2010 - Configuring Adobe PDF iFilter 9 for 64-bit platforms." You need to install the iFilter only on those SharePoint servers that run the Search Index role, although installing it on the rest of your SharePoint servers doesn't hurt. If you have a large farm and want to reduce the time needed to index your PDF files, you can use the PDF iFilter from Foxit. This product has better performance than the Adobe iFilter but isn't free.

a “solution” means just that—a solution to a problem

2012-01-09T11:15:00.000-08:00

After your SharePoint implementation is up and running, users start to discover its capabilities and to demand solutions to business problems. How do you help users solve business problems with In fact, many solutions can be built with no code, using browser-configured functionality of lists, libraries, and content types, along with SharePoint Designer, InfoPath, Access, Excel, and other Office client applications.
From my point of view, There are three “best practices”—that create a trifecta for success.

Self-Help

Much of SharePoint’s powerful functionality is easily accessible to end users through the browser-based UI, SharePoint Designer, InfoPath and Office clients. Just because it’s easily accessible does not, unfortunately, mean that it’s easy to figure out how to build a specific solution—such as a form or a workflow to support a business process.
Even fundamental components—lists, libraries, content types, and metadata (columns)—are not necessarily straightforward to end users, particularly as they are focused on addressing a yet-unsolved business problem with SharePoint.

I am not a fan of the following statement:
“We sent our users to a five-day course on SharePoint.”
I’m a MCT. So for me to say, “Do NOT train users to use SharePoint” may seem surprising.

I do believe that users need various levels of training on SharePoint—at least a fundamental understanding of some of the core components and concepts. But my experience is that it is not effective—or at least not efficient—to teach a new user “everything they need to know” about things like workflows and forms and the inner workings of SharePoint because, simply, it’s too much.
What’s more important, in my opinion, is that users see the potential of SharePoint as a business problem solver, and that they know where to go for help.

When a user needs to create a solution—a form with a workflow for example—they only need to know the steps for doing so with InfoPath and SharePoint Designer for a couple of minutes or an hour. It’s at that moment that you must have resources ready to help the user succeed in helping themselves.
Google and Bing are not the best answer. There’s a tsunami of information much of which is irrelevant to your specific business, poorly written, or inaccurate.

Point users to specific resources, including the Microsoft Office website and to other selected resources that you find accurate, helpful, and relevant.
I also recommend two specific sets of resources as an internal training and knowledge base. Fellow MVP Asif Rehmani’s SharePoint Videos provides hundreds of short video clips that are excellent at providing just-in-time guidance to specific SharePoint tasks, including and importantly SharePoint Designer and InfoPath. Another MVP, Rob Bogue, offers the SharePoint Shepherd resources which tend to be more “text-and-picture” (versus video) based, and which cover many of the core concepts and functionality.

Community

Your users are the best sources of knowledge about how to use SharePoint in your environment, to solve your problems. You are missing out on a golden opportunity if you don’t capture this resource from Day 1.
Create a discussion forum about SharePoint usage. Keep it focused on usage—have a separate forum for technical support. Spotlight your internal evangelists and success stories.
A build a library of solutions. Again I mean this in the broadest sense.
Find a way to collect the knowledge that your users build about using SharePoint in your environment. A wiki and a library where they can drop documentation about “How I built X” is a start. Create a gallery where templates and other solutions can be found.

Escalation

Above all, there needs to be someone—or a team of people—to whom SharePoint usage questions can be addressed.
Someone who really knows how to use SharePoint and the tools listed earlier—or at least someone who is capable of “figuring it out” on demand.
Ideally, this person is highly skilled with no-code development (browser, SPD, InfoPath and Office) and has a knack for business analysis—for eliciting real requirements.
Even more ideally, this person or team can drive the development of self-help resources and community, so that as your SharePoint implementation scales, you do not need to scale the escalation resource, but rather escalation needs start being filled by self-help and community.
Most ideally, the escalation resource ends up putting themselves out of business by effectively integrating their knowledge and experience into evolving self-help and community resources.
At several clients' locations, I’ve worked with the person in this role. Honestly, these people tend to be among the most vibrant and exciting people I work with.
They’re expert, enthusiastic, and deeply aware that SharePoint doesn’t really matter—the business matters. And that focus on business first means that business problems do get solved.

7 SharePoint Predictions For 2012

2012-01-05T11:38:00.000-08:00

Dan Holme, AvePoint's Chief SharePoint Evangelist, posted the following hot post.

1. The Forecast: Cloudy

With the introduction and success of Office 365, 2012 will see more businesses looking to take advantage of the cloud. As additional functionality is introduced to the online platform to bring features up to par with on-premise SharePoint 2010 environments, collaborative workloads such as team sites and extranets are likely to be migrated into the cloud, allowing anytime, anywhere access to business data. Businesses are likely to take a ‘best of both worlds’ approach by buying into hybrid solutions and plugging the gaps between on premise and cloud with the help of third-party software.
One feature that could be added to Office 365 in the near future is the introduction of an ‘app store’ for SharePoint solutions. In addition, the cloud is also likely to be used more and more as a replacement for temporary infrastructure, becoming a replacement for SharePoint development, testing and proof of concept due to its scalability and flexibility.

2. Tighter, Stricter, Stronger

Governance will be an important trend in 2012, as the amount of data that businesses are required to store continues to grow. In fact, a study released by research firm IDC, Extracting Value from Chaos, states that the world’s data is doubling every two years. This is making it increasingly difficult to find documents and manage site sprawl.
The increase in data will drive businesses to implement governance across their SharePoint deployments in order to better manage the content while at the same time ensuring that the data is not accessed by unauthorised personnel. As such, 2012 will see businesses develop governance plans that include input from both a business and IT perspective, imposing stricter rules on access and data management.

3. Consumerisation of IT

Consumerisation was huge in 2011 and is primed to continue in 2012. A wide variety of computing devices, tools and platforms have permeated the enterprise, and SharePoint has addressed this consumerisation trend by supporting various browsers, operating systems and devices. However, as it stands, mobile support is very limited and focused only on the Microsoft mobile environment. Analyst firm Forrester Research expects third-party software to make SharePoint more accessible for other prevalent operating systems in the near future.

4. Moving onwards and upwards

Businesses that are currently using earlier versions of SharePoint today are likely to focus their attention on upgrading or migrating to SharePoint 2010. New features and functionalities supported by the 2010 platform including, social and enhanced enterprise search functions, are appealing to SharePoint users due to the opportunity for fast return of investment.

5. Mind the gap

According to Forrester Research, lack of IT skills is an issue for businesses that have deployed SharePoint. The broad scope of technologies that Microsoft has built into SharePoint creates a complex technical environment. As businesses increasingly acknowledge the need to provide support for continuous improvement, adoption and engagement, training and education will be a priority for SharePoint users. Until administrators are adequately trained to manage this evolving platform, the ability to fully optimise SharePoint is limited. This year, third-party vendors will look to address this skills gap and reduce the complexity of SharePoint through automation.

6. Taking Control of Data

In 2012, businesses will be looking to concentrate and consolidate content in their SharePoint deployments. Storage optimisation solutions for SharePoint will be the drivers behind this consolidation effort. One such solution is SharePoint’s Remote BLOB Storage (RBS) APIs. However, RBS coding can be complex and time consuming, so expect to see third-party vendors plug this gap through storage optimisation software solutions and solutions that are built directly into the storage hardware.
Alongside this, organisations are starting to apply ECM methodologies, such as taxonomy and document holds in SharePoint. This will encourage businesses to focus even more on governance and planning.

7. A little birdie told me….

Social networks are one of the big trends of 2012. Businesses that deployed SharePoint as a collaboration and file share tool are now looking for the next step. Microsoft has been touted as the ‘Facebook for the enterprise’ and is a leader in the 2011 Gartner Magic Quadrant for Social Software in the Workplace. Businesses will want to take advantage of SharePoint’s new found social capabilities, as well as out-of-the-box enhancements. Expect to see more social features and functions to be added throughout 2012 by both Microsoft and third-party vendors.
2012 is set to be a year when businesses will change and develop the ways in which they use and interact with SharePoint. There will be a greater emphasis on governance and planning, and businesses will also look to unlock SharePoint’s full potential through its cloud, mobile and social features. Where SharePoint doesn’t improve natively, third party vendors will offer a solution to help companies maximise the value of this collaboration platform.
2012 will no doubt be another strong year for SharePoint, and this summer Microsoft will release the public beta of the next version of SharePoint, currently code named “SharePoint 15,” and many pundits expect Microsoft to make a big announcement at SharePoint Conference 2012 in Las Vegas – watch this space!

Understand database mirroring requirements for disaster recovery purpose

2011-11-15T15:12:00.000-08:00

SharePoint 2010 is mirroring aware and utilizes the FailoverPartner keyword in its database connection strings to identify a SQL Server instance that is used for mirroring purposes. Upon learning this, it might be tempting to jump right in and start mirroring SharePoint databases for redundancy. Before doing so, though, you should be aware that the following requirements apply:

Less than 1ms latency between principal and mirror SQL Server instances
1GB/s bandwidth or greater between principal and mirror SQL Server instances
Principal and mirror instances must be running the same version and edition of SQL Server
Mirrored databases must use the Full recovery model
High safety with automatic failover (that is, synchronous mirroring with witness server) is recommended

Mirroring is certainly useful, but as the aforementioned list demonstrates: it shouldn’t be implemented without careful planning and infrastructure design.

KPI Values in SharePoint

2011-11-11T22:09:00.000-08:00

Previous versions of SharePoint had limitations to folders support for the KPI Lists. Whenever you tried to set Folder as a source of your KPI, SharePoint gave you an error that the folder can't be selected. To avoid such situation you had to maintain KPI values in different list or use Views. The issue with Views is that they don't allow you to assign the permissions per View, so you can't have groups of data and assign different permission for KPI values based on views. The only solution for SharePoint 2007 was usage of separate Lists. SharePoint 2010 fixed this issue, and now you can organize your values per folders in one List for KPI’s.

SharePoint BLOB Caching to increase performance

2011-11-05T13:04:00.000-07:00

BLOB caching, or disk-based caching, is an out of the box (OOTB) caching mechanism that is built into the MOSS 2007 and SharePoint Server 2010 platforms. It is commonly used to speed-up access to large and relatively static resources that are stored in content databases, such as images, videos, javascript files, and more. Performance improvements are gained by storing these assets on web front-ends (WFEs) once they’ve been requested by a client. This allows SharePoint to serve subsequent requests for such assets directly from WFEs instead of round-tripping to the content database each time a request for such an asset is received. For most SharePoint sites, this type of caching can significantly lighten the load on your SQL Servers and back-end network.

BLOB Caching is controlled through the web.config file for each of the IIS web sites that is associated with a Web application, and it is not enabled by default. Enabling BLOB caching is as simple as setting the enabled attribute to true in the web.config element as shown below.
BlobCache location=”C:\blobCache” path=”\.(gif|jpg|png|css|js)$” maxSize=”10” enabled=”true” />

Find info about Farm Configurations

2011-10-23T13:00:00.000-07:00

You can use the Get-SPFarmConfig cmdlet to retrieve global settings for the local farm. The cmdlet returns information for items that are not on the SPFarm Object.

PS > Get-SPFarmConfig

WorkflowBatchSize : 100

WorkflowPostponeThreshold : 15

WorkflowEventDeliveryTimeout : 5

DataFormWebPartAutoRefreshEnabled : True

ASPScriptOptimizationEnabled : True

You Cannot Use SharePoint Foundation 2010 Objects with .NET 4

2011-10-11T15:10:00.001-07:00

The SharePoint Foundation 2010 object model is not accessible using the .NET Framework 4 (or later). Calling any object or method in the object model using any framework version other than .NET 3.5 will throw the following exception:

System.PlatformNotSupportedException
Microsoft SharePoint is not supported with version 4.0.30319.1 of the Microsoft .Net Runtime.

Of course, you can always access the SharePoint objects using the web services interface from your .NET 4 application, but this will only allow limited functionality of the complete object model.

Embedding a YouTube Video

2011-10-11T13:24:00.000-07:00

To embed YouTube videos on your SharePoint site, get the ‘embed video code’ from the YouTube site and copy paste into a notepad. Upload the notepad to a library.
Add a content editor web part and point the content link to this notepad. This will embed the video on the SharePoint page and can be played via the SharePoint media player.

Using "Send To" to Route Documents

2011-10-08T20:40:00.000-07:00

Documents are not always created in the location where they should finally be routed to. For example, documents may be created in one site but routed to a different site for final review by clients or customers.

This can be easily achieved in SharePoint 2010 via simple short cut menus that can be set up for a document library. This is done by enabling the content organizer features and configuring ‘send to’ connections from central administration. This connection will then appear for all documents in a document library for the configured site. Easily write content organization rules for the drop library to route the document to its final destination.

Sync Users Information from Active Directory

2011-10-06T21:44:00.000-07:00

You can sync User information from the User Directory Store. Simply, use the Set-SPUser cmdlet and use the SyncFromAD switch parameter to enable syncing.

PS > Set-SPUser -Identity powershell\username

>> -Web http://sp01 -SyncFromAD

Adding Text Fields to a List

2011-10-03T10:46:00.000-07:00

You can use Windows PowerShell to add Text fields to a List in SharePoint 2010. Simply use the Add() method available on a fieldcollection. The example below demonstrates how to add a Text field to the Tasks list, set a Description and set the field as required. Note that the Add() method allows us to specify the Fields Name, the Type of Field and a Boolean value that determines if the field should be required.

PS > $spWeb = Get-SPWeb http://SP01.powershell.nu

PS > $spList = $spWeb.Lists["Tasks"]

PS > $spList.Fields.Add("Text Field","Text",$true)

PS > $spList.Fields[“Text Field”].Description = “My Custom Text Field”

PS > $spList.Fields[“Text Field”].Update()

PS > $spWeb.Dispose()