This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
rem http://www.shrew.net/ | |
"C:\Program Files\ShrewSoft\VPN Client\ipsecc.exe" -r "VPN Profile Name" -u "Username" -p "Password" -a |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
declare @SpaceUsed table (TableName sysname, NumRows bigint, ReservedSpace varchar(50), DataSpace varchar(50), IndexSize varchar(50), UnusedSpace varchar(50)) | |
declare @str varchar(500) | |
set @str = 'exec sp_spaceused ''?''' | |
insert into @SpaceUsed | |
exec sp_msforeachtable @command1=@str | |
select TableName, | |
FORMAT(CAST(NumRows as bigint), 'N0') as NumRows, | |
FORMAT(CAST(REPLACE(ReservedSpace, ' KB', '') as bigint), 'N0') + ' KB' as ReservedSpace, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
aws ec2 describe-network-interfaces --filters "Name=subnet-id,Values=[subnet-id]" --query "NetworkInterfaces[*].[PrivateIpAddress,Description]" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Find-Package -AllVersions -AllowPrereleaseVersions -Source "<Source URL>" | Install-Package -Destination "C:\tmp" -SkipDependencies |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
REM Package folder named .\1001\ in to zip file, use the * at the end to keep from creating a base folder in the zip file. | |
"C:\Program Files\7-Zip\7z.exe" a -tzip 1001.zip .\1001\* | |
REM Build single zip file for each folder in current directory. | |
for /D %d in (*) do "C:\Program Files\7-Zip\7z.exe" a "%d.zip" ".\%d\*" | |
REM Build single zip file for each folder in current directory and keep folder in root. | |
for /D %d in (*) do "C:\Program Files\7-Zip\7z.exe" a "%d.zip" ".\%d\" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select distinct name | |
from sysobjects o | |
inner join syscomments c on o.id = c.id | |
where text like '%search%' |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Get-ChildItem -File | Where-Object { $_.Name.Contains("-") } | Rename-Item -NewName { $_.Name -replace "-","." } |
NewerOlder