A Fine Slice Of SQL Server
John MacKintosh troubleshoots an issue:
I recently updated my R installation, and then realised that I’d broken my VSCode/ R set up in the process – I could not launch an R terminal either directly or via radian.
I have a repo where I’ve collated various blog posts relating to setting up VSCode for R, but that didn’t solve all my problems.
I did get it resolved eventually, and here’s how.
Read on for that resolution. H/T R-Bloggers.
Comments closedRobert Cain continues a series on KQL:
In my previous post, Fun With KQL – Max, MaxIf, Min and MinIf, we looked at the aggregation functions
maxandmin. In this post we’ll talk about another aggregation function,sum. We’ll also look at a variant of it,sumif.
Check out the details and examples in Robert’s post.
Comments closedPatrick Gruenauer counts the ways:
The enum statement can be used to declare an enumeration. Microsoft describes this statement as follows:
The
enumstatement allows you to create a strongly typed set of labels. That enumeration can be used in the code without having to parse or check for spelling errors.
Click through for more description, as well as an example of how to create, instantiate, and operate on enumerations.
Comments closedNithya Bondalapati notes a discrepancy:
ARM (Azure Resource Manager) API does not support specific T-SQL resource naming formats and that’s why when Databases are created using T-SQL/SSMS, unsupported characters could get allowed into the names.
Azure Portal UI does not have this issue, because when you use Portal UI for creating a Database, the creation goes through ARM, and hence when unsupported characters are entered in the Name field, it immediately throws error, as shown in the below image.
None of the restrictions or onerous, but Nithya explains what actions fail or don’t quite work right if you have a database with special characters or ending in a period or space.
Comments closedNicholas Xuan Nguyen doesn’t just echo to the screen:
The PowerShell
Write-Outputcmdlet writes objects to the output stream and displays the output of a command or message in the console. But you will be surprised how this tool makes the output more meaningful and valuable.
Read on to see what you can do with the cmdlet and why it’s better than Write-Host.
Chad Callihan explains a feature:
If you’re running into problems caused by concurrent inserts and you’re on SQL Server 2019 or above, it’s worth testing out OPTIMIZE_FOR_SEQUENTIAL_KEY. This may alleviate those issues by handling inserts a little bit differently to reduce contention. OPTIMIZE_FOR_SEQUENTIAL_KEY will “control the rate at which new threads are allowed to request the latch, and favor threads that are likely to keep the throughput high.”
Read on to see how you can enable it but also when it makes sense to enable it.
Comments closedIf you’re like me, Plan Explorer has always been a must-have tool in your performance tuning arsenal. And one of the things that made it so useful was a simple little SSMS Integration that would allow you to right click on an Execution Plan and see “View with […] Plan Explorer.”
Unfortunately, I started hearing reports of that no longer being available in SSMS v19. But I know a thing or two, so was willing to bet 30 minutes of time that I could get it back.
Andy won that bet, so shower him with accolades.
1 CommentJaydeep Patil adds a NuGet package:
We will go over Apache Kafka basics, installation, and operation, as well as a step-by-step implementation using a .NET Core 6 web application.
Click through for a demo-heavy walkthrough. And if you’re interested in ksqldb or Kafka Streams, also check out Tomas Fabian’s library. Both are under active development and each forms a piece of the whole Kafka solution.
Comments closedPaul Turley lays out facts (and dimensions):
There is no secret about this. If you do any legitimate research about Power BI (reading blogs, books or training from reliable sources), you will quickly learn that a lot of basic functionality requires a dimensional model, aka “Star Schema”. This is a hard fact that every expert promotes, and self-taught data analysts either have learned or will learn through experience. So, if everyone agrees on this point, why do so many resist this advice?
Perspective is everything. I didn’t understand why getting to the star schema was so out of reach so often until I was able to see it from another perspective. There are a few common scenarios that draw source data into different directions than an ideal dimensional model.
Read on for Paul’s take on the subject.
Comments closedReza Rad takes us through the workspace model in Power BI:
Workspaces are another way of sharing Power BI content with other people. The benefit of this sharing approach is that you can share content with a group of people and create a collaborative development environment where everyone can access it. In this article and video, I get you through sharing with workspaces, what the limitations and advantages are, and how it is different from dashboard sharing, and you will have a complete understanding at the end of this article which scenarios are suitable to be used with this method of sharing.
Click through for a video and an article.
Comments closed