Importing Excel files into SQL Server, Azure Edition
How to Use Azure Functions to insert Excel Files into an Azure SQL Database.
Planning for Change
Change is inevitable, so Steve says we ought to plan, and prepare, for things to be different in the future.
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.
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.
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.
PostgreSQL 19 Is Late
Steve notes that PostgreSQL 19 is late, but the reasons and implications extend to other platforms, and really, all other software.
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.
Take the 2027 State of the Database Landscape Survey
Share your view on the database landscape and you could win USD$500.
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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