USE [master]
GO
ALTER DATABASE DBNAME SET RECOVERY SIMPLE WITH NO_WAIT
GO
ALTER DATABASE DBNAME SET RECOVERY SIMPLE   -- 设置简单模式
GO
USE DBNAME
GO
DBCC SHRINKFILE (N'DBNAME_log' , 2, TRUNCATEONLY)  -- 设置压缩后的日志大小为 2M
GO

<!-- web.config -->

<configuration>
  <system.webServer>
  
    <rewrite>
      <rules>
        <rule name="RewriteHTML">
          <match url="(.*)" />
          <conditions logicalGrouping="MatchAll">

# 示例：netsh wlan set hostednetwork mode=allow ssid=SSID名称 key=WIFI密码
netsh wlan set hostednetwork mode=allow ssid=NB key=notebook

# 开启
netsh wlan start hostednetwork

# 关闭
netsh wlan stop hostednetwork

docker search portainer # 搜索包
docker pull portainer/portainer # 下载镜像
# 本机部署
docker run -d -p 90:9000 --restart=always -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data --name prtainer-test portainer/portainer
# 汉化部署（须下载汉化包）
docker run -d -p 90:9000 --restart=always  -v /var/run/docker.sock:/var/run/docker.sock -v portainer_data:/data -v /package/portainer_cn:/public --name prtainer-test  portainer/portainer
# 访问 ip:90，初始化账号、密码，选择 Local --> Connect

# help
https://www.cnblogs.com/Bug-Hunter/p/12023130.html

yum install package1            # 安装指定的安装包package1
yum groupinsall group1          # 安装程序组group1

yum update                      # 全部更新
yum update package1             # 更新指定程序包package1
yum check-update                # 检查可更新的程序
yum upgrade package1            # 升级指定程序包package1
yum groupupdate group1          # 升级程序组group1

yum info package1               # 显示安装包信息package1

npm login   # 登录
npm init    # 初始化 package.json 包的信息
npm publish # 发布

# 设置淘宝镜像
npm config set registry https://registry.npm.taobao.org

# 清除淘宝镜像，恢复
npm config set registry https://registry.npmjs.org

npm install -g npm-check-updates    # 安装 npm-check-updates

ncu --loglevel verbose --packageFile package.json   # 查看

ncu -u --packageFile package.json   # 更新配置

npm install # 删除node_modules目录，重新下载依赖

# help
https://github.com/raineorshine/npm-check-updates/issues/136

-- 查看表空间物理文件的名称及大小
SELECT tablespace_name,
       file_id,
       file_name,
       round(bytes / (1024 * 1024), 0) total_space
  FROM dba_data_files
 ORDER BY tablespace_name;
 
-- 查询所有用户所对应的表空间，有dba权限的帐号，如sys,system
select username, default_tablespace from dba_users;

var ssu = {
    init: function () {
        var txt = window.getSelection().toString();
        ssu.speech(txt);
    },
    speech: function (txt) {
        if (!txt || txt.trim() == "") {
            txt = "未选择文字";
        }
        var ws = new window.SpeechSynthesisUtterance(txt);