Referencias interesantes sobre Excel Services

September 16th, 2008 by ldusolier

Excel Services Technical Overview

http://msdn.microsoft.com/en-us/library/aa972194.aspx

The basics of using Kerberos in a Sharepoint environment.

http://www.windowsecurity.com/articles/Kerberos-Sharepoint-Environment.html

Algunos tutoriales de uso de Excel Services

Setting up the Server – Step 1: Creating a Trusted Location with Excel Services

Setting up the Server – Step 2: Configuring Single Sign-On for Excel Services

Setting up the Server – Step 3: Creating a Trusted Data Connection Library with Excel Services

Building a Report Based on Cube Functions for Excel Web Access

Protecting Workbook Intellectual Property (IP) with View Item Rights

Using OLAP Formulas, Conditional Formatting, and Charts

Building an OLAP PivotTable Report with Excel Services

Building a Relational PivotTable Report with Excel Services

Building a Report with a Chart for Excel Web Access Based on Cube Functions

Creating a Multi-Report Summary Page of Reseller Sales Data

How to configure SharePoint Server 2007 and Excel Services for Kerberos authentication

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

Configuring Kerberos for SharePoint 2007: Part 1 – Base Configuration for SharePoint

http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

Configuring Kerberos for SharePoint 2007: Part 2 – Excel Services and SQL Analysis Services

http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

Referencias interesantes sobre Excel Services

September 16th, 2008 by ldusolier

Excel Services Technical Overview

http://msdn.microsoft.com/en-us/library/aa972194.aspx

The basics of using Kerberos in a Sharepoint environment.

http://www.windowsecurity.com/articles/Kerberos-Sharepoint-Environment.html

Algunos tutoriales de uso de Excel Services

Setting up the Server – Step 1: Creating a Trusted Location with Excel Services

Setting up the Server – Step 2: Configuring Single Sign-On for Excel Services

Setting up the Server – Step 3: Creating a Trusted Data Connection Library with Excel Services

Building a Report Based on Cube Functions for Excel Web Access

Protecting Workbook Intellectual Property (IP) with View Item Rights

Using OLAP Formulas, Conditional Formatting, and Charts

Building an OLAP PivotTable Report with Excel Services

Building a Relational PivotTable Report with Excel Services

Building a Report with a Chart for Excel Web Access Based on Cube Functions

Creating a Multi-Report Summary Page of Reseller Sales Data

How to configure SharePoint Server 2007 and Excel Services for Kerberos authentication

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

Configuring Kerberos for SharePoint 2007: Part 1 – Base Configuration for SharePoint

http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx

Configuring Kerberos for SharePoint 2007: Part 2 – Excel Services and SQL Analysis Services

http://blogs.msdn.com/martinkearn/archive/2007/04/27/configuring-kerberos-for-sharepoint-2007-part-2-excel-services-and-sql-analysis-services.aspx

Social BookMarking, dando el ejemplo…

September 14th, 2008 by ldusolier

Sabes lo que es Social BookMarking?, es una forma de generar redes de conocimiento a travéz de los distintos interesas y necesidades de la gente. Puedes encontrar más información en español aquí o en inglés acá.

Les comparto e invito a ver un video que ayuda a entender esto de una manera muy sencilla. Es parte de la serie de videos de youtube de "…in plain English".

 

Estos puedes ser de distintos rubros, pero enfoquémonos por ahora en las tecnologías de Microsoft.

Los que nos dedicamos a esto conocemos los dos portales dedicados a desarrolladores y a It Pros, es decir http://msdn.microsoft.com y http://technet.microsoft.com

Permitanme compartirles lo que es hacer divulgación tecnológica con el ejemplo…Desde el Blog de Somasegar por demos ver las nuevas iniciativas orientadas al Social Bookmarking.

Les invito a que revisen las siguientes ligas:

MSDN for Developers http://msdnbookmarks.com

TechNet for IT Professionals http://technetbookmarks.com

Expression for Designers http://expressionbookmarks.com

 

Bonus de Recomendación:

Microsoft Communities: http://www.microsoftcommunities.com

The ticker: http://ticker.microsoftcommunities.com/

Social BookMarking, dando el ejemplo…

September 14th, 2008 by ldusolier

Sabes lo que es Social BookMarking?, es una forma de generar redes de conocimiento a travéz de los distintos interesas y necesidades de la gente. Puedes encontrar más información en español aquí o en inglés acá.

Les comparto e invito a ver un video que ayuda a entender esto de una manera muy sencilla. Es parte de la serie de videos de youtube de "…in plain English".

 

Estos puedes ser de distintos rubros, pero enfoquémonos por ahora en las tecnologías de Microsoft.

Los que nos dedicamos a esto conocemos los dos portales dedicados a desarrolladores y a It Pros, es decir http://msdn.microsoft.com y http://technet.microsoft.com

Permitanme compartirles lo que es hacer divulgación tecnológica con el ejemplo…Desde el Blog de Somasegar por demos ver las nuevas iniciativas orientadas al Social Bookmarking.

Les invito a que revisen las siguientes ligas:

MSDN for Developers http://msdnbookmarks.com

TechNet for IT Professionals http://technetbookmarks.com

Expression for Designers http://expressionbookmarks.com

 

Bonus de Recomendación:

Microsoft Communities: http://www.microsoftcommunities.com

The ticker: http://ticker.microsoftcommunities.com/

Cómo obtener mejores prácticas de una implementación de SharePoint 2007

September 3rd, 2008 by ldusolier

Hace tiempo ya existía el System Center Capacity Planner, ahora están disponibles para descargar dos módulos para SharePoint. Un add-in para WSS 3.0 y otro para MOSS 2007, muy interesante.

Ya tienen tiempo pero por ahí me preguntaron sobre donde descargarlas y no recordaba el nombre de les herramientas, entonces aquí están como recordatorio.

Les invito a que los descarguen y evalúen con sus implementaciones.

Announcing New System Center Operations Manager 2007 Packs for WSS 3.0 and MOSS 2007

SharePoint Monitoring Toolkit

This Solution Accelerator provides a set of System Center Ops Manager 2007 Management Packs for Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (including SP1). The Toolkit also includes user documentation for each of the Management Packs.

Overview

The SharePoint Monitoring Toolkit helps you manage Microsoft® SharePoint® environments of all sizes with two new management packs for System Center Operations Manager 2007:

  • Windows® SharePoint Services 3.0 Management Pack
  • Microsoft Office SharePoint Server 2007 Management Pack

These packs monitor the health state of the components in your SharePoint environment that affect performance and availability. When there is an issue that may cause service or performance degradation, Operations Manager 2007 uses the management packs to detect the issue, alert you to its existence, and facilitate diagnosis and corrective actions.
The management packs monitor:

  • Windows SharePoint Services 3.0 related services (Timer, Tracing and Search)
  • Windows SharePoint Services 3.0 related Events
  • Web server applications such as Internet Information Services (IIS)
  • IIS-related Events
  • Microsoft SQL Server® database-related events
  • WSS Server performance

The SharePoint Monitoring Toolkit Management Packs have been rewritten from the ground up to take advantage of the latest features of System Center Operations Manager 2007. Major improvements from previous packs include:

  • Extended rules
  • New and improved reports
  • Additional actions
  • New views
  • Elimination of backward compatibility dependencies
  • Increased reliability
  • Noise reduction through tuning and event suppression
  • Thoroughly tested compatibility of management packs with:
    • System Center Operations Manager 2007
    • System Center Essentials
    • Microsoft Office SharePoint Server 2007 SP1

Have you tried? what do you think?

Lo has probado, que opinas?

Cómo obtener mejores prácticas de una implementación de SharePoint 2007

September 3rd, 2008 by ldusolier

Hace tiempo ya existía el System Center Capacity Planner, ahora están disponibles para descargar dos módulos para SharePoint. Un add-in para WSS 3.0 y otro para MOSS 2007, muy interesante.

Ya tienen tiempo pero por ahí me preguntaron sobre donde descargarlas y no recordaba el nombre de les herramientas, entonces aquí están como recordatorio.

Les invito a que los descarguen y evalúen con sus implementaciones.

Announcing New System Center Operations Manager 2007 Packs for WSS 3.0 and MOSS 2007

SharePoint Monitoring Toolkit

This Solution Accelerator provides a set of System Center Ops Manager 2007 Management Packs for Windows SharePoint Services 3.0 and Microsoft Office SharePoint Server 2007 (including SP1). The Toolkit also includes user documentation for each of the Management Packs.

Overview

The SharePoint Monitoring Toolkit helps you manage Microsoft® SharePoint® environments of all sizes with two new management packs for System Center Operations Manager 2007:

  • Windows® SharePoint Services 3.0 Management Pack
  • Microsoft Office SharePoint Server 2007 Management Pack

These packs monitor the health state of the components in your SharePoint environment that affect performance and availability. When there is an issue that may cause service or performance degradation, Operations Manager 2007 uses the management packs to detect the issue, alert you to its existence, and facilitate diagnosis and corrective actions.
The management packs monitor:

  • Windows SharePoint Services 3.0 related services (Timer, Tracing and Search)
  • Windows SharePoint Services 3.0 related Events
  • Web server applications such as Internet Information Services (IIS)
  • IIS-related Events
  • Microsoft SQL Server® database-related events
  • WSS Server performance

The SharePoint Monitoring Toolkit Management Packs have been rewritten from the ground up to take advantage of the latest features of System Center Operations Manager 2007. Major improvements from previous packs include:

  • Extended rules
  • New and improved reports
  • Additional actions
  • New views
  • Elimination of backward compatibility dependencies
  • Increased reliability
  • Noise reduction through tuning and event suppression
  • Thoroughly tested compatibility of management packs with:
    • System Center Operations Manager 2007
    • System Center Essentials
    • Microsoft Office SharePoint Server 2007 SP1

Have you tried? what do you think?

Lo has probado, que opinas?

Cómo hacer más eficiente la generación de respaldos y su restauración en SharePoint 2007

August 31st, 2008 by ldusolier

Cuando comenzamos a trabajar en planear nuestro DRP (Disaster Recovery Plan) de SharePoint 2007 para considerarlo como parte de nuestro SLA (Service Level Agreement), tenemos que revisar los distintos escenarios, opciones y herramientas disponibles para generar los respaldos de nuestra informaci¢n y su restauraci¢n en un momento necesario.

Ahora, con conocer las distintas opciones que podemos manejar no es suficiente, es importante tambi‚n estar al tanto de cuando una opci¢n de respaldo es mejor que otra.

A continuaci¢n compartimos una tabla que habla de datos puntuales que valen la pena tomar en cuenta.

 

Tool Maximum backup size supported

System Center Data Protection Manager

32-bit systems: 150 data sources

64-bit systems: 300 data sources

For more information, see Data Protection Manager 2007 Frequently Asked Questions (http://go.microsoft.com/fwlink/?LinkId=126629).

SharePoint farm backup and recovery

< 200 GB

VSS Writer

No known limit

SQL Server

Content databases > 200 GB  may require additional management

Stsadm site collection backup and recovery

15 GB

Stsadm import and export

100 GB

SharePoint Designer backup

24 MB

MSIT Site Delete Capture tool

15 GB

Referencia: http://technet.microsoft.com/en-us/library/cc901593.aspx

Cómo hacer más eficiente la generación de respaldos y su restauración en SharePoint 2007

August 31st, 2008 by ldusolier

Cuando comenzamos a trabajar en planear nuestro DRP (Disaster Recovery Plan) de SharePoint 2007 para considerarlo como parte de nuestro SLA (Service Level Agreement), tenemos que revisar los distintos escenarios, opciones y herramientas disponibles para generar los respaldos de nuestra informaci¢n y su restauraci¢n en un momento necesario.

Ahora, con conocer las distintas opciones que podemos manejar no es suficiente, es importante tambi‚n estar al tanto de cuando una opci¢n de respaldo es mejor que otra.

A continuaci¢n compartimos una tabla que habla de datos puntuales que valen la pena tomar en cuenta.

 

Tool Maximum backup size supported

System Center Data Protection Manager

32-bit systems: 150 data sources

64-bit systems: 300 data sources

For more information, see Data Protection Manager 2007 Frequently Asked Questions (http://go.microsoft.com/fwlink/?LinkId=126629).

SharePoint farm backup and recovery

< 200 GB

VSS Writer

No known limit

SQL Server

Content databases > 200 GB  may require additional management

Stsadm site collection backup and recovery

15 GB

Stsadm import and export

100 GB

SharePoint Designer backup

24 MB

MSIT Site Delete Capture tool

15 GB

Referencia: http://technet.microsoft.com/en-us/library/cc901593.aspx

Preparación de respaldos y restauración de una granja (implementación) de SharePoint

August 31st, 2008 by ldusolier

 

Les recomiendo estos tres artículos de TechNet en cuanto a respaldos y recuperación de SharePoint se refiere:

Plan for backup and recovery (Office SharePoint Server) 

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

 

Prepare to back up and restore a farm (Office SharePoint Server 2007)

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

 

Backup, Recovery, and Availability Resource Center for SharePoint Server 2007 (Disaster recovery, data protection, and high availability for SharePoint Server)

http://technet.microsoft.com/en-us/office/sharepointserver/bb736212.aspx

Preparación de respaldos y restauración de una granja (implementación) de SharePoint

August 31st, 2008 by ldusolier

 

Les recomiendo estos tres artículos de TechNet en cuanto a respaldos y recuperación de SharePoint se refiere:

Plan for backup and recovery (Office SharePoint Server) 

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

 

Prepare to back up and restore a farm (Office SharePoint Server 2007)

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

 

Backup, Recovery, and Availability Resource Center for SharePoint Server 2007 (Disaster recovery, data protection, and high availability for SharePoint Server)

http://technet.microsoft.com/en-us/office/sharepointserver/bb736212.aspx