Importing Excel files into SQL Server, Azure Edition
How to Use Azure Functions to insert Excel Files into an Azure SQL Database.
2026-11-04
2,048 reads
How to Use Azure Functions to insert Excel Files into an Azure SQL Database.
2026-11-04
2,048 reads
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
2023-08-07
The Excel (365) "LET" formula below will return a formatted SQL Values Table "T1" that can be pasted into SSMS.
2022-04-06 (first published: 2022-03-29)
1,025 reads
In this article we look at PowerShell code you can use to import Excel data into SQL Server.
2021-01-05
In this article we look at how to export data from different SQL Server tables or queries into multiple Excel sheets in the same file.
2020-12-07
Learn how to format your SQL Server results in Excel using conditional formatting to quickly identify patterns and issues.
2020-03-10
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers