[Product Review]: SQLDocKit de Acceleratio!

En esta ocasión os comparto la review del último producto liberado por Acceleratio: el SQLDocKit que viene a ser para SQL Server lo que el SharePoint Documentation Toolkit es para SharePoint Sonrisa. + Info: https://www.sqldockit.com/

  • Una vez instalado el SQLDocKit (la instalación es realmente rápida), lo primero que tenemos que hacer es proceder a configurarlo creando inicialmente la Base de Datos (BD) que necesita para recoger la info. relativa a los servidores de BD y las BDs que se analicen.
  • En el caso de que tengamos una licencia de Consultor, no podremos configurar la sección de Service Settings (+ Info: https://www.sqldockit.com/support/help/activation/licensing-faqs/#panel-14) necesaria para hacer uso de las capacidades avanzadas del SQLDocKit.
  • A continuación, el proceso de configuración procede a crear la BD necesaria para el SQLDocKit. Si todo va bien, se muestra una pantalla indicando que podemos proceder a ejecutar la herramienta.

image

image

  • La pantalla de inicio del SQLDocKit es similar a la del SharePoint Documetation Toolkit en cuanto a que de inicio muestra una serie de opciones disponibles como Take Snapshot, View Snaptshots, etc. Vamos a analizar cada una de estas opciones para conocer sus posibilidades.
  • Por ejemplo, el Live Explorer nos da información rápida al servidor actual en lo que a configuraciones de BD se refiere como pueden ser configuraciones avanzadas, logins disponibles o bien información detallada de las BDs disponibles en el servidor.

image

image

  • Para las BDs del servidor podremos ver en un simple vistazo información como el espacio en disco, el nivel de compatibilidad o el Recovery Model.
  • La sección informes da una serie de informes rápidos con info. como el uso de disco de las BDs, BDs huérfanas, etc. Para que los informes muestren información es necesario que se hagan tres snapshopts en días diferentes. Una vez hechos, los informes están operativos y muestra información de una forma muy visual como podéis ver por ejemplo en el informe

image

image
  • Lo mismo sucede con la sección de Best Practices que cuenta con un Dashboard de inicio mostrando si el servidor de BD está configurado de forma correcta en distintos aspectos como HW disponible, configuraciones de las BDs ModelDB y TempDB, etc. En ese Dashboard se muestran tanto las configuraciones / parámetros con error como los que son correctos.
  • Por ejemplo, para el parámetro de Database Autogrowth de las BDs se muestra un informe tipo tabla en el que podremos ver todas las BDs del servidor y cuáles no siguen las buenas prácticas en lo que a configuración de este parámetro se refiere tanto para los archivos de datos como para los de LOG.

image

image

  • La opción de SQL Inventory nos proporciona información de “inventario” relativa a los servidores de BD’s y las BDs que estamos documentando con el SQLDocKit.
  • Por ejemplo, con esta opción podemos obtener la configuración avanzada de uno de los servidores de BD.

image

image

  • Por supuesto, el SQLDocKit permite en todo momento que exportemos la información en distintos formatos y que generemos un informe completo de los servidores SQL Server que se están analizando. Por ejemplo, esta es la apariencia del informe generado en la granja de pruebas de SharePoint 2013.

image

Como decía al inicio, el SQLDocKit viene a ser para SQL Server lo que el SharePoint Documentation Toolkit es para SharePoint. En mi opinión es una herramienta interesante para hacer una auditoría rápida de servidores SQL Server y detectar problemas y malas prácticas en la configuración de los mismos.

[Herramientas]: PowerShell Script Analyzer!

En esta ocasión, y gracias a este post de Tahir Naveed, os comparto una utilidad pensada para asegurar la calidad de nuestros scripts PowerShell: El PowerShell Script Analyzer. Se trata de una herramienta creada por el equipo de PowerShell de Microsoft y de la comunidad que tenéis disponible en el siguiente enlace: https://github.com/PowerShell/PSScriptAnalyzer

image

El detalle del PowerShell Script Analyzer lo podéis encontrar en la página del proyecto en GitHub:

PSScriptAnalyzer is a static code checker for Windows PowerShell modules and scripts. PSScriptAnalyzer checks the quality of Windows PowerShell code by running a set of rules. The rules are based on PowerShell best practices identified by PowerShell Team and the community. It generates DiagnosticResults (errors and warnings) to inform users about potential code defects and suggests possible solutions for improvements.

PSScriptAnalyzer is shipped with a collection of built-in rules that checks various aspects of PowerShell code such as presence of uninitialized variables, usage of PSCredential Type, usage of Invoke-Expression etc. Additional functionalities such as exclude/include specific rules are also supported.

[Tools]: Url Decoder/Encoder!

This time I would like to introduce you a really simple and useful tool you can use to decode / encode web URLs. You can find this tool in the following URL: http://meyerweb.com/eric/tools/dencoder/. For instance, as an example of how to use, just paste in the URL Decoder/Encode area the URL you want to decode/decode. In my case, I have pasted the URL of a SharePoint Add-in (A Provider-Hosted one)

image

If you click the “Decode” button, you will get a Clean URL and for instance the value of some SharePoint Add-in parameters such as  SPHostUrl, SPLanguage, etc.

image

[Herramientas]: Url Decoder/Encoder!

En esta ocasión os comparto una utilidad que os servirá tanto para codificar URLs como para hacer la operación inversa. En concreto, se trata de la utilidad que podéis encontrar en la siguiente URL: http://meyerweb.com/eric/tools/dencoder/. Si por ejemplo pegáis la URL de un Add-in de SharePoint Online (SPO):

image

El resultado de hacer clic en “Decode” nos permite obtener la URL “limpia” del Add-in y acceder por ejemplo a los valores de parámetros como SPHostUrl, SPLanguage, etc.

image

[Herramientas]: Microsoft Virtual Machine Converter 3.0!

En esa ocasión os comparto una herramienta que seguro que a más de uno le será de utilidad. Se trata de Microsoft Virtual Machine Converter 3.0 que como su nombre indica, permite convertir máquinas virtuales o discos a Microsoft Hyper-V, en particular permite convertir máquinas virtuales VMWare a Hyper-V. Os dejo un par de enlaces de interés respecto a esta herramienta:

[Recursos]: Herramientas y Recursos de formación gratuitos con Visual Studio Dev Essentials!

Entre las novedades que hemos tenido de Microsoft últimamente, se encuentra el acceso a herramientas de desarrollo y recursos de formación gratuitos y disponibles a través del programa Visual Studio Dev Essentials.

image

Entre los beneficios encontraremos:

  • Acceso a los entornos de desarrollo gratuitos de Microsoft: Visual Studio Community, Visual Studio Code, Visual Studio Espress y Team Foundation Express.
  • Acceso a los siguientes recursos de formación:
    • Pluralsight  (6-month subscription)—limited time only**
    • Xamarin University mobile training*— coming soon
    • WintellectNOW  (3-month subscription)*
    • Microsoft Virtual Academy
    • HackHands Live Programming Help  ($25 credit)*
    • Priority Forum Support*
  • Acceso a los siguientes servicios Cloud:
    • Azure credit  ($25/month for 12 months)*—coming soon
    • Visual Studio Team Services account with five users*
    • App Service free tier
    • PowerBI free tier
    • HockeyApp free tier
    • Application Insights free tier
  • Y finalmente, para los que trabajan con MAC:
    • Parallels Desktop® for Mac Pro Edition
      (3-month subscription)*
    • Parallels® Access  (3-month subscription)*
    • Windows Platform VM (60 days) —coming soon
    • Office Online Apps

image

[Product Review]: LepideMigrator for Documents!

This time I’m sharing the review of LepideMigrator for Documents, a really complete and unexpensive migration tool to move documents in OnPremises and Cloud migrrations.LepideMigrator for documents provide is a really simple and effective tool that allows to migrate present public folders, on-premise file servers, or any existing data source, to OneDrive or Office 365 along with providing complete SharePoint to SharePoint migration which enable users to migrate a site/central admin, list/library, and items from a SharePoint to another SharePoint.

Disclaimer

Product review of LepideMigrator for Documents represents my own personal opinion. My only motive is to provide an unbiased and precise view of the product for the benefit of the community. This review represents my personal experience of using the trial version of LepideMigrator for Documents and is not prejudiced by the owner of the software.

Supported Platforms

LepideMigrator for Documents support the following versions of SharePoint Servers:

  • SharePoint Server 2010
  • SharePoint Foundation 2010
  • SharePoint Foundation 2013
  • SharePoint Server 2013
  • Office 365 (SharePoint Online)

It also supports the following versions of Exchange Servers:

  • Exchange Server 2000
  • Exchange Server 2003
  • Exchange Server 2007
  • Exchange Server 2010
  • Exchange Server 2013
  • Office 365

Various Outlook versions supported by LMD are:

  • Outlook 2003
  • Outlook 2007
  • Outlook 2010
  • Outlook 2013

This review has been completed using the trial version 15.1 of LepideMigrator for Documents. There is a trial version of the software that is available for 30 days, but only with some limited functionalities, you can upload/download a maximum five files per session.  For this review I have used an OnPremises installation of SharePoint 2010 as source of the information to be moved to SharePoint Online in Office 365.

Moving documents from SP 2010 to SP Online with LepideMigrator for Documents

The steps required to use LepideMigrator for Documents are the following ones:

  • Install the software after downloading the installer file from Lepide’s website. You simply have to right click on the document and then you start the Migration Wizard. The download will take some time but the installation process is quite simple and fast. Its user-friendly interface makes it really easy to use. After installing the software you’ll get the welcome screen as shown below:

image

  • LMD provides an easy way to add a site of a SharePoint Sever in the software as the destination. Other than adding, it also provides a way to edit or delete the already present SharePoint sites in the destination. Likewise you can also add SharePoint site as a source and execute edition and deletion of already existing files in the source. After adding a new site in SharePoint On-premises as the source and SharePoint Online as the destination, enter SharePoint details such as “Central Admin URL”, “User Name”, and “Password”.

image

image

Content migration from SharePoint On-premises to SharePoint Online

This tool has really streamlined the process of content migration from one SharePoint On-premises to SharePoint Online or to a different site/library/list/item of the same SharePoint server. It asks you to add the content which you want to migrate as per your requirement. This tool allows to migrate all document libraries, list contents, metadata, content types, workflows, InfoPath form, columns, views, web parts, SharePoint designer objects, contents, and items together from source to destination SharePoint sites. Moreover, it also allows you to migrate permissions or remap users/group as per your requirements as shown in the figure. The speed of the migration was amazing, it took only about 5 minutes to migrate sites from SharePoint On-premises to SharePoint Online.

  • Before initiating the migration process you have to add the SharePoint objects (List, Library/List or Item) which has to be migrated.
  • After adding site, it also provides you options to select whether you want to migrate data as an existing site or as a new site.

image

image

  • Many copy options are available to simplify the site migration from SharePoint On-premises to SharePoint Online.
  • In order to migrate library/list, select this option from the source. Now the next step is to select the List/Library options from the following wizard.

image

image

  • Now, the next step is to select the Copy options for Lists/Libraries.
  • Select the Item migration option from the source and then select item that needs to be migrated.
image

 

image

  • Next step is to select destination.
  • LMD allows also you to schedule direct SharePoint On-premises to SharePoint Online Migration, Migration using CSV, and Copy and Paste Migration jobs. This tool has precisely followed the scheduling date and time specified by me, without any delay. It restarted the scheduling job from where it had stopped on the next schedule. You can either execute the migration job immediately or schedule it for later as shown in the figure.

image

image

  • You can schedule the migration jobs as per your requirements. The schedule will be created by default, but you can easily change it accordingly. The starting and ending time provided here is indeed a plus.

image

image

Other LepideMigrator features

Finally, let me talk about some other great features available  in LMD:

  • SharePoint On-premises to SharePoint Online Migration Using CSV. Before migrating content from SharePoint On-premises to SharePoint Online using CSV, you have to generate a CSV file enclosing the list of contents to be migrated from SharePoint to SharePoint. You can generate CSV for SharePoint site, list/library, and items.  After generating the CSV file for SharePoint, you can use it for performing the migration from SharePoint On-premises to SharePoint Online. Select the desired CSV file from your system that you want to migrate.
  • Copy and Paste. It also provides the feature of copy and paste which allows you to simply copy the content from source SharePoint Server and paste them on the destination SharePoint Server.
  • Migration History. LMD saves the record of all real-time migration jobs, scheduled migration jobs, and downloads from SharePoint. You can view these records using a feature called “History”. With history feature, you can easily know about the things happened in your SharePoint.
image

 

image

Conclusion

The LepideMigrator for Documents (http://www.lepide.com/lepidemigratordocuments/) is a fully clad tool to perform content migration from SharePoint 2010 to SharePoint 2013. This software is a cluster of some great features and is tremendously powerful. It worked really well for me. I encourage any company that is new to SharePoint and wants to migrate their SharePoint content to give it a try.

This software helped me in performing quick migration from SharePoint On-premises to SharePoint Online. You can download the software from http://www.lepide.com/lepidemigratordocuments/download.html.

The trial version of this software is available for 30 days. The Product licensing of Lepide Migrator for Documents is based on the number of Seats/Machine Installation. This software is available in subscription model which you can buy from here: http://www.lepide.com/lepidemigratordocuments/buy.html