Why is my SQL Server using all of the RAM on the server?
The TL;DR on this is simple:
"BECAUSE IT'S SUPPOSED TO!"
A frequent complaint we receive comes from a client that has an...
2016-01-14 (first published: 2016-01-08)
7,751 reads
Transaction Logging & Recovery (part 2)
Transaction Logging & Recovery (part 2)
… Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server:...
2016-01-08
447 reads
Trace Flag 3226 - Suppress all successful backups in SQL server error log
SQL server error log contain all information about how a SQL server is running, what is happening and occurring for...
2016-01-13 (first published: 2016-01-08)
22,432 reads
Transaction Logging & Recovery (part 2)
... Continuation of some notes regarding the excellent content by Paul Randal in Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-08
326 reads
Alter Event Session
Altering an Extended Event session is not necessarily a difficult task, but it is a very useful ability. Having this basic skill in your wheelhouse can be very positive...
2016-01-08
25 reads
Alter Event Session
Ready for a change of pace? Good! Today is a really good time to start looking into one of the...
2016-01-13 (first published: 2016-01-08)
2,535 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
890 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about the documented API. What I mean by documented is...
2016-01-07
9 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
34 reads
What is SSDT? Part 3 - an API for me, an API for you, an API for everyone!
In the final part of this 3 part series on what SSDT actually is I am going to talk about...
2016-01-07
55 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