Tricks and Treats with XE
Halloween is a great time of year. It is unfortunate that it is just one day of the year. That...
2015-10-30
1,027 reads
SQL RNNR
Tricks and Treats with XE
With the proximity to Halloween, it's not hard (knowing me) to figure out why I originally decided to terminate this series on the Eve of Halloween day. Join me...
2015-10-30
10 reads
Default Sessions
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,113 reads
Default Sessions
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
53 reads
Azure SQL Database
So far I have strictly focused on Extended Events for SQL Server installations. This means I have been looking at Extended...
2015-10-28
768 reads
Azure SQL Database
What hasn't received any TLC is Extended Events from the Azure SQL Database perspective. You may be wondering why it matters since I just said that Extended Events is...
2015-10-28
14 reads
Exposure to Internals
For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the...
2015-10-27
602 reads
Exposure to Internals
The premise of the article today is to get a little exposure to some of the internals that may cause a bit of curiosity for you. I will share...
2015-10-27
9 reads
Short Circuit Events
I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading...
2015-10-26
628 reads
Short Circuit Events
The predicate order is critical. Having the wrong order can result in not trapping the desired events. I cover the critical nature of predicates in the aforementioned article. At...
2015-10-26
14 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
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
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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