stswordman - 博客园

2019年11月17日

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 阅读 (6) 评论 (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 阅读 (7) 评论 (0) 编辑

2019年2月22日

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 阅读 (97) 评论 (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 阅读 (36) 评论 (0) 编辑

2019年2月9日

“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 阅读 (96) 评论 (0) 编辑

2019年1月26日

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 阅读 (135) 评论 (0) 编辑

2018年2月27日

在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 阅读 (222) 评论 (2) 编辑

2017年12月28日

CDC在sql server 2017中无法使用的问题

摘要：Symptom sp_MScdc_capture_job in the CDC job raised error message Msg 217, Level 16, State 1, Procedure msdb.dbo.sp_cdc_sqlagent_log_jobhistory, Line 1 阅读全文

posted @ 2017-12-28 02:47 stswordman 阅读 (201) 评论 (0) 编辑

2017年4月28日

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 阅读 (285) 评论 (0) 编辑

2016年1月11日

将数据库备份到AZURE blob storage

摘要：1创建一个Storage Account1)点击Browse->Storage accounts2) 填写Storage account，请记住这个名字，之后创建credential需要用到。3)点击Create。一般等待一段时间就好了2 创建container1)All resources->B... 阅读全文

posted @ 2016-01-11 09:31 stswordman 阅读 (561) 评论 (0) 编辑