Identifying large queries using Extended Events
Following on from my last blog post I now want to run through how to identify large queries using Extended...
2014-10-06 (first published: 2014-10-01)
12,227 reads
Intro to Auditing in SQL Server on SQL Shack
I had an article published yesterday on http://www.SQLShack.com.
Intro to Auditing in SQL Server.
It’s worth reading if I do say...
2014-10-01
1,231 reads
Track My Query Utility
Were you ever in a situation where you ran a query, it ran for a long time and you didn’t...
2014-10-06 (first published: 2014-10-01)
7,576 reads
Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling
If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential...
2014-10-01
880 reads
Error while enabling NetFx3 feature || Alternate source path error
Hello Friends,
Life Is a struggle with Lot of If and buts. It’s being a many month I was out of...
2014-10-01
1,301 reads
PASS 24HOP AlwaysOn Questions Answered
I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event. You...
2014-09-30
1,261 reads
I Must Be Doing Something Right – MVP Award
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.
For...
2014-09-30
961 reads
I Must Be Doing Something Right – MVP Award
I am extremely excited to announce that I have just received the Microsoft MVP award for SQL Server for 2014.
For...
2014-09-30
905 reads
PASS Voting Extended Until October 14th
The Board of Directors has extended voting in the current election through October 14th. Read the post from President Thomas...
2014-10-07 (first published: 2014-09-30)
6,159 reads
Speaking at Space Coast SQL Users Group on October 10th, 2014
I’ll be driving to Viera for the monthly Space Coast SQL Users Group meeting next week. Topic still to be...
2014-09-30
1,018 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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