A Fine Slice Of SQL Server
Koen Verbeeck takes us through switching the current environment in Azure Data Factory:
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately, the functionality to switch between them is a bit hidden in the user interface.
Read on to see how.
Comments closedMarc Lelijveld shows how you can share a dataset in Power BI:
There are many different use cases to consider where shared datasets can be an advantage. Below I have quickly listed a few advantages, but probably you can think of many more.
– Centrally managed definitions and calculations to avoid different calculations for the same metrics and different versions of the truth.
– One central load from source to Power BI dataset, which lowers the performance impact on the source system.
– Easier to kickstart the data driven analytics experience for the business users and any other self-service analytics purposes.
Sharing here doesn’t mean giving to the broader world; it’s sharing within an organization.
Comments closedAndrew Pruski is a Kubernetes slumlord:
The default time that it takes from a node being reported as not-ready to the pods being moved is 5 minutes.
This really isn’t a problem if you have multiple pods running under a single deployment. The pods on the healthy nodes will handle any requests made whilst the pod(s) on the downed node are waiting to be moved.
But what happens when you only have one pod in a deployment? Say, when you’re running SQL Server in Kubernetes? Five minutes really isn’t an acceptable time for your SQL instance to be offline.
Click through to see how to handle this scenario.
Comments closedSo I figured I’d take a look and see what was happening and how we could fix it. Now I’m going to be honest with you, my usual method of debugging involves adding
Write-Host 'Hi‘, or piping objects toOut-GridView. I did start down this route, but theGet-DbaRegServerfunction calls an internal function, and things quickly got complicated.Luckily, the PowerShell extension for VSCode includes a debugger so we can level up our game and use that to track down our issues.
Click through to see how it works.
Comments closedHimanshu Gupta walks us through the log4r package:
One of the most important aspect of an application is Logging. Since logs provide visibility into the behavior of a running app. Hence logs play a vital role in maintenance and enhancement of an application.
However, most of us are already aware with the importance of logging. That’s why we add them in our applications. But one thing that we are not aware of is that, the application should never be concerned with routing or storage of logs, i.e., it should not attempt to write to or manage logs or log files. Instead, each running process, within the application, writes logs to a stdout. In local environment, we can view the logs in the console whereas in staging/production environment, logs can be collated together in .log file(s).
Hence, in this blog post we will learn – how to collect, customize, and standardize R logs using log4r? But first let’s know what log4r is.
Read on for a demonstration of log4r and some of the settings you can choose.
Preetdeep Kumar crosses the streams:
Apache Flink provides various connectors to integrate with other systems. In this article, I will share an example of consuming records from Kafka through
FlinkKafkaConsumerand producing records to Kafka usingFlinkKafkaProducer.
Read on for an example. I’m glad to see that integration between these two competitors (more exactly, Flink and Kafka Streams are competitors) is so easy.
Comments closedDenny Cherry walks us through the steps for updating a SQL Server 2019 Big Data Cluster:
If you’ve been running your SQL Server 2019 Big Data Cluster (BDC) for a while now, you probably want to patch it to the current (or a specific) build version.
Upgrading a BDC is actually fairly easy. A couple of commands will do the trick.
Read on for the steps.
Comments closedImke Feldmann takes us through an interesting scenario:
When downloading data from the web, it’s often best to grab the data from APIs that are designed for machine-to-machine communication than from the site that’s actually visible on the screen. Not only is the download usually faster, but you also often get more additional parameters that can be very useful. In this article I’m going to show you how to retrieve the relevant URLs for downloading files from webpages (without resorting to external tools like Fiddler) and how to tweak them to your needs.
Read on to see different techniques for finding a URL to give to end users.
Comments closedDavid Klee walks us through the concept of resource pools in VMware:
Resource pools are used to hierarchically partition available CPU and memory resources, and are available for use at the VMware host cluster layer.
To better prioritize certain VMs over others, especially in a highly concurrent VM farm, I recommend leveraging three resource pools for SQL Server-on-VMware environments. Tier-1 can be created with a high value of resources assigned for CPU and memory; Tier-2 is normal; Tier-3 is low. Do not manually specify the amount of shares for each, as this metric will become skewed if compute hardware is added or removed from the host cluster.
Read on to understand why and how, as well as a few more tips around resource pools.
Comments closedReza Rad shows us how to build out a substring using DAX:
Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from “Reza Rad”, if I want to get the start starting from index 2, for 4 characters, it should return “za R”. Considering that the first character is index 0. Let’s see how this is possible.
The answer’s not as pretty as a SUBSTRING() function would be, but it’s also not too far off.