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,786 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
669 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,515 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,303 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,762 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
612 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,752 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,568 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,165 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,624 reads
Blogs
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
By gbargsley
Hello, dear blog reader. Today’s post is coming to you straight from the home...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers