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 data
Exporting Data with PowerShell
Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]
2020-01-02
18,251 reads
Export data to an earlier SQL Server version
I have data in a SQL Server database that I need to get to an older version of SQL Server. I tried the backup and restore method, but received an error indicating that this wasn't allowed. I also tried to detach and attach the database, but that operation failed too. I understand that typical methods I use to move the database around don't work when I have to work with an earlier SQL Server version. What can I do to get the data out? This is a simple database and I want to spend a minimal amount of effort.
2012-05-10
3,518 reads
Blogs
WIT Mental Health and Wellness Videos Posted
By Steve Jones
I was honored to speak at the WIT Mental Health and Wellness day last...
Daily Coping 13 May 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell...
Forums
The Gift of Asking Stupid Questions
Comments posted to this topic are about the item The Gift of Asking Stupid...
Container Logs
Comments posted to this topic are about the item Container Logs
Azure SQL Database and SQL Managed Instance Security Best Practices
Hello, I have 7 different SQL Managed Instances which were newly migrated over from...
Ask SSC