Ravi Agarwal Recently I was faced with an interesting issue where upon rerunning distributor agent, complete snapshot was being applied even though we had got “snapshot has been delivered successfully” message. The activity was about adding newly created tables into the replication. Below were high level steps followed for the activity. After step 5, once we got … Read more
In SQL server 2022, MS introduced a new feature in the area of security , called Ledger. SQL server ledger makes data temper-evident through cryptography which enables organizations to confirm if their data is 100% trusted or if it has been tempered with. This feature uses are power of blockchain yet avoid the complexity and … Read more
Recently I got a interesting issue where I was getting error ‘SHOWPLAN permission denied in database ‘SSISDB” even though I was having SYSADMIN permissions on the SQL instance. This is in continuation of previous article https://wordsontech.com/failed-to-execute-is-server-package-because-of-error-0x80131904/ I was trying to get estimated exeution plan for the stored procedure “internal.cleanup_server_retention_window” using the show estimated execution plan … Read more
Recently I faced an issue where SQL agent jobs executing SSIS packages were failing with error: “Failed to execute IS server package because of error 0x80131904. Description: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.” As per above error message it is evident that … Read more
In this blog post we will demonstrate on steps to check if the backup file in sql server is encrypted or not.
Recently I faced an issue where secondary replica was showing as disconnected in always on availability group. Below troubleshooting was done to fix the issue. In summary, DBA should ensure to update endpoint URLs in availability group configuration if server’s domain is changed to avoid any issue. This does not require a downtime . Hope … Read more
Hi All, Recently I faced an issue while trying to update the certificate used for SQL server connection encryption. When I updated the thumbprint value of certificate in following registry key and restarted SQL services I got below error. Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\MSSQLServer\SuperSocketNetLib\Certificate Error Message: I checked and verified that SQL server service account … Read more
In this article we will setup the lab environment using Oracle Virtual Box and install Ubuntu operating system followed by installation of SQL Server 2022 on Ubuntu. Step-1: Install Oracle Virtual Box Kindly download Oracle Virtual Box package as per your operating system from https://www.virtualbox.org/wiki/Downloads and install it. Kindly also install Virtual Box guest additions … Read more
Continuing to previous post link, where I explained the reason of CDC capture job failure for a database enabled in transactional replication with remote distributor; here I would like to discuss the scenario of enabling change data capture for a database with local distributor. In this article we will discuss about interoperatibility of SQL server … Read more
Recently I faced very interesting scenario where for a database both change data capture and transactional replication was enabled. As per MS documentation, both features can work together but we need to keep few things in mind while implementing both features together on a database. Coming to my case, although change data capture job was … Read more