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
Blog Posts
Making Better Presentations–Practice
This is part of a series of tips for speakers on how to make your presentations better.
There’s one thing that...
2014-10-06
849 reads
Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell
So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...
2014-10-06
725 reads
SQL Server Days 2014 – Slide deck
SQL Server Days 2014 is over, but it has been one great event. A very big thanks to the organizers!...
2014-10-06
517 reads
Thoughts on the Student to IT Pro Seminar
Miscellaneous notes as I think on this.
I’ve been reading through feedback from the students. Reading the raw feedback is interesting...
2014-10-06
771 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
SQL Server MVP for a Sixth Year
Thank you to the Microsoft MVP Program for awarding me MVP for six years running! I love this program and...
2014-10-05
435 reads
SQLSaturday 311, Sofia, October 11
Making last changes before sqlsat 311.
By the way, did you ever visited SQL Saturday? No? Why?
SQL Saturday is fun, SQL Saturday...
2014-10-05
643 reads
The Only Constant Is Change
In March of this year, I celebrated 10 years at Magenic. I blogged about it and called out values and...
2014-10-05
486 reads
October Omaha SQL Server User Group Meeting
We hope you have enjoyed your summer and are ready to get back to learning all things SQL Server related! We...
2014-10-04
552 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