Excel 2013 PowerPivot Dashboards with Sharepoint 2013 BI TutorialGP0|#be9f6e37-d079-4e4e-84f3-416739395df1;L0|#0be9f6e37-d079-4e4e-84f3-416739395df1|PowerPivot;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213Sharing PowerPivot reports built in Excel 2013 by publishing them to SharePoint 2013. Business Intelligence tutorial. Sort your chart. Use slicers.
Tuning SQL Server 2012 for SharePoint 2013 (01) Key SQL Server and SharePoint Server Integration ConceptsGP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213This session provides an overview of SQL Server deployment options and database types; understanding SQL Server and SharePoint integration, schema overview, database structure, schema restrictions and SharePoint database descriptions. Learn how to efficiently manage multiple instances on one physical server.
Tuning SQL Server 2012 for SharePoint 2013 (02) Best Practices for SQL Server Database SettingsGP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213Get ready to understand model and Tempdb database settings, database file placement, and how to determine the number of content databases. This module goes over how to modify model database to reflect configuration of new databases and configure Tempdb for improved performance, and much more.
Tuning SQL Server 2012 for SharePoint 2013 (03) Server Settings for SQL ServerGP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213In this segment you will learn how to modify memory settings to control memory usage by SQL Server, how to change default file locations, how to leave MAXDOP at 1 for SharePoint and how to verify operating system set to 64KB allocation unit size. Get ready for some great demos and rich dialogue.
Tuning SQL Server 2012 for SharePoint 2013 (04) SQL Server and SharePoint AvailabilityGP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213This module will show you how to avoid ginormous T-Logs by performing regular T-Log backups, how to have multiple copies of your backups, how to configure AlwaysOn for high availability and verify integrity of SQL Server databases. Lastly the instructors will cover SQL Server for SharePoint best practices.
Kerberos - SharePoint 2013, SQL 2012 for Business IntelligenceGP0|#876a554a-0cb6-40ec-ae6a-1db546d01457;L0|#0876a554a-0cb6-40ec-ae6a-1db546d01457|Kerberos;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#6553c9ac-7cd3-4c35-9ee0-494641495101;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#915d058d-239c-403d-8c63-ddcd997c707f;L0|#0915d058d-239c-403d-8c63-ddcd997c707f|BI;GPP|#a5205c2f-ad79-446f-8d9e-afd0eeecf427;GP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4 ​The focus of this article is that you would like to configure Kerberos for all the BI functionality in SharePoint. It is a step by step checklist to ensure your Kerberos configuration is correct.
Re-enable the PremiumSite Feature after removing PowerPivotGP0|#be9f6e37-d079-4e4e-84f3-416739395df1;L0|#0be9f6e37-d079-4e4e-84f3-416739395df1|PowerPivot;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#b8094c52-e86a-452d-ab36-1a0091ea9c22;L0|#0b8094c52-e86a-452d-ab36-1a0091ea9c22|Excel Services;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903 ​After you uninstall the PowerPivot for SharePoint component, Excel Services and other services in the PremiumSite feature are disabled. To re-enable the features for all the SharePoint sites in a SharePoint farm, run the following script
Microsoft BI Authentication and Identity DelegationGP0|#6553c9ac-7cd3-4c35-9ee0-494641495101;L0|#06553c9ac-7cd3-4c35-9ee0-494641495101|Authentication;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GP0|#1da233f4-dc04-4361-9f9b-16d4053ca898;L0|#01da233f4-dc04-4361-9f9b-16d4053ca898|Performance Point;GPP|#aa2447c2-0307-4407-bd59-fedab9e12903;GP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1 ​From straightforward client/server designs to complex architectures relying on distributed Windows services, SharePoint applications, Web services, and data sources, Microsoft BI solutions can pose many challenges to seamless user authentication and end-to-end identity delegation. SQL Server technologies and data providers expect to use Windows authentication while SharePoint Server uses Web Services Security (WS-Security). Familiarity with the authentication protocols and capabilities, delegation limitations, and possible workarounds is an indispensable prerequisite to delivering a positive BI user experience across the entire Microsoft BI solution stack in enterprise environments.
Migrate SSRS Content between Report ServersGP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 A sample Reporting Services RSS script that copies content items and settings from one SQL Server Reporting Services report server to another report server, using the RS.exe utility. RS.exe is installed with Reporting Services. The script migrates Reporting Services items, for example reports and subscriptions, from server to server. The script supports both SharePoint mode and Native mode report servers.
Tavis LovellGP0|#915d058d-239c-403d-8c63-ddcd997c707f;L0|#0915d058d-239c-403d-8c63-ddcd997c707f|BI;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#a5205c2f-ad79-446f-8d9e-afd0eeecf427;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4
Microsoft BI Authentication and Identity Delegation technical reference guideGP0|#6553c9ac-7cd3-4c35-9ee0-494641495101;L0|#06553c9ac-7cd3-4c35-9ee0-494641495101|Authentication;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#1b064965-36f6-40b1-a474-78053852e564;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213;GP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4
Create a Download SSRS Report Link in SharePoint Document LibraryGP0|#696b9a94-3537-458e-b81e-938e4aefd34a;L0|#0696b9a94-3537-458e-b81e-938e4aefd34a|Reporting Services;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#cad6386c-0bed-4b5d-80d2-8b25269297e1;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213
SharePoint 2013 and SQL Server AlwaysOnGP0|#cad6386c-0bed-4b5d-80d2-8b25269297e1;L0|#0cad6386c-0bed-4b5d-80d2-8b25269297e1|SQL Server;GTSet|#68e31ecf-dbe9-45e0-8a3c-fc6bd6ad0ce6;GPP|#622a2a3e-b232-4024-952a-55c7b56949a4;GPP|#74f9ea2a-fcec-489f-9ca4-da563b559213 ​AlwaysOn is a great new feature to SQL Server 2012 that allows consuming clients to have a mirroring and failover database solution all transparently for a single named instance.