Loading

摘要: [root@linux ~]# egrep -i "dns1|domain" /etc/sysconfig/network-scripts/ifcfg-eth0 DNS1=192.168.2.50 DOMAIN='sqlrepro.edu' [root@linux ~]# cat /etc/reso 阅读全文
posted @ 2022-09-01 11:07 Jas0n0ss 阅读(56) 评论(0) 推荐(0) 编辑
摘要: Linux client login windows SQL Server with keytab https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-active-directory-authentication?view=sql 阅读全文
posted @ 2022-08-15 17:30 Jas0n0ss 阅读(92) 评论(0) 推荐(0) 编辑
摘要: Pre-Work linux should join AD same as SQL Server setspn on windows SQL Server for linux Windows SQL Server C:\Users\Administrator>setspn -L sqladmin R 阅读全文
posted @ 2022-08-15 16:02 Jas0n0ss 阅读(65) 评论(0) 推荐(0) 编辑
摘要: 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 阅读(45) 评论(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 阅读(485) 评论(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 阅读(35) 评论(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 阅读(461) 评论(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 阅读(34) 评论(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 阅读(150) 评论(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 阅读(105) 评论(0) 推荐(0) 编辑