PASSMN Meeting Later Today
Well folks, we’re already to the third Tuesday of June. Where’s the summer going to? That means that this afternoon...
2011-06-21
713 reads
Index Rebuild progress v2
I have actually written about this subject earlier on my Danish blog (http://www.performanceduo.com/post/Index-Rebuild-progress.aspx), but last week when working on a...
2011-06-21
18,111 reads
New York SQL Events - Upcoming Triple Play......
If you're in a New York State of Mind (song by Billy Joel), then you'll like the triple play of...
2011-06-21
1,348 reads
A Tale of Two Sandy Bridge Laptops
I recently bought a new teaching and presentation laptop, which is a Toshiba Portege R835-P55X, which I found at the...
2011-06-21
958 reads
Rebuild all the Indexes of a SQL Database in one go
Introduction
In my last post, I had explained what could be the best value of Fill Factor for the indexes in...
2011-06-20
5,429 reads
Miss TechEd 2011? No problem, all videos are online
While nothing beats going to a conference, the next best thing is to watch the recorded sessions. Fortunately, Microsoft has...
2011-06-20
835 reads
T-SQL Formatting Workaround (Word Macro)
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-20
1,581 reads
Double Hop of Doom
I recently had to battle through THE DOUBLE HOP OF DOOOOOMMM!! It was a very rewarding experience and I think...
2011-06-20
4,437 reads
Indexes Aren’t Always the Answer
There’s a tendency to think all problems can be solved with an index or two (or partitions, or other performance...
2011-06-20
991 reads
Evaluating Sessions You Attend
I have seen more than a few posts about feedback that speakers get from sessions in the last couple months....
2011-06-20
1,439 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