A Fine Slice Of SQL Server
Joe Obbish resolves a specific type of plan cache issue involving shared temp tables:
The problem can be observed with a simple repro script. The child stored procedure performs a series of updates on a temp table. The parent procedure creates the temp table, calls the child stored procedure, and returns data from the temp table.
Click through to see an example of the issue, as well as one technique to mitigate the problem.
Comments closedJana Sattainathan gets things backwards and then forwards:
In the case of this app, I just did “Select All” within the app and moved all the videos over to “Photos”. When I downloaded the content to my computer, I noticed that it downloaded the most recently downloaded video first and the oldest video last. This meant the file names given to the videos were in reverse order of chronological order.
Read on to see how you can use Powershell to sort this all out.
Comments closedSoheil Bakhshi certifies the quality of this Power BI content:
In the previous post, we discussed that a Power BI administrator must enable certification and grant sufficient rights to the security groups. Therefore, all members of the specified security group are authorised to certify the content. If you are a Power BI administrator, follow these steps to do so:
This post is a step-by-step guide to enabling content certification, as well as how to certify specific types of content.
Comments closedImke Feldmann shorts out a firewall issue:
Formula.Firewall issues can hit you when designing your queries or even “out of the blue” when suddenly refreshes in the service are failing due to changes in the query evaluation.
You will find a lot of methods published on the internet which are good and cover different scenarios. But there is also a very quick fix method that I learned from Miguel Escobar that I want to demonstrate in this post. This will basically circumvent the data privacy level, so make sure that you understand the implications (risk of data leakage from one source to another). If not, please read Miguels article first!
After reading Miguel’s post, read on for a fix.
Comments closedUst Oldfield sneaks in a file:
File seeding is a useful way of maintaining and deploying static, or very slowly changing, reference data for a data model to use repeatably and reliably across environments, whilst benefitting from source control.
If you aren’t in the Databricks world, this also feels like a job for DVC.
Comments closedLiliam Leme provides an answer to a common Synapse Spark pool question:
I’ve been reviewing customer questions centered around “Have I tried using MSSparkUtils to solve the problem?”
One of the questions asked was how to share results between notebooks. Every time you hit “run” in a notebook, it starts a new Spark cluster which means that each notebook would be using different sessions. Making it impossible to share results between executions of notebooks. MSSparkUtils offers a solution to handle this exact scenario.
Read on to see what MSSparkUtils is and how it helps in this case.
Comments closedTomaz Kastrun continues an advent series on Azure ML:
MLFlow is an open-source framework for registering, managing and tracking machine learning models. It is multiplatform, bringing consistent model training and model consumption across different platforms. This means, that training a model locally and uploading it to Azure or training a model on remote compute instances and downloading it, is a great feature for MLflow.
You can use MLflow with Azure CLI, Azure Python SDK or in the studio and it will deliver a consistent experience (note, some functionalities are limited to the language).
Click through for a quick overview of MLflow.
Comments closedPower BI is not only a cloud-based reporting technology. Due to the demand for some businesses to have their data and reporting solutions on-premises, Power BI also has the option to be deployed fully on-premises. Power BI on-premises hosting is called Power BI Report Server. This post concerns using Power BI in a fully on-premises solution with Power BI Report Server.
This post will teach you everything you need about the on-premises world of Power BI. You will learn how to install Power BI Report Server, learn all requirements and configurations for the Power BI Report Server to work correctly, and see all the pros and cons of this solution. At the end of this post, you will be able to decide if Power BI on-premises is the right choice for you, and if it is, then you will be able to set a Power BI on-premises solution up and running easily.
I used Power BI Report Server for a few years. My short version is that it’s really useful if you aren’t allowed to use Power BI Online (as was my case) but if you know what’s in the Online version, you’ll see just how much you’re missing out on.
Comments closedMarco Russo troubleshoots an issue:
There are cases where the dictionary size reported by VertiPaq Analyzer (used by DAX Studio, Bravo for Power BI, and Tabular Editor 3) does not correspond to the actual memory required by the dictionary. However, the number reported is technically correct because it represents the memory currently allocated for the dictionary. The issue is that – after a refresh – this memory amount is larger than the actual memory required for hash-encoded columns.
Read on to learn what the consequences are and how you can resolve this in Power BI Desktop as well as in Analysis Services.
Comments closedCross-database ownership chaining is a SQL Server security feature allowing database users access to other database objects hosted on the same SQL server instance, in the case where database users don’t have access granted explicitly
Tom shows us whether it is on as well as how to enable it. I’d recommend not enabling it at all and using module signing instead.
Comments closed