Trace Query in Extended Events
The ability to quickly and easily trace a query is important to database professionals. This script provides one useful alternative to trace a specific spid similar to the method...
2020-01-28
11 reads
SQL RNNR
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM...
2020-02-03 (first published: 2020-01-23)
247 reads
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM...
2020-01-23
19 reads
Coping with Self Doubt
One of the best coping mechanisms for Impostor Syndrome is the use of learned behaviors. This article shares some of these coping mechanisms and learned behaviors.
Related Posts:
Passion, Challenges, and...
2020-01-28 (first published: 2020-01-14)
647 reads
Coping with Self Doubt
One of the best coping mechanisms for Impostor Syndrome is the use of learned behaviors. This article shares some of these coping mechanisms and learned behaviors.
Related Posts:
Passion, Challenges, and...
2020-01-14
11 reads
PowerShell to Backup XE Session
Working with Extended Events will help you become a better DBA. Working with PoSh can also help you in many various tasks to become a better DBA. Combine the...
2020-01-20 (first published: 2020-01-10)
285 reads
PowerShell to Backup XE Session
Working with Extended Events will help you become a better DBA. Working with PoSh can also help you in many various tasks to become a better DBA. Combine the...
2020-01-10
8 reads
Unicode, Emojis and Databases Oh My!
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
297 reads
Unicode, Emojis and Databases Oh My!
Explore an easy method to create a table of all unicode (and emoji) characters to store within your database environment. This easy solution can save you a significant amount...
2020-01-06
10 reads
Creative XE Sessions – Funky Data
Playing around with emojis in a database is a fun endeavor. Not only is it fun to play with for personal growth, but it does have some business advantages.
Related...
2020-01-04
129 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