Happy Thanksgiving! (USA Holiday)
In the United States, today is Thanksgiving. The intent behind the holiday is to remember all that we have to be thankful. I have a lengthy list from friends...
2025-11-27
42 reads
Blog Posts
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...
2025-11-26 (first published: 2025-11-06)
521 reads
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
I mentioned this in my talk on Quantum Computing at the PASS Data Community Summit: Microsoft has announced that the post-quantum cryptography APIs are now generally available.
2025-11-26
321 reads
Query Intelligence in SQL Server 2025: What Developers Need to Know
When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental...
2025-11-26 (first published: 2025-11-05)
756 reads
The PASS Data Community Summit 2025 Recap
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...
2025-11-26
34 reads
SQL Server 2025 Generally Available
This was announced last week at Microsoft Ignite and it's been covered by others such as Brent Ozar, but if you haven't heard, SQL Server 2025 is now generally...
2025-11-25
219 reads
Check Power BI Bookmarks with Semantic Link Labs
Have you ever added a visual to a Power BI report page and published the updated report only to realize you forgot to adjust a related bookmark? It’s very...
2025-11-24 (first published: 2025-11-05)
235 reads
Finding and Killing Blockers with Redgate AI Tech
Redgate has a research arm, called the Foundry, that has been experimenting with AIs and DBA tasks. This post shows how GenAI tech can be helpful to DBAs in...
2025-11-24 (first published: 2025-11-05)
345 reads
Prepping for Certification, Part 2 of ?
The advantage of understanding the make-up of the exam: I can tailor my efforts for best results.
2025-11-24
40 reads
SQL Server 2016 End of Extended Support
Many organizations are still running SQL Server 2016 in production. Sadly, many are running versions older than 2016 as well, however with SQL Server 2016, the end of extended...
2025-11-24
90 reads
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