Data can be kept in different media, Sometimes, the data need to be extracted, transformed or loaded in different ways.
For this article, I'm going to demonstrate some of the popular ways of importing Excel data into MS SQL Server.
This article guides you in finding the user, process and host, which produced too many transactions filling the transaction log and preventing you from shrinking it.