Change Data Capture known as CDC records that DML (insert, update, delete) action is performed on a table of a database. These changes are recorded in a corresponding table that is created. Through systemic functions we can... read more
How to replicate tables from Oracle Database to SQL Server using GoldenGate
In this article we will see how we can copy table records from Oracle Database that is on Unix to SQL Server that is on Windows using Oracle GoldenGate. What is GoldenGate Oracle GoldenGate… read more
How can we connect SQL Server to Oracle Database using Linked Server
SQL Server enables us to be able to connect and execute queries on remote Database Instances that do not have to be in the same RDBMS. In this article we will see specifically how it is done by instance... read more
How do I connect to SQL Server when I can't connect any other way (DAC, lost password, missing sysadmin)
Sometimes we will not be able to connect to the SQL Server Instance even as a sysadmin user, either because of a problem with the instance, or because we have forgotten the password of the sysadmin user or we do not have/know... read more
How do we find what features each SQL Server instance has?
In this article we will see a query that I have made so that we can easily find the specs of each SQL Server instance. This query can be run in any version without needing any conversion as... read more
How can we get email whenever an error occurs in SQL Server Error Log
In an instance of SQL Server, potential problems that occur are recorded in a place called the Error Log. However, it would be very useful for us if any important error appeared in the Error Log, SQL Server forwarded it to us... read more
How to setup a SQL Server Always On Availability Group for High Availability
Microsoft provides us with the ability to Replicate our databases as a Group on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery or even for reading without the Primary Node being occupied. THE… read more
How do we create a Group Managed Service in Active Directory to pick up the SQL Server service without using a password
In SQL Server, we must change the user that "starts" the SQL Server service from the Windows default to someone with specific rights that belongs to the Active Directory Domain. In this article we will see how we can… read more
What is Always On Availability Group
The Always On Availability Group is the feature provided by Microsoft in SQL Server to Replicate our bases on up to eight Secondary Nodes (servers) as a solution for High Availability, Disaster Recovery and for reading... read more
