Thursday, November 9, 2017

Why SharePoint? – What is the Value?

SharePoint 2016

8 reasons why Intranet in SharePoint rocks!
http://sharepointmaven.com/why-sharepoint-intranet-rocks/

Business Value and SharePoint
http://www.expertsofsharepoint.com/business-value-sharepoint/

Office 365

Reinventing business processes in SharePoint and Office 365
https://techcommunity.microsoft.com/t5/SharePoint-Blog/Reinventing-business-processes-in-SharePoint-amp-Office-365/ba-p/69260

SharePoint 2013

How IT Can Pitch SharePoint for Business Decision Makers
https://www.avepoint.com/blog/avepoint-blog/can-pitch-sharepoint-strategic-business-platform-decision-makers/

Why Use SharePoint?
https://en.share-gate.com/blog/why-use-sharepoint-its-benefits-between-two-farms

What business value does SharePoint provide?
https://www.winxnet.com/blog/blog-home/sharepoint-business-value/

Older Legacy

Found good article on why should you use SharePoint

http://www.onsearchinteractive.com/microsoft-sharepoint/fully-leveraging-microsoft-sharepoint-questions-to-ask/

Would you like to provide your employees with an internal website/platform where employees can communicate, share/store documents and content, collaborate on projects/documents, search for internal information and expertise, execute business processes online (i.e. submit an expense report for approval), and consume business information for decision making (i.e. business intelligence)

How do employees learn about new business process, policies, or any other important communication?
Are you only relying on email?
How do employees access company applications, services, forms, contact information, and documents?
How do employees find certain expertise within the company?
How do employees collaborate in projects?
Do your employees take online training today?
How do employees share the projects that are working on, their interest or any other info that may be relevant to the rest of employees?
Do you know how much time your employees spend searching for info and the cost of that time?
How are you dealing with business process/document approvals? (i.e purchase requests, travel expense)
How do you access the company directory? Is it visual? Can you see the relationship of employees?
If an employee left right now and sue the company, how would you lock all the content he was involved?
Do you have document retention/archive plans or policies and if so what are they?
How do you manage records for compliance (i.e. controlling changes to document such as policies, declare records so they cannot be edited or deleted and sent to the proper record center)
How are forms being handled today? (i.e. in paper)
How are you managing version control?
What about auditing of documents?
How are forms being handled today? (i.e. in paper)
How does IT manage the onboarding process? (ie. assign PC, give access to email, etc)
How much is spent in paper and document storage on a monthly basis?
How do you collaborate in projects with parties outside of the company?
How do you manage the publication of web content today?
How is the procedure to upload and store documents?
How do you control access to documents?
How are documents signed today? (i.e. paper)
How does management get information/reports on Key Performance Indicators (KPIs)?

All solved by SharePoint

Friday, November 3, 2017

SharePoint Performance Optimization and Scale

2016

Optimize Performance
https://technet.microsoft.com/en-us/library/jj721440(v=office.16).aspx
Planning Performance
https://technet.microsoft.com/en-us/library/cc262971(v=office.16).aspx

2013

How To Calculate Number of web front end servers in a SharePoint farm 2013 and 2010
http://abhayajoshi.blogspot.com/2014/01/how-to-calculate-number-of-web-front_24.html

Capacity management and sizing for SharePoint Server 2013
https://technet.microsoft.com/en-us/library/cc261700(v=office.16).aspx

Optimize Performance
https://technet.microsoft.com/en-us/library/jj721440.aspx
Planning Performance
https://technet.microsoft.com/en-us/library/cc262971(v=office.15).aspx

2010

Scaling SharePoint
https://technet.microsoft.com/en-us/library/cc261795(v=office.12).aspx

Interacting with Data Collector Sets via Powershell
http://blogs.technet.com/b/brad_rutkowski/archive/2009/02/18/interacting-with-data-collector-sets-via-powershell.aspx
http://social.technet.microsoft.com/wiki/contents/articles/7926.sharepoint-2010-tips-for-dealing-with-performance-issues.aspx
Great list of Links on SharePoint Performance
http://www.sharepointedutech.com/2011/10/09/spc373-performance-tuning-sharepoint-2010/
http://www.slideshare.net/joeloleson/sharepoint-performance-optimization-in-10-steps-for-the-it-professional

Developer Performance Tools (Visual Studio Solutions)
SPDisposeCheck is a tool that helps developers and administrators check custom SharePoint solutions that use the SharePoint Object Model helping measure against known Microsoft dispose best practices http://blogs.msdn.com/b/rogerla/archive/2010/12/13/announcing-spdisposecheck-v14-0-4762-1000-update-for-sharepoint-development.aspx

IIS
w3wp.exe using too much memory and resources
http://blog.whitesites.com/w3wp-exe-using-too-much-memory-and-resources__633900106668026886_blog.htm

SAN
Great Video and scripts to help diagnose issues (SAN or not)http://www.brentozar.com/archive/2011/08/how-prove-its-san-problem-webcast-video/

SQL Performance Tools

SQLIOSim - For Microsoft SQL Server 2005, SQLIOSim was shipped as a separate download package. Starting with SQL Server 2008, SQLIOSim is included with the SQL Server product installation http://support.microsoft.com/kb/231619
SQLIO - Microsoft Utility used to determine the I/O capacity of a given configuration.
http://www.microsoft.com/download/en/details.aspx?id=20163

Other Performance Tools

Logman and powershell
http://colleenmorrow.com/2012/02/13/using-powershell-to-deploy-performance-monitor/
Team Foundation Server with Test Edition
Jumble
Grinder
OpenSTA
Fiddler2
webpagetest.org
perfmon
SQL Server Management Studio
Firebug and Firebug lite
HTTP Watch
IE Dev Tool Bar
Temp DB
Separate Disk
Watch Disk Space
Compact
Watch Memory
GZip

OLD

http://blogs.msdn.com/b/sanjaynarang/archive/2009/04/18/sharepoint-performance-stress-load-testing.aspx

Friday, October 27, 2017

SharePoint Things

http://makeitstranger.com/ (works best in Chrome)

Monday, October 16, 2017

Audiences

Audience (2010 Latest Found)
https://technet.microsoft.com/en-us/library/cc263065(v=office.14).aspx

Audience (2016)
https://support.office.com/en-us/article/Target-content-to-specific-audiences-33d84cb6-14ed-4e53-a426-74c38ea32293

Audience via PowerShell
http://blog.kuppens-switsers.net/sharepoint/toggle-audience-targeting-using-powershell/

Office Integration with SharePoint

Updates

Office 2007 supported extended until April 2017

Obsolete Products
https://support.microsoft.com/en-us/gp/lifeobsoleteproducts
End of Life Products
https://support.microsoft.com/en-us/gp/lifeselectoff
Support Lifecycles
https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy

2016

https://www.avepoint.com/blog/avepoint-blog/sharepoint-2016-frequently-asked-questions/

2013

IE 10 or 11 Compatibility Issues (use compatibility mode)
http://blog.fpweb.net/sharepoint-internet-explorer-compatibility-issues-with-video/#.Vqd6RYd4fcs
https://connect.microsoft.com/IE/feedback/details/808799/internet-explorer-11-doesnt-work-well-with-sharepoint-and-infopath-form
http://social.technet.microsoft.com/wiki/contents/articles/26663.issues-with-sharepoint-2013-with-internet-explorer-11.aspx
http://windows.microsoft.com/en-IN/internet-explorer/use-compatibility-view#ie=ie-11-win-7

Can I use Office 2010 with SharePoint 2013?
http://bit.ly/1Uokayc

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013
http://blogs.technet.com/b/raymond_ris/archive/2013/04/04/cannot-open-or-create-word-documents-in-sharepoint-2013-with-office-2010-and-project-2013.aspx

SharePoint 2013, Cannot Open Documents in Office 2010 or Office 2013
http://serverfault.com/questions/529629/sharepoint-2013-cannot-open-documents-in-office-2010-or-office-2013

Fix problems opening documents in SharePoint libraries
SP 2013 Office 2010
https://support.office.com/en-US/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329FA1-4AD0-47FC-95D8-BB0C5B12A536

Co-Authoring Support
http://technet.microsoft.com/en-us/library/ff718249(v=office.15).aspx

Issues Running Office 2010 and SharePoint 2013

https://support.office.com/en-us/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329fa1-4ad0-47fc-95d8-bb0c5b12a536

http://sharepointmadam.blogspot.com/2014/01/using-office-2010-with-sharepoint-2013.html

https://social.technet.microsoft.com/Forums/sharepoint/en-US/dde334db-88f5-4ea0-b5d7-3e47503e17de/limitations-when-using-sharepoint-2013-together-with-office-2010

https://blogs.technet.microsoft.com/projectsupport/2013/04/04/sharepoint-2013-problems-opening-documents-with-office-2010-if-you-load-project-2013/

2010

Compatability Issues with Sharepoint 2010 and Office 2016
https://social.technet.microsoft.com/Forums/ie/en-US/df4a3830-15e4-4791-8071-d003d2cceacd/cant-edit-word-and-excel-documents-with-office-2016-in-sharepoint-2010?forum=sharepointgeneralprevious

Fix problems opening documents in SharePoint libraries
SP 2010 Office 2013
https://support.office.com/en-US/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329FA1-4AD0-47FC-95D8-BB0C5B12A536

Compatability Issues with Sharepoint 2010 and Office 2013
http://bit.ly/1WMJqzO

Synchronize SharePoint 2010 content with Outlook 2010
http://office.microsoft.com/en-us/sharepoint-foundation-help/synchronize-sharepoint-2010-content-with-outlook-2010-HA101881295.aspx

Client Features for Office 2003 2007 or 2010 (pdf)
http://go.microsoft.com/?linkid=9690494

Microsoft Office 2010 with Different Versions of Microsoft SharePoint
http://mrin17.wordpress.com/2010/04/29/microsoft-office-2010-with-different-versions-of-microsoft-sharepoint/

SharePoint 2010 with Office 2013 Clients (IE 9 – 32 bit)
https://social.technet.microsoft.com/Forums/sharepoint/en-US/9124f4f9-02e4-4997-a54c-da14e8069964/compatability-issues-with-sharepoint-2010-and-office-2013?forum=sharepointgeneral

http://social.technet.microsoft.com/Forums/en-US/fde11a55-4f9a-420d-b2a1-b000a81c6795/compatibility-issue-between-desktop-office-2010-and-sharepoint-2013?forum=sharepointgeneral

http://social.technet.microsoft.com/Forums/en-US/a7bbb703-4bf0-4f2d-b27a-74aa03aa7e6c/ms-office-2013-and-ms-shaarepoint-2010-compatibility?forum=sharepointadminprevious

http://social.technet.microsoft.com/Forums/en-US/c0eb8246-d8b1-4b78-b603-d08f803c3d17/will-infopath-2013-compatible-with-sharepoint-2010?forum=sharepointdevelopmentprevious

http://support.microsoft.com/kb/2755126/en-us

Issues with Office 2013 in SharePoint 2010 Farm

Excel 2013 workbook in a SharePoint Server 2010 farm
http://support.microsoft.com/kb/2755126

Visio 2013 Files in SharePoint 2010
http://blogs.msdn.com/b/chhopkin/archive/2013/02/14/working-with-visio-2013-files-in-sharepoint-2010.aspx

Known Office 2013 Issues - (Use Find - SharePoint)
http://office.microsoft.com/en-us/help/office-2013-known-issues-HA102919019.aspx

Thursday, October 12, 2017

High Availability in SharePoint

As we become more dependent on SharePoint, how do we keep it online always? SQL must first be online. Here is more to help.

AlwaysOn

Brents take on Always On
http://brentozar.com/go/alwayson

Detailed steps to configure an AlwaysOn Availability Group for SharePoint
http://technet.microsoft.com/en-us/library/jj715261.aspx

SharePoint 2013 and SQL Server AlwaysOn - High Availability SharePoint
http://blogs.msdn.com/b/sambetts/archive/2013/04/24/sharepoint-2013-and-sql-server-alwayson-high-availability-sharepoint.aspx

SQL 2012 AlwaysOn Availability Groups for SharePoint 2013 - SharePoint Connections Amsterdam 2012
http://www.slideshare.net/michaeltnoel/sql-2012-alwayson-availability-groups-for-sharepoint-2013-sharepoint-connections-amsterdam-2012

SQL Clusters

Many thinks from Brent Ozar … thx brent and kendra

Introduction to SQL Server Clusters (2012)
https://www.brentozar.com/archive/2012/02/introduction-sql-server-clusters/

Why doesn’t SQL Server always share memory well with other applications? Well, not all applications share memory in ways that work well with it! More information is here: http://msdn.microsoft.com/en-us/library/ms177455.aspx

Brent did a great webcast comparing disaster recovery options. He gives an overview of different methods along with pros and cons of each one. Check it out here: https://www.brentozar.com/archive/2011/12/sql-server-high-availability-disaster-recovery-basics-webcast/

Can you explain a little more on your reluctance to cluster a virtualized server? “Why Your SQL Server Cluster Shouldn’t Be Virtualized” https://www.brentozar.com/archive/2012/09/why-your-sql-server-cluster-shouldnt-be-virtualized/

Excellent three part series on cluster network communication in Server 2008 by Chuck Timon: http://blogs.technet.com/b/askcore/archive/2010/02/12/windows-server-2008-failover-clusters-networking-part-1.aspx

Everything You Know About Clustering is Wrong
https://www.brentozar.com/archive/2012/06/everything-know-about-clustering-wrong/

very tricky to make SSIS highly available. Here’s a blog post explaining the challenges and one workaround here:
http://blogs.technet.com/b/andrew/archive/2008/11/28/high-availability-integration-services-in-sql-server.aspx

Want more info? See “Running multiple instances of SQL Server” here– it’s not specific to clustering but the same info applies: http://msdn.microsoft.com/en-us/library/ms178067.aspx. Note that the article lists three approaches, and I am recommending the second one, which lets you get the most bang for your buck, but I do still recommend setting max memory.

These properties are one of the interesting things about working with clusters. Check out Books Online here: http://msdn.microsoft.com/en-us/library/ms174396.aspx

Microsoft has published some general requirements for failover clustering hardware: http://technet.microsoft.com/en-us/library/jj612869.aspx

First start by checking out our explanations of the different recovery technologies at https://www.brentozar.com/go/fail and there’s resources for each one.

https://www.brentozar.com/sql/sql-server-failover-cluster/

high availability planning worksheet: https://www.brentozar.com/archive/2014/05/new-high-availability-planning-worksheet/

Brent’s video on licensing here: https://www.brentozar.com/archive/2014/09/how-sql-server-licensing-works/

https://www.brentozar.com/archive/2015/06/how-to-set-up-standard-edition-alwayson-availability-groups-in-sql-server-2016/

How to install and fail over your clustered instance
https://technet.microsoft.com/en-us/library/ms189134%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396