My 2015 SQL Events
It’s the first day of the year 2016 and I’m thinking about all the SQL events I attended in 2015.
SQL Sat...
2016-01-01
546 reads
Filtering Logged Data
Explore how to customize the view of the GUI for working with XEvent Log files or XEL files. This further customization does include working with filters.
Related Posts:
Get a List...
2016-01-01
31 reads
Filtering Logged Data
Over the course of the past couple of articles, I have shown some interesting if not useful functionality in the...
2016-01-07 (first published: 2016-01-01)
1,232 reads
Fun with Operator Precedence
Let’s have some fun with operator precedence today. Specifically, logical operator precedence. Specifically, how is it evaluated when your where clause...
2016-01-06 (first published: 2015-12-31)
2,820 reads
Customize the XEvent Log Display
Explore how to configure the XEvents GUI with specific views to suit your needs and tastes for data display by adding, removing or changing the column orders.
Related Posts:
Easy Open...
2015-12-31
16 reads
Customize the XEvent Log Display
In the previous article I showed a couple of methods to merge Extended Event Log files. In that article I...
2015-12-31
1,032 reads
SQL Recovery Software: An Ultimate Tool For SQL Database Recovery
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some reasons like virus infection, improper closing of the Server,...
2015-12-31
30 reads
SQL Recovery Software: An Ultimate Tool For SQL Database Recovery
SQL Server is a database management system which enables to store and retrieve data from the database. Due to some...
2015-12-31
1,407 reads
Delivering workshop at SQLBits XV
Sometimes one receives amazing gifts at the most unexpected moment. I was beyond thrilled to find out that I was...
2015-12-30
839 reads
Getting Started with R Visuals in Power BI
Thanks to the December 2015 update released for Power BI, we can now use R to visualize our data in...
2016-01-05 (first published: 2015-12-30)
4,916 reads
Blogs
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...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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