Can you query a SSAS cube while it is processing?
I have always wondered if queries against a SSAS cube while it is processing would be forced to wait the...
2011-06-29
2,611 reads
SQLDIY: Tracking Space Usage At the Index Level
I am a fan of information, the more the merrier. Anytime I’m tasked with tracking a production server over the...
2011-06-29
1,440 reads
Understanding Benchmarks
That Means What?
Vizzini: HE DIDN’T FALL? INCONCEIVABLE.
Inigo Montoya: You keep using that word. I do not think it means...
2011-06-29
2,126 reads
Energy Efficient Offices
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation...
2011-06-29
894 reads
New Connect Item – TDE
Does the certificate matter for TDE? Apparently not as I found a number of people discussing the fact that the...
2011-06-29
1,194 reads
Cleaner T-SQL with Table Value Constructors
Table Value Constructors were introduced in SQL Server 2008 and enables you to (not only) insert more records with one...
2011-06-29
992 reads
A Lost Day
I’m not sure what happened, but I had some sort of stomach bug yesterday. I was up throughout the night...
2011-06-28
876 reads
Getting Ahead and Getting Involved
I spend a little time on AskSSC (that is the question and answer section on http://www.sqlservercentral.com). Quite often the question...
2011-06-28
889 reads
Pain of the Week: Understanding Your Indexes
Want to take a few minutes out of your day on to learn a bit more about indexes? On Thursday,...
2011-06-28
897 reads
Miss SQLBits 8? No problem, all videos are online
OK, since this conference in is England, it’s a little harder to get to compared to TechEd. No matter, all...
2011-06-28
883 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