Export SQL Server Data to Excel and Add New Columns with C#
Learn how to export data from SQL Server into Excel and programmatically add new columns to the spreadsheet using C#.
2021-04-13
export
Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules
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
4,474 reads
Export/Import Data using BCP - SQL Server on Linux
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
5,274 reads
Blogs
Using SQL Compare for One Procedure
By Steve Jones
A customer recently was concerned about the time to run SQL Compare for a...
Daily Coping 11 June 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Azure SQL Database – Secondary Database and Tiers
By Arun Sirpal
On the theme of failover groups let’s do a quick recap on my environment....
Forums
Tracking, Privacy, and Lots of Data
Comments posted to this topic are about the item Tracking, Privacy, and Lots of...
CU 24 patching issue.
We are having an issue applying CU24 patches on SQL 2017. The version of...
what condition case when related to portion key mean ?
I work on sql server 2012 I don't understand condition below do this condition...
Ask SSC