Top 3 Easy Help Queries for XEvents in Azure SQL
These are a few simple queries to help you along your way to becoming better acquainted w/ XEvents in Azure SQL. These queries will make XEvents easier for you!
The...
2021-01-04
28 reads
Blog Posts
What A Year That Was
If anything, 2020 is an asterisk. Some lost their jobs. Some lost their loved ones. Perhaps more books will be written about it. Pundits will keep the conversation going....
2021-01-04
39 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
27 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
24 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
15 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
37 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
26 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
14 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
19 reads
How to Find SQL Server Configuration Manager
SSCM likes to disappear from time to time. When it does, what is your backup plan? This article shows how not to be fooled by the vanishing act of...
2021-01-03
14 reads
Blogs
SQL Server Problems You Can Reproduce, Measure and Fix: A Free Demo Library
I built a free library of runnable SQL Server demos. Each reproduces a real...
Experimenting with CHOOSE: #SQLNewBlogger
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
Forums
Managed Instance vs Azure Database - is this a good option?
We're currently in Azure, however as we had a very tight migration timeline when...
MERGE in a nested TRY/CATCH won't roll back
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Perfermance result aftet purge operatio
Hello everyone, I am planning to implement a data purging solution that is expected...
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers