I like Extended Events and I regularly use the Session Properties window to create and explore sessions. I’m in the window all the time, noting it’s quirks & odd...
2022-03-02 (first published: 2022-02-15)
232 reads
I recently got an update from the SQL Monitor PM on the progress we’ve made across all the teams. We have a number focusing on different aspects of the...
2022-02-14
51 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...
2022-02-14
35 reads
Today I’m talking about Extent Management in SQL Server, because this is a very important topic, especially when you deal with TempDb in SQL Server. On a very high...
2022-02-28 (first published: 2022-02-14)
644 reads
A look at the sessions I'll be presenting at SQL Bits 2022 in London this year. Excited to return to a great conference and hope to see you...
2022-02-11
60 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...
2022-02-11
55 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...
2022-02-10
48 reads
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-10
31 reads
This is one of those things that when I look back on it seems really obvious. Note: If at the ... Continue reading
2022-02-25 (first published: 2022-02-10)
757 reads
If you have used MySQL before you will know about the system server variables, you know such commands as SHOW VARIABLES; You can access most of them via the...
2022-02-10
66 reads
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Hello everyone, I am planning to implement a data purging solution that is expected...
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers