Skip to content

Instantly share code, notes, and snippets.

View sqlsimon's full-sized avatar

Simon sqlsimon

1 follower · 0 following
  • UK
View GitHub Profile
@sqlsimon
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
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
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
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
sqlsimon / SSISDB_cleardown.sql
Last active October 17, 2019 21:31
:setvar SSISDB_NAME "SSISDb"
USE $(SSISDB_NAME)
SET NOCOUNT ON
SET XACT_ABORT ON
BEGIN TRANSACTION
@sqlsimon
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
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
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
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
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