Skip to content

Instantly share code, notes, and snippets.

View analyzethat's full-sized avatar

Johan van den Brink analyzethat

View GitHub Profile
analyzethat / SQLServerIndexMaintenance.ps1
Created February 21, 2018 09:43 — forked from silverl/SQLServerIndexMaintenance.ps1
Reworked version of Pieter Vanhove's Azure SQL Database reindexing Azure Automation Runbook
Perform index maintenance
This runbook uses Azure Automation to perform reindexing and statistics maintenance of all databases on a target server.
As prerequisite, please create an Azure Automation credential asset that contains the username and password for the target Azure SQL DB logical server ($SqlServerName).
Make sure that you have installed the scripts IndexOptimize.sql and CommandExecute.sql of Ola Hallengren (
Make sure to get Ola's modified scripts which work on Azure here:
analyzethat /
Created September 28, 2017 17:10 — forked from stephlocke/
Preparing for Operationalising R

Sign up

Azure config

  • [If you have plenty of Azure credit] Create an Azure SQL DB Premium or PRemium RS in West Central US <- These bits are important for getting the preview with R-in-DB
  • Configure Azure ML resources

Program installation links

  • R