DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,791 reads
Rayis Imayev
- Website: http://datanrg.blogspot.com/
Power BI with Narrative Science: Look Who's Talking (Part 3: On or Off premises)
[2017-May-08] Listening to a car radio with many different talk shows available, it comes more often to my mind, that...
2017-05-08
683 reads
SSIS Web Service Task: misleading role of WSDL file
[2017-Mar-31] You can call one of your web service methods in SSIS package using a .NET script task or you can just...
2017-03-31
3,521 reads
External SQL files vs. Stored procedures in SSIS development
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,332 reads
How to compare two SSAS databases with a custom MDX query
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,772 reads
Open Data is like a soup
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
617 reads
Power BI with Narrative Science: Look Who's Talking (Part 2: Predicting the Future)
[2016-Oct-18] I read a book one time about the importance of using visual aids in teaching. They also used a well...
2016-10-28 (first published: 2016-10-18)
1,754 reads
Historical Reports vs. Predictive analytics: Rear view mirror look vs. Forward-looking view. Really?
[2016-Sep-30] Working with reports based on historical data is like driving a car while looking in the rear view mirror. I heard...
2016-09-30
1,582 reads
Power BI with Narrative Science: Look Who's Talking?
[2016-Aug-31] Someone said a picture is worth a thousand words and this is true that in most cases a visual representation...
2016-08-31
1,169 reads
Power BI: If you have a Cloud of Words, let them Fly!
[2016-July-31] Last week was my 2nd time participating at the local Toronto Open Data meetup (https://www.meetup.com/opentoronto/). The audience of this meetup...
2016-08-02 (first published: 2016-07-31)
2,639 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers