Thursday, December 21, 2017

Theme:
     - we want our logo
     - we want our colors
     - we want our fonts
     - we want background image
Master Page:
     - we want site logo to link to start page, not to subsites
     - we want another navigation
     - we want links on the top
     - we want footer on every page
     - we want a big banner on the top
     - we want breadcrumb
Page Layouts:
     - we want more content zones on the page
     - we want a content zone on the right for related links and content
Styling
    - we want 20px or 30px margins
    - we want larger headings (H1,H2,H3..)
    - we want border around content

Guide to quick SharePoint 2013 branding
http://blog.blksthl.com/2013/02/26/a-guide-to-quick-sharepoint-2013-branding/

Step by Step
http://www.sharepointempower.com/Blog/Post/3/SharePoint-2013-branding-step-by-step

Start Master Pages
http://startermasterpages.codeplex.com/

How do I apply master page changes to all subsites in SharePoint 2013?
http://sharepoint.stackexchange.com/questions/61979/how-do-i-apply-master-page-changes-to-all-subsites-in-sharepoint-2013

Hide Recent
http://sharepoint.stackexchange.com/questions/61347/how-to-hide-recent-in-the-navigation

Tips on Team Site
Recent Heading – current navigation (five most recent appear)
http://blogs.office.com/b/sharepoint/archive/2012/07/25/the-new-team-site.aspx

SharePoint 2013 Design Manager
http://sharepointfordeveloper.blogspot.com/2013/06/sharepoint-2013-design-manager.html
MSDN - Overview of Design Manager in SharePoint 2013
https://msdn.microsoft.com/en-us/library/office/jj822363.aspx

2010

Basics
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Hack-SharePoint-Master-Pages-Introduction.aspx

Navigation
https://www.nothingbutsharepoint.com/sites/eusp/Pages/Brand-SharePoint-Global-Navigation-The-Journey-Begins.aspx

Mega Menu

http://www.nothingbutbranding.com/blog/2012/august/mega-menu-dropdown-sharepoint

Move Quick Launch – to the Right Side

http://www.nothingbutbranding.com/blog/2012/august/move-sharepoint-quicklaunch-to-the-right

Heather Solomon - great presentations on branding in 2007 and is now working on 2010
http://www.heathersolomon.com/blog/

Monday, December 18, 2017

SharePoint Deletion Log

SharePoint has a powerful report for file deletion in SharePoint 2016 / 2013.

Under Site Collection Administration > Site Collection Audit Settings
Turn on all events needed for audit, but remember this will significatly increase the size of your content database.

So consider turning on Audit Log Trimming which is end of the month by default
https://support.office.com/en-US/article/Configure-audit-settings-for-a-site-collection-F5A346D0-EE0F-4412-A5E6-D9B5ABAA1012

Delete Audit Report Report Data

Next, lets create some activity using built-in document library.

Add and delete document.

Back to Site Collection Administration > Audit Log Reports > Deletion
Save report (Suggestion: Create a new document library for audting)

Open Report using Excel or Excel Web App

Auditing in SharePoint

Articles

SharePoint 2016

Excel Import Permissions
http://www.sharepointdiary.com/2015/05/export-sharepoint-users-and-group-permissions-to-excel.html
Audit Specific Event ID Function
https://howtodowithsharepoint.wordpress.com/2016/11/26/sharepoint-20162013-event-log-monitoring-by-automation/

Configure audit settings for a site collection (2016)
https://support.office.com/en-us/article/Configure-audit-settings-for-a-site-collection-A9920C97-38C0-44F2-8BCB-4CF1E2AE22D2
More from The Cloud EngineerSharepoint Deletion Log
http://thecloudengineer.blogspot.com/2016/03/sharepoint-deletion-log.html

Office 365

Office 365 Audit Logging
https://www.petri.com/office-365-audit-logging-generates-data

SharePoint Legacy

SharePoint 2013

Enables auditing of how site collections, sites, lists, folders, and list items are accessed, changed, and used
https://msdn.microsoft.com/en-us/library/ms441917.aspx

SharePoint Server 2013 custom audit log report - PowerShell script
https://gallery.technet.microsoft.com/office/SharePoint-Server-2013-9657c24e
Using PowerShell Scripts to Implement SharePoint Audit Logging (part 1 and part 2)
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-1/
http://www.coyotecrk.com/using-powershell-scripts-implement-sharepoint-audit-logging-part-2/
View and configure usage analytics reports in SharePoint Server 2013
https://blogs.technet.microsoft.com/tothesharepoint/2014/01/23/view-and-configure-usage-analytics-reports-in-sharepoint-server-2013/
Auditing - A Built-in Feature of SharePoint 2010
https://www.codeproject.com/articles/431342/auditing-a-built-in-feature-of-sharepoint

More Tools

Simple SharePoint Permissions Auditing – OOTB

The question is how do I view permissions and perform a site auditing using out of the box tools. Using PowerShell script found from fellow Buckeye SPUG member Brian Jackett, I was able to create an excel report below.
https://briantjackett.com/2013/07/01/powershell-script-to-enumerate-sharepoint-2010-or-2013-permissions-and-active-directory-group-membership/
First I needed to add the policy at the web application level.
Second I ran the script and dumped out an xml file.
Finally results displayed by using Excel import from the XML file for a small lab setup.

Displaying XML in SharePoint

http://thecloudengineer.blogspot.com/2015/11/displaying-xml-in-sharepoint.html

Auditing - A Built-in Feature of SharePoint

http://www.codeproject.com/Articles/431342/Auditing-A-Built-in-Feature-of-SharePoint

SharePoint Foundation

http://auditlogsp.codeplex.com/
2010

Tuesday, December 5, 2017

Project Honolulu – Management Tool

Microsoft Project Honolulu

Install was smooth on Windows 10, but …

Run as different user since Edge is needed and won’t run as domain admin

Run winrm quickconfig

Alternate Creds needed

Up and running in a few minutes and looks nice.

Yeah !!! powershell remote

Download
https://aka.ms/HonoluluDownload

Reference
https://docs.microsoft.com/en-us/windows-server/manage/honolulu/honolulu

Note WMF 5.1 prerequisite download WMF 5.1.

More Info

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

Resources

https://www.brentozar.com/responder/

Technet
http://technet.microsoft.com/en-us/library/cc748824.aspx

Great SQL Resource
http://dba.stackexchange.com.

Third Party Solutions
http://sharepointgalaxy.blogspot.com/search/label/vendor

Wednesday, September 27, 2017

Red Hat Linux

Hello World! – Download Install Red Hat

Bare Metal

https://developers.redhat.com/products/rhel/hello-world/#fndtn-bare-metal_install-rhel-on-bare-metal

Hyper-V

https://developers.redhat.com/products/rhel/hello-world/#fndtn-hyper-v

SharePoint Development

2019

SPFx

Overview of the SharePoint Framework
(SharePoint 2016 Feature Pack 2)
https://docs.microsoft.com/en-us/sharepoint/dev/spfx/sharepoint-framework-overview

SPFx - The SharePoint Framework—an open and connected platform
https://blogs.office.com/en-us/2016/05/04/the-sharepoint-framework-an-open-and-connected-platform/

Installing the SPFx Fantastic 40 WebParts (Examples)
https://github.com/OlivierCC/spfx-40-fantastics/wiki/Installation-process

SPFx Interview Mark Rackley
https://www.voitanos.io/blog/sharepoint-framework-in-mark-rackley-s-own-words

SPFX Manoj Mittal Webinars
Part 1 https://www.c-sharpcorner.com/article/online-webinar-sharepoint-framework-part-1/
Part 2
https://www.c-sharpcorner.com/article/online-webinar-sharepoint-framework-with-reactjs-part2/

2016

SharePoint Client Side Developers

5 Things to Stop Doing

1/5 Things Sharepoint Client Side Developers Should Stop
2/5 Things Sharepoint Client Side Developers Should Stop
3/5 Things Sharepoint Client Side Developers Should Stop
4/5 Things Sharepoint Client Side Developers Should Stop
5/5 Things Sharepoint Client Side Developers Should Stop

Can I Use … Browser support tables for modern web technologies

http://caniuse.com/

Old News

SDK https://www.microsoft.com/en-us/download/details.aspx?id=30722

Set up a general development environment for SharePoint 2013
https://msdn.microsoft.com/en-us/library/ee554869(v=office.15)

Setting up Visual Studio 2012 for SharePoint 2013 development offline
http://blogs.msdn.com/b/timquin/archive/2013/01/22/setting-up-visual-studio-2012-for-sharepoint-2013-development-offline.aspx

Prerequisites for creating SharePoint 2013 projects using Visual Studio 2012
http://blogs.msdn.com/b/how24/archive/2013/03/12/creating-sharepoint-2013-projects-using-visual-studio-2012.aspx

CSS and Branding

To brand or not to brand ??? That is the question.
http://blog.sharepointexperience.com/2015/01/to-brand-or-not-to-brand/

CSS Dev on Large Scale Websites
http://sixrevisions.com/css/css-development-at-large-sites/

Branding
http://blog.drisgill.com/
http://sharepointexperience.com/

CSS
http://sharepointexperience.com/csschart/csschart.html

Good Resources http://www.codeproject.com/KB/sharepoint/

More from The Cloud Engineer

More 2010 Info
http://thecloudengineer.blogspot.com/2012/05/development-environment.html

Tuesday, September 26, 2017

SharePoint 2019

Updates from Vendors
SharePoint Server 2019 Preview Now Available
https://redmondmag.com/articles/2018/07/25/sharepoint-server-2019-preview.aspx
2019 Install Public Preview with errors
https://jeffangama.wordpress.com/2018/08/05/install-and-configure-sharepoint-2019-public-preview-for-sharepoint-administrators
SharePoint 2019 Preview (Microsoft)
Download 2019
https://www.microsoft.com/en-us/download/details.aspx?id=57169
Install SharePoint Server 2019 Public Preview
https://docs.microsoft.com/en-us/sharepoint/install/install-for-sharepoint-server-2019
Key Features
New and Improved Features
https://docs.microsoft.com/en-us/SharePoint/what-s-new/new-and-improved-features-in-sharepoint-server-2019
Deprecated or Removed
https://docs.microsoft.com/en-us/SharePoint/what-s-new/what-s-deprecated-or-removed-from-sharepoint-server-2019
SMPT Authentication
https://blogs.technet.microsoft.com/mikelee/2018/07/25/finally-smtp-authentication-included-with-sharepoint-2019/
Old News SharePoint 2019
https://www.metalogix.com/blog/what-expect-sharepoint-2019
https://www.avepoint.com/blog/sharepoint-hybrid/sharepoint-2019-info-timeline/
https://harmon.ie/blog/hey-what%E2%80%99s-new-sharepoint-2019?utm_source=HootSuite
Announced at Ignite 2017, SharePoint vNext is …
SharePoint 2019
https://blogs.office.com/en-us/2017/09/26/the-next-perpetual-release-of-office/
Feature List Opinions
https://www.techtask.com/whats-coming-sharepoint-server-2019-premises
https://collab365.community/sharepoint-2019-announced-complete-round-ignite/

Thursday, September 21, 2017

SharePoint Monitoring Tools

2013

PoShMon
https://www.powershellgallery.com/packages/PoShMon/0.13.0

https://github.com/HiltonGiesenow/PoShMon/blob/master/README.md

2010

SharePoint Farm Monitoring Report using Powershell Script
https://gallery.technet.microsoft.com/office/SharePoint-Farm-Report-6c2a7229

Andriod Apps

To Do – these apps are on my to do list to try:
(Test First !!!)

Credit Card Skimmer Detector
https://thenextweb.com/apps/2017/09/20/heres-how-to-stop-criminals-from-stealing-your-credit-card-info-at-the-gas-pump/#.tnw_ZACIQGbZ

Wednesday, September 13, 2017

Content Types and Columns and Views

Permission Workarounds

Due to performance, SharePoint does not set permissons on columns but here are some workarounds.

SharePoint Online - Office 365 - Column Level Security Issues Options
http://www.c-sharpcorner.com/article/sharepoint-online-office-365-column-level-security-iss/

3 Approaches to Restricting Access to SharePoint Columns and Metadata
http://sharepointpromag.com/blog/3-approaches-restricting-access-sharepoint-columns-and-metadata

Clean Column level permissions using local lookup
http://aviralchawda.blogspot.in/2014/09/column-level-permission-in-

Office 365

SharePoint Online - Office 365 - Column Level Security Issues Options
http://www.c-sharpcorner.com/article/sharepoint-online-office-365-column-level-security-iss/

SharePoint 2013

Visual Approach to Content Type Tagging
https://blog.splibrarian.com/2015/01/15/a-visual-approach/

Planning
http://technet.microsoft.com/en-us/library/cc262735.aspx

Calculated Columns
https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

Content Types Diagram

2010

Content Type Hub
http://sharepointgalaxy.blogspot.com/2012/04/content-type-hub.html

Calculated columns:
http://msdn.microsoft.com/en-us/library/bb862071.aspx
https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx
NOTE: You can get up to 7 nested "if" statements in a calculated column of a SharePoint list
http://sharemypoint.in/2009/03/04/sharepoint-calculated-columns-formulas/

Time and Date
http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/16cb40af-55fe-4b88-b3ee-5189babe44d5

Columns Issues
No out of the box solution for column permissions yet. Here is good article on permissions for columnshttp://www.infowisesolutions.com/blog/Comments.aspx?ArticleId=24
Possible Vendor solutionshttp://www.speals.com/products/listpermissionsup/default.aspx

Content Type
Content type and workflow planning http://technet.microsoft.com/en-us/library/cc262735.aspx

Views
Modify Sharepoint List and Library Views
http://office.microsoft.com/en-us/sharepoint-foundation-help/create-modify-or-delete-a-view-HA010377693.aspx?CTT=1

Permissions
Good article on customizing permissions for a document library in such a way that authors can only change their own documents.
http://www.sharepointusecases.com/index.php/2010/03/configure-item-level-permissions-for-document-libraries-part-2/

Psuedo Permissions using VIews
http://www.learningsharepoint.com/2013/12/14/sharepoint-views-permission/

Friday, September 1, 2017

SharePoint Search Query Tool

Awesome tool for troubleshooting SharePoint Search issues.
New Site
https://github.com/SharePoint/PnP-Tools/tree/master/Solutions/SharePoint.Search.QueryTool
Old
https://sp2013searchtool.codeplex.com/

Monday, July 17, 2017

Web Application vs Site Collection vs Site

SharePoint 2016/2013/2010

UPDATES:

Search Configuration is done at both at Site and Site Collection level

Farm Settings – SPFarm

Max Database 500
Farm Administration
Email Settings

Web Application Settings – SPWebApplication

https://technet.microsoft.com/en-us/library/cc261978(v=office.16).aspx

http://technet.microsoft.com/en-us/library/cc287691.aspx (2010)

NOT RECOMMENDED!!! ~~Shredded Storage can be disabled and re-enabled per Web Application~~
Recycle Bin: per Web App. How long items are deleted from user bins and Second Stage recycle bin size.
Maximum Upload Size: per Web Application.
Authentication Provider: Choose up to 5 zones
Define Managed Paths: per web application only.
Enable Self Service Site Creation: per web application level.
Blocked File Types: per Web Application
List Throttling: per Web Application
Service Application Association
Dedicated Add-in or App Settings
Email Settings

Site Collection – SPSite

https://technet.microsoft.com/en-us/library/ff607925(v=office.16).aspx

http://technet.microsoft.com/en-us/library/ff607786.aspx (2010)
Recycle Bin: Dedicated Recycle Bin for the site collection
Dedicated usage reports: Usage reports work on the site collection level.
Dedicated Administration: Site Collection Administrators
http://technet.microsoft.com/en-us/library/cc263199.aspx#architecture
Search Configuration: Configurable search scopes, keywords and best bets
Galleries: Galleries for libraries, images and styles
Site Quota templates: All sites within a site collection contribute to the quota.
Dedicated Database: Recommended due to improved DR and smallest unit to allow/restore with full fidelity restore
Permissions: Permissions are not inherited from another site
Considered a “Security Boundary”
URL Character Limit 150 (2016 to remove but remains)

Site - SPWeb

https://technet.microsoft.com/en-us/library/ff607925(v=office.16).aspx

http://technet.microsoft.com/en-us/library/ff607786.aspx (2010)
Administration: Needs to be controlled from Site Collection Admin
Site Features: Features particular to your site
MDS:Minimal Download Strategy
Navigation: Inherit navigation from parent site
Permissions: Inherit permissions from Site Collection
Sharing: Share and consume list data from other sites in same site collection
Themes: Themes are site specific
URL Character Limit 255 (2016 to remove but remains)

References

Plan Site/Site Collections – TechNet - 2016

https://technet.microsoft.com/en-us/library/cc263267(v=office.16).aspx

Design Checklists/Worksheets – 2013 or 2010

http://technet.microsoft.com/en-us/library/cc262451.aspx (2013)

http://nikpatel.net/2012/03/11/checklist-for-designing-and-implementing-sharepoint-2010-extranets-things-to-consider/

http://www.sharepointgeoff.com/implementation-checklist/

Wednesday, July 12, 2017

Troubleshooting Windows

Error Message Hall of Fame

Reference

Microsoft Ignite 2016

Case of the unexplained: Windows troubleshooting with Mark Russinovich

https://channel9.msdn.com/Events/Ignite/2016/BRK4028

Monday, June 26, 2017

Cloud Security

News

Summer 2017

Azure vs AWS

UpGuard in a post

The UpGuard report was just the latest in a string of such announcements, including:

In April, an analysis of AWS cloud usage by Threat Stack Inc. revealed widespread critical AWS security misconfigurations affecting nearly three-quarters of more than 200 surveyed organizations.
In May, RedLock Inc. published a research report finding many security issues primarily caused by user misconfigurations on public cloud platforms, with AWS figuring prominently.
Earlier this month, Appthority published investigation results that found nearly 43 TB of enterprise data was exposed on cloud back-ends, including personally identifiable information (PII).

The finding by UpGuard resulted in a post about "AWS S3 Bucket Provisioning."

Tools

DNS

Simple DNSCrypt

DNS Proxy

https://simplednscrypt.org/

https://github.com/bitbeans/SimpleDnsCrypt

IPLookup

https://community.spiceworks.com/tools/ip-lookup/results

Browsers

Epic Privacy Browser

https://www.epicbrowser.com/

Comodo Dragon

https://www.comodo.com/home/browsers-toolbars/internet-products.php

Brave

https://brave.com/

Tor

Anonymous Browsing

https://www.torproject.org/index.html.en

Google

If using Google via tor you might end up redirected to a localized google site so try:

http://www.google.com/ncr (no country redirect) instead

https://www.google.com/webhp?cr=countryUS should also work.

Browser Security – Go Private

Use InPrivate or InCognito Browsing

Internet Explorer: Control + Shift + P

add –private to shortcut

Chrome Control/Command + Shift + N

add –incognito to shortcut

FireFox

"C:\Program Files\Mozilla Firefox\firefox.exe" -private-window

Clean your Flash Cookies

%appdata%\Macromedia\Flash Player\#SharedObjects

Clean your DNS Cache

ipconfig /flushdns

Reference

In Private Browsing

https://www.howtogeek.com/137466/how-to-always-start-any-browser-in-private-browsing-mode/

Wednesday, June 21, 2017

Wifi Hardware

Looking to buy new wifi hardware and have been asking around and here is what has been recommened to me:

Ubiquiti Unifi Ap AC Lite
Wireless Access Point - 802.11 B/A/G/n/AC (UAPACLITEUS)

https://www.ubnt.com/unifi/unifi-ap-ac-lite/

UAP-AC-LR

https://www.ubnt.com/unifi/unifi-ap-ac-lr/

more to come

Popular Workflows

Delete Item

Since a condition is missing for delete item, there are many workarounds to solve this issue.

SharePoint 2010 Start a Workflow on Item Delete
https://jenniferannmason.com/2011/01/26/sharepoint-2010-start-a-workflow-on-item-delete/

Guest Post: Instantiate SharePoint Workflow On Item Deleted
https://briantjackett.com/2010/12/09/guest-post-instantiate-sharepoint-workflow-on-item-deleted/

Launch Workflow on Delete
http://www.go4sharepoint.com/Forum/launch-workflow-item-delete-8368.aspx

Friday, May 19, 2017

Azure Terminology

IaaS – infrastructure as a service
https://azure.microsoft.com/en-us/overview/what-is-iaas/
PaaS - platform as a service
https://azure.microsoft.com/en-us/overview/what-is-paas/
SaaS stands for software as a service
https://azure.microsoft.com/en-us/overview/what-is-saas/

IaaS is comprised of highly automated and scalable compute resources, complemented by cloud storage and network capability which can be self-provisioned, metered, and available on-demand.

PaaS functions at a lower level than SaaS, typically providing a platform on which software can be developed and deployed. PaaS providers abstract much of the work of dealing with servers and give clients an environment in which the operating system and server software, as well as the underlying server hardware and network infrastructure are taken care of, leaving users free to focus on the business side of scalability, and the application development of their product or service.

SaaS has a main difference of being hosted by a vendor where iPaaS is cloud-based. Applications that are on-premise hosted can be integrated and allow for free flow of data. The application or service is made available to customers over a network, usually the internet.

aPaaS - application platform as a service

https://azure.microsoft.com/en-us/resources/gartner-apaas-magic-quadrant/en-us/

iPaaS - integration platform as a service

https://azure.microsoft.com/en-us/blog/announcing-azure-logic-apps-general-availability/

aPaaS allows for rapid application development and delivery. This form has high productivity and high control. The coding process for platforms as a service can slow down delivery, but aPaaS brings automation for the application lifecycle. aPaaS offers a faster way to build apps
iPaaS is a cloud-based integration solution, unlike SaaS which is hosted by a vendor on-premise. It iPaaS allows applications that reside on the cloud or on-premise to integrate and have data flow freely between them. It does not need any download, it is simply deployed. This is the most balanced offering because it can bring differently hosted software solutions or applications together.

Reference

Cloud Service Models (IaaS, SaaS, PaaS)https://www.cmswire.com/cms/information-management/cloud-service-models-iaas-saas-paas-how-microsoft-office-365-azure-fit-in-021672.php

Azure Glossary
https://docs.microsoft.com/en-us/azure/azure-glossary-cloud-terminology

Cloud computing terms
https://azure.microsoft.com/en-us/overview/cloud-computing-dictionary/
Compare AWS and Azure
https://www.cloudyn.com/blog/azure-terminology-for-aws-speakers/
Windows Azure Platform Glossary for IT Pros
https://blogs.technet.microsoft.com/yungchou/2011/04/21/windows-azure-platform-glossary-for-it-pros/
https://ryvit.com/the-difference-between-ipaas-apaas-and-saas/
https://www.computenext.com/blog/when-to-use-saas-paas-and-iaas/
https://msdn.microsoft.com/en-us/magazine/ee309870.aspx

Azure Maintenance

Use TRIM with unmanaged standard disks
https://docs.microsoft.com/en-us/azure/storage/storage-about-disks-and-vhds-windows

Thursday, December 21, 2017

Color Status Indicator

Calender

Calendar - Office 365

2019

Branding guidance for SharePoint

Office 365

Branding SharePoint: The New Normal

2013 / 2016

Composed Looks

Themes

Branding

2010

Monday, December 18, 2017

Articles

SharePoint 2016

Office 365

SharePoint Legacy

SharePoint 2013

More Tools

SharePoint Audit Logging

SharePoint Deletion Log Report

SharePoint Permissions Analyzer

Simple SharePoint Permissions Auditing – OOTB

Displaying XML in SharePoint

Auditing - A Built-in Feature of SharePoint

SharePoint Foundation

Tuesday, December 5, 2017

Thursday, November 9, 2017

SharePoint 2016

Office 365

SharePoint 2013

Older Legacy

Friday, November 3, 2017

2016

2013

2010

SQL Performance Tools

Other Performance Tools

OLD

Friday, October 27, 2017

Monday, October 16, 2017

Updates

Office 2007 supported extended until April 2017

2016

2013

2010

Issues with Office 2013 in SharePoint 2010 Farm

Thursday, October 12, 2017

AlwaysOn

SQL Clusters

Resources

Wednesday, September 27, 2017

Hello World! – Download Install Red Hat

2019

SPFx

2016

SharePoint Client Side Developers

5 Things to Stop Doing

Old News

CSS and Branding

More from The Cloud Engineer

Tuesday, September 26, 2017

Updates from Vendors

SharePoint Server 2019 Preview Now Availablehttps://redmondmag.com/articles/2018/07/25/sharepoint-server-2019-preview.aspx

SharePoint 2019 Preview (Microsoft)

Key Features

Thursday, September 21, 2017

2013

2010

Wednesday, September 13, 2017

Permission Workarounds

Office 365

SharePoint 2013

2010

Friday, September 1, 2017

Monday, July 17, 2017

SharePoint 2016/2013/2010

UPDATES:

Farm Settings – SPFarm

SharePoint Server 2019 Preview Now Available
https://redmondmag.com/articles/2018/07/25/sharepoint-server-2019-preview.aspx

References

Plan Site/Site Collections – TechNet - 2016