SQL Server Configurations – Back to Basics
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
548 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would...
2018-01-11
548 reads
One thing that SQL Server does very well is come pre-configured in a lot of ways. These pre-configured settings would be called defaults. Having default settings is not a...
2018-01-11
22 reads
Conquering Challenges
I really like the topic of the TSQLTuesday party today. Today we have been instructed in no uncertain terms...
2018-01-19 (first published: 2018-01-10)
1,086 reads
The challenge at hand - conquering that technical problem and getting that high associated with the metaphorical high of summiting a tough task.
Related Posts:
Summiting that Technical Challenge Part II...
2018-01-10
9 reads
Once in a while I come across something that sounds fun or interesting and decide to dive a little deeper...
2018-01-06
567 reads
In this article I introduce you to some basics in regards to default behaviors and settings in tempdb along with some best practices. It is advisable to investigate from...
2018-01-06
36 reads
Every now and then I find a topic that seems to fit perfectly into the mold of the theme of...
2018-01-17 (first published: 2018-01-05)
1,512 reads
In this article I will explore altering the default logs directory location. Some may say this is no big deal and you can just use the default location used...
2018-01-05
53 reads
One of the all-time greatest and most beloved applications among DBAs happens to be Sharepoint. Most of us would be...
2018-01-04
1,669 reads
In this article I have introduced you to a quick session setup that comes from using the SPDiag tool that could plausibly be useful in the troubleshooting of various...
2018-01-04
66 reads
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,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
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