A Fine Slice Of SQL Server
Robert Cain follows up on a prior post:
In the conclusion of my last post, Fun With KQL – Datatable, I mentioned a
datatablecan also be useful when you need to do special calculations. I decided it really needed further explanation and created this post to dive in a bit deeper.If you haven’t read my
datatablepost yet, you should as I’ll refer back to it. Go ahead, I’ll wait.
Click through to see what Robert has in mind.
Comments closedHugo Kornelis offers a mea culpa:
In my post, I pointed out that SQL Server automatically creates a unique nonclustered index on the (internal and hidden) column graph_id, that you can delete, but can’t modify. I added that users cannot specify indexes on that column, nor on the other internal and hidden columns that exist in edge tables (from_obj_id, from_id, to_obj_id, and to_id). These statements are factually correct, but misleading.
I then concluded from those facts that once you delete the automatically generated index, you can not re-create it. This is actually incorrect.
Read on for the correct answer, as well as more information on indexing practices and advice on the right kinds of indexes to create on graph tables.
Comments closedTeo Lachev reviews the primary methods for data ingestion in Microsoft Fabric:
Fabric supports three options for automated data integration: Data Pipeline (Azure Data Factory pipeline), Dataflow Gen2 (Power BI dataflow), and Notebook (Spark). I summarize these three options in the following table, which loosely resembles the Microsoft comparison table but with my take on it.
Read on for Teo’s thoughts on the matter.
Comments closedPieter Vanhove makes an announcement:
A few months ago we announced the support for virtualization-based security (VBS) enclaves in Azure SQL Database. This announcement brings numerous advantages, including robust confidential queries and seamless cryptographic operations, to all Azure SQL Database offerings, independent from the underlying hardware. You can use the feature with any compute tier (provisioned or serverless), purchasing model (vCore or DTU), compute size and region that aligns with your workload needs. And, since VBS enclaves are available in existing hardware offerings, there is no additional cost.
In addition to this preview, we are excited to announce the preview of VBS enclaves in Azure SQL Database elastic pools!
Read on to learn more about how to enable enclaves and add a database to an elastic pool.
Comments closedMarc Lelijveld imports some icons:
In the past, I’ve made a draw.io file for Power BI to help you using the right icons to design your solutions and make architectural diagrams. With Fabric, a bunch of new services and icons have been introduced. This asks for a new draw.io file.
With this blog, I will provide the draw.io file for all new icons and elements of Fabric.
Click through for that link. Also note that you might be more familiar with the new name of draw.io, diagrams.net.
Comments closedAndy Leonard troubleshoots an error:
Have you encountered this error: “Failed Get Parameter Info of parameter ____”? I ran into this error a couple times while consulting for a client to lift and shift SQL Server Integration Services (SSIS) to Azure Data Factory (ADF).
Click through for an example and what is the most likely cause of the problem.
Comments closed