A Fine Slice Of SQL Server
You can add scrape_interval parameter in your configuration by default it is every 1 minute scrape_interval: 5s
Prometheus has its own query language called promql. You can learn more about this language from this here https://prometheus.io/docs/prometheus/latest/querying/basics/
There are lot of metrics you can define for Kafka. I will mention a few of them in this article
Read on for a breakdown of some of these measures.
Comments closedJared Poche is flirting with the dark side:
I work on hundreds of databases with the same schema. They have different data sets and distributions, different sizes, and their statistics are going to update at different times. But if one of them chooses a bad plan, I have to push aside whatever other work to research the high CPU on database xyz.
Consistency is really valuable to me. And in this case, the answer is simple. Yes, I want to scan the fast, small memory-optimized table variable first, and use it to filter the larger, slower table. Adding a join hint or a force order to this query should keeps its plan and performance consistent.
Click through for a few examples of where query hints can be useful, but also where they can fail you in unexpected ways.
Comments closedGilbert Quevauvilliers walks us through the Vertipack Analyzer in DAX Studio:
If you are looking to better understand your Power BI Model, how big are your tables, which column is taking up the most space then you can use Vertipaq analyzer which is built directly into the amazing DAX studio.
If you are looking for a video on how to do this, there are some awesome videos found here.
SQLBI.COM – Introducing VertiPaq Analyzer in DAX Studio
Guy In a Cube – How do you even use VertiPaq Analyzer with Power BI???
The reason for my blog post, is that I find sometimes I want to watch a video to better understand the content, and other times I want to follow a step by step process on how complete the analysis.
Click through for a walkthrough of the process.
Comments closedPatrick LeBlanc shows us how to incorporate images into Power BI data sets:
Are you curious about how images can be used in Power BI? Patrick looks at some different ways to incorporate images into your data model and Power BI Report!
Click through for a video. All of the techniques here use an image URL which gets pulled in rather than storing the binaries in Power BI itself.
Comments closedAaron Nelson has a pair of new Powershell cmdlets:
I built two new PowerShell commands to deploy SSRS projects, and they have finally been merged into the ReportingServicesTools module. The commands are Get-RsDeploymentConfig & Publish-RsProject. While the Write-RsFolderContent command did already exist, and is very useful, it does not support deploying the objects in your SSRS Project to multiple different folders in your report server. These two new commands can handle deployment to multiple folders.
Click through for details on each.
Comments closedErik Darling reminds me why I hate user-defined functions in SQL Server:
At 23 seconds, this is probably unacceptable. And this is on SQL Server 2019, too. The function inlining thing doesn’t quite help us, here.
One feature restriction is this, so we uh… Yeah.
The UDF does not contain aggregate functions being passed as parameters to a scalar UDF
But we’re probably good query tuners, and we know we can write inline functions.
Read the whole thing, as this is not always straightforward.
Comments closedWe have an application that uses
datetimecolumns in a number of places. All of the users have always been in Eastern Time, but now we have a request to introduce users from a different time zone (Central Time) into the system. The lack of time zone information in our dates and times now presents a problem.The system needs to communicate to users how long ago something occurred, or a time in the future that something needs to be done. If an Eastern Time user enters in a “follow up time” of today at 2:00 pm, a Central Time user could log in, see that, and end up being an hour late following up with their customer.
Click through for the process and several bugaboos you might run into. What we’ve done was to force all application times in UTC in DATETIME or DATETIME2 format and then store user preferences on time zone in the application, translating from UTC to the relevant time zone at that level.
Comments closed