Is That Database in Use?
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Monitor Database Offline Events November 15, 2018
Audit Logons...
2019-07-03
20 reads
Is That Database in Use?
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Related Posts:
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
976 reads
Performance Tuning Steps a Query by looking an execution plan and effectiveness of the index creation Part-1
The index is very important and powerful object...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
2019-07-03
197 reads
Chaos engineering for SQL Server running on AKS using KubeInvaders
A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...
2019-07-26 (first published: 2019-07-03)
472 reads
2019-07-02
10 reads
2019-07-02
7 reads
T-SQL Tuesday #116 Invitation – SQL on Linux
Ever since Microsoft said SQL would run on Linux, I was excited. Finally, all the Linux administrators I had worked with could be quiet and the Oracle DBAs that...
2019-07-02
15 reads
Join a List of Values
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Finding Data...
2019-07-02
35 reads
Join a List of Values
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
Related Posts:
Correlate Trace...
2019-07-18 (first published: 2019-07-02)
686 reads
Behind the Scenes: How I Create Weekly Technical Videos
Be sure to watch this week’s video to get the full behind the scenes experience! Today I want to share my process for blogging and making weekly YouTube videos....
2019-07-19 (first published: 2019-07-02)
394 reads
Blogs
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
The flight recorder: Replaying what an AI agent did on my SQL Server
By Arun Sirpal
“What exactly did it do on my server?” is the first question a DBA...
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications
The Hidden Security Risks of Role Combination in SSAS Tabular
Comments posted to this topic are about the item The Hidden Security Risks of...
The Empty Aggregate
Comments posted to this topic are about the item The Empty Aggregate
Question of the Day
The Empty Aggregate
I have this table in a SQL Server 2025 database:
CREATE TABLE [dbo].[CustomerOrder] ( [OrderID] [int] NULL, [CustomerID] [int] NULL, [total] [money] NULL ) ON [PRIMARY] GOWhat is returned from this code? (answers are for the sum and then the count)
SELECT SUM(total) AS sum,
COUNT(total) AS count
FROM dbo.CustomerOrder;
See possible answers