August 07, 2020 https://sqlserverbang.blogspot.com/2020/08/tutorial-create-sql-fci-on-rhel.html
Author: Liwei
My name is Liwei, I joined Microsoft in 2011. Currently I am a SQL Server Support Escalation engineer.
How to find SQL Server Replication related jobs and T-SQL statements
Hi Guys, I run into issue with this ‘Open Live Writer’. So I start a new blog. I’ll repost the articles back after the tool is available.… Read more “How to find SQL Server Replication related jobs and T-SQL statements”
Log records of update statement
Compared to insert and delete statement, the update statement creates more log records, even more than you expected. I’m going to use fn_dblog to show you HOW… Read more “Log records of update statement”
Realcase:SQL Server Alwayson diagnostics log is not created.
SQL Server Alwayson diagnostics log is a useful tool to troubleshoot SQL Server Alwayson related issue. It saves the result of stored procedure system stored procedure sp_server_diagnostics… Read more “Realcase:SQL Server Alwayson diagnostics log is not created.”
DBCC Stackdump–new feature
Since SQL 2019 CU2, you can use DBCC Stackdump to create mini, filtered, full dump directly without using trace flag. Here are samples: DBCC STACKDUMP WITH MINI_DUMP… Read more “DBCC Stackdump–new feature”
Create a hybrid Distributed Availability group Between SQL Windows and SQL Linux
This article describes how to create a SQL Server Distributed Availability Group (AG) for high availability on RHEL 7.6 and SQL Windows 2016. Here is the topology… Read more “Create a hybrid Distributed Availability group Between SQL Windows and SQL Linux”
Failed to restart Polybase Data Movement service after running sp_polybase_join_group
If you have a SQL Server 2019 named instance with Polybase feature, you may fail to restart the PolyBase Data movement service after running the sp_polybase_join_group. You… Read more “Failed to restart Polybase Data Movement service after running sp_polybase_join_group”
Failed to create ‘CREATE EXTERNAL DATA SOURCE’
Let’s say you have a SQL Server 2019 installed in Windows server. The Windows server is not in domain, and you are connecting SQL Server using windows… Read more “Failed to create ‘CREATE EXTERNAL DATA SOURCE’”
SQL Server 