SQL Server XQuery Against Execution Plans
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,051 reads
One of the greatest things about all the DMOs is how you can combine the information they present to you...
2011-10-25
2,051 reads
If I could win the DBA In Space contest, I’d be all over it like white on rice. But I...
2011-10-24
1,467 reads
I’ve been working quite a bit over the last week or so with extended events in Denali. The sheer magnitude...
2011-10-17
1,899 reads
Another Summit done gone by and I’m exhausted. You know you did the Summit correctly if you’re crawling onto the...
2011-10-17
1,448 reads
And we’re off. We opened with a video of people saying “Connect, Share, Learn” and “This, is Community”
Rob Farley & Buck...
2011-10-14
1,345 reads
Bill Graziano has come out on stage, looking marvelous, in a traditional kilt and stockings. Thanks Bill.
For those who don’t...
2011-10-13
1,101 reads
This is Day 2 of the Summit proper. But for me, this is the fifth day of the Summit and...
2011-10-13
1,020 reads
Hello again. The PASS Organization has once more allowed me to sit at the bloggers table for the key note....
2011-10-12
995 reads
I’m working on updating my book, Query Performance Tuning Distilled, so that it reflects the new things available in SQL...
2011-10-05
1,825 reads
No, I’m not talking about hubs and switches. I’m talking about people. Networking is a major component of an event...
2011-10-03
1,158 reads
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
By James Serra
(This is the second post in a three-part series on how AI is changing...
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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