SQL Server Setup Error – There was an error generating the XML document. Error code 0x84B10001.

Error: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt If we look at the start place of the error, it says System.Security.Cryptography.CryptographicException. This means that there are some issues while encryption of the data. And the real error message is “The requested operation cannot be completed. The computer must be trusted for delegation and the current user account... » read more

0
Read
echiang
Transactional Replication vs Availability Groups

Transactional Replication  Configuration is not that easy. Replication is always table level. Lot of maintenance work. There is a latency and latency may increase in busy system. Need to configure it for each table. Not a high availability option.You can use it as a DR strategy.  AlwaysOn High Availability and Disaster recovery strategy.Built on top of Windows Failover Clustering... » read more

0
Read
echiang
SQL Server AlwaysOn

SQL Server AlwaysOn provides a high-availability and Disaster-recovery solution for SQL Server. An availability group supports one set of primary databases and one to eight sets of corresponding secondary databases. Each set of availability database is hosted by an availability replica. Two types of availability replicas exist: a single primary replica. which hosts the primary databases, and one... » read more

0
Read
echiang
ALLOW_PAGE_LOCKS

ALLOW_PAGE_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether page locks are allowed. The default is ON. ONPage locks are allowed when accessing the index. The Database Engine determines when page locks are used. OFFPage locks are not used.

0
Read
echiang
ALLOW_ROW_LOCKS

ALLOW_ROW_LOCKS = { ON | OFF }Applies to: SQL Server 2008 through SQL Server 2017. Specifies whether row locks are allowed. The default is ON. ONRow locks are allowed when accessing the index. The Database Engine determines when row locks are used. OFFRow locks are not used.

0
Read
echiang
IGNORE_DUP_KEY

IGNORE_DUP_KEY = { ON | OFF }Specifies the response type when an insert operation attempts to insert duplicate key values into a unique index. The IGNORE_DUP_KEY option applies only to insert operations after the index is created or rebuilt. The option has no effect when executing CREATE INDEX, ALTER INDEX, or UPDATE. The default is OFF. ONA warning message occurs when duplicate... » read more

0
Read
echiang
STATISTICS_NORECOMPUTE

STATISTICS_NORECOMPUTE = { ON | OFF }Specifies whether statistics are recomputed. The default is OFF. ONOut-of-date statistics are not automatically recomputed. OFFAutomatic statistics updating are enabled. The general recommendation to leave auto-update stats turned on (STATISTICS_NORECOMPUTE = OFF, which is the default) is for safety reasons, because if this is turned off and nothing is manually updating the stats,... » read more

0
Read
echiang