Skip to content

Instantly share code, notes, and snippets.

View silverl's full-sized avatar

Larry Silverman silverl

View GitHub Profile
@silverl
silverl / Boxstarter-DevRig.txt
Last active January 30, 2019 22:06
Boxstarter Basic Windows Workstation
Set-WindowsExplorerOptions -EnableShowHiddenFilesFoldersDrives -EnableShowProtectedOSFiles -EnableShowFileExtension -EnableOpenFileExplorerToQuickAccess -EnableShowRecentFilesInQuickAccess -EnableShowFrequentFoldersInQuickAccess
Install-WindowsUpdate -acceptEula
Update-ExecutionPolicy RemoteSigned
Enable-MicrosoftUpdate
Enable-RemoteDesktop
Disable-InternetExplorerESC
Disable-GameBarTips
Disable-BingSearch
choco install visualstudio2017professional --package-parameters "--allWorkloads --includeRecommended --includeOptional --passive --locale en-US"
cinst 7zip
@silverl
silverl / SQLServerIndexMaintenance.ps1
Created December 28, 2016 15:32
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
if [type] == "apache-access" or [type] == "apache-error" {
geoip {
source => "clientip"
database => "/opt/logstash/vendor/geoip/GeoLiteCity.dat"
}
if [agent] != "-" {
useragent {
source => "agent"
target => "ua"
add_tag => [ "UA" ]