SQL Server

Código de error: 22903, texto: “Ya hay otra conexión ejecutando ‘sp_replcmds’ para la captura de datos modificados en la base de datos actual.”

by

Recientemente me enfrenté a un escenario muy interesante en el que para una base de datos se habilitaban tanto la captura de datos modificados como la replicación transaccional. Según la documentación de MS, ambas funciones pueden funcionar juntas, pero debemos tener algunas cosas en cuenta al implementar ambas funciones juntas en una base de datos. En … Read more

PowerShell to export data from a SQL Server table to csv in chunk of 15 days

by

A client had a table which was storing data since 11 years, and he wanted to export all that data into csv files in a chunk of 15 days data per csv file. So I developed a PowerShell script to do the same. Hope it helps in different scenarios.

TSQL to get all logins’ permissions

by

We had a request from one customer where he wanted to have a visual representation of all the logins present in the SQL instance and the kind of server lever and database level permissions they have in one result set. I searched the net for solutions but could either find a script that gave either … Read more

T-SQL Script to list foreign key relationships

by

In this article, we will see T-SQL scripts to list foreign key relationships between tables. What is Referential dependency ? Referential dependency is a constraint between two tables in a relational database that ensures data consistency. To establish a referential dependency, you define a foreign key on a table that refers to the primary key … Read more

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

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