Please find below a collection of Spotfire Server Administration tools and scripts that I have developed for Spotfire Administrators and IT.

You are welcome to use these scripts and modify them to meet your own goals, but please be aware that you use them at your own risk. I am not liable for any damages or loss of data that occur from improper use or modification. It is highly recommended to test these scripts on a development or test environment of Spotfire before deploying to a production environment.

SQL Server update powershell script

SQL Server update powershell script, that upgrades and patches your Microsoft SQL Server to the latest service packs and patches. This ensures your database is optimally stable and patched to provide a stable Spotfire Server environment to your users.

To download and install, please find it in the following document:
SQL Server Update Powershell

Spotfire prerequisite software installer powershell script

A Spotfire Server prerequisite powershell script that installs or updates your Spotfire Server so that prerequisites such as Net Framework and Java Runtime are up-to-date, optimal and stable

User Guide: Spotfire Prerequisite Software Powershell

Download: Spotfire_PrerequisiteSoftware_v0.2.4.zip

Change Log:

Version 0.2.4 - 19 Jan 2023
Java Runtime Environment Update

Modified:

  • Java Runtime Environment 8 Update 361

Version 0.2.3 - 10 Nov 2022
Java Runtime Environment Update

Modified:

  • Java Runtime Environment 8 Update 351

Version 0.2.2 - 21 Oct 2021
Java Runtime Environment Update

Modified:

  • Java Runtime Environment 8 Update 311

Version 0.2.1 - 16 Sept 2021
Java Runtime Environment Update

Modified:

  • Java Runtime Environment 8 Update 301

Version 0.2.0 - 15 Jul 2021
Java Runtime Environment Update

Modified:

  • Java Runtime Environment 8 Update 291

Version 0.1.1 - 21 Jan 2021
Java Runtime Environment 8 Update 281

Modified:

  • Changed to Java Runtime Environment 8 Update 281

Version 0.1.0 - 19 Nov 2020
Migration of installer / update script over to new Azure DevOps instance

Migrated:

  • Powershell 5 for Windows 7
  • Powershell 5 for Windows 8
  • Powershell 5 for Windows 8.1
  • Powershell 5 for Windows Server 2008 R2
  • Powershell 5 for Windows Server 2012
  • Powershell 5 for Windows Server 2012 R2
  • .NET Framework 4.8
  • Java Runtime Environment 8 Update 271

Spotfire Server maintenance stored procedures for Microsoft SQL Server and SQL Server Agent

Various Spotfire database maintenance stored procedures that ensures that the Spotfire Server databases have the optimal settings for better performance, simpler administration and an more enjoyable user experience.

User Guide: Spotfire Server Maintenance Stored Procedures

Download: Spotfire_Maintenance_v0.1.0.zip

Change Log:

Migration of scripts over to new Azure DevOps instance

Server Maintenance

  • Reconfigure the optimise for ad-hoc workloads setting
  • Reconfigure the database memory settings
  • Reconfigure and set the database recovery model to simple
  • Reconfigure the database compatibility level
  • Reconfigure the database backup compression settings
  • Reconfigure the spotfire server database collation (if not already set to the default Latin1_General_CI_AS)
  • Reconfigure the owner of the spotfire server database to a sql login system administrator
  • Ensure that the Spotfire_Server and Spotfire_ActionLog Users are in the db_owner role of their respective databases

Action Log

  • Clear action log from before date limit
  • Clear action log maintenance log from before date limit
  • Clear spotfire server maintenance log from before date limit

Library Maintenance

  • Remove duplicated user / group permissions from library folders
  • Remove disabled users from library folders

User Maintenance

  • Remove licenses for disabled users
  • Remove licenses for inactive users
  • Remove users that have been deleted from the active directory

SQL Server Agent Setup

  • Setup the maintenance procedures into a SQL Server Agent job