In the article we will see an easy and quick way to see which databases are in use and which users are currently connected to them. To see when a database was last accessed in... read more
How can we run multiple SQL Scripts in SQL Server from within Windows with batch script
In this article we will see an easy way to be able to run SQL Scripts en masse in SQL Server with batch script and keep the results for each separately in CSV. The example Suppose we have… read more
How to replicate tables from SQL Server to Oracle Database using GoldenGate
In a previous article we saw how we can replicate tables from Oracle Database to SQL Server using GoldenGate. In this article we will see how we can do the reverse from SQL Server to… read more
How do we enable auditing in SQL Server?
In this article we will see the steps and options we have to enable the database auditing specification in SQL Server. Through the database auditing specification we can record who accesses and how... read more
How we set an Azure Storage Account as a Cloud Witness in Windows Failover Cluster Quorum
When we install a Windows Failover Cluster on Windows Server and we want to have automatic failover, we need to define a Witness. Witness's job is to communicate with both sites and in case any… read more
How do we add a database that has TDE Encryption enabled to a SQL Server Always On Availability Group?
In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How can we get emails whenever syncing to SQL Server via Oracle GoldenGate is having problem
When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
How to migrate a SQL Server database to Azure using Data Migration Assistant
Many times we will need to migrate databases to a newer version or move them to Azure. In such a transfer there is a possibility that some components are not compatible and need corrections before we start the migration. The tool… read more
How can we export daily data from SQL Server to Excel and email it
In the daily operations of companies it is often necessary to extract daily data from the database and give it to an Excel. In these Excels we usually want to have some specific name along with a date and to… read more
