Skip to content

Instantly share code, notes, and snippets.

Avatar

Johan van den Brink analyzethat

View GitHub Profile
@analyzethat
analyzethat / SQLServerIndexMaintenance.ps1
Created Feb 21, 2018 — forked from silverl/SQLServerIndexMaintenance.ps1
Reworked version of Pieter Vanhove's Azure SQL Database reindexing Azure Automation Runbook
View SQLServerIndexMaintenance.ps1
<#
.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 Sep 28, 2017 — forked from stephlocke/Prep.md
Preparing for Operationalising R
View Prep.md

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