Impersonation can give you the wrong answer
I use impersonation all the time to let me see additional permissions information I can only get that way and,...
2016-02-08
481 reads
I use impersonation all the time to let me see additional permissions information I can only get that way and,...
2016-02-08
481 reads
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”,...
2016-02-08
13 reads
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading this and thinking “crap, I’m not a BI person!”,...
2016-02-08
25 reads
Hello everyone and welcome to this month’s T-SQL Tuesday. This month’s topic is all about Power BI! If you’re reading...
2016-02-08
585 reads
SQL CREATE TABLEThe CREATE TABLE statement is used to create a table in a database to stored data.Tables are organized...
2016-02-08
209 reads
SQL BasicsAn instruction to a database to combine data from more than one table.A SQL join combines records from two or more...
2016-02-08
945 reads
Transaction logs are split into VLFs which affects performance. How large are yours and what does that mean for you?
2016-02-08
100 reads
Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files...
2016-02-08
812 reads
.Net CLI is the new tooling that sits in front of .Net Core, allowing you to create and run projects...
2016-02-07
56 reads
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective technical communities such as SQL, .NET and ALM and...
2016-02-07
28 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