As a SQL database administrator, it’s your responsibility to maintain and secure the databases. However, you may still experience database corruption. If not handled correctly and on time, you...
2021-05-24
5,886 reads
On Tuesday I'm looking forward to presenting again at GroupBy Americas on a topic that was voted on by the attending public. This presentation "SQL Server Admin Best Practices...
2021-05-24
54 reads
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
15 reads
Where I’ve Been Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot...
2021-05-22
36 reads
I get asked this question all the time, so I figured it was time to write a blog post, record a video and write some code to automate the...
2021-06-09 (first published: 2021-05-22)
327 reads
Here is a short but sweet post on how to change the drive letter of a partition. Despite using my best Google skills I couldn’t find an example that...
2021-06-07 (first published: 2021-05-21)
383 reads
(last updated: 2021-05-31 @ 19:00 EST / 2021-05-31 @ 23:00 UTC ) Many of us that work with Microsoft SQL Server, especially those of us working on systems with...
2021-05-21
233 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-05-21
29 reads
That’s how someone described a Tesla recently, talking about how the software keeps changing. I had watched a few videos after I stumbled on this one: That got me...
2021-05-31 (first published: 2021-05-20)
419 reads
Have you ever opened the SQL Server Error Log and wondered, “where are all the errors?” Digging through the Error Log to find what you need can be a...
2021-06-02 (first published: 2021-05-20)
918 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
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
Comments posted to this topic are about the item Planning for Change
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