A Fine Slice Of SQL Server
Imke Feldmann has another Excel function to convert:
TRIMMEAN is a statistical function in Excel that calculates the “mean taken by excluding a percentage of data points from the top and bottom tails of a data set”. So you can use it if you want to exclude potential outliers from your data. Daniil Maslyuk has a nice approach for it in DAX, but in here I want to share my M version for Power Query for it.
Read on for the function and how you can use it.
Comments closedHugo Gruson, et al, share some techniques for ensuring function input matches your expectations:
Are you, like we were, tired of filling your functions with argument checking code that sometimes ends up being longer that the core of the function itself? Are you trying to find what is the most efficient approach to check inputs easily and without forgetting any edge cases? Read about our exploration into the various ways to check your function inputs in R in this blog post. And please share your own tips and discoveries in the comment section!
Read on for several techniques.
Comments closedK.H. Kim has an article on unit conversion in R:
Data
mtcarshas a column namedmpg.mpgmeans miles per gallon. ‘Mile’ and ‘gallon’ are units for length and volume. A mile is approximately 1.6 kilometers and a gallon is approximately 3.7 liters. Mile and gallon sound unfamiliar to people who live outside England or U.S.A. because international standard units for length and volume are meter and liter.In this post, we will learn how to convert a unit to another unit, for instance, we will convert mpg to km/L, which is more comprehensible to people who use SI units
This is something that I’m surprised languages don’t do more of. F# has the concept of units of measure but these are compile-time—at runtime, you can still break the rules. And in most languages, type systems are so simplistic that it’s all just plain decimal math. H/T R-bloggers.
Comments closedRick Spurgeon has a video series:
Decentralized architectures continue to flourish as engineering teams look to unlock the potential of their people and systems. From Git, to microservices, to cryptocurrencies, these designs look to decentralization as a method of breaking apart centralized bottlenecks. Data mesh is an approach to data and organizational management centered around decentralizing control of data itself. In this post, we’ll look at a Confluent Developer video-led course that tackles the big concepts and walks you through creating your own data mesh using event streams and Confluent Cloud.
Click through for a 9-part video series.
Comments closedJeffery Hicks translates security identifiers:
As usually happens during my day, I get sidetracked to another issue, and before you know it, I have a new PowerShell tool. In this instance, I was looking at event logs using Get-WinEvent. One of the event record properties is a UserID.
That’s very nice, but who is this? In this particular instance, the UserID property is SecurityIdentifier object.
Read on to see how to translate a SecurityIdentifier into something human-understandable.
Comments closedMarco Russo does a bit of transformation:
In matrix visuals, Power BI usually hides rows where all the measures return a blank value. To leverage this behavior or simply to change the visualization of a measure depending on its result, you might want to achieve one of the following:
– Transforming a blank result to zero: this is covered in the article, How to return 0 instead of BLANK in DAX.
– Transforming a zero result to blank: this is the scenario described in this article.
Click through to see what the process looks like.
Comments closedGrant Fritchey implores us not to forget the SELECT/INSERT/UPDATE/whatever operator:
I’ve watched several people recently go straight to XML when reading execution plans because they didn’t know about the execution plan properties in the first operator. Now, don’t get me wrong. If going straight to the XML is working for you, that’s fine. Keep doing it. I’m absolutely not questioning how anyone does things. I just want people to know that “hidden” information isn’t so much hidden as much as it’s not too obvious.
Read on to see what this contains.
Comments closedImke Feldmann translates another Excel function:
If you are looking for the Excel equivalent of the WEEKNUM function for Power Query this article is for you.
As this is also a function that has many regional options, I was lucky to find an algorithm that I could use for its main part here: M functions to convert between ISO 8601 Week & Year ⇄ dates (e.g.,
2014-12-29⇄"2015-W01-1") (github.com)
Read on for the code and details on function parameters.
Comments closedTomaz Kastrun pays for 20% of ticket prices because he’s always on the edge:
What you need to do is simply run:
python -m pip install notebook --pre --upgradeAnd with this prerelease version of the Jupyter notebook, you have in addition several options to enhance your workspace.
Besides the refreshed outlook, what else is available in this version?
Check out what’s in this version of Jupyter.
Comments closedAnna Hoffman brings us tidings:
Emily Lisa kicked it off by telling us about the latest Azure SQL Database product updates including Azure SQL maintenance windows, zone redundancy for SQL Hyperscale, and configurable backup storage redundancy for SQL Hyperscale.
Dani Ljepava from the Azure SQL Managed Instance product team came on to share a range of new features announced at SQL Bits now available in public preview: Link feature for Managed Instance, data virtualization with ADLS, Advanced notifications for planned events, Hybrid Service Broker, Windows authentication for Azure AD Principals, and the general availability of Maintenance windows. Watch the episode to see a special look at Link feature for Managed Instance!
Pam Lahoud also came on to talk about about the latest improvements that help you manage your SQL Server in Azure Virtual Machines, including the newly released SQL best practices assessment, all available to you by installing the free SQL IaaS Agent extension!
Read on for plenty more links and updates.
Comments closed