Skip to content

Instantly share code, notes, and snippets.

View bvanskiver's full-sized avatar

Bernd VanSkiver bvanskiver

View GitHub Profile
@bvanskiver
bvanskiver / git-helpers.sh
Created June 22, 2022 20:32
# Pull latest on all repos
for d in */; do
cd "$d" && echo "*********** $d ***********" &&
if [ -d .git ]; then
git pull
else
echo "Not a git repository, skipping.";
fi
cd .. && echo
done
@bvanskiver
bvanskiver / aws-subnet-usage.cmd
Created October 21, 2021 17:31
aws ec2 describe-network-interfaces --filters "Name=subnet-id,Values=[subnet-id]" --query "NetworkInterfaces[*].[PrivateIpAddress,Description]"
@bvanskiver
bvanskiver / nuget-export.ps1
Last active May 21, 2021 11:45
Export all NuGet packages from a source
Find-Package -AllVersions -AllowPrereleaseVersions -Source "<Source URL>" | Install-Package -Destination "C:\tmp" -SkipDependencies
@bvanskiver
bvanskiver / git-clean-merged-branches.sh
Last active October 14, 2021 12:01
# Iterate through folders of git repos and show merged branches older than 3 months
for d in */; do
cd "$d" && echo "*********** $d ***********" &&
if [ -d .git ]; then
git fetch --prune --quiet origin &&
for k in $(git branch -r --merged | egrep -v 'HEAD|main|master'); do
if [ -z "$(git log -1 --since='3 months ago' -s $k)" ]; then
echo -e `git show --format="%ci %cr %an" $k | head -n 1` \\t$k;
fi
done | sort -r
@bvanskiver
bvanskiver / search-schema.sql
Created March 14, 2019 16:45
select distinct name
from sysobjects o
inner join syscomments c on o.id = c.id
where text like '%search%'
@bvanskiver
bvanskiver / Replace Filename Dashes with Dots.ps1
Created January 4, 2019 13:28
Get-ChildItem -File | Where-Object { $_.Name.Contains("-") } | Rename-Item -NewName { $_.Name -replace "-","." }
@bvanskiver
bvanskiver / delete-empty-folders.bat
Created July 11, 2018 17:31
robocopy . . /S /MOVE
@bvanskiver
bvanskiver / logparser.cmd
Created April 17, 2018 16:34
logparser.cmd
LogParser.exe -i:IISW3C -o:csv file:C:\Path\To\File.sql -stats:off > C:\Path\To\results.csv
@bvanskiver
bvanskiver / enabled-managed-backup-all-databases.sql
Last active July 24, 2017 22:48
-- Define the variables
declare @databases table (rowid int identity primary key, dbname varchar(500))
declare @rowid int, @dbname varchar(500), @sql varchar(2000)
-- Get the database names from the system function
insert into @databases (dbname)
select db_name
from msdb.smart_admin.fn_backup_db_config (null)
where is_managed_backup_enabled = 0
and is_dropped = 0
@bvanskiver
bvanskiver / progress.sql
Last active December 17, 2023 05:59
select r.session_id as SPID, r.command, r.[status],
FORMAT(r.percent_complete, 'n0') + '%' as percent_complete,
FORMAT(r.start_time, 'MM/dd/yyyy hh:mm:ss tt') as start_time,
FORMAT(r.total_elapsed_time / 3600000 % 60, '00') + ':' + FORMAT(r.total_elapsed_time / 60000 % 60, '00') + ':' + FORMAT(r.total_elapsed_time / 1000 % 60, '00') as elapsed_time,
FORMAT(DATEADD(MILLISECOND, r.estimated_completion_time, GETDATE()), 'MM/dd/yyyy hh:mm:ss tt') as estimated_completion_time,
FORMAT(r.estimated_completion_time / 3600000 % 60, '00') + ':' + FORMAT(r.estimated_completion_time / 60000 % 60, '00') + ':' + FORMAT(r.estimated_completion_time / 1000 % 60, '00') as estimated_time_remaining,
FORMAT((r.total_elapsed_time + r.estimated_completion_time) / 3600000 % 60, '00') + ':' + FORMAT((r.total_elapsed_time + r.estimated_completion_time) / 60000 % 60, '00') + ':' + FORMAT((r.total_elapsed_time + r.estimated_completion_time) / 1000 % 60, '00') as estimated_total_time
from sys.dm