A Fine Slice Of SQL Server
Steven Sanderson is looking for a date:
As an R programmer, you may often encounter datasets where you need to determine whether a column contains date values. This task is crucial for data cleaning, manipulation, and analysis. In this blog post, we’ll explore various methods to check if a column is a date in R, with a focus on using the
lubridatepackage and thets_is_date_class()function from thehealthyR.tspackage.
Click through to see how, using lubridate and healthyR.
Comments closedKevin Chant enables a feature:
In this post I want to cover accessing the new Microsoft Purview portal in your own Microsoft Fabric environment.
To clarify, I mean a Microsoft Fabric environment you have created for your own use. Like the one I covered in a previous post.
You can do this in a trial environment thanks to the new capability provided by Microsoft last year to infuse Microsoft Fabric items into Microsoft Purview. Which Microsoft covered in a blog post about Microsoft Fabric items in Microsoft Purview.
Read on to see how.
Comments closedErik Darling makes a proposal:
So, here’s where indexed views are tough: THERE ARE SO MANY RESTRICTIONS ON THEM IT’S ABSURD.
They are borderline unusable. Seriously, read through the list of “things you can’t do” I linked to up there, and note the utter scarcity of “possible workarounds”.
Aside from that, indexed views often are counter-productive, as Erik shows.
Comments closedChris Webb taps into the source:
There’s a new M function in Power Query in Power BI that allows you to read the data from a Parquet file: Parquet.Metadata. It’s not documented yet and it’s currently marked as “intended for internal use only” but I’ve been told I can blog about it. Here’s an example of how to use it:
Click through to see what you can get in a Parquet file. This is part of the secret of why the Parquet file format is so fast.
Comments closedSoheil Bakhshi does some scaling:
In a previous post I explained how to manage the capacity costs of a Fabric F capacity (under Pay-As-You-Go pricing model) using Logic Apps to Suspend and Resume it.
A customer who read my previous blog asked me “Can we use a similar method to scale up and down before and after specific workloads?”. This blog post is to answer exactly that.
This is pretty neat, though I wonder how long it takes and how much downtime it produces.
Comments closed