MDX+SSRS #34 – Query not returning results: there are good reasons
When we are learning MDX, we unavoidably have to deal with the tools we use. Adding confusions about the behaviors...
2013-11-10
3,042 reads
MDX #32 – Vincent Rainardi’s blog
I came across Vincent Rainardi’s blog, and thought I’d share it with the readers.
Sherry Li and Tomislav’s 2012 MDX Cook...
2013-10-24
912 reads
SQL #51 – Timeout when updating a big table
A co-worker recently asked me why she would get timeout when updating a column in a big table. This column...
2013-10-24
16,743 reads
SQL #52 – set statistics xml on
When tuning SQL queries, I find that I use the following three SET options quite often.
set showplan_xml on
When showplan_xml...
2013-10-24
1,867 reads
MDX+SSRS #31– Query Designer in SSRS only allows the Measures dimension in the first axis
In Chapter 1 of the book MDX with SSAS 2012 Cookbook, in the first recipe “Putting data on x and...
2013-10-03 (first published: 2013-09-28)
4,138 reads
MDX #30 – Get The Book: MDX with SSAS 2012 Cookbook
MDX with SSAS 2012 Cookbook
by Sherry Li and Tomislav Piasevoli
Packt Publishing 2013
The book is now available in both paperback...
2013-09-22
1,399 reads
SQL #50–Deleting or updating data from a table of 20+ GB
I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a...
2013-09-22
5,038 reads
MDX #29–Co-authored MDX with SSAS 2012 Cookbook
I have been absent from this blog for the last few months. For those who have noticed, I’d like to...
2013-08-29
871 reads
MDX #28– Time functions will not work with subquery
I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with...
2013-03-22
1,244 reads
MDX #27–Who are Ascendants?
Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often use in...
2013-03-02
2,453 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