A Fine Slice Of SQL Server
Matthew McGiffen has a query for us:
Some time ago I wrote a query store version of the “Top 20 queries” query that will produce a ranked list of your most expensive queries – and I’ve ended up using this a lot.
The only downside of using the DMVs for Query Store is that they are per database whereas dm_exec_query_stats is a view across the whole instance. So I had to use a cursor and a temp table, populating the temp table for each database in turn.
Click through for the query.
Comments closedTomaz Kastrun laughs at 24-day advent calendars:
In the last two days we have focused on understanding Apache Spark through performance tuning and through troubleshooting. Both require some deeper understanding of Spark and Azure Databricks, but gives also a great insight to all who will need to improve performance and work with Spark.
Today, I would like to list couple of additional Learning material, documentation and any other additional resources for further exploration on Azure Databricks.
Click through for links to additional resources on Apache Spark and Databricks, as well as the other 30 entries in the series.
Comments closedMarco Russo takes us through the evolution of a language:
Microsoft released 4 new DAX functions, and added 49 financial functions to DAX which correspond to identical Excel functions:
Read on for the summary of those changes, as well as additional important events for DAX and some of the stuff that Marco and Alberto have been working on throughout the year.
Comments closedPaul Turley continues a series on relationship modeling in Power BI:
So far, you’ve seen that the essential components of a data model include tables related to each other. Filtering records in one table prorogates the filter to related tables(s), causing records in the related table to be filtered. This dimensional model schema is the foundation of the reporting solution. Once the fact and dimension tables are in-place, you can create more advanced solutions by working outside of this standard relationship pattern.
Read on for the full story.
Comments closedShane O’Neill implements a linear backoff strategy:
Pushups are hard! Even when I’m not trying to rep out as many as I can, they still take a toll on the body. Soon a five-minute break is not enough, and I’m taking longer and longer rests.
Fine, if that’s the way we’re going to do this, then I’m going to go with the flow.
I can confirm that pushups are hard. Also, click through for a link to the backoff script.
Comments closedChris Webb answers a timeless question:
One question I get asked all the time is this:
Why don’t you add [insert feature idea here] to Power BI?
It’s sometimes followed up by one or more of the following comments:
It would be so easy for you to do
I can’t believe you haven’t done it already
Power BI is unusable without it
[insert competitor name here] has had this feature for years…and a real or virtual exasperated sigh.
Read on for the answer. This isn’t special to Power BI or even Microsoft—once you start to have customers with competing interests, these decisions get a lot harder.
Comments closedMikey Bronowski wants things to look just right:
Conditional formatting is important, however by default we change the look of the cells that have specific values. What about changing the entire row if a specific cell meets certain conditions?
Read on to see how.
Comments closedJess Pomfret shares a few Powershell tips:
My goal was to gain more stars than last year, which I succeeded at. I only got 6 total stars last year. Now my goal for next year will be to beat this year’s performance. I did learn several neat things while working on these puzzles and those I thought were worth sharing.
Read on for those things.
Comments closed