Sharepoint 2013 - Services

Quick tip for tuning SharePoint 2013 Usage and Health data retention

http://www.chrismcnulty.net/blog/Lists/Posts/Post.aspx?ID=83

Configure SQL Server Reporting Services (SSRS) 2012 Integration with SharePoint 2013 - Step by Step Guide

Read more: http://www.sharepointdiary.com/2013/12/configure-ssrs-2012-integration-with-sharepoint-2013.html#ixzz4bSG96dFT

Configure SharePoint 2013 Farm with PowerShell

https://blogs.msdn.microsoft.com/priyo/2013/09/13/configure-sharepoint-2013-farm-with-powershell/

https://social.technet.microsoft.com/wiki/contents/articles/35016.sharepoint-2016-visio-service-application-step-by-step-guide.aspx

SharePoint 2010 Database Naming Conventions

SharePoint 2010 Database Naming Standards/Conventions

When it comes to SharePoint database naming standards, There are lot of patterns used by SharePoint Admins. Yes, it is a good practice to have a database naming convention. Not only just a good practice, but it will be good for your DBAs as well :-). and here goes mine.

Pattern:  SP2010_ + Scope (such as Farm, Sales, IT, etc) + _Database Type (Config , Content, Service)

Database Name	Brief Description
SP2010_Farm_Config	Farm Configuration The configuration database contains data about SharePoint databases, Internet Information Services (IIS) Web sites, Web applications, trusted solutions, Web Part packages, site templates, and Web application and farm settings specific to SharePoint 2010 Products, such as default quota settings and blocked file types.
SP2010_Farm_Admin_Content	Central Administration content The Central Administration content database is considered to be a configuration database. It stores all site content, including site documents or files in document libraries, list data, and Web Part properties, in addition to user names and rights for the Central Administration site collection. If Microsoft SQL Server PowerPivot for Microsoft SharePoint is installed, the Central Administration content database also stores the Excel worksheets and PowerPivot data files used in the PowerPivot Management Dashboard.
SP2010_Portal_Content	Content databases Content databases store all content for a site collection, including site documents or files in document libraries, list data, Web Part properties, audit logs, and sandboxed solutions, in addition to user names and rights.
SP2010_Partner_Content	Same as above
SP2010_Farm_Logging_Config	Usage and Health Data Collection database The Usage and Health Data Collection database is used by the Usage and Health Data Collection service application. It stores health monitoring and usage data temporarily, and can be used for reporting and diagnostics.
SP2010_Farm_UserProfileSocial_Service	User Profile service application Social Tagging database The Social Tagging database stores social tags and notes created by users, along with their respective URLs.
SP2010_Farm_UserProfileSynch_Service	User Profile service application Synchronization database The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.
SP2010_Farm_UserProfile_Service	User Profile service application Profile database The Profile database stores and manages users and associated information. It also stores information about a user's social network in addition to memberships in distribution lists and sites.
SP2010_Farm_ManagedMetadata_Service	Managed Metadata database The Managed Metadata service application database stores managed metadata and syndicated content types.
SP2010_Farm_Search_Service	Search service application Administration database The Administration database hosts the Search service application configuration and access control list (ACL), and best bets for the crawl component. This database is accessed for every user and administrative action.
SP2010_Farm_SearchCrawl_Service	Search service application Crawl database The Crawl Databases host the crawled data and drives crawl
SP2010_Farm_SearchProperty_Service	Search service application Property database The Property database stores information that is associated with the crawled data, including properties, history, and crawl queues.
SP2010_Farm_WebAnalyticsReporting_Service	Web Analytics Reporting database The Reporting database stores aggregated standard report tables, fact data aggregated by groups of sites, date and asset metadata, and diagnostics information for the Web Analytics service application.
SP2010_Farm_WebAnalyticsStaging_Service	Web Analytics Staging database The Staging database temporarily stores un-aggregated fact data, asset metadata, and queued batch data for the Web Analytics service application.
SP2010_Farm_SecureStore_Service	Secure Store database The Secure Store service application database stores and maps credentials, such as account names and passwords.
SP2010_Farm_State_Service	State database The State service application database stores temporary state information for InfoPath Forms Services, the chart Web Part, and Visio Services.
SP2010_Farm_Usage_Service	Usage Service database
SPS2010_Farm_AppRegistry_Service	Application Registry database The Application Registry service application database stores backward-compatible information that is used to connect to information that is used by the Microsoft Office SharePoint Server 2007 Business Data Catalog API.
SPS2010_Farm_BCS_Service	Business Data Connectivity database The Business Data Connectivity service application database stores external content types and related objects.
SPS2010_Farm_AppRegistry_Service	Application Registry database The Application Registry service application database stores backward-compatible information that is used to connect to information that is used by the Microsoft Office SharePoint Server 2007 Business Data Catalog API.
SPS2010_Farm_PPS_Service	PerformancePoint service application database The PerformancePoint service application database stores temporary objects, persisted filter values, and user comments.
SPS2010_Farm_PowerPivot_Service	PowerPivot Application database The PowerPivot Application database stores the location of cached or loaded PowerPivot data files, data refresh schedules, and PowerPivot usage data that is copied from the central usage data collection databa