A Fine Slice Of SQL Server
Arshad Ali does a bit of construction:
Data Lakehouse architecture has become the de facto standard for designing and building data platforms for analytics as it bridges the gap and breaks the silos created by the traditional/modern data warehouse and the data lake. This blog post introduces you to the world of data lakehouse and it goes into details of how to implement it successfully in Azure with Azure Synapse Analytics.
Read the whole thing.
Comments closedI continue a series on data virtualization in SQL Server 2022:
Today’s post is a fairly short one. Let’s say you want to connect to Azure Data Lake Storage Gen2 from SQL Server 2022. We saw in a recent post how to connect to Azure Blob Storage. When it comes to Azure Data Lake Storage, the story is almost the same, though there are a couple pitfalls you will want to avoid.
Read on for that error, which stymied me for a good 10 minutes.
Comments closedWarwick Rudd continues a series on Azure Arc-enabled data services:
Now that we have our Azure Arc-enabled Data Controller configured and available, we can now deploy our first Arc-enabled SQL Managed Instance into our environment. As previously mentioned depending on the type of configuration required for your environment with your Arc-enabled Data Controller (Directly connected or Indirectly connected modes) this will dictate the approach available for you to setup / configure your Arc-enabled SQL Managed Instance.
Click through for a step-by-step guide.
Comments closedReitse Eskens begins an interesting series:
The trigger for this feast were a number of questions from my employer. What database tier and SKU (Stock Keeping Unit) should we choose for customer C. Well, the answer depends on their budget and the performance they’re expecting. And we didn’t have a conclusive answer. Microsoft will provide you with their statistics on database performance, but what does that mean in real life. Because no matter what the good people in Redmond can come up with as databases, we as data engineers can do worse. Much worse.
So, I created some horrible query’s to insert, select and delete data and fired them off to a database. My own laptop with nvme disks provided the baseline, after that I gradually worked my way up from the Basic DTU database to the Hyperscale database.
This first post is an introduction to the method and laying out expectations. I’m looking forward to the remaining posts in the series.
Comments closedErik Svensen needs to build a date:
Sometimes it’s the little things that can help you minimize the number of steps in your Power Queries.
Here is another example that might help you.
Let’s imagine your data contains two columns with year and the month name and you want to create a date column.
Read on for a clever function modification to generate a date from these two fields.
Comments closedThe thing that got me excited about the Power BI Enhanced Refresh API, and which inspired me to start this series of posts, was the fact that for the first time it gives you a way of cancelling Power BI dataset refreshes. In this last post in the series I’ll show you how you can add an Action to your Power Automate custom connector to cancel a refresh and how you can use it in a Power Automate Flow.
Click through to see how.
Comments closed