Loading

摘要: Reference https://adamtheautomator.com/samba-active-directory/ Server: root@ad:~# cat /etc/resolv.conf search hubo.io nameserver 10.157.17.12 root@ad: 阅读全文
posted @ 2022-08-15 15:46 Jas0n0ss 阅读(92) 评论(0) 推荐(0)
摘要: reference https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15 查询数据库索引碎片超过30%的表,然后重建 阅读全文
posted @ 2022-07-28 09:49 Jas0n0ss 阅读(536) 评论(0) 推荐(0)
摘要: [root@azk8s-oc sqlmi]# head sql1-linux.yaml apiVersion: v1 data: username: c3FsYWRtaW4K password: SHVhd2VpMTIjMjMK kind: Secret metadata: name: sql1-l 阅读全文
posted @ 2022-07-22 16:28 Jas0n0ss 阅读(49) 评论(0) 推荐(0)
摘要: CPU最佳实践。 根据CPU架构和核数配置MaxDop. https://learn.microsoft.com/zh-CN/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-co 阅读全文
posted @ 2022-07-07 10:44 Jas0n0ss 阅读(593) 评论(0) 推荐(0)
摘要: Create Azure Arc-enabled sqlmi instance using OpenShift tool Microsoft official doc reference https://docs.microsoft.com/en-us/azure/azure-arc/data/cr 阅读全文
posted @ 2022-06-30 16:20 Jas0n0ss 阅读(46) 评论(0) 推荐(0)
摘要: reference https://docs.microsoft.com/en-us/azure/azure-arc/data/create-sql-managed-instance-using-kubernetes-native-tools issue encountered: failed to 阅读全文
posted @ 2022-06-22 10:18 Jas0n0ss 阅读(165) 评论(0) 推荐(0)
摘要: Microsoft Troubleshooting Guide Common reasons for a full transaction log: The appropriate response to a full transaction log depends on what conditio 阅读全文
posted @ 2022-06-16 09:03 Jas0n0ss 阅读(119) 评论(0) 推荐(0)
摘要: Azure data controller Setup https://docs.microsoft.com/en-us/azure/azure-arc/data/create-data-controller-direct-cli?tabs=windows create resources grou 阅读全文
posted @ 2022-06-11 13:41 Jas0n0ss 阅读(10) 评论(0) 推荐(0)
摘要: 修改某个数据库的文件存储位置 reference https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases?view=sql-server-ver16 -- relocate dat 阅读全文
posted @ 2022-06-08 09:57 Jas0n0ss 阅读(1391) 评论(0) 推荐(0)
摘要: 前提条件 创建自动化账户 添加运行方式账户 在自动化账户添加runner(如如下脚本) Param ( [Parameter(Mandatory=$true)][ValidateNotNullOrEmpty()] [String] $AzSubscriptionId, [Parameter(Mand 阅读全文
posted @ 2022-04-19 16:06 Jas0n0ss 阅读(79) 评论(0) 推荐(0)