Skip to content

Instantly share code, notes, and snippets.

View analyzethat's full-sized avatar

Johan van den Brink analyzethat

9 followers · 41 following
View GitHub Profile
@analyzethat
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
<#
.SYNOPSIS
Perform index maintenance
.DESCRIPTION
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 (https://ola.hallengren.com/downloads.html)
Make sure to get Ola's modified scripts which work on Azure here: https://ola.hallengren.com/downloads.html
@analyzethat
analyzethat / Prep.md
Created September 28, 2017 17:10 — forked from stephlocke/Prep.md
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