New answers tagged

0 votes
Accepted

Always on high availability groups option is grayed out

You cant do that. From Microsoft documentation: Prior to SQL Server 2017, and Windows Server 2016, the instance had to reside on a Windows Server Failover Cluster (WSFC) node to enable the Always On ...
  • 948
0 votes

Capturing datetime of change in SQL Server CDC

Inspired by Gareth's answer, here's a shorter version. This doesn't use DECLARE which is great if you need to create a VIEW (DECLARE isn't allowed in VIEW) SELECT sys.fn_cdc_map_lsn_to_time(__$...
  • 9
0 votes

Syncing data between onprem and Azure SQL

Keep in Mind that Azure Data Sync Does not accept computed columns in the tables involved in the data sync!

Top 50 recent answers are included