sql - 随笔分类 - stswordman

Tutorial: Add a node to SQL cluster on RHEL

摘要：https://sqlserverbang.blogspot.com/2020/08/tutorial-add-node-to-sql-cluster-on-rhel.html 阅读全文

posted @ 2020-08-17 06:08 stswordman 阅读(168) 评论(1) 推荐(0) 编辑

Failed to restart Polybase Data Movement service after running sp_polybase_join_group

摘要：https://sqlserver.code.blog/2020/01/22/failed-to-restart-polybase-data-movement-after-running-sp_polybase_join_group/ 阅读全文

posted @ 2020-01-23 05:18 stswordman 阅读(265) 评论(0) 推荐(0) 编辑

Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)

摘要：https://sqlserver.code.blog/2019/12/18/realcase-failed-to-upgrade-sql-server-2016-sp2-cu11-installation-success-or-error-status-1648/ 阅读全文

posted @ 2019-12-18 11:40 stswordman 阅读(306) 评论(0) 推荐(0) 编辑

Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps

摘要：https://sqlserver.code.blog/2019/12/14/connect-sql-server-from-linux-client-using-windows-authentication-and-troubleshoot-steps/ 阅读全文

posted @ 2019-12-14 09:50 stswordman 阅读(263) 评论(0) 推荐(0) 编辑

Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’

摘要：https://sqlserver.code.blog/2019/12/10/different-ag-groups-have-the-exactly-same-group_id-value-if-the-group-names-are-same-and-the-cluster_type-exter 阅读全文

posted @ 2019-12-11 07:14 stswordman 阅读(189) 评论(0) 推荐(0) 编辑

An example of polybase for Oracle

摘要：https://sqlserver.code.blog/2019/12/09/an-example-of-polybase-for-oracle/ 阅读全文

posted @ 2019-12-09 14:50 stswordman 阅读(300) 评论(0) 推荐(0) 编辑

use azure data studio to create external table for oracle

摘要：https://sqlserver.code.blog/2019/12/06/use-azure-data-studio-to-create-external-table-for-oracle-server/ 阅读全文

posted @ 2019-12-06 14:32 stswordman 阅读(359) 评论(0) 推荐(0) 编辑

Missing MSI and MSP files

摘要：https://sqlserver.code.blog/2019/11/26/missing-msi-and-msp-files/ 阅读全文

posted @ 2019-11-27 05:55 stswordman 阅读(244) 评论(0) 推荐(0) 编辑

You may fail to backup log or restore log after TDE certification/key rotation.

摘要：https://sqlserver.code.blog/2019/11/25/you-may-fail-to-backup-log-or-restore-log-after-tde-certification-key-rotation/ 阅读全文

posted @ 2019-11-26 06:54 stswordman 阅读(213) 评论(0) 推荐(0) 编辑

Password is required when adding a database to AG group if the database has a master key

摘要：https://sqlserver.code.blog/2019/11/25/password-required-when-you-trying-to-add-a-database-having-a-master-key-to-ag-group/ 阅读全文

posted @ 2019-11-26 00:53 stswordman 阅读(298) 评论(0) 推荐(0) 编辑

Use KTPASS instead of adden to configure mssql.keytab

摘要：https://sqlserver.code.blog/2019/11/23/use-ktpass-instead-of-adden-to-configure-mssql-keytab/ 阅读全文

posted @ 2019-11-23 13:17 stswordman 阅读(271) 评论(0) 推荐(0) 编辑

Failed to run 'create login' or 'sp_addsrvrolemeber' in sql Linux using windows authentcation

摘要：Error 15404 ‘Could not obtain information about Windows NT group/user ‘%ls’, error code 0x80090304′ 阅读全文

posted @ 2019-11-23 10:07 stswordman 阅读(223) 评论(0) 推荐(0) 编辑

Sql Server Linux(Redhat) Distributed Availability Group Setup — step by step

摘要：https://sqlserver.code.blog/2019/11/14/sql-server-linuxredhat-distributed-availability-group-setup-step-by-step/ 阅读全文

posted @ 2019-11-17 08:50 stswordman 阅读(174) 评论(0) 推荐(0) 编辑

Example of SQL Linux Windows Authentication configuration using Managed Service Accounts

摘要：https://sqlserver.code.blog/2019/11/13/example-of-sql-linux-windows-authentication-configuration-using-managed-service-accounts/ 阅读全文

posted @ 2019-11-17 08:46 stswordman 阅读(186) 评论(0) 推荐(0) 编辑

FILESTREAM feature can't be enabled if you use cluster shared volumes

摘要：Create a SQL Cluster instance. Create Cluster Shared Volume Please note. No Share storage is added into SQL Server. Open SQL Server configuration mana 阅读全文

posted @ 2019-02-22 03:29 stswordman 阅读(422) 评论(0) 推荐(0) 编辑

SQL Server does not purge row versioning records even the transaction are committed if there are other open transaction running in the databases with read-committed snapshot enabled .

摘要：This is a by-design behavior. There is only one allocation unit in tempdb that istracking the versioned records across the server. Cleanup of this all 阅读全文

posted @ 2019-02-22 02:19 stswordman 阅读(171) 评论(0) 推荐(0) 编辑

“The subscription does not exist” when a distributor primary replica fails over to a replica that does not use the same agent profile

摘要：Symptoms  Consider the following scenario: In Microsoft SQL Server 2017, 阅读全文

posted @ 2019-02-09 05:36 stswordman 阅读(484) 评论(0) 推荐(0) 编辑

The thumbprint of same asymmetric key is not same in 'SQL Server Connector for Microsoft Azure Key Vault' 1.0.4.0 and 'SQL Server Connector for Microsoft Azure Key

摘要：https://support.microsoft.com/en-us/help/4470999/db-backup-problems-to-sql-server-connector-for-azure-1-0-5-0 A breaking change has been introduced in 阅读全文

posted @ 2019-01-26 03:37 stswordman 阅读(601) 评论(0) 推荐(0) 编辑

在SQL Server 2017 中，当Alwasyon group启用了DTC_SUPPORT = PER_DB, 会导致无法创建replicaiton.

摘要：当Alwasyon group启用了DTC_SUPPORT = PER_DB, 会导致无法创建replicaiton.无法修改已经存在的replication. 原因：当当Alwasyon group启用了DTC_SUPPORT = PER_DB,任何对于DMV的查询都被认为是'user xact 阅读全文

posted @ 2018-02-27 04:43 stswordman 阅读(560) 评论(2) 推荐(1) 编辑

Use Dynamic Data Masking to obfuscate your sensitive data

摘要：Data privacy is a major concern today for any organization that manages sensitive data or personally identifiable information (PII). Examples of such 阅读全文

posted @ 2017-04-28 05:11 stswordman 阅读(563) 评论(0) 推荐(1) 编辑

随笔分类 - sql