We cannot import multiple packages on the SSIS server. So, loading 100 packageS from file location will be a tedious task for a DBA. We can solve this issue by making use of the DTUTIL utility. The DTUTIL utility can also import one package at a time, but we can write the batch file using the […]
2021-09-27 (first published: 2021-09-22)
1,689 reads
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.
2020-06-30
6,549 reads
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
2020-01-30
10,311 reads
By Steve Jones
It’s the last T-SQL Tuesday of the year, and it’s amazing to think we’ve...
By Patrick
Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since...
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Comments posted to this topic are about the item The Hash Join III
Comments posted to this topic are about the item Continuous Learning
Comments posted to this topic are about the item Virtualizing GCP data by using...
In a hash join, if all the build input does not fit in memory, what type of hash join is this?
See possible answers