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
echo Start code coverage | |
cd %2 | |
IF EXIST .\TestResult.xml ( | |
del .\TestResult.xml | |
) | |
IF NOT EXIST .\CoverageReport ( | |
md .\CoverageReport |
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
delete => HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power\ModernSleep\EnabledActions | |
set CsEnabled to zero => HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Power |
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
net stop docker | |
net stop com.docker.service | |
taskkill /IM "dockerd.exe" /F | |
taskkill /IM "Docker for Windows.exe" /F | |
net start docker | |
net start com.docker.service | |
start "" "c:\program files\docker\docker\Docker for Windows.exe" |
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
#it in docker | |
docker exec -it 980733335feb /bin/bash | |
#create dump | |
PGSSLMODE=allow | |
pg_dump -h xx.postgres.azure.com -p 5432 --username user@xx --table table --dbname db_name --file ./file.sql | |
#restore dump | |
psql -U username -d database_name -1 -f ./file.sql |
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
USE [master]; | |
DECLARE @kill varchar(8000) = ''; | |
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';' | |
FROM sys.dm_exec_sessions | |
WHERE database_id = db_id('ifrs17_database') | |
EXEC(@kill); | |
drop database ifrs17_database; |
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 pg_terminate_backend(pg_stat_activity.pid) | |
FROM pg_stat_activity | |
WHERE pg_stat_activity.datname = 'database' | |
AND pid <> pg_backend_pid(); | |
drop database database; | |
create database database; |
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
docker ps --format {{.ID}}\t{{.Names}} |