SQL Server allows us to read and import files at will without the use of SSIS (Integration Services) and Wizard packages. This process is done using the OPENROWSET function and the BULK INSERT. We can… 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 can we schedule a Job in Azure SQL Database using Logic App
Let's say that every day we would like to send by email a report from the result of a query in a database. This process in SQL Server is done using SQL Server Agent and Database… read more
