CINXE.COM

<!DOCTYPE html><html munual-autotracker-init="" qct-pv-id="CMjs8tZtGCq-7k_KzSrye" qct-ip="8.222.208.146"><head><meta charSet="UTF-8"/><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/><title>云数据库 SQL Server - 标签 - 腾讯云开发者社区-腾讯云</title><meta name="keywords" content="云数据库 SQL Server,云+社区标签"/><meta name="subjectTime" content="2018-05-11 12:24:43"/><meta name="description" content="正版授权 SQL Server 云数据库"/><meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1, viewport-fit=cover"/><meta name="format-detection" content="telephone=no"/><link rel="canonical" href="https://cloud.tencent.com/developer/tag/10245"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/open_proj/proj_qcloud_v2/gateway/portal/css/global-20209142343.css"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/qcloud/ui/cloud-community/build/base/base-202410111735.css"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/open_proj/proj_qcloud_v2/community-pc/build/AskDialog/AskDialog-202204021635.css?max_age=31536000"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/open_proj/proj_qcloud_v2/community-pc/build/AskDialog/AskDialog-202204021635.css?max_age=31536000"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/qcloud/ui/community-pc/build/base/base-202410211524.css"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/qcloud/ui/cloud-community/build/base/base-202410111735.css"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/open_proj/proj_qcloud_v2/community-pc/build/Tag/Tag-202105140928.css?max_age=31536000"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/open_proj/proj_qcloud_v2/community/portal/css/markdown-201810241044.css?max_age=31536000"/><link rel="stylesheet" href="//cloudcache.tencent-cloud.cn/qcloud/draft-master/dist/draft-master-v2.0.118.d4s2ddo9sb.css?max_age=31536000"/><style media="screen">@supports (padding:max(0px)){.set-safe-area .com-main{bottom:calc(max(12px,constant(safe-area-inset-bottom)) + 50px);bottom:calc(max(12px,env(safe-area-inset-bottom)) + 50px)}.set-safe-area .com-main-simple-sec,.set-safe-area .com-main.without-tab-ft,.set-safe-area .com-main.without-ft{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}.set-safe-area .com-main-sec{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}.set-safe-area .com-m-footer,.set-safe-area .sa-fixed-btns{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}.set-safe-area .com-mobile-body{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}}@supports (padding:max(0px)){.set-safe-area .support-wrap,.set-safe-area div.body{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}.set-safe-area .com-responsive-no-ft div.body{bottom:max(12px,constant(safe-area-inset-bottom));bottom:max(12px,env(safe-area-inset-bottom))}}.doc-con .J-docShareModal{display: none;} .doc-con .J-docShareCopyTipModalMB{display: none} .with-focus+.com-main-simple-sec, .with-focus+.com-main,.with-focus+.com-body,.with-focus+.qa-body{top:100px} .qa-detail-ask-panel:after{display:none!important;} .sa-fixed-btns .c-btn-weak{background-color: #fff;} .qa-r-editor.draft-editor-host.rno-markdown{height: 290px;overflow-y:auto;} .uc-achievement{line-height:24px;margin-bottom:5px;white-space: initial;overflow:visible;text-overflow:initial} .uc-achievement .uc-achievement-icon{top:0;margin-top:0;}</style></head><body style="position:initial"><div id="react-root" class=""><div class="comp-tag-detail"><div class="cdc-header is-fixed"><div class="cdc-header__placeholder"></div><div class="cdc-header__inner"><div class="cdc-header__top"><div class="cdc-header__top-left"><a href="/?from=20060&from_column=20060" target="_blank" class="cdc-header__top-logo"><i>腾讯云</i></a><div class="cdc-header__top-line"></div><a href="/developer" class="cdc-header__top-logo community"><i>开发者社区</i></a><div class="cdc-header__activity"><div id="cloud-header-product-container"></div></div></div><div class="cdc-header__top-operates"><a href="/document/product?from=20702&from_column=20702" target="_blank" class="cdc-header__link">文档</a><a href="/voc/?from=20703&from_column=20703" target="_blank" class="cdc-header__link">建议反馈</a><a href="https://console.cloud.tencent.com?from=20063&from_column=20063" target="_blank" class="cdc-header__link" track-click="{"areaId":102001,"subAreaId":1}">控制台</a><div class="cdc-header__account"><div class="cdc-header__account-inner"><button class="cdc-btn cdc-header__account-btn cdc-btn--primary">登录/注册</button></div></div></div></div><div class="cdc-header__bottom"><div class="cdc-header__bottom-nav"><a href="/developer" class="cdc-header__bottom-home">首页</a><div class="cdc-header__nav-list"><div class="cdc-header__nav-item">学习</div><div class="cdc-header__nav-item">活动</div><div class="cdc-header__nav-item">专区</div><div class="cdc-header__nav-item">工具</div></div><a href="/tvp?from=20154&from_column=20154" class="cdc-header__tvp" target="_blank">TVP</a><div class="cdc-header__activity"><a class="cdc-header__activity-tit" href="/act?from=20061&from_column=20061" target="_blank">最新优惠活动<div class="cdc-badge"><div class="cdc-badge-inner"><div class="cdc-badge-text"></div></div></div></a></div><div id="community-header-product-container"></div></div><div class="cdc-header__bottom-operates"><div class="cdc-header__search"><div class="cdc-search__wrap"><div class="cdc-search"><span class="cdc-search__text">文章/答案/技术大牛</span><button class="cdc-search__btn">搜索<i class="cdc-search__i search"></i></button></div><div class="cdc-search__dropdown"><div class="cdc-search__bar"><input type="text" class="cdc-search__bar-input" placeholder="文章/答案/技术大牛" value=""/><div class="cdc-search__bar-btns"><button class="cdc-search__btn">搜索<i class="cdc-search__i search"></i></button><button class="cdc-search__btn">关闭<i class="cdc-search__i clear"></i></button></div></div></div></div></div><div class="cdc-header__create"><span class="cdc-header__create-btn not-logged"><span class="cdc-svg-icon-con"><span class="cdc-svg-icon" style="line-height:1;color:#0052D9;width:16px;height:16px"><svg width="16" height="16" viewBox="0 0 16 16" fill="currentcolor" xmlns="http://www.w3.org/2000/svg"><path d="M14.2466 12.0145C14.1698 13.6258 12.8381 14.9131 11.2129 14.9131H11.1579H4.0927H4.03772C2.4125 14.9131 1.08014 13.6258 1.00334 12.0145H1V11.8668V4.07213V4.04627V3.89922H1.00334C1.08014 2.28732 2.4125 1 4.03772 1H9.6473V1.00069H10.0786L8.7688 2.10773H8.43888H7.7916H6.37904H4.03772C2.97234 2.10773 2.10445 2.9777 2.10445 4.04629V4.41869V4.4472V6.39498V11.4269V11.4309V11.8668C2.10445 12.9354 2.97234 13.8053 4.03772 13.8053H6.37904H8.87153H11.2129C12.2782 13.8053 13.1461 12.9355 13.1461 11.8668V11.466V11.454V9.5181V6.39364L14.2506 5.3051V11.8668V12.0145H14.2466ZM10.4324 7.15226L9.63146 7.99761C9.36577 8.2693 8.69326 8.95104 8.48066 9.17631C8.26726 9.40288 8.09039 9.58901 7.95061 9.73544C7.81079 9.88188 7.72667 9.96597 7.70083 9.98656C7.63321 10.0488 7.55703 10.1144 7.47022 10.1846C7.38412 10.2542 7.29404 10.3099 7.20063 10.3516C7.10722 10.4007 6.97072 10.459 6.79049 10.5305C6.61028 10.6001 6.42213 10.6676 6.22468 10.7339C6.02792 10.8002 5.84109 10.8571 5.66484 10.9061C5.48795 10.9538 5.3561 10.9863 5.2693 11.0009C5.08977 11.0214 4.96988 10.993 4.90956 10.9168C4.84931 10.8405 4.83276 10.7107 4.85924 10.5312C4.87315 10.4331 4.9043 10.292 4.95468 10.1078C5.00431 9.92297 5.05802 9.7315 5.11431 9.53341C5.1713 9.33526 5.22629 9.15179 5.27926 8.98484C5.33297 8.8179 5.37599 8.7026 5.40978 8.64032C5.44953 8.54357 5.49463 8.45413 5.54495 8.37399C5.59465 8.29379 5.66616 8.20503 5.75965 8.10766C5.79934 8.06588 5.89281 7.96649 6.03988 7.81018C6.18624 7.65311 6.80114 7.02774 7.02104 6.79783L7.75117 6.03524L8.56212 5.1899L10.6345 3.02466L12.5214 4.93874L10.4324 7.15226ZM13.816 3.58581C13.7166 3.68987 13.6272 3.78064 13.5483 3.85883C13.4694 3.93703 13.4006 4.0066 13.3423 4.06686C13.276 4.13643 13.2144 4.19738 13.1561 4.24903L11.2785 2.33569C11.3785 2.24025 11.4965 2.12565 11.6336 1.99115C11.7707 1.85668 11.8854 1.75061 11.9761 1.67242C12.0934 1.57708 12.2133 1.51013 12.3385 1.47109C12.4525 1.43529 12.5644 1.41805 12.6751 1.41876H12.7056C12.7665 1.42139 12.8268 1.42729 12.8851 1.43724C12.8838 1.4366 12.8811 1.43724 12.8798 1.4366C12.8811 1.4366 12.8838 1.4366 12.8851 1.43724C13.1376 1.48428 13.4019 1.62009 13.6265 1.83743C13.7511 1.95871 13.8524 2.09382 13.9259 2.23296C14.0346 2.43834 14.0863 2.65304 14.0763 2.8491C14.0763 2.87294 14.0783 2.89748 14.0783 2.92201C14.0783 3.03529 14.0571 3.14789 14.0154 3.26055C13.9737 3.37314 13.9067 3.48185 13.816 3.58581Z" fill="#0052D9"></path></svg></span></span>发布<span class="cdc-svg-icon-con cdc-header__create-btn-arrow"><span class="cdc-svg-icon" style="line-height:1;color:inherit;width:16px;height:16px"><svg width="16" height="16" viewBox="0 0 16 16" fill="currentcolor" xmlns="http://www.w3.org/2000/svg"><path d="M8.16377 4L9.57798 5.41421L14.5277 10.364L13.1135 11.7782L8.1638 6.829L3.21402 11.7782L1.7998 10.364L8.16377 4Z"></path></svg></span></span></span></div></div></div></div></div><div class="cdc-m-header with-focus is-fixed"><div class="cdc-m-header__placeholder"></div><div class="cdc-m-header__inner"><div class="cdc-m-guider-banner is-sticky"><div class="cdc-m-guider-banner__guide-mvp" track-exposure="{"areaId":118000}" track-click="{"areaId":118000}"><div class="cdc-m-guider-banner__guide-mvp-text">精选内容/技术社群/优惠产品,<em>尽在小程序</em></div><div class="cdc-m-guider-banner__guide-mvp-btn">立即前往</div></div></div><div class="cdc-m-header__main"><div class="cdc-m-header__trigger"></div><div class="cdc-m-header__logo"><i class="cdc-m-header__logo-icon"></i></div><div class="cdc-m-header__search"><i class="cdc-m-header__search-icon"></i></div><div class="cdc-m-header__operate"><span class="cdc-m-header__operate-icon"></span></div></div></div></div><div class="J-body com-body max-width"><div class="com-crumb"><div class="com-inner"><a href="/developer" class="crumb-item">首页</a><span class="crumb-split"></span><a href="/developer/tags" class="crumb-item">标签</a><span class="crumb-split"></span><span class="crumb-item current">云数据库 SQL Server</span></div></div><div track-click="{"areaId":{"areaId":113006}}" track-exposure="{"areaId":{"areaId":113006}}" class="com-tag-intro"><i class="intro-bg"></i><h2 class="intro-title"><em>#</em>云数据库 SQL Server</h2><p class="intro-desc">正版授权 SQL Server 云数据库</p><div class="intro-btns"><button type="button" class="c-btn" track-click="{"elementId":1}">关注</button></div></div><div class="com-2-layout"><div class="layout-main"><div class="com-tab large tag-tab"><div class="com-tab-hd large"><ul class="com-tab-ctrl"><li class="com-tab-item actived"><a href="javascript:;">专栏文章<span class="num">(24.4K)</span></a></li><li class="com-tab-item"><a href="/developer/tag/10245?entry=video">技术视频<span class="num">(205)</span></a></li><li class="com-tab-item"><a href="/developer/tag/10245?entry=ask">互动问答<span class="num">(20.5K)</span></a></li></ul></div><div class="com-tab-bd"><com class="com-tab-panel"><div class="com-article-panel-v2-list"><section class="com-article-panel-v2 higher"><a href="/developer/article/2454806" track-click="{"areaId":113001,"objectType":"article","objectId":2454806}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2454806}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">SQLServer采集data和log的体积推送到prometheus</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-10-01 09:25:37" title="2024-10-01 09:25:37"> 2024-10-01<span class="com-v-box">2024-10-01 09:25:37</span></time></span></div></div></div><p class="com-article-panel-v2-des">生产上需要采集各个库的datasize和logsize，便于DBA提前介入优化（例如数据文件最近为啥体积暴涨、事务日志为啥一直在涨or收缩失败？）</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>82</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2454806.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2454802" track-click="{"areaId":113001,"objectType":"article","objectId":2454802}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2454802}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">SQLServer中的锁等待巡检</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-10-01 09:12:00" title="2024-10-01 09:12:00"> 2024-10-01<span class="com-v-box">2024-10-01 09:12:00</span></time></span></div></div></div><p class="com-article-panel-v2-des">在日常运维sqlserver的过程中，偶发慢事务或存储过程与DDL语句（改表或者修改索引）需要锁定相同的资源，造成锁等待，如果不及时发现和处理，将影响到业务系统...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>93</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2454802.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2453295" track-click="{"areaId":113001,"objectType":"article","objectId":2453295}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2453295}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">SQLServer中使用登录触发器限制用户的访问地址</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-09-24 20:09:33" title="2024-09-24 20:09:33"> 2024-09-24<span class="com-v-box">2024-09-24 20:09:33</span></time></span></div></div></div><p class="com-article-panel-v2-des">目前有个需求，需要限制个别账号（或者其他权限较高的账号）的登录IP，降低访问的风险。</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>114</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2453295.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2448329" track-click="{"areaId":113001,"objectType":"article","objectId":2448329}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2448329}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">sqlcmd的使用</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-08-29 15:01:44" title="2024-08-29 15:01:44"> 2024-08-29<span class="com-v-box">2024-08-29 15:01:44</span></time></span></div></div></div><p class="com-article-panel-v2-des">官方文档 https://learn.microsoft.com/zh-cn/sql/tools/sqlcmd/sqlcmd-utility?view=sql-...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>131</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2448329.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2443896" track-click="{"areaId":113001,"objectType":"article","objectId":2443896}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2443896}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">SQLServer中批量导出的存储过程明细</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-08-13 10:38:01" title="2024-08-13 10:38:01"> 2024-08-13<span class="com-v-box">2024-08-13 10:38:01</span></time></span></div></div></div><p class="com-article-panel-v2-des">使用sqlserver management客户端可以导出存储过程的明细，但是如果要大批量导出则很不方便，这种情况下，可以使用python脚本来实现</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>194</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2443896.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2441185" track-click="{"areaId":113001,"objectType":"article","objectId":2441185}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2441185}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">sqlserver查看备份历史记录</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-08-01 15:33:07" title="2024-08-01 15:33:07"> 2024-08-01<span class="com-v-box">2024-08-01 15:33:07</span></time></span></div></div></div><p class="com-article-panel-v2-des"></p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>176</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2441185.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2439620" track-click="{"areaId":113001,"objectType":"article","objectId":2439620}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2439620}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">MSSQL 2014 TDE透明加密的使用</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-07-27 15:22:35" title="2024-07-27 15:22:35"> 2024-07-27<span class="com-v-box">2024-07-27 15:22:35</span></time></span></div></div></div><p class="com-article-panel-v2-des">https://learn.microsoft.com/zh-cn/sql/relational-databases/security/encryption/t...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>131</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2439620.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2437615" track-click="{"areaId":113001,"objectType":"article","objectId":2437615}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2437615}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">MSSQL查询脱敏的思路</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-07-19 22:09:02" title="2024-07-19 22:09:02"> 2024-07-19<span class="com-v-box">2024-07-19 22:09:02</span></time></span></div></div></div><p class="com-article-panel-v2-des">下面代码的核心在于引用了一个外部的jar包用于sql解析（暂未确认企业环境是否可以直接使用）。</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>70</span><span class="com-opt-link link-like"><i class="com-i-like"></i>0</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2437615.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2436140" track-click="{"areaId":113001,"objectType":"article","objectId":2436140}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2436140}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">sql server中的DDM动态数据屏蔽</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-07-13 21:28:45" title="2024-07-13 21:28:45"> 2024-07-13<span class="com-v-box">2024-07-13 21:28:45</span></time></span></div></div></div><p class="com-article-panel-v2-des">sqlserver从2016开始，具备了动态数据屏蔽（也可以叫动态数据掩码DDM全称dynamic data masking）的功能。</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>142</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2436140.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2435253" track-click="{"areaId":113001,"objectType":"article","objectId":2435253}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2435253}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">解决sqlserver进行连接的时候出现了报错</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/10670887" track-click="{"objectType":"user","objectId":10670887}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/2a919cea48bb13252f4b49a1f5d50661.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/10670887" track-click="{"objectType":"user","objectId":10670887}" target="_blank" class="author-info name">f1sh</a><span class="author-info time"><time dateTime="2024-07-10 13:06:51" title="2024-07-10 13:06:51"> 2024-07-10<span class="com-v-box">2024-07-10 13:06:51</span></time></span></div></div></div><p class="com-article-panel-v2-des">这是因为一些玄学问题，导致对应的服务没有启动起来，想要解决这个问题也很简单，只需要进入服务–>启动，把下图中的进程配置打开即可。另外可以把启动类型从手动改为...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>211</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2435253.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2431599" track-click="{"areaId":113001,"objectType":"article","objectId":2431599}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2431599}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">应对抢购脚本攻击：保障线上商场高并发场景下的稳定性</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10431?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10431}" class="com-tag-v2">DDoS 防护</a><a href="/developer/tag/17818?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":17818}" class="com-tag-v2">商场客留大数据</a><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-object"><span class="com-article-panel-v2-img" style="background-image:url(https://developer.qcloudimg.com/http-save/yehe-9917444/167185fe8aa89db39a2f697f9e1ede3d.png?imageView2/2/w/400/h/7000)"></span></div><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/9917444" track-click="{"objectType":"user","objectId":9917444}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/4ef7467d702237e82e7f84e70f1270e6.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/9917444" track-click="{"objectType":"user","objectId":9917444}" target="_blank" class="author-info name">群联云安全小杜</a><span class="author-info time"><time dateTime="2024-06-25 16:41:36" title="2024-06-25 16:41:36"> 2024-06-25<span class="com-v-box">2024-06-25 16:41:36</span></time></span></div></div></div><p class="com-article-panel-v2-des">在电商促销活动期间，抢购脚本成为了一种常见的攻击方式，导致服务器负载激增，甚至引发系统瘫痪。本文将探讨抢购脚本的工作原理，分析其对线上商场的影响，并提供一系列预...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>196</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2431599.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2427272" track-click="{"areaId":113001,"objectType":"article","objectId":2427272}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2427272}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">万界星空科技MES生产管理系统：私有云、公有云与本地化部署的比较分析</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a><a href="/developer/tag/17280?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":17280}" class="com-tag-v2">工业互联网</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/10850153" track-click="{"objectType":"user","objectId":10850153}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/avatar/153.png?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/10850153" track-click="{"objectType":"user","objectId":10850153}" target="_blank" class="author-info name">用户10850153</a><span class="author-info time"><time dateTime="2024-06-13 10:54:44" title="2024-06-13 10:54:44"> 2024-06-13<span class="com-v-box">2024-06-13 10:54:44</span></time></span></div></div></div><p class="com-article-panel-v2-des"> 随着信息技术的迅猛发展，云计算作为一种新兴的技术服务模式，已经深入渗透到企业的日常运营中。在众多部署方式中，私有云、公有云和本地化部署是三种最为常见的选择。...</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>128</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2427272.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2426508" track-click="{"areaId":113001,"objectType":"article","objectId":2426508}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2426508}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">SQL中为什么不要使用1=1</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a><a href="/developer/tag/10253?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10253}" class="com-tag-v2">sql</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-object"><span class="com-article-panel-v2-img" style="background-image:url(https://developer.qcloudimg.com/http-save/yehe-9379088/761f5aebdfc595145507c2392f4bc592.jpg?imageView2/2/w/400/h/7000)"></span></div><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/9379088" track-click="{"objectType":"user","objectId":9379088}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://ask.qcloudimg.com/http-save/yehe-9379088/dbccf09b08d375f952c731c8df421748.jpeg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/9379088" track-click="{"objectType":"user","objectId":9379088}" target="_blank" class="author-info name">阿珍</a><span class="author-info time"><time dateTime="2024-06-11 00:15:33" title="2024-06-11 00:15:33"> 2024-06-11<span class="com-v-box">2024-06-11 00:15:33</span></time></span></div></div></div><p class="com-article-panel-v2-des">最近看几个老项目的SQL条件中使用了1=1，想想自己也曾经这样写过，略有感触，特别拿出来说道说道。</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>226</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2426508.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section><section class="com-article-panel-v2 higher"><a href="/developer/article/2416298" track-click="{"areaId":113001,"objectType":"article","objectId":2416298}" track-exposure="{"areaId":113001,"objectType":"article","objectId":2416298}" target="_blank" class="com-article-panel-v2-link"></a><div class="com-article-panel-v2-hd"><h3 class="com-article-panel-v2-title">[翻译]如何从 SQL Server 恢复已删除的数据</h3><nav class="com-tag-v2-list com-article-panel-v2-tags"><a href="/developer/tag/10245?entry=article" track-click="{"areaId":113001,"objectType":"tag","objectId":10245}" class="com-tag-v2">云数据库 SQL Server</a></nav></div><div class="com-article-panel-v2-bd"><div class="com-article-panel-v2-cnt"><div class="com-article-panel-v2-user-wrap"><div class="com-media com-user-infos"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="com-media-object"><span class="com-media-img" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg?imageView2/2/w/48/h/7000)"></span></a><div class="com-media-body"><a href="/developer/user/3663994" track-click="{"objectType":"user","objectId":3663994}" target="_blank" class="author-info name">保持热爱奔赴山海</a><span class="author-info time"><time dateTime="2024-05-10 14:49:41" title="2024-05-10 14:49:41"> 2024-05-10<span class="com-v-box">2024-05-10 14:49:41</span></time></span></div></div></div><p class="com-article-panel-v2-des">在我使用 SQL Server 的这些年里，最常见的问题之一一直是“我们如何恢复已删除的记录？”</p><div class="com-operations com-article-panel-v2-opt"><span class="com-opt-link link-view"><i class="com-i-view"></i>176</span><span class="com-opt-link link-like"><i class="com-i-like"></i>1</span><span class="com-opt-link link-comment"><i class="com-i-dialog"></i>0</span><span><a href="javascript:;" class="com-opt-link link-share" hotrep="community.tag.tag_detail.activities.article.2416298.sharing"><i class="com-i-share"></i></a><ul class="com-share-options"></ul></span></div></div></div></section></div><div><div class="c-loading c-loading-tip"><div class="c-loading-inner"><div class="one"></div><div class="two"></div><div class="three"></div></div></div></div></com></div></div></div><div class="layout-side" track-click="" track-exposure=""><div class="com-2-section side"><header class="com-2-section-hd"><h2 class="com-2-section-title without-icon"><span><em>相关</em>产品</span></h2></header><div class="com-2-section-bd"><ul class="com-side-products"><li class="panel-cell"><div class="com-side-product"><a href="" target="_blank" class="panel-link"></a><header class="com-side-product-hd"><div class="com-side-product-object"><img src="https://main.qcloudimg.com/image/product/2026/32_32/blue.svg" alt=""/></div><h3 class="com-side-product-title">云数据库 SQL Server</h3></header><p class="com-side-product-desc">正版授权 SQL Server 云数据库</p></div></li></ul></div></div><div class="com-2-section side"><header class="com-2-section-hd"><h2 class="com-2-section-title without-icon"><span><em>热门</em>专栏</span></h2></header><div class="com-2-section-bd"><div class="com-side-column-panels-wrap"><div class="com-side-column-panels-cnt"><ul track-click="{"areaId":113004}" track-exposure="{"areaId":113004}" class="com-side-column-panels"><li class="panel-cell"><a href="/developer/column/91377" trackClick="{"objectType":"column","objectId":91377}" class="com-media com-side-column-panel"><div class="com-media-object"><span class="com-2-avatar"><span class="com-2-avatar-inner" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/5eef79a6a73684fac572184b7b0fa2c9.jpg?imageView2/2/w/76/h/7000)"></span></span></div><div class="com-media-body"><h3 class="com-side-column-panel-title">全栈程序员必看</h3><div class="com-side-column-panel-infos"><div class="com-datas"><span class="com-data">55K 文章</span><span class="com-data">516 订阅</span></div></div></div></a></li><li class="panel-cell"><a href="/developer/column/95569" trackClick="{"objectType":"column","objectId":95569}" class="com-media com-side-column-panel"><div class="com-media-object"><span class="com-2-avatar"><span class="com-2-avatar-inner" style="background-image:url(https://ask.qcloudimg.com/http-save/yehe-8492898/11088ab128a8fe2c80ff678b4113dc08.jpeg?imageView2/2/w/76/h/7000)"></span></span></div><div class="com-media-body"><h3 class="com-side-column-panel-title">开源部署</h3><div class="com-side-column-panel-infos"><div class="com-datas"><span class="com-data">4.7K 文章</span><span class="com-data">55 订阅</span></div></div></div></a></li><li class="panel-cell"><a href="/developer/column/85409" trackClick="{"objectType":"column","objectId":85409}" class="com-media com-side-column-panel"><div class="com-media-object"><span class="com-2-avatar"><span class="com-2-avatar-inner" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/864a60182540ad4dc3f05f841a6b5130.jpg?imageView2/2/w/76/h/7000)"></span></span></div><div class="com-media-body"><h3 class="com-side-column-panel-title">爱可生开源社区</h3><div class="com-side-column-panel-infos"><div class="com-datas"><span class="com-data">858 文章</span><span class="com-data">46 订阅</span></div></div></div></a></li><li class="panel-cell"><a href="/developer/column/78009" trackClick="{"objectType":"column","objectId":78009}" class="com-media com-side-column-panel"><div class="com-media-object"><span class="com-2-avatar"><span class="com-2-avatar-inner" style="background-image:url(https://ask.qcloudimg.com/avatar/male/BJtgMyRZB_m.png)"></span></span></div><div class="com-media-body"><h3 class="com-side-column-panel-title">AustinDatabases</h3><div class="com-side-column-panel-infos"><div class="com-datas"><span class="com-data">871 文章</span><span class="com-data">58 订阅</span></div></div></div></a></li><li class="panel-cell"><a href="/developer/column/2127" trackClick="{"objectType":"column","objectId":2127}" class="com-media com-side-column-panel"><div class="com-media-object"><span class="com-2-avatar"><span class="com-2-avatar-inner" style="background-image:url(https://developer.qcloudimg.com/http-save/10011/f968a799e0a2404a9965c1d64cf7af2d.jpg?imageView2/2/w/76/h/7000)"></span></span></div><div class="com-media-body"><h3 class="com-side-column-panel-title">杨建荣的学习笔记</h3><div class="com-side-column-panel-infos"><div class="com-datas"><span class="com-data">1.7K 文章</span><span class="com-data">251 订阅</span></div></div></div></a></li></ul></div></div></div></div></div></div></div><div class="cdc-footer J-footer com-2-footer"><div class="cdc-footer__inner"><div class="cdc-footer__main"><div class="cdc-footer__website"><ul class="cdc-footer__website-group"><li class="cdc-footer__website-column"><div class="cdc-footer__website-box"><h3 class="cdc-footer__website-title">社区</h3><ul class="cdc-footer__website-list"><li class="cdc-footer__website-item"><a href="/developer/column">专栏文章</a></li><li class="cdc-footer__website-item"><a href="/developer/inventory">阅读清单</a></li><li class="cdc-footer__website-item"><a href="/developer/ask">互动问答</a></li><li class="cdc-footer__website-item"><a href="/developer/salon">技术沙龙</a></li><li class="cdc-footer__website-item"><a href="/developer/video">技术视频</a></li><li class="cdc-footer__website-item"><a href="/developer/teams">团队主页</a></li><li class="cdc-footer__website-item"><a href="/developer/timl">腾讯云TI平台</a></li></ul></div></li><li class="cdc-footer__website-column"><div class="cdc-footer__website-box"><h3 class="cdc-footer__website-title">活动</h3><ul class="cdc-footer__website-list"><li class="cdc-footer__website-item"><a href="/developer/support-plan">自媒体同步曝光计划</a></li><li class="cdc-footer__website-item"><a href="/developer/support-plan-invitation">邀请作者入驻</a></li><li class="cdc-footer__website-item"><a href="/developer/article/1535830">自荐上首页</a></li><li class="cdc-footer__website-item"><a href="/developer/competition">技术竞赛</a></li></ul></div></li><li class="cdc-footer__website-column"><div class="cdc-footer__website-box"><h3 class="cdc-footer__website-title">资源</h3><ul class="cdc-footer__website-list"><li class="cdc-footer__website-item"><a href="/developer/specials">技术周刊</a></li><li class="cdc-footer__website-item"><a href="/developer/tags">社区标签</a></li><li class="cdc-footer__website-item"><a href="/developer/devdocs">开发者手册</a></li><li class="cdc-footer__website-item"><a href="/lab?from=20064&from_column=20064">开发者实验室</a></li></ul></div></li><li class="cdc-footer__website-column"><div class="cdc-footer__website-box"><h3 class="cdc-footer__website-title">关于</h3><ul class="cdc-footer__website-list"><li class="cdc-footer__website-item"><a rel="nofollow" href="/developer/article/1006434">社区规范</a></li><li class="cdc-footer__website-item"><a rel="nofollow" href="/developer/article/1006435">免责声明</a></li><li class="cdc-footer__website-item"><a rel="nofollow" href="mailto:cloudcommunity@tencent.com">联系我们</a></li><li class="cdc-footer__website-item"><a rel="nofollow" href="/developer/friendlink">友情链接</a></li></ul></div></li></ul></div><div class="cdc-footer__qr"><h3 class="cdc-footer__qr-title">腾讯云开发者</h3><div class="cdc-footer__qr-object"><img class="cdc-footer__qr-image" src="https://qcloudimg.tencent-cloud.cn/raw/a8907230cd5be483497c7e90b061b861.png" alt="扫码关注腾讯云开发者"/></div><div class="cdc-footer__qr-infos"><p class="cdc-footer__qr-info"><span class="cdc-footer__qr-text">扫码关注腾讯云开发者</span></p><p class="cdc-footer__qr-info"><span class="cdc-footer__qr-text">领取腾讯云代金券</span></p></div></div></div><div class="cdc-footer__recommend"><div class="cdc-footer__recommend-rows"><div class="cdc-footer__recommend-cell"><h3 class="cdc-footer__recommend-title">热门产品</h3><div class="cdc-footer__recommend-wrap"><ul class="cdc-footer__recommend-list"><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="https://dnspod.cloud.tencent.com?from=20064&from_column=20064">域名注册</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cvm?from=20064&from_column=20064">云服务器</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/tbaas?from=20064&from_column=20064">区块链服务</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/mq?from=20064&from_column=20064">消息队列</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/dsa?from=20064&from_column=20064">网络加速</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/tencentdb-catalog?from=20064&from_column=20064">云数据库</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cns?from=20064&from_column=20064">域名解析</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cos?from=20064&from_column=20064">云存储</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/css?from=20064&from_column=20064">视频直播</a></li></ul></div></div><div class="cdc-footer__recommend-cell"><h3 class="cdc-footer__recommend-title">热门推荐</h3><div class="cdc-footer__recommend-wrap"><ul class="cdc-footer__recommend-list"><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/facerecognition?from=20064&from_column=20064">人脸识别</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/tm?from=20064&from_column=20064">腾讯会议</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/act/pro/enterprise2019?from=20064&from_column=20064">企业云</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cdn-scd?from=20064&from_column=20064">CDN加速</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/trtc?from=20064&from_column=20064">视频通话</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/tiia?from=20064&from_column=20064">图像分析</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cdb?from=20064&from_column=20064">MySQL 数据库</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/symantecssl?from=20064&from_column=20064">SSL 证书</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/asr?from=20064&from_column=20064">语音识别</a></li></ul></div></div><div class="cdc-footer__recommend-cell"><h3 class="cdc-footer__recommend-title">更多推荐</h3><div class="cdc-footer__recommend-wrap"><ul class="cdc-footer__recommend-list"><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/solution/data_protection?from=20064&from_column=20064">数据安全</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/clb?from=20064&from_column=20064">负载均衡</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/sms?from=20064&from_column=20064">短信</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/ocr?from=20064&from_column=20064">文字识别</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/vod?from=20064&from_column=20064">云点播</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="https://tm.cloud.tencent.com?from=20064&from_column=20064">商标注册</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/solution/la?from=20064&from_column=20064">小程序开发</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cat?from=20064&from_column=20064">网站监控</a></li><li class="cdc-footer__recommend-item"><a class="com-2-footer-recommend-link" href="/product/cdm?from=20064&from_column=20064">数据迁移</a></li></ul></div></div></div></div><div class="cdc-footer__copyright"><div class="cdc-footer__copyright-text"><p>Copyright © 2013 - 2024 Tencent Cloud. All Rights Reserved. 腾讯云版权所有 </p><p>深圳市腾讯计算机系统有限公司 ICP备案/许可证号：<a href="https://beian.miit.gov.cn/#/Integrated/index" target="_blank">粤B2-20090059 </a><a href="https://www.beian.gov.cn/portal/index.do" target="_blank">深公网安备号 44030502008569</a></p><p>腾讯云计算（北京）有限责任公司京ICP证150476号 |  <a href="https://beian.miit.gov.cn/#/Integrated/index" target="_blank">京ICP备11018762号</a> |  <a href="https://www.beian.gov.cn/portal/index.do" target="_blank">京公网安备号11010802020287</a></p></div></div></div></div></div><div class="com-widget-global"><div style="position:relative;z-index:8088"><div class="com-widget-global2"><div class="com-widget-global2__btn code"><div class="com-widget-global2__btn-tag">领券</div></div><div class="com-widget-global2__btn top" style="visibility:hidden"></div></div></div></div><div id="dialog-root"></div><div id="rno-dialog-root" class="rno-modal-wrap"></div></div><script>window.isServerContext = false; window.isClientContext = true;</script><script>window.$serverTime = 1732408073940; window.$clientTime = 1732408073940;</script><script class="">window.$ua = {"browser":{"name":"IE","version":"7.0","major":"7"},"cpu":{},"device":{},"engine":{},"os":{"name":"Windows","version":"Vista"}};</script><script src="//cloudcache.tencent-cloud.com/qcloud/developer/scripts/release/libs/dom4/1.8.3/dom4.js"></script><script src="https://cloudcache.tencent-cloud.com/qcloud/main/scripts/release/common/vendors/babel/polyfill.6.26.min.js"></script><script src="https://cloudcache.tencent-cloud.com/qcloud/main/scripts/release/common/vendors/react/react.16.8.6.min.js"></script><script src="https://cloudcache.tencent-cloud.com/qcloud/main/scripts/release/common/vendors/react/react-dom.16.8.6.min.js"></script><script src="https://cloudcache.tencent-cloud.com/qcloud/main/scripts/release/common/vendors/jquery-3.2.1.min.js"></script><script src="//cloudcache.tencent-cloud.com/qcloud/developer/scripts/release/base.e1782d07ea.js?max_age=31536000" crossorigin="anonymous"></script><script src="//cloudcache.tencent-cloud.com/qcloud/draft-master/dist/draft-master-v2.0.118.d4s2ddo9sb.js?max_age=31536000"></script><script src="https://cloud.tencent.com/qccomponent/login/api.js"></script><script src="//cloudcache.tencent-cloud.com/qcloud/main/scripts/release/common/deps/wechatJsSdk.js?version=1_0_1&max_age=31536000"></script><script src="//cloudcache.tencent-cloud.com/qcloud/developer/scripts/release/common.d861693252.js?max_age=31536000" crossorigin="anonymous"></script><script src="https://web.sdk.qcloud.com/player/tcplayer/release/v4.7.2/tcplayer.v4.7.2.min.js"></script><script src="//dscache.tencent-cloud.cn/ecache/qcstat/qcloud/qcloudStatApi.js"></script><script src="https://qccommunity.qcloudimg.com/common/exposure-plugin-4.1.15.min.js"></script><script src="https://qccommunity.qcloudimg.com/community-track/qcloud-community-track.min.js"></script><script src="https://dscache.tencent-cloud.com/sdk/dianshi-sdk/loader/umd/dianshi-sdk-loader.v0.0.18.js"></script><script src="//cloudcache.tencent-cloud.com/qcloud/developer/scripts/release/tag/tag-detail.525acd5146.js?max_age=31536000" crossorigin="anonymous"></script><script class=""> window.$render({"tagInfo":{"id":10245,"name":"云数据库 SQL Server","icon":"https://main.qcloudimg.com/image/product/2026/32_32/blue.svg","defaultIcon":"//cloudcache.tencent-cloud.com/open_proj/proj_qcloud_v2/gateway/q-and-a/css/img/tags/tag_comm.svg","shareIcon":"https://cloudcache.tencent-cloud.com/open_proj/proj_qcloud_v2/gateway/q-and-a/css/img/tags/share_comm.png","initial":"Y","desc":"正版授权 SQL Server 云数据库","followCount":68,"questionCount":20471,"answerCount":29306,"unanswerCount":71,"articleCount":24376,"devdocCount":0,"vlogCount":205,"boundProductId":0,"stick":{"articleIds":[],"askIds":[],"vlogIds":[]},"createTime":"2018-05-11 12:24:43"},"activeRelatedEntry":"article","timelineData":{"ask":{"fetchStatus":"none","done":false,"nextPageNumber":1,"pageSize":20,"total":0,"list":[]},"article":{"fetchStatus":"loaded","done":false,"nextPageNumber":2,"pageSize":20,"total":24374,"list":[{"id":2454806,"articleId":2454806,"title":"SQLServer采集data和log的体积推送到prometheus","content":"","plain":"","brief":"","summary":"生产上需要采集各个库的datasize和logsize，便于DBA提前介入优化（例如数据文件最近为啥体积暴涨、事务日志为啥一直在涨or收缩失败？）","abstract":"生产上需要采集各个库的datasize和logsize，便于DBA提前介入优化（例如数据文件最近为啥体积暴涨、事务日志为啥一直在涨or收缩失败？）","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1727745937,"updateTime":1727745937,"viewCount":82,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2454802,"articleId":2454802,"title":"SQLServer中的锁等待巡检","content":"","plain":"","brief":"","summary":"在日常运维sqlserver的过程中，偶发慢事务或存储过程与DDL语句（改表或者修改索引）需要锁定相同的资源，造成锁等待，如果不及时发现和处理，将影响到业务系统...","abstract":"在日常运维sqlserver的过程中，偶发慢事务或存储过程与DDL语句（改表或者修改索引）需要锁定相同的资源，造成锁等待，如果不及时发现和处理，将影响到业务系统...","posterSummary":"在日常运维sqlserver的过程中，偶发慢事务或存储过程与DDL语句（改表或者修改索引）需要锁定相同的资源，造成锁等待，如果不及时发现和处理，将影响到业务系统的稳定性。","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1727745120,"updateTime":1727745120,"viewCount":93,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2453295,"articleId":2453295,"title":"SQLServer中使用登录触发器限制用户的访问地址","content":"","plain":"","brief":"","summary":"目前有个需求，需要限制个别账号（或者其他权限较高的账号）的登录IP，降低访问的风险。","abstract":"目前有个需求，需要限制个别账号（或者其他权限较高的账号）的登录IP，降低访问的风险。","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1727179773,"updateTime":1727179773,"viewCount":114,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2448329,"articleId":2448329,"title":"sqlcmd的使用","content":"","plain":"","brief":"","summary":"官方文档 https://learn.microsoft.com/zh-cn/sql/tools/sqlcmd/sqlcmd-utility?view=sql-...","abstract":"官方文档 https://learn.microsoft.com/zh-cn/sql/tools/sqlcmd/sqlcmd-utility?view=sql-...","posterSummary":"官方文档 https://learn.microsoft.com/zh-cn/sql/tools/sqlcmd/sqlcmd-utility?view=sql-server-ver16&tabs=go%2Cwindows&pivots=cs1-bash","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1724914904,"updateTime":1724914904,"viewCount":131,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2443896,"articleId":2443896,"title":"SQLServer中批量导出的存储过程明细","content":"","plain":"","brief":"","summary":"使用sqlserver management客户端可以导出存储过程的明细，但是如果要大批量导出则很不方便，这种情况下，可以使用python脚本来实现","abstract":"使用sqlserver management客户端可以导出存储过程的明细，但是如果要大批量导出则很不方便，这种情况下，可以使用python脚本来实现","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1723516681,"updateTime":1723516681,"viewCount":194,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2441185,"articleId":2441185,"title":"sqlserver查看备份历史记录","content":"","plain":"","brief":"","summary":"","abstract":"","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":3,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1722432397,"updateTime":1722497587,"viewCount":176,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2439620,"articleId":2439620,"title":"MSSQL 2014 TDE透明加密的使用","content":"","plain":"","brief":"","summary":"https://learn.microsoft.com/zh-cn/sql/relational-databases/security/encryption/t...","abstract":"https://learn.microsoft.com/zh-cn/sql/relational-databases/security/encryption/t...","posterSummary":"https://learn.microsoft.com/zh-cn/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1722064955,"updateTime":1722064955,"viewCount":131,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2437615,"articleId":2437615,"title":"MSSQL查询脱敏的思路","content":"","plain":"","brief":"","summary":"下面代码的核心在于引用了一个外部的jar包用于sql解析（暂未确认企业环境是否可以直接使用）。","abstract":"下面代码的核心在于引用了一个外部的jar包用于sql解析（暂未确认企业环境是否可以直接使用）。","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1721398142,"updateTime":1721398142,"viewCount":70,"likeCount":0,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2436140,"articleId":2436140,"title":"sql server中的DDM动态数据屏蔽","content":"","plain":"","brief":"","summary":"sqlserver从2016开始，具备了动态数据屏蔽（也可以叫动态数据掩码DDM全称dynamic data masking）的功能。","abstract":"sqlserver从2016开始，具备了动态数据屏蔽（也可以叫动态数据掩码DDM全称dynamic data masking）的功能。","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":80681,"columnIds":[],"writeTime":1720877325,"updateTime":1720877325,"viewCount":142,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2435253,"articleId":2435253,"title":"解决sqlserver进行连接的时候出现了报错","content":"","plain":"","brief":"","summary":"这是因为一些玄学问题，导致对应的服务没有启动起来，想要解决这个问题也很简单，只需要进入服务–\u003E启动，把下图中的进程配置打开即可。另外可以把启动类型从手动改为...","abstract":"这是因为一些玄学问题，导致对应的服务没有启动起来，想要解决这个问题也很简单，只需要进入服务–\u003E启动，把下图中的进程配置打开即可。另外可以把启动类型从手动改为...","posterSummary":"这是因为一些玄学问题，导致对应的服务没有启动起来，想要解决这个问题也很简单，只需要进入服务–\u003E启动，把下图中的进程配置打开即可。另外可以把启动类型从手动改为自动","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":10670887,"columnId":0,"columnIds":[],"writeTime":1720588011,"updateTime":1720588011,"viewCount":211,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/2a919cea48bb13252f4b49a1f5d50661.jpg","company":"","introduce":"不负少年心气，为爱博此一生","isProfessionVerified":0,"nickname":"f1sh","title":"","uid":10670887,"id":10670887,"name":"f1sh","avatar":"https://developer.qcloudimg.com/http-save/10011/2a919cea48bb13252f4b49a1f5d50661.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2431599,"articleId":2431599,"title":"应对抢购脚本攻击：保障线上商场高并发场景下的稳定性","content":"","plain":"","brief":"","summary":"在电商促销活动期间，抢购脚本成为了一种常见的攻击方式，导致服务器负载激增，甚至引发系统瘫痪。本文将探讨抢购脚本的工作原理，分析其对线上商场的影响，并提供一系列预...","abstract":"在电商促销活动期间，抢购脚本成为了一种常见的攻击方式，导致服务器负载激增，甚至引发系统瘫痪。本文将探讨抢购脚本的工作原理，分析其对线上商场的影响，并提供一系列预...","posterSummary":"在电商促销活动期间，抢购脚本成为了一种常见的攻击方式，导致服务器负载激增，甚至引发系统瘫痪。本文将探讨抢购脚本的工作原理，分析其对线上商场的影响，并提供一系列预防和应对策略，包括技术实现细节，以确保系统的高可用性和安全性。","description":"","picture":"https://developer.qcloudimg.com/http-save/yehe-9917444/167185fe8aa89db39a2f697f9e1ede3d.png","coverImageUrl":"https://developer.qcloudimg.com/http-save/yehe-9917444/167185fe8aa89db39a2f697f9e1ede3d.png","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":9917444,"columnId":102739,"columnIds":[],"writeTime":1719304896,"updateTime":1719304896,"viewCount":196,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/4ef7467d702237e82e7f84e70f1270e6.jpg","company":"群联科技","introduce":"ddos防护 waf 十五年安全经验","isProfessionVerified":0,"nickname":"群联云安全小杜","title":"售前技术","uid":9917444,"id":9917444,"name":"群联云安全小杜","avatar":"https://developer.qcloudimg.com/http-save/10011/4ef7467d702237e82e7f84e70f1270e6.jpg"},"tags":[{"tagId":10431,"tagName":"DDoS 防护","id":10431,"name":"DDoS 防护"},{"tagId":17818,"tagName":"商场客留大数据","id":17818,"name":"商场客留大数据"},{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]},{"id":2427272,"articleId":2427272,"title":"万界星空科技MES生产管理系统：私有云、公有云与本地化部署的比较分析","content":"","plain":"","brief":"","summary":" 随着信息技术的迅猛发展，云计算作为一种新兴的技术服务模式，已经深入渗透到企业的日常运营中。在众多部署方式中，私有云、公有云和本地化部署是三种最为常见的选择。...","abstract":" 随着信息技术的迅猛发展，云计算作为一种新兴的技术服务模式，已经深入渗透到企业的日常运营中。在众多部署方式中，私有云、公有云和本地化部署是三种最为常见的选择。...","posterSummary":" 随着信息技术的迅猛发展，云计算作为一种新兴的技术服务模式，已经深入渗透到企业的日常运营中。在众多部署方式中，私有云、公有云和本地化部署是三种最为常见的选择。它们各自具有独特的特点和适用场景，并在不同程度上影响着企业的信息化建设。私有云、公有云和本地化部署是不同的云计算部署方式，它们在数据存储、资源管理、安全性和控制权等方面存在一些区别和联系。","description":"","picture":"","coverImageUrl":"","sourceType":1,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":10850153,"columnId":101318,"columnIds":[],"writeTime":1718247284,"updateTime":1718247284,"viewCount":128,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/avatar/153.png","company":"","introduce":"","isProfessionVerified":0,"nickname":"用户10850153","title":"","uid":10850153,"id":10850153,"name":"用户10850153","avatar":"https://developer.qcloudimg.com/avatar/153.png"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"},{"tagId":17280,"tagName":"工业互联网","id":17280,"name":"工业互联网"}]},{"id":2426508,"articleId":2426508,"title":"SQL中为什么不要使用1=1","content":"","plain":"","brief":"","summary":"最近看几个老项目的SQL条件中使用了1=1，想想自己也曾经这样写过，略有感触，特别拿出来说道说道。","abstract":"最近看几个老项目的SQL条件中使用了1=1，想想自己也曾经这样写过，略有感触，特别拿出来说道说道。","posterSummary":"","description":"","picture":"https://developer.qcloudimg.com/http-save/yehe-9379088/761f5aebdfc595145507c2392f4bc592.jpg","coverImageUrl":"https://developer.qcloudimg.com/http-save/yehe-9379088/761f5aebdfc595145507c2392f4bc592.jpg","sourceType":2,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":9379088,"columnId":0,"columnIds":[],"writeTime":1718036133,"updateTime":1718036133,"viewCount":226,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://ask.qcloudimg.com/http-save/yehe-9379088/dbccf09b08d375f952c731c8df421748.jpeg","company":"","introduce":"","isProfessionVerified":0,"nickname":"阿珍","title":"","uid":9379088,"id":9379088,"name":"阿珍","avatar":"https://ask.qcloudimg.com/http-save/yehe-9379088/dbccf09b08d375f952c731c8df421748.jpeg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"},{"tagId":10253,"tagName":"sql","id":10253,"name":"sql"}]},{"id":2416298,"articleId":2416298,"title":"[翻译]如何从 SQL Server 恢复已删除的数据","content":"","plain":"","brief":"","summary":"在我使用 SQL Server 的这些年里，最常见的问题之一一直是“我们如何恢复已删除的记录？”","abstract":"在我使用 SQL Server 的这些年里，最常见的问题之一一直是“我们如何恢复已删除的记录？”","posterSummary":"","description":"","picture":"","coverImageUrl":"","sourceType":3,"sourceDetail":{},"channelType":0,"channelDetail":{},"authorId":3663994,"columnId":0,"columnIds":[],"writeTime":1715323443,"updateTime":1715323781,"viewCount":176,"likeCount":1,"commentCount":0,"favorCount":0,"weight":0,"status":2,"draftId":0,"tagIds":[],"isCommentEnable":true,"highQuality":false,"skipAds":false,"showAds":false,"focusRead":false,"publishTime":null,"editTime":null,"isCloseTextLink":false,"author":{"avatarUrl":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg","company":"","introduce":"如有漏Ref或有误地方，请私信或评论区留言","isProfessionVerified":0,"nickname":"保持热爱奔赴山海","title":"DBA","uid":3663994,"id":3663994,"name":"保持热爱奔赴山海","avatar":"https://developer.qcloudimg.com/http-save/10011/80eca3b47e653d9910ac18dc9349b97b.jpg"},"tags":[{"tagId":10245,"tagName":"云数据库 SQL Server","id":10245,"name":"云数据库 SQL Server"}]}]},"video":{"fetchStatus":"none","done":false,"nextPageNumber":1,"pageSize":20,"total":0,"list":[]}},"relatedProducts":[{"id":11030,"type":1,"name":"sqlserver","cnName":"云数据库 SQL Server","iconUrl":"https://main.qcloudimg.com/image/product/2026/32_32/blue.svg","intro":"正版授权 SQL Server 云数据库","introUrl":"","desc":"云数据库 SQL Server（TencentDB for SQL Server）具有微软正版授权，可持续为用户提供最新的功能，避免未授权使用软件的风险。具有即开即用、稳定可靠、安全运行、弹性扩缩容等特点，同时也具备高可用架构、数据安全保障和故障秒级恢复功能，让您能专注于应用程序的开发。","documentUrl":"/document/product/238","features":"[]","weight":0}],"relatedDevdocs":[],"activeUsers":[],"hotColumns":[{"id":91377,"name":"全栈程序员必看","desc":"15年+全栈程序员，公众号【全栈程序员社区】领 5T 全栈编程资料和学习经验，共同学习，共同进步。","icon":"https://imgcache.qq.com/qcloud/developer/images/release/column-icons/14.png","background":"","status":2,"creatorId":8223537,"memberCount":1,"articleCount":54959,"followCount":516,"createdTime":1616060221,"creator":{"id":8223537,"uid":8223537,"name":"全栈程序员站长","label":"一个工作10多年的全栈程序员分享。欢迎关注公众号“全栈程序员社区”。","avatar":"https://developer.qcloudimg.com/http-save/10011/5eef79a6a73684fac572184b7b0fa2c9.jpg","province":"1017","city":"1018","company":"CTO","title":"","school":"北京交通大学","major":"计算机应用","homePage":"http://ispacesoft.com","region":1,"jobType":1,"graduationDate":"","education":0,"specialityIds":[10164,10216,10151,10169,10800],"specialities":[],"gender":1,"trade":"","growthLevel":0,"isProfessionVerified":false,"upvoteCount":0,"followingCount":2,"followerCount":4094,"questionCount":0,"answerCount":1,"followQuestionCount":0,"followTagCount":0,"favorAnswerCount":0,"beHandPickedCount":0,"followColumnCount":4,"articleCount":55016,"validArticleCount":54959}},{"id":95569,"name":"开源部署","desc":"","icon":"https://imgcache.qq.com/qcloud/developer/images/release/column-icons/17.png","background":"","status":2,"creatorId":8492898,"memberCount":1,"articleCount":4672,"followCount":55,"createdTime":1653288165,"creator":{"id":8492898,"uid":8492898,"name":"星哥玩云","label":"","avatar":"https://ask.qcloudimg.com/http-save/yehe-8492898/11088ab128a8fe2c80ff678b4113dc08.jpeg","province":"1213","city":"1216","company":"","title":"","school":"","major":"","homePage":"https://www.xgss.net","region":1,"jobType":1,"graduationDate":"","education":0,"specialityIds":[10848,10935,104],"specialities":[],"gender":1,"trade":"","growthLevel":0,"isProfessionVerified":false,"upvoteCount":0,"followingCount":4,"followerCount":567,"questionCount":0,"answerCount":0,"followQuestionCount":0,"followTagCount":0,"favorAnswerCount":0,"beHandPickedCount":0,"followColumnCount":3,"articleCount":4709,"validArticleCount":4673}},{"id":85409,"name":"爱可生开源社区","desc":"","icon":"https://imgcache.qq.com/qcloud/developer/images/release/column-icons/4.png","background":"","status":2,"creatorId":7053949,"memberCount":1,"articleCount":858,"followCount":46,"createdTime":1583819783,"creator":{"id":7053949,"uid":7053949,"name":"爱可生开源社区","label":"爱可生开源社区，一个有深度的数据库社区；更多技术分享可关注wx：爱可生开源社区","avatar":"https://developer.qcloudimg.com/http-save/10011/864a60182540ad4dc3f05f841a6b5130.jpg","province":"1081","city":"","company":"上海爱可生信息技术股份有限公司","title":"技术分享","school":"","major":"","homePage":"https://opensource.actionsky.com/","region":1,"jobType":1,"graduationDate":"","education":0,"specialityIds":[14827,15645,10537,16500,15009],"specialities":[],"gender":1,"trade":"","growthLevel":0,"isProfessionVerified":false,"upvoteCount":0,"followingCount":2,"followerCount":108,"questionCount":0,"answerCount":0,"followQuestionCount":0,"followTagCount":0,"favorAnswerCount":0,"beHandPickedCount":0,"followColumnCount":2,"articleCount":863,"validArticleCount":858}},{"id":78009,"name":"AustinDatabases","desc":"一个研究数据库，坚持不懈的小角色","icon":"https://imgcache.qq.com/qcloud/developer/images/release/column-icons/16.png","background":"https://imgcache.qq.com/qcloud/developer/images/release/column-bgs/5.svg","status":2,"creatorId":5669671,"memberCount":1,"articleCount":871,"followCount":58,"createdTime":1561093653,"creator":{"id":5669671,"uid":5669671,"name":"AustinDatabases","label":"一个热爱数据库的，还在往前走的琢磨着的小角色","avatar":"https://ask.qcloudimg.com/avatar/male/BJtgMyRZB_m.png","province":"","city":"","company":"某头部数据库公司","title":"数据库产品经理","school":"","major":"","homePage":"","region":1,"jobType":1,"graduationDate":"","education":0,"specialityIds":[10245,10252,10537,10249,10704],"specialities":[],"gender":1,"trade":"","growthLevel":0,"isProfessionVerified":false,"upvoteCount":0,"followingCount":3,"followerCount":119,"questionCount":0,"answerCount":0,"followQuestionCount":0,"followTagCount":0,"favorAnswerCount":0,"beHandPickedCount":0,"followColumnCount":2,"articleCount":869,"validArticleCount":869}},{"id":2127,"name":"杨建荣的学习笔记","desc":"公众号：jianrong-notes","icon":"https://ask.qcloudimg.com/column-icons/2127/1341391/2nbqxa8db1.jpg","background":"","status":2,"creatorId":1341391,"memberCount":2,"articleCount":1678,"followCount":251,"createdTime":1518158047,"creator":{"id":1341391,"uid":1341391,"name":"jeanron100","label":"《MySQL/Oracle DBA工作笔记》作者,专注于开源技术、运维自动化和性能调优, 公众号：jianrong-notes","avatar":"https://developer.qcloudimg.com/http-save/10011/f968a799e0a2404a9965c1d64cf7af2d.jpg","province":"1001","city":"","company":"竞技世界","title":"资深DBA","school":"对外经济贸易大学","major":"统计学","homePage":"https://blog.csdn.net/yangjianrong1985","region":1,"jobType":1,"graduationDate":"","education":0,"specialityIds":[10244,10247,10253,10245,10308],"specialities":[],"gender":1,"trade":"","growthLevel":0,"isProfessionVerified":true,"upvoteCount":0,"followingCount":2,"followerCount":223,"questionCount":0,"answerCount":0,"followQuestionCount":0,"followTagCount":0,"favorAnswerCount":0,"beHandPickedCount":0,"followColumnCount":3,"articleCount":1679,"validArticleCount":1678}}],"recommendedTags":[],"env":"production","documentBaseTitle":"腾讯云开发者社区-腾讯云","cdnDomain":"cloudcache.tencent-cloud.cn","cssDomain":"cloudcache.tencent-cloud.cn","qcloudDomain":"cloud.tencent.com","consoleDomain":"console.cloud.tencent.com","qcommunity_identify_id":"CxrbBNQR0MlfobM_bVPWL","session":{"isLogined":false,"isQcloudUser":false,"isOwner":false,"nickname":"","accountInfoCompleted":false,"phoneCompleted":false,"profile":{},"contactPhoneCompleted":false,"userInfo":{}},"pvId":"CMjs8tZtGCq-7k_KzSrye","userIp":"8.222.208.146","fromMiniProgram":false,"route":{"url":"/developer/tag/10245?entry=article","path":"/developer/tag/10245?entry=article","pathname":"/developer/tag/10245","search":"?entry=article","query":{"entry":"article"},"segments":["developer","tag","10245"]}}); </script><script class=""> if (!Element.prototype.matches) Element.prototype.matches = Element.prototype.msMatchesSelector || Element.prototype.webkitMatchesSelector; if (!Element.prototype.closest) Element.prototype.closest = function(s) { var el = this; if (!document.documentElement.contains(el)) return null; do { if (el.matches(s)) return el; el = el.parentElement; } while (el !== null); return null; }; window.addEventListener('mouseover', function(evt) { const target = evt.target; if (!target) { return; } const aEle = target.closest('a'); if (!aEle) { return; } let href = aEle.getAttribute('href'); if (!href) { return; } href = href.replace(/cloud.tencent.com.cn|cloud.tencent.com|cloud.tencent.cn/g, 'cloud.tencent.com'); aEle.setAttribute('href', href); }, true); </script></body></html>