Loading

摘要: Before starting our next teams session, I would like to confirm if you have fully meet the Prerequisites: https://learn.microsoft.com/en-us/sql/sql-se 阅读全文
posted @ 2022-12-22 21:01 Jas0n0ss 阅读(56) 评论(0) 推荐(0) 编辑
摘要: Prerequisites & environments | HostName | CPU & MEM | Role | OS | | : : | : : | : : | : : | | node1.io | 4Core 16GB | k8s master | centos7.8 | | node2 阅读全文
posted @ 2022-09-09 10:01 Jas0n0ss 阅读(68) 评论(0) 推荐(0) 编辑
摘要: [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 阅读(53) 评论(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 阅读(82) 评论(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 阅读(58) 评论(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 阅读(39) 评论(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 阅读(447) 评论(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 阅读(31) 评论(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 阅读(363) 评论(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 阅读(31) 评论(0) 推荐(0) 编辑