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,891 reads
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
In this article we look at how we can use R and SQL Server to import lottery numbers from a PDF document into a SQL Server table.
2021-01-11
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
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,909 reads
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Comments posted to this topic are about the item Multiple Deployment Processes
Comments posted to this topic are about the item How to Use sqlpackage to...
Comments posted to this topic are about the item Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers