SSMS Tools Pack – Script Grid Results
Most of us like things that make our lives easier. When they’re free, it’s just that much sweeter. I would...
2011-02-13
1,606 reads
Examining PFS, GAM and SGAM pages
Anyone who can interpret data and index pages will surely think about interpreting PFS, GAM and SGAM pages. I am...
2011-02-13
5,650 reads
I travel, I work, I EAT
As most of you know I am a consultant with Pragmatic Works, which requires me to travel a bit. During...
2011-02-12
670 reads
Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs
I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM...
2011-02-12
867 reads
Get Well Trevor – Call to action!
Tim Ford, SQL MVP and all around Good Guy, has been having a really hard time so far in 2011....
2011-02-12
584 reads
Can You Dig It? – Find Estimated Cost
She can dig it!
D Sharon PruittIt’s the eighth post in the plan cache series. I hadn’t expect to take as...
2011-02-11
914 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs. I’m not arguing whether or not NULLs in a...
2011-02-11
15 reads
A NULL Is Not Unknown
Like it or not, NULLs happen. I don’t think that’s I’ve ever seen a production database that didn’t have NULLs.
Waiter,...
2011-02-11
885 reads
T-SQL Tuesday Topics – Feb 2011
I was looking for a static list of all the T-SQL Tuesday topics and couldn’t find one. The domain moves...
2011-02-11
900 reads
Un-SQL Friday #003: Show Some Love
Last week, I asked the Twitter hive-mind about its favorite tech companies: “Which SQL (or SQL-adjacent) tech companies are doing...
2011-02-11
515 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