Deprecation, Trace and Execution Plans
As I’m sure you know, Microsoft occasionally changes it’s mind. Or, it makes bad decisions and then rectifies them. Or,...
2011-01-21
895 reads
Grant Fritchey
- Twitter: @https://twitter.com/gfritchey
- Website: https://scarydba.com
- LinkedIn: https://www.linkedin.com/in/grant-fritchey/
- Bluesky: https://bsky.app/profile/gfritchey.bsky.social
DBA 101: Why is my log file full?
This question comes up constantly in different venues. I see it sometimes 2-3 times a day on SQL Server Central....
2011-01-18
2,683 reads
Failed Blog Posts
Over the last week I’ve started and trashed two blog posts. Let me tell you, that’s painful. You get some...
2011-01-14
738 reads
TSQL Tuesday: Resolutions
Sounds like a good action adventure movie. The theme this month on TSQL Tuesday, thanks to our host, Jen McCown...
2011-01-11
1,013 reads
Encryption and the Performance DMOs
Ever wonder what you can see in the performance oriented DMOs when stored procedures were encrypted? Me neither. But, I...
2011-01-05
609 reads
My Review of SeV Revolution Jacket
Originally submitted at SCOTTEVEST, Inc.
26 Pockets are perfect for everyday and travel items; includes the TravelSmartSystem?. The SCOTTEVEST revolution began...
2011-01-05
1,655 reads
Temporary Post Used For Theme Detection (7152665d-114f-4469-a816-6ca6880e832a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (95b57a7c-aa49-471e-a63c-76ea6775d1d4 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-01-04
527 reads
PASS Summit 2010 Survey Results
As I have done in previous years, I’m going to post the results from my sessions at the PASS Summit....
2010-12-23
805 reads
The iPad/SQL Monitor Results
I ended up with 131 posts (1 late hit, sorry), not counting any duplicates with Brent or Steve. It was...
2010-12-20
892 reads
The iPad, So Far
In the front yard, using the iPad & SQL Monitor
After a great deal of unseemly begging, I managed to acquire an...
2010-12-15
910 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
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