Reason for Early Termination of Statement
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,069 reads
Wouldn’t you like to know why the optimizer stopped tuning the execution plan you’re looking at? It’s actually possible and...
2010-11-18
3,069 reads
The new book is available in a free download from Red Gate. I had a lot of fun working on...
2010-11-16
1,173 reads
After all the conversations at FreeCon last week (more on that later, when I’ve assimilated it better), I finally decided...
2010-11-15
533 reads
Or, another way to put it, in most cases, shooting yourself in the foot.
I was not aware that the cumulative...
2010-11-15
2,901 reads
Microsoft has announced changes to the MCM program. This page shows all the ways that you can become an MCM...
2010-11-12
1,339 reads
Today is Dr. Dewitt.
The ballroom, where the keynotes are held, is filled with extra chairs. The Summit organizers expect extra...
2010-11-11
797 reads
Today is Kilt Day at the PASS Summit. We’re going to try to arrange a group photo at lunch time.
The...
2010-11-10
788 reads
Sitting at the big kids table at the PASS Summit, ready to rock and roll. The Summit has not officially...
2010-11-09
671 reads
Mark Souza from the SQL CAT Team, some of the smartest & most capable of MS consultants in SQL Server, is...
2010-11-09
725 reads
Ted Kummert is still talking.
For the cloud, of course, they’re talking about SQL Azure. Microsoft really is throwing themselves into...
2010-11-09
685 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Comments posted to this topic are about the item Pay for Performance, which is...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
Comments posted to this topic are about the item 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