sql server备份所有数据库脚本

DECLARE @name VARCHAR(50) -- database name  
DECLARE @path VARCHAR(256) -- path for backup files  
DECLARE @fileName VARCHAR(256) -- filename for backup  
DECLARE @fileDate VARCHAR(20) -- used for file name
 
-- specify database backup directory
SET @path = 'C:\Backup\'  
 
-- specify filename format
SELECT @fileDate = CONVERT(VARCHAR(20),GETDATE(),112) 
 
DECLARE db_cursor CURSOR READ_ONLY FOR  
SELECT name 
FROM master.dbo.sysdatabases 
WHERE name NOT IN ('master','model','msdb','tempdb')  -- exclude these databases
 
OPEN db_cursor   
FETCH NEXT FROM db_cursor INTO @name   
 
WHILE @@FETCH_STATUS = 0   
BEGIN   
   SET @fileName = @path + @name + '_' + @fileDate + '.BAK'  
   BACKUP DATABASE @name TO DISK = @fileName  
 
   FETCH NEXT FROM db_cursor INTO @name   
END   

 
CLOSE db_cursor   
DEALLOCATE db_cursor

 

ida for mac 插件配置 tips

yara:

sudo pip install yara-python,不行下载安装

vim /usr/local/lib/python2.7/site-packages/yara/libyara_wrapper.py

修改308行左右

else:
    #dllpath = os.path.join(sys.prefix, 'lib')
    dllpath = os.path.join("/usr/local/Frameworks/Python.framework/Versions/2.7/", 'lib')
    library = os.path.join(dllpath, 'libyara.so')

默认从系统目录找,系统Frameworks目录不可写,自然找不到so文件

继续阅读ida for mac 插件配置 tips

aliyun高性能计算服务HPC破解密码性能实测

总体评价:屌炸天
对比在线GPU破解阵列:短时间破解无性价比优势,时间超过5小时以后具有性价比优势
以下是实际测试

BenchMark测试:

[root@AliHPC-M40-410 hashcat]# hashcat -b –force
hashcat (v3.20-88-gd36cc4c) starting in benchmark mode…

OpenCL Platform #1: NVIDIA Corporation
======================================
* Device #1: Tesla M40, 2047/11519 MB allocatable, 24MCU
* Device #2: Tesla M40, 2047/11519 MB allocatable, 24MCU

Hashtype: MD4

Speed.Dev.#1…..: 26644.2 MH/s (60.42ms)
Speed.Dev.#2…..: 26506.5 MH/s (60.74ms)
Speed.Dev.#*…..: 53150.6 MH/s

Hashtype: MD5

Speed.Dev.#1…..: 13648.3 MH/s (58.98ms)
Speed.Dev.#2…..: 13537.3 MH/s (59.46ms)
Speed.Dev.#*…..: 27185.6 MH/s
继续阅读aliyun高性能计算服务HPC破解密码性能实测