A Fine Slice Of SQL Server
Dany Hoter combines Azure Data Explorer and a new feature in Power BI:
Field parameters are a new feature in Power BI as of the May version.
With field parameters you can give the consumer of a report a lot of flexibility about the content of the report, what fields are used in the visuals, what time granularity is used and what measures are displayed.
All this without writing any DAX or M code.
Click through for an example of how this works.
Comments closedErik Darling speaks with wisdom:
The more people want to avoid fixing what’s really wrong with their server, the more they go out and find all the weird stuff that they can blame on something else (usually the product), or keep doing the same things that aren’t fixing the problem.
Spinlocks are one of those things. People will measure them, stare them, Google them, and have no idea what to make of them, all while being sure there’s something going on with them.
I don’t want to discount when spinlocks can actually cause a problem, but you shouldn’t treat every performance problem like it’s a bridge too far from what you can solve.
I have seen performance problems which actually did come down to spinlock issues. For every one of those, I’ve seen, oh, about 95-100 or so which came down to inefficient code.
Comments closedGilbert Quevauvilliers figures out how field parameters work:
In this blog post I want to give a visual representation as to how field parameters works and what the current limitations are.
It is important to be aware of the limitations so that you do not get caught out later or you are trying to figure out why it is not working.
I do hope my descriptions and pictures below help you understand how it works and when it does not work!
Click through for some detailed graphics and explanation.
Comments closedRayis Imayev is slinging JSON:
Requirements:
1. Sourcing data comes from a SQL Server database
2. The destination is a PostgreSQL database table
3. Transformation logic is to aggregate several rows from a sourcing table and populate the resulting JSON structured document into a single row JSONB type column
Read on for Rayis’s notes.
Comments closed