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
1,821 reads
Articles
Migrate a VLDB with SQL Server Log Shipping
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, “we need your help.” We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
2026-11-04
Troubleshooting Slow Queries That Already Have an Index
This article looks at some common query patterns that cause performance issues and provides some guidance on how to fix them.
2026-11-02
2,586 reads
What I learned after a weekend of AI troubleshooting gone wrong (8 key lessons)
Grant Fritchey walks through a real troubleshooting saga – using Wine, a shim DLL, a misconfigured registry entry, and a lot of trial and error – to get a BridgeCom Maverick radio’s Windows CPS running on Linux Mint.
2026-11-02
Calculating Weighted Average in Power BI
Learn how you can add a weighted average to your Power BI Calculations, a function that is not built into DAX.
2026-10-30
1,452 reads
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
2026-10-30 (first published: 2026-09-28)
Why your schema shouldn’t mirror your database (and what to do instead)
In this guide, learn all about GraphQL: what it is, how it works, the problems it solves, and how to design the perfect schema – one that holds up as systems keep changing.
2026-10-30
MiniMax m3 and SQL Server
Learn how you can download and run a local model to help with your SQL Server work.
2026-10-26
3,074 reads
Strip double quotes from an import file in Integration Services SSIS
When loading data using SQL Server Integration Services (SSIS) to import data from a CSV file, every single one of the columns in the CSV file has double quotes around the data. When using the Data Flow Task to import the data I have double quotes around all of the imported data. How can I import the data and remove the double quotes?
2026-10-26
PostgreSQL in action with Opensearch
Learn about using Opensearch with PostgreSQL to improve performance and quickly return results to your users.
2026-10-23
1,593 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers