jump to navigation

Change EPT Project Server August 20, 2013

Posted by juanpablo1manrique in SharePoint.
Tags:
add a comment

Hola,

Para cambiar el Enterprise Project Type existen algunas opciones para realizar esta acción,

con workflow

ChangeEPT2

sin workflow

ChangeEPT1

 

Saludos

System.Windows.Forms.Panel Controls.Add only see first July 27, 2013

Posted by juanpablo1manrique in SharePoint.
Tags:
add a comment

Buen día amigos,

Aquí estoy realizando una aplicación Windows forms, pero en forms ciertas cosas funcionan diferente, me anime a escribir este post para todos aquellos que estamos acostumbrados a desarrollar WEB y nos encontramos con la necesidad de Hacer WindowsForms por casualidad.

Al ejecutar este código solo veía el primer control,

  • Label lbl = new Label();            
  • lbl.Text = “sdfsdasdcsddf”;            
  • Panel12.Controls.Add(lbl);
  • TextBox lbl3 = new TextBox();            
  • lbl3.Text = “1234 ABC”;            
  • Panel12.Controls.Add(lbl3);
  • Label lbl2 = new Label();                       
  • lbl2.Text = “123223”;            
  • Panel12.Controls.Add(lbl2);

Las solución para que en pantalla no se viera solo el primero fue agregar el location

  • Label lbl = new Label();
  • lbl.Text = “sdfsdasdcsddf”;
  • lbl.Location = new System.Drawing.Point(0, 0);
  • Panel12.Controls.Add(lbl);
  • TextBox lbl3 = new TextBox();
  • lbl3.Text = “1234 ABC”;
  • lbl3.Location = new System.Drawing.Point(0, lbl.Size.Height);
  • Panel12.Controls.Add(lbl3);
  • Label lbl2 = new Label();
  • lbl2.Text = “123223”;
  • lbl2.Location = new System.Drawing.Point(0, lbl.Size.Height + lbl3.Size.Height);
  • Panel12.Controls.Add(lbl2);

Happy WinForm Coding

Open HTML, FLASH, PDF files in SharePoint Library try Download July 15, 2013

Posted by juanpablo1manrique in SharePoint, SharePoint2013.
Tags:
2 comments

Hola
En estos días tuve el impedimento de poder desplegar archivos HTML, PDF, FLASH desde una librería de SharePoint, al dar click sobre un archivo HTML que estaba en una librería, me lo intentaba descargar en vez de abrirlo de una vez,

Untitled2
Una de las soluciones fue ir al central administrator y en los settings del webApplication decirle “permissive”, pero la idea no era darle “permissive” ya que esto abría un poco la seguridad del web application, así que seguí buscando y encontré la función AllowedInlineDownloadedMimeTypes (Realmente es un vector), el cual permite agregar los tipos de application que quiero que se desplieguen sobre SharePoint, el script completo quedo de la siguiente manera.

$webApp=Get-SPWebApplication http://webapplicationurl:90
$webApp.BrowserFileHandling = “strict”
$webApp.AllowedInlineDownloadedMimeTypes.Add(“application/octet-stream”)
$webApp.AllowedInlineDownloadedMimeTypes.Add(“text/html”)
$webApp.AllowedInlineDownloadedMimeTypes.Add(“application/pdf”)
$webApp.AllowedInlineDownloadedMimeTypes.Add(“application/x-shockwave-flash”)
$webApp.Update()

Para poder ver que tipo de application que quiero desplegar, me recomendaron RESTClient de Firefox el cual me dice que tipo de application es el que necesito

https://addons.mozilla.org/en-us/firefox/addon/restclient/Untitled1

PD. los archivo de tipo “application/octet-stream” igualmente no se abren en modo permissive sino que toca, colocarlo strict y agregar el tipo de application correspondiente.

Happy SharePoint,

Move sites in other database content July 6, 2013

Posted by juanpablo1manrique in SharePoint.
add a comment

En este caso vamos a mirar como mover sites entre bases de datos de contenido en el caso de Sharepoint 2010,

Lo primero es crear un archivo XML con la ubicación de los sitios que deseamos mover,

stsadm -o enumsites -url http://localhost > c:\sites.xml

Este comando enumera todos los sitios de este WebApplication, así que es necesario editarlo en notepad y eliminar los sitios que no queremos mover, y luego ejecutamos el siguiente comando,

stsadm -o mergecontentdbs -url http://localhost -sourcedatabasename WSS_Content -destinationdatabasename WSS_content_2 -operation 3 -filename c:\sites.xml

y taran,

Hack or restore sa account sql server March 18, 2013

Posted by juanpablo1manrique in SharePoint.
add a comment

Exactamente no la vamos a hackiar, vamos a elevernos permisos a ‘sysadmin’ y ahi recuperar el control de la instancia de SQL SERVER y entrar en modo Dios.

  • Iniciar consola con permisos de administración
  • cd\ para pararse en C:
  • SQLCMD –E -S ‘Domain\Account’
  • CREATE LOGIN ‘Domain\Account’ FROM WINDOWS  *
  • exec sp_addsrvrolemember @loginame=’Domain\Account’,@rolename=’sysadmin’
  • servics.msc y reiniciar el servicio, tambien se puede hacer desde la consola de administración de SQL pero es lo mismo
* Este es un paso adicional que no siempre es necesario, toca ejecutarlo en caso que no se logre entrar a la instancia, por lo general se logran entrar dado que el BUILTIN\Users siempre esta presente en todas las instancias de SQL muy pocas veces se toman el trabajo de quitarlo para asegurar la instancia. En caso de que se logre entrar a la instancia este usuario se puede crear por el management studio pero va a quedar con permisos de public y luego se corre este procedimiento por comandos para elevarle los permisos.

Esto no es exactamente Hackear la cuenta, solo es entrar con una cuenta de administrador y elevarse privilegios, para casos más extremos se puede utilizar
http://www.windowsecurity.com/articles-tutorials/misc_network_security/Hacking_an_SQL_Server.html

Saludos

Error: var logoImg = documentGetElementsByName – MoveSiteTitle February 24, 2013

Posted by juanpablo1manrique in SharePoint, SharePoint Development.
Tags: ,
3 comments

Hola Amigos

Ahora que ingresamos al mundo cross-browser, con sharepoint 2013, encontrmos que sharepoint 2010 todavia tiene algunos incovenientes, uno de ellos se me present en estos días al estar trabajando con el SharePoint recien instalado y con el Master.Page v4 que trae sharepoint por defecto, en Chrome en el momento de hacer debug se evidenciaba error en estas 2 líneas.

PlaceHolderPageTitleInTitleArea

solucion medio temporal:

En SharePoint designer se busca el PlaceHolder:PlaceHolderPageTitleInTitleArea  al abrir el master page se le dice a que visible = false

<asp:ContentPlaceHolder id=”PlaceHolderPageTitleInTitleArea” runat=”server” Visible=”false” />

Esto ya no renderiza este molesto código en sharepoint

Se intento bajar el ultimo Cumulative Update de Diciembre 2012 http://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2596957

Pero esto no soluciono el problema

Asi que este place holder quedo con la propiedad visible=”false”, esta solución no me convence del todo así que seguire investigando sobre el tema, cualquier sugerencia con gusto sera recibida.

SHPludos

Reordenar las propiedades de un WebPart January 22, 2013

Posted by juanpablo1manrique in SharePoint.
add a comment

Hola Amigos

Cuando se agregan propiedades personalizadas a un WebPart las mismas quedan de ultimas.

Untitled3

  • Recordemos que al crear un VisualWEbPart siempre se crean 2 archivos WebPartMyClass y UserControlWebPartMyClass.

Estuve investigando un resto como ponerlas en el primer lugar, pero no encontre nada, esta vez san Google no me ayudo, así que toco pedirle ayuda a otro santo, a VS 2010. Me dio por sobreescribir solo a nivel de prueba el metodo, en WebPartMyClass:

public override Microsoft.SharePoint.WebPartPages.ToolPart[] GetToolParts()

Y al mirar por debug las variables en cuestion me encontre con, muy buenas noticias.

Untitled1

El metodo final quedo de la siguiente manera, y ya se ven en el orden que queria

Untitled2

Untitled4

Siempre es bueno probar override de las clases que uno tiene disponibles, haber que encuentra,

saludos

Modificar las propiedades de un WebPart sin usar el control de EditWebPart por defecto de SharePoint January 18, 2013

Posted by juanpablo1manrique in SharePoint, SharePoint Development.
Tags:
add a comment

Hola amigos

En esta oportunidad he tenido el atrevimiento de modificar las propiedades de un webPart desde un boton sin necesidad de utilizar el control de propiedades que trae por defecto SharePoint,

Recordemos que un WebPart esta dividido en 2 clases importantes una para la definición de WebPart que hereda de Microsoft.SharePoint.UI.WebParts.WebPart de ahora en adelante WebPartMyClass y otra que es un User Control ascx; en el caso de los WebPart visuales de ahora en adelante alias UserControlWebPartMyClass,

Para lograr salvar las propiedades de esta manera es necesario construir un metodo publico en WebPartMyClass de la siguiente manera


public void SaveCustomProperties(string val1, string val2)
{
this.Property1 = val1;
this.Property2 = val2;
this.SaveProperties = true;
this.SaveControlState();
}

El código dice más que mil palabras, 🙂

Y desde el evento de boton del ascx (UserControlWebPartMyClass) llamar este metodo que acabamos de construir de la siguiente manera


protected void Button1_Click(object sender, EventArgs e)
{
((WebPartMyClass)this.Parent).SaveCustomProperties(“val1”, “val2”);
}

Aqui el código de las 2 clases

— Clase WebPartMyClass

using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;


namespace xxxx
{
[ToolboxItemAttribute(false)]
public class Processes : WebPart
{
// Visual Studio might automatically update this path when you change the Visual Web Part project item.
private const string _ascxPath = @”~/_CONTROLTEMPLATES/yyyyy/UserControlWebPartMyClass.ascx”;


protected override void CreateChildControls()
{


Control control = Page.LoadControl(_ascxPath);
((UserControlWebPartMyClass)control).Property1 = this.Property1;
((UserControlWebPartMyClass)control).Property2 = this.Property2;
Controls.Add(control);
}


public void SaveCustomProperties(string val1, string val2)
{
this.Property1 = val1;
this.Property2 = val2;
this.SaveProperties = true;
this.SaveControlState();
}


[WebBrowsable(true), WebDisplayName(“Property1”), WebDescription(“Property1”),
Personalizable(PersonalizationScope.Shared), Category(“Custom Property”),
System.ComponentModel.DefaultValue(“”)]
public string Property1{get;set;}


[WebBrowsable(true), WebDisplayName(“Property1”), WebDescription(“Property1”),
Personalizable(PersonalizationScope.Shared), Category(“Custom Property”),
System.ComponentModel.DefaultValue(“”)]
public string Property2{get;set;}


}
}

— UserControlWebPartMyClass —


using System;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint.WebPartPages;


namespace xxxx
{
public partial class ProcessesUserControl : WebPartControl
{


protected void Page_Load(object sender, EventArgs e)
{
}


protected void Button1_Click(object sender, EventArgs e)
{
((WebPartMyClass)this.Parent).SaveCustomProperties(“val1”, “val2”);
}


}
}

Este post fue inspirado por esta duda

http://stackoverflow.com/questions/13654841/set-webpart-custom-properties-without-using-the-edit-web-part-interface

SQL SERVER 2012 Enterprise vs Business Intelligence vs Standard vs Web vs Express with Advanced Services vs Express with Tools vs Express December 10, 2012

Posted by juanpablo1manrique in SharePoint.
1 comment so far

Y en este mundo de las comparaciones …

Connection DirectorYes      Online page and file restoreYes      Online indexingYes      Online schema changeYes      Fast recoveryYes

SQL SERVER 2012 Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Cross-Box Scale Limits
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 Operating System maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting
Services) 1
Operating system maximum Operating system maximum Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 4 Sockets or 16 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores Limited to lesser of 1 Socket or 4 cores
Maximum memory utilized (SQL Server Database Engine) Operating system maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Maximum memory utilized (Analysis Services) Operating system maximum Operating system maximum 64 GB N/A N/A N/A N/A
Maximum memory utilized (Reporting Services) Operating system maximum Operating system maximum 64 GB 64 GB 4 GB N/A N/A
Maximum relational Database size 524 PB 524 PB 524 PB 524 PB 10 GB 10 GB 10 GB
High Availability (AlwaysOn)
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Server Core support1 Yes Yes Yes Yes Yes Yes Yes
Log Shipping Yes Yes Yes Yes
Database mirroring Yes Yes (Safety Full Only) Yes (Safety Full Only) Witness only Witness only Witness only Witness only
Failover Clustering Yes (Node support: Operating system maximum Yes (Node support: 2) Yes (Node support: 2)
Backup compression Yes Yes Yes
Database snapshot Yes
AlwaysOn Availability Groups Yes
SQL Server Multi-Subnet Clustering Yes
Mirrored backups Yes
Hot Add Memory and CPU2 Yes
Database Recovery Advisor Yes Yes Yes Yes Yes Yes Yes
Scalability and Performance
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Multi-instance support 50 50 50 50 50 50 50
Table and index partitioning Yes
Data compression Yes
Resource Governor Yes
Partition Table Parallelism Yes
Multiple Filestream containers Yes
Security
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Basic Auditing Yes Yes Yes Yes Yes Yes Yes
Fine Grained Auditing Yes
Transparent database encryption Yes
Extensible Key Management Yes
User-Defined Roles Yes Yes Yes Yes Yes Yes Yes
Contained Databases Yes Yes Yes Yes Yes Yes Yes
Replication
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server change tracking Yes Yes Yes Yes Yes Yes Yes
Merge replication Yes Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Transactional replication Yes Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Snapshot replication Yes Yes Yes Yes (Subscriber only Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Heterogeneous subscribers Yes Yes Yes
Oracle publishing Yes
Peer to Peer transactional replication Yes
Management Tools
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Management Objects (SMO) Yes Yes Yes Yes Yes Yes Yes
SQL Configuration Manager Yes Yes Yes Yes Yes Yes Yes
SQL CMD (Command Prompt tool) Yes Yes Yes Yes Yes Yes Yes
SQL Server Management Studio Yes Yes Yes Yes Yes Yes
Distributed Replay – Admin Tool Yes Yes Yes Yes Yes Yes
Distributed Replay – Client Yes Yes Yes Yes
Distributed Replay – Controller Yes (Enterprise supports up to 16 clients, Developer supports only 1 client) Yes (1 client support only) Yes (1 client support only) Yes (1 client support only)
SQL Profiler Yes Yes Yes No2 No2 No2 No2
SQL Server Agent Yes Yes Yes Yes
Microsoft System Center Operations Manager Management Pack Yes Yes Yes Yes
Database Tuning Advisor (DTA) Yes Yes Yes3 Yes3
RDBMS Manageability
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
User Instances Yes Yes Yes
LocalDB Yes Yes
Dedicated admin connection Yes Yes Yes Yes Yes (under trace flag) Yes (under trace flag) Yes (under trace flag)
PowerShell scripting support Yes Yes Yes Yes Yes Yes Yes
SysPrep support1 Yes Yes Yes Yes Yes Yes Yes
Support for Data-tier application component operations – extract, deploy, upgrade,
delete
Yes Yes Yes Yes Yes Yes Yes
Policy automation (check on schedule and change) Yes Yes Yes Yes
Performance data collector Yes Yes Yes Yes
Able to enroll as a managed instance in a multi-instance management Yes Yes Yes Yes
Standard performance reports Yes Yes Yes Yes
Plan guides and plan freezing for plan guides Yes Yes Yes Yes
Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes
Automatic indexed view maintenance Yes Yes Yes Yes
Distributed partitioned views Yes Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable
Parallel indexed operations Yes
Automatic use of indexed view by query optimizer Yes
Parallel consistency check Yes
SQL Server Utility control point Yes
Contained Databases Yes Yes Yes Yes Yes Yes Yes
Development Tools
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Microsoft Visual Studio Integration Yes Yes Yes Yes Yes Yes Yes
SQL Server Developer Studio Yes Yes Yes Yes Yes Yes Yes
Intellisense (Transact-SQL and MDX) 1 Yes Yes Yes Yes Yes Yes Yes
SQL Server Data Tools (SSDT) Yes Yes Yes Yes Yes
SQL query edit and design tools1 Yes Yes Yes
Version control support1 Yes Yes Yes
MDX edit, debug, and design tools1 Yes Yes Yes
Programmability
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes Yes Yes
Native XML support Yes Yes Yes Yes Yes Yes Yes
XML indexing Yes Yes Yes Yes Yes Yes Yes
MERGE & UPSERT Capabilities Yes Yes Yes Yes Yes Yes Yes
FILESTREAM support Yes Yes Yes Yes Yes Yes Yes
FileTable Yes Yes Yes Yes Yes Yes Yes
Date and Time datatypes Yes Yes Yes Yes Yes Yes Yes
Internationalization support Yes Yes Yes Yes Yes Yes Yes
Full-text and semantic search Yes Yes Yes Yes Yes
Specification of language in query Yes Yes Yes Yes Yes
Service Broker (messaging) Yes Yes Yes No (Client only) No (Client only) No (Client only) No (Client only)
Web services (HTTP/SOAP endpoints) Yes Yes Yes Yes
TSQL endpoints Yes Yes Yes Yes
Integration Services
Feature
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server Import and Export Wizard Yes Yes Yes Yes Yes Yes Yes
Built-in data source connectors Yes Yes Yes Yes Yes Yes Yes
SSIS designer and runtime Yes Yes Yes
Basic Transforms Yes Yes Yes
Basic data profiling tools Yes Yes Yes
Change Data Capture Service for Oracle by Attunity Yes
Change Data Capture Designer for Oracle by Attunity Yes
Integration Services – Advanced Adapters
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
High performance Oracle destination Yes
High performance Teradata destination Yes
SAP BW source and destination Yes
Data mining model training destination adapter Yes
Dimension processing destination adapter Yes
Partition processing destination adapter Yes
Change Data Capture components by Attunity Yes
Connector for Open Database Connectivity (ODBC) by Attunity Yes
Integration Services – Advanced Transforms
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Persistent (high performance) lookups Yes
Data mining query transformation Yes
Fuzzy grouping and lookup transformations Yes
Term extractions and lookup transformations Yes
Master Data Services
Feature
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Master Data Services database Yes Yes
Master Data Manager web application Yes Yes
Data Warehouse
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Create cubes without a database Yes Yes Yes
Auto-generate staging and data warehouse schema Yes Yes Yes
Change data capture Yes
Star join query optimizations Yes
Scalable read-only Analysis Services configuration Yes
Parallel query processing on partitioned tables and indices Yes
xVelocity memory optimized columnstore indexes Yes
Analysis Services
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Scalable Shared Databases (Attach/Detach, Read only databases) Yes Yes
High Availability Yes Yes Yes
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) Yes Yes Yes
BI Semantic Model (Multidimensional)
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Semi-additive Measures Yes Yes No1
Hierarchies Yes Yes Yes
KPIs Yes Yes Yes
Perspectives Yes Yes
Actions Yes Yes Yes
Account intelligence Yes Yes Yes
Time Intelligence Yes Yes Yes
Custom rollups Yes Yes Yes
Writeback cube Yes Yes Yes
Writeback dimensions Yes Yes
Writeback cells Yes Yes Yes
Drillthrough Yes Yes Yes
Advanced hierarchy types (Parent-Child, Ragged Hiearchies) Yes Yes Yes
Advanced dimensions (Reference dimensions, many-to-many dimensions Yes Yes Yes
Linked measures and dimensions Yes Yes
Translations Yes Yes Yes
Aggregations Yes Yes Yes
Multiple Partitions Yes Yes Yes, up to 3
Proactive Caching Yes Yes
Custom Assemblies (stored procs) Yes Yes Yes
MDX queries and scripts Yes Yes Yes
Role-based security model Yes Yes Yes
Dimension and Cell-level Security Yes Yes Yes
Scalable string storage Yes Yes Yes
MOLAP, ROLAP, HOLAP storage modes Yes Yes Yes
Binary and compressed XML transport Yes Yes Yes
Push-mode processing Yes Yes
Direct Writeback Yes Yes
Measure Expressions Yes Yes
BI Semantic Model (Tabular)
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Hierarchies Yes Yes
KPIs Yes Yes
Semi-additive Measures Yes Yes
Perspectives Yes Yes
Translations Yes Yes
DAX calculations, DAX queries, MDX queries Yes Yes
Row-level Security Yes Yes
Partitions Yes Yes
In-Memory and DirectQuery storage modes (Tabular only) Yes Yes
PowerPivot for SharePoint
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SharePoint farm integration based on shared service architecture Yes Yes
Usage reporting Yes Yes
Health monitoring rules Yes Yes
PowerPivot Gallery Yes Yes
PowerPivot Data Refresh Yes Yes
PowerPivot Data Feeds Yes Yes
Data Mining
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Standard Algorithms Yes Yes Yes
Data Mining Tools (Wizards, Editors Query Builders) Yes Yes Yes
Cross Validation Yes Yes
Models on Filtered Subsets of Mining Structure Data Yes Yes
Time Series: Custom Blending Between ARTXP and ARIMA Methods Yes Yes
Time Series: Prediction with New Data Yes Yes
Unlimited Concurrent DM Queries Yes Yes
Advanced Configuration & Tuning Options for Data Mining Algorithms Yes Yes
Support for plug-in algorithms Yes Yes
Parallel Model Processing Yes Yes
Time Series: Cross-Series Prediction Yes Yes
Unlimited attributes for Association Rules Yes Yes
Sequence Prediction Yes Yes
Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression Yes Yes
Reporting Services Features
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Supported catalog DB SQL Server edition Standard or higher Standard or higher Standard or higher Web Express
Supported data source SQL Server edition All SQL Server editions All SQL Server editions All SQL Server editions Web Express
Report server Yes Yes Yes Yes Yes
Report Designer Yes Yes Yes Yes Yes
Report Manager Yes Yes Yes Yes Yes
Role based security Yes Yes Yes Yes Yes
Word Export and Rich Text Support Yes Yes Yes Yes Yes
Enhanced gauges and charting Yes Yes Yes Yes Yes
Export to Excel, PDF, and Images Yes Yes Yes Yes Yes
Custom authentication Yes Yes Yes Yes Yes
Report as data feeds Yes Yes Yes Yes Yes
Model support Yes Yes Yes Yes
Create custom roles for role-based security Yes Yes Yes
Model Item security Yes Yes Yes
Infinite click through Yes Yes Yes
Shared component library Yes Yes Yes
Email and file share subscriptions and scheduling Yes Yes Yes
Report history, execution snapshots and caching Yes Yes Yes
SharePoint Integration Yes Yes Yes
Remote and non-SQL data source support1 Yes Yes Yes
Data source, delivery and rendering, RDCE extensibility Yes Yes Yes
Data driven report subscription Yes Yes
Scale out deployment (Web farms) Yes Yes
Alerting2 Yes Yes
Power View2 Yes Yes
Reporting Services : Report Server Database Server Edition Requirements
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Use this edition of the Database Engine instance to host the database Standard, Business Intelligence Enterprise, editions (local or remote) Standard, Business Intelligence Enterprise, editions (local or remote) Standard, Enterprise editions (local or remote) Web edition (local only) Express with Advanced Services (local only).
Business Intelligence Clients
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Report Builder Yes Yes Yes
Data Mining Addins for Excel and Visio 2010 Yes Yes Yes
PowerPivot for Excel 2010 Yes Yes
Master Data Services Add-in for Excel Yes Yes
Spatial and Location Services
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Spatial indexes Yes Yes Yes Yes Yes Yes Yes
Planar and Geodetic datatypes Yes Yes Yes Yes Yes Yes Yes
Advanced spatial libraries Yes Yes Yes Yes Yes Yes Yes
Import/export of industry-standard spatial data formats Yes Yes Yes Yes Yes Yes Yes
Additional Database Services
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server Migration Assistant Yes Yes Yes Yes Yes Yes Yes
Database mail Yes Yes Yes Yes
Other Components
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Data Quality Services Yes Yes
StreamInsight StreamInsight Premium Edition StreamInsight Standard Edition StreamInsight Standard Edition StreamInsight Standard Edition
StreamInsight HA StreamInsight Premium Edition

Tomado de http://msdn.microsoft.com/en-us/library/cc645993.aspx

Configuration Wizard SharePoint 2010 vs SharePoint 2013 December 10, 2012

Posted by juanpablo1manrique in SharePoint, SharePoint2013.
Tags:
add a comment

Continuando con las comparaciones

SharePoint 2010 SharePoint 2013

Access Services 2010

Allows viewing, editing, and interacting with Access Services 2010 databases in
a browser.

X

Access Services

Allows viewing, editing, and interacting with Access Services databases in a browser.

X X

Application Registry Service

Backwards compatible Business Data Connectivity API.

X

App Management Service

Allows you to add SharePoint Apps from the SharePoint Store or the App Catalog.

X

Business Data Connectivity Service

Enabling this service provides the SharePoint farm with the ability to upload BDC
models that describe the interfaces of your enterprises’ line of business systems
and thereby access the data within these systems.

X X

Excel Services Application

Allows viewing and interactivity with Excel files in a browser.

X X

Lotus Notes Connector

Search connector to crawl the data in the Lotus Notes server.

X X

Machine Translation Service

Performs automated machine translation.

X

Managed Metadata Service

This service provides access to managed taxonomy hierarchies, keywords and social
tagging infrastructure as well as Content Type publishing across site collections.

X X

PerformancePoint Service Application

Supports the monitoring and analytic capabilities of PerformancePoint Services such
as the storage and publication of dashboards and related content.

X X

PowerPoint Conversion Service Application

Enables the conversion of PowerPoint presentations to various formats.

X

Search Service Application

Index content and serve search queries.

X X

Secure Store Service

Provides capability to store data (e.g. credential set) securely and associate it
to a specific identity or group of identities.

X X

State Service

Provides temporary storage of user session data for SharePoint Server components.

X X

Usage and Health data collection

This service collects farm wide usage and health data and provides the ability to
view various usage and health reports.

X X

User Profile Service Application

Adds support for My Sites, Profiles pages, Social Tagging and other social computing
features. Some of the features offered by this service require Search Service Application
and Managed Metadata Services to be provisioned.

X X

Visio Graphics Service

Enables viewing and refreshing of Visio Web Drawings.

X X

Web Analytics Service Application

Web Analytics Service Application

X

Word Automation Services

Provides a framework for performing automated document conversions.

X X

Work Management Service Application

This service provides task aggregation across work management systems.

X

Workflow Service Application

This service connects SharePoint to an external workflow service

X