sqlsimon’s gists

sqlsimon / splitting_large_files_with_7z

Created May 3, 2018 08:41

	Spliting large files into 1GB chunks for copying.

	Go and get the portable 7za from https://www.7-zip.org/download.html Grab the one labelled
	(7-Zip Extra: standalone console version, 7z DLL, Plugin for Far Manager)

	The following command will use the fastest compression and split into 1GB chunks

	7za a c:\temp\<archive name>.7z c:\temp\<source_files>.* -v1000m -mx1

sqlsimon / camping.txt

Last active August 9, 2017 20:55

Camping Stuff


	Kit wise we have this stuff that we can pool:

	* camping table
	* 4 x stoves
	* 1 x bbq + charcoal, lighters etc (this will double as a firepit for after BBQ)
	* 2 x cooking pots
	* wooden skewers
	* bbq tools
	* small kettle

sqlsimon / postModuleInstall.ps1

Created November 2, 2016 23:19

	$InstallPath = $OctopusParameters["Octopus.Action[Deploy dbatools package].Output.Package.InstallationDirectoryPath"] + "\contents\"

	Write-Host $InstallPath

	Copy-Item -Path $InstallPath -Destination "C:\Program Files\WindowsPowershell\Modules\dbatools" -Recurse -Force

sqlsimon / legacy_sql_sequence_gen.sql

Created March 17, 2016 11:41

	CREATE SCHEMA [common] AUTHORIZATION [dbo]


	CREATE TABLE [common].[sequence_test_id]
	(
	sequence_id bigint identity(1,1)
	,CONSTRAINT [pk_sequence_test_id] PRIMARY KEY (sequence_id)
	)
	GO

sqlsimon / SSISDB_cleardown.sql

Last active October 17, 2019 21:31

sqlsimon / 14DayJobStepRuntimes.sql

Created November 6, 2015 13:36

	USE msdb;

	/*

	Get the runtime of sql agent job and job steps over the last 14 days

	*/

	DECLARE @JobName SYSNAME = '<job name here>'

sqlsimon / RestoreHistory.sql

Created October 23, 2015 20:04

	Use [msdb]
	GO

	create view [dbo].[vwRestoreHistory]
	as
	select
	this_instance_name = @@SERVERNAME
	,source_server_name = left(bs.server_name, 40)
	,database_name = left(bs.database_name, 60)

sqlsimon / BackupHIstory.sql

Last active October 23, 2015 20:04

	USE [msdb]
	GO

	CREATE view [dbo].[vwBackupHistory]
	as

	select
	this_instance_name = @@SERVERNAME
	,source_server_name = left(bs.server_name, 40)
	,database_name = left(bs.database_name, 60)

sqlsimon / tfs2013build.txt

Last active October 21, 2015 21:05

BoxStarter script to build and configure TFS2013 along with SQL Express to host the db

	cinst VisualStudioTeamFoundationServerExpress2013
	cinst MsSqlServer2012Express
	cinst visualstudio2013teamexplorer

	$tfsConfig="$env:ProgramFiles\Microsoft Team Foundation Server 12.0\Tools\TfsConfig.exe"
	.$tfsConfig unattend /configure /type:standard
	.$tfsConfig unattend /configure /type:build `
	/inputs:collectionurl=http://localhost:8080/tfs`;ServiceAccountName="LOCAL SERVICE"`;ServiceAccountPassword="pass"

sqlsimon / Useful Chocolatey Packages.txt

Last active October 21, 2015 21:05

	sqlserver2014express - sql 2014 express with management studio
	sqlserver2012express - sql 2014 express with management studio
	git
	git.install
	visualstudioteamfoundationserverexpress2013
	visualstudioexpress2012tfs
	octopusdeploy.tentacle
	octopusdeploy
	octopustools

Simon sqlsimon