Power BI Monthly Digest – October 2018
In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through...
2018-10-15
489 reads
Regular Expressions: tagging expressions
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
384 reads
Generic Modifier In & Out C#
In [Contravariant]The image is self-explanatory.
Out [Covarient]The image is self-explanatory.
2018-10-15
73 reads
SQL Pivot and Unpivot relational operatots
In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose...
2018-10-15
276 reads
Using Extended Events to Capture Implicit Conversions
Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices....
2018-10-24 (first published: 2018-10-15)
1,813 reads
Presenting at the SQL Server PASS Detroit User Group in November
In or around Detroit? Come see my Getting Started with Machine Learning session at the Detroit PASS User Group, Thursday, November 8th at 6 PM. Power Point [8MB] Demo...
2018-10-15
38 reads
Highlighting sp_spaceused
I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick...
2018-10-15
234 reads
How does data file size relate to log file size?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-10-15
211 reads
How much affects encryption to your database performance?
Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups...
2018-10-15
262 reads
Generic Modifier In & Out C#
In [Contravariant]
The image is self-explanatory.
Out [Covarient]
The image is self-explanatory.
2018-10-15
241 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