As we have seen in an earlier article for the easiest way to access data in databases we use indexes and statistics. Indexes are essentially an index that helps us find what we are looking for faster. But as... read more
How can we perform backups and other Agent jobs in an Always On Availability Group of SQL Server
In this article we will see how to take backups and run jobs on any server that has the Primary role or is a Preferred Backup Replica in an Always On Availability Group of SQL Server. While installing… read more
How do we find what queries are currently running in SQL Server?
Many times we will need to quickly find out what queries are running in an instance of SQL Server. In this article we will see a query that I have written that can directly extract all the information we need. The query retrieves… read more
How do we automate the database backup process in SQL Server without using a maintenance plan
In this article we will see the easiest and most efficient way to backup all instance databases. We will do this using the DatabaseBackup procedure created by Ola Hallengren. Of course… read more
What is Change Data Capture (CDC) and how is it enabled in SQL Server
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
