SSAS Tabular DirectQuery–No Hierarchies in Dimensions
I recently was testing DirectQuery to see the reporting differences in a Tabular Model. After Deploying to a development server...
2017-09-28
889 reads
Blog Posts
Thank You–#PASSElections
This week has been a whirlwind; as the results came in earlier this week on the election I wanted to...
2017-09-28
543 reads
Compañero Conference and SQL Modernization Roadshow
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to...
2017-09-27
561 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,238 reads
Error – Unable to retrieve child resources in Azure Storage Explorer
Hello friends, Please find the link of this article here – https://social.technet.microsoft.com/wiki/contents/articles/40188.error-unable-to-retrieve-child-resources-in-azure-storage-explorer.aspx
2017-09-27
903 reads
Hmmm… What’s This?
OK So, I am doing some digging and peaking around again in SQL Server and came across a database option...
2017-09-27 (first published: 2017-09-20)
2,055 reads
SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
462 reads
TSQL2sDay – Get-PostRoundup
First an apology, this round up is late!
The reason for that is an error in the PowerShell testing module Pester...
2017-09-27 (first published: 2017-09-20)
1,072 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on Unsplash
How many times have you known that adding an index would improve query performance but you weren't exactly sure which type of index to add?
This happened to me all the time...
2017-09-26
16 reads
Clustered vs Nonclustered: Index Fundamentals You Need To Know
Photo by Patrick Tomasso on UnsplashHow many times have you known that adding an index would improve query performance but you weren’t exactly sure which type of...
2017-09-26
1,959 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
Checking the Error Log III
If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?
See possible answers