Extended Events File Initialization Failure
It should come as no surprise that I write a lot of articles about Extended Events (XE). This happens to...
2018-03-21 (first published: 2018-03-09)
5,964 reads
SQL RNNR
Extended Events File Initialization Failure
One of the recommended methods to trap payload data in an XE session is via the use of the event_file target. Sending data to a file has numerous benefits...
2018-03-09
60 reads
Profiler for Extended Events: Quick Settings
Not long ago, I wrote a rather long article about a new-ish feature within SQL Server Management Studio (SSMS) that...
2018-03-15 (first published: 2018-03-05)
1,868 reads
Profiler for Extended Events: Quick Settings
As of SSMS 17.4 we have been given the ability to control XEvents Profiler just a tiny bit more. For what it is worth, we as Database Professionals love...
2018-03-05
28 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is...
2018-01-24
536 reads
SQL Server User Already Exists – Back to Basics
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse...
2018-01-24
36 reads
Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is...
2018-01-18
1,020 reads
Database Corruption and IO Errors
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users...
2018-01-18
20 reads
Checking the Health of your CLR
The Common Language Runtime (CLR) is the fundamental nerve center of the Microsoft .NET Framework. It is this nerve center that...
2018-01-16
1,033 reads
Checking the Health of your CLR
Having a tool to be able to monitor CLR health will be essential as you deploy more and more managed code within SQL Server. Extended Events offers a great...
2018-01-16
33 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
Alamat Telp BCA KCP Poris Indah (+62) 838-4945-0961
Wa:083849450961 Ruko Poris Indah, Komp, Jl. Poris Indah Blok K No. 2-3, RT.003/RW.003, Cipondoh...
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