A Fine Slice Of SQL Server
Sandeep Pawar distributes PDFs like candy:
With the proposed solution below, you will be able to :
- Export a Power BI report, or a page of a report or a specific visual from any page as a PDF, PNG, PPTX or other supported file formats
- Apply report level filters before exporting
- Automate the extracts on a schedule
- Save the exported reports to specific folders
- Grant access to individual folders in the Lakehouse
Click through for the solution.
Leave a CommentErik Darling doesn’t focus on logical reads:
To summarize the video a little bit:
- High average or total logical reads isn’t a guarantee that a query is slow
- Looking for high average CPU and duration queries is a better metric
- You may see logical reads go up or down as you make queries faster
- For I/O bound workloads, you’re better off looking for queries with a lot of physical reads
I agree with Erik. Disk has gotten so much faster, especially if you’re on all-flash arrays or (even better) direct attached nVME storage. Even relatively old SSDs are still a couple orders of magnitude faster than the spinning rust we typically dealt with 15 years ago.
Sometimes, the faster query is one that requires more logical reads. APPLY-based queries typically fall into that category: I might have 10x as many logical reads but the query takes half the time (or less) to finish using a similar percentage reduction of CPU time.
Leave a CommentI finish up a series on GitHub:
In this video, I show off some of the GitHub Advanced Security functionality available to open-source public repositories, and describe what you can get with GitHub Enterprise Cloud.
It’s been fun going through various features in GitHub, but next week, I’ll start a brand new series.
Leave a CommentMartin Schoombee continues a series on orchestration in Azure Data Factory:
Before we dive into the details of the Data Factory pipelines, it is worth explaining the conceptual structure of my framework and its components. How it all fits together is important, and after reading the post on the metadata as well the pieces of the puzzle will hopefully start falling into place.
When I started thinking about what I’d like the framework to do, three conceptual layers started to emerge and we’ll review them from the bottom up:
Click through for the description of each layer.
Leave a CommentThe NDepend Blog has an interesting post on Visual Studio:
Notice that there are two distinct questions:
- Will Visual Studio Be Migrated to .NET Core? (but still remain Windows-centric).
- Will Visual Studio Be Multi-Platform?
Disclaimer: For nearly two decades, I’ve been the creator and lead developer of NDepend, a tool that functions both as a Visual Studio extension and a standalone app that can collaborate with VSCode and JetBrains Rider. NDepend also integrates into CI/CD pipelines to deliver interactive web reports on .NET code quality and security. We’ve collaborated with many Visual Studio engineers over the years, who have provided invaluable assistance, though we have no insider information. This post is based purely on observable facts and speculations derived from them.
Read on for those thoughts. My money’s on “No” for the latter, as that’s the purview of Visual Studio Code, and just thinking about the sheer amount of work necessary to make Visual Studio itself cross-platform, I can’t see it happening.
Leave a CommentGilbert Quevauvilliers builds a report:
How much data is being stored in my Fabric OneLake (Lakehouse files and tables)
I recently had a question from someone in the fabric community asking how much storage was being used by the Lakehouse and tables.
This got me thinking that currently there is not an easy way to do this.
Read on to see how Gilbert found the answer.
Leave a CommentDeborah Melkin continues a series on Power Apps:
As a developer, I have two things I have to do: 1. Check code into source control and 2. Make sure I can use that code to deploy to any and all environments repeatably and successfully. The question then becomes, how do you do this when the development environment is in a portal?
Read on for the answer, as well as a tricky situation you might run into along the way.
Leave a CommentAndy Brownsword digs into SSISDB:
I’ve recently been reviewing SSIS packages to make some performance fixes and needed a way to validate the results of those changes. I thought I’d share the scripts as they may be useful for others.
Rather than relying on run times from the SQL Agent running the packages I wanted to dive deeper into the packages so took another approach.
Read on for a query that gets the information. You can also eyeball it in the SSIS reports if you have a small or consistent set of packages to run.
Leave a CommentKendra Little has a public service announcement:
I’m a huge fan of SQL Server’s Query Store feature. Query Store collects query execution plans and aggregate query performance metrics, including wait stats. Having Query Store enabled makes troubleshooting performance issues such as bad parameter sniffing, much, much easier. Because Query Store is integrated into SQL Server itself, it also can catch query plans in a lightweight way that an external monitoring system will often miss.
When performance matters, it’s important to ensure that you’re managing Query Store so that Query Store cleanup does not run during high volume times. Query Store cleanup could slow your workload down significantly.
Read on for more information. I’d also like to plug qdstoolbox, an open-source solution some of my former colleagues worked on. This includes QDSCacheCleanup, which works considerably better than the built-in cleanup process.
Leave a CommentSteven Sanderson wants to check for row existence:
Hello, fellow R users! Today, we’re going to explore a common scenario you might encounter when working with data frames: checking if a row from one data frame exists in another. This is a handy skill that can help you compare datasets and verify data integrity.
There are several ways to do it. Click through for two of those ways.
Leave a Comment