Using Power Query to Combine Data from Multiple Sheets in Excel
This article employs Power Query features to combine queries and implement requirements in different listed scenarios.
2023-08-07
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)
909 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
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers