SQL Bits 2025 Wrap
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend, with lots of friends, a family atmosphere, and some amazing speakers from whom I learn...
2025-06-22
51 reads
Blog Posts
A New Word: Lackout
lackout – n. the sudden awareness that you’re finally over someone, noticing that the same voice that once triggered a cocktail of emotions now evokes nothing at all –...
2025-06-21
46 reads
Simplify Kubernetes Security With Kyverno and OPA Gatekeeper
Here’s how these tools can make Kubernetes security easier and help you avoid common pitfalls.Image from haalkab on Pixabay.Kubernetes is hands-down the go-to tool for managing containerized applications, yet it...
2025-06-21
75 reads
Cyber Scams and Operation Shamrock
Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East conference on cyber scams. How bad is it? Well, according to the Internet Crime Complaint...
2025-06-20 (first published: 2025-06-06)
343 reads
Delta Lake over Spark Connect
All Spark Connect Posts
I have just finished an update for the spark connect dotnet lib that contains the DeltaTable implementation so that we can now use .NET to maintain...
2025-06-20
67 reads
Easily query your GitHub Contribution activity
For a variety of reasons, including your Microsoft MVP activity reports, you might want to summarize your GitHub activity across multiple repos. For contributors to Microsoft open-source docs on GitHub,...
2025-06-20 (first published: 2025-06-05)
334 reads
Generating Random Strings with GenAI
One of the things I’ve been experimenting with in AI is taking things other people do and seeing how well the AI works. In this case, I took a...
2025-06-20
38 reads
Heading to SQL Bits 2025
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day of the conference. I wasn’t selected to speak, but since I’m in Cambridge next week...
2025-06-20
35 reads
Introducing FabricTools (PowerShell module)
🔍 The Challenge: DevOps for Microsoft Fabric In the world of Microsoft Fabric, DevOps is still maturing. Unlike Azure Data Factory (ADF), which has been around long enough to...
2025-06-20
61 reads
Build a C++ Pipeline with Docker, GitHub Actions, Azure ACR and Azure App Service
In today’s Software Development Life Cycle (SDLC), having a robust build pipeline is very important for ensuring that there is a smooth deployment and maintainable code quality. Building a...
2025-06-19
112 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