Skip to content

Instantly share code, notes, and snippets.

View ettingshausen's full-sized avatar

ettingshausen ettingshausen

16 followers · 137 following
View GitHub Profile
@ettingshausen
ettingshausen / Keybase.md
Created December 9, 2017 17:57

Keybase proof

I hereby claim:

  • I am ettingshausen on github.
  • I am nipkow (https://keybase.io/nipkow) on keybase.
  • I have a public key ASDS_InRSBd8f7p97awgTgsx9K9bOHXIh7MJUiD-4AfF4go

To claim this, I am signing this object:

@ettingshausen
ettingshausen / del-overlays.cmd
Last active January 20, 2018 18:21
delete overlay folder in each module in Java web project
:: Name: del-overlays.cmd
:: Purpose: delete overlay folder in each module
:: Author: ettingshausen
:: Revision: 2017/12/19 - initial version
::
@ECHO OFF
SET parent=%~dp0
FOR /D %%I IN (%parent%*) DO RD /S /Q %%I\overlays
EXIT /B 0
@ettingshausen
ettingshausen / sql_auto_bak.cmd
Last active July 12, 2021 04:06
backup database for SQL Server via sqlcmd
:: Name: sql_auto_bak.cmd
:: Purpose: backup database for SQL Server via sqlcmd
:: Author: ettingshausen
:: Revision: 2018/1/24 - initial version
::
@ECHO OFF
SETLOCAL ENABLEEXTENSIONS
SET parent=%~dp0
SET interactive=0
@ettingshausen
ettingshausen / add-jquery.js
Created February 9, 2018 09:58
add jQuery support for site
var script = document.createElement('script');
script.setAttribute('src', 'https://cdn.bootcss.com/jquery/3.3.1/jquery.min.js');
document.body.appendChild(script);
@ettingshausen
ettingshausen / sql_execute.cmd
Last active May 19, 2022 18:04
execute sql script via sqlcmd
:: Name: sql_execute.cmd
:: Purpose: execute script.sql via sqlcmd
:: Author: ettingshausen
:: Revision: 2018/3/1 - initial version
::
@ECHO OFF
SETLOCAL ENABLEEXTENSIONS
SET parent=%~dp0
SET interactive=0
@ettingshausen
ettingshausen / linked_server.sql
Created April 12, 2018 08:53
How To Create a SQL Server Linked Server
EXEC sp_addlinkedserver
@server='DBMES', --链接服务器别名
@srvproduct='', -- 如果是SQL Server 可以不用指定@srvproduct
@provider='SQLOLEDB',
@datasrc='172.16.0.91' --要访问的的数据库所在的服务器的ip
GO
EXEC sp_addlinkedsrvlogin
@rmtsrvname = 'DBMES', --链接服务器别名
@useself = 'false', --是否使用当前账号登录
@locallogin = NULL,
@ettingshausen
ettingshausen / resize.cmd
Last active July 6, 2018 07:51 — forked from Starefossen/gist:319f36ff30694a775806
Resize VirtualBox .vmdk disk
:: Clone the .vmdk image to a .vdi.
vboxmanage clonehd "virtualdisk.vmdk" "new-virtualdisk.vdi" --format vdi
:: Resize the new .vdi image (30720 == 30 GB).
vboxmanage modifyhd "new-virtualdisk.vdi" --resize 30720
:: Optional; switch back to a .vmdk.
VBoxManage clonehd "cloned.vdi" "resized.vmdk" --format vmdk
@ettingshausen
ettingshausen / export_import_docker_image.sh
Last active September 5, 2018 05:33
export and import docker image
#export image
docker save raymondwong/idcardocr -o idcardocr.tar
#import image
docker load -i idcardocr.tar
@ettingshausen
ettingshausen / Dockerfile
Created September 6, 2018 03:30
Docker say Hello
FROM alpine
ENV user=ettingshausen
ENTRYPOINT [ "sh", "-c", "echo Hello $user !" ]
# build
# docker build -t docker-greet .
# run without env
# docker run -it --rm docker-greet
@ettingshausen
ettingshausen / OpenCmdHere.reg
Created November 20, 2018 11:49
add cmd in right click menu
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Directory\shell\OpenCmdHere]
@="在此处打开命令提示符"
"Icon"="cmd.exe"
[HKEY_CLASSES_ROOT\Directory\shell\OpenCmdHere\command]
@="cmd.exe /s /k pushd "%V""
[HKEY_CLASSES_ROOT\Directory\Background\shell\OpenCmdHere]