MS SQL Server

Snapshot getting applied repeatedly

by

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

Power of Blockchain in SQL server

by

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

Msg 262: SHOWPLAN permission denied in database ‘SSISDB’

by

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

Data Anonymization Techniques in SQL Server

by

Data anonymization is the process of removing or modifying identifiable information from a database so that it cannot be linked back to an individual. In SQL Server, there are several techniques you can use to achieve data anonymization.

Read more

Data classification in SQL Server

by

Data classification in SQL Server is a way to organize and label data based on its sensitivity and the level of protection it requires. This labeling can be used to implement data security policies, access control rules, and compliance requirements for data protection regulations.

Read more

SQL Server Logshipping Error: 14421, Severity: 16, State: 1.

by

If you’re running log shipping in Microsoft SQL Server, you may encounter the Error: 14421, Severity: 16, State: 1.

Read more

SQL Server Mirroring Error 1418: The server network address “%.*ls” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational.

by

If you’re using database mirroring in Microsoft SQL Server. Encountering Error 1418, which signifies that the Principal and mirror server are unable to communicate is quite common.

Read more

Always On vs. Read Scale Availability Groups

by

In this article we will try to understand differences of SQL Server Always On Availability Groups vs. Read Scale Availability Groups. Designing HA/DR Solution and Customer’s Question: Recently, we were working on designing SQL Server HA/DR database solution for one of our customer. After considering customer’s requirement, we suggested a multi subnet three node Always … Read more

Failed to execute IS server package because of error 0x80131904

by

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

Find if backup is encrypted or not.

by

In this blog post we will demonstrate on steps to check if the backup file in sql server is encrypted or not.