A Fine Slice Of SQL Server
Jean-Georges Perrin hosts another Q&A:
As part of the Data Mesh Learning Community, Eric Broda invited Laveena Kewlani, Kruthika Potlapally, and me to discuss the implementation of Data Mesh at PayPal. As expected, the session went longer than scheduled, and some questions remained open. As with the previous Q&A sessions ([#1] and [#2]), here is an attempt to answer them.
Click through for the questions, as well as the answers.
Comments closedSteven Sanderson plots a course:
The code is used to create a Shiny app that allows the user to search for a type of amenity (such as a pharmacy) in a particular city, state, and country, and then display the results on a map. Here is a step-by-step explanation of how the code works.
Click through for notes, the code, and an example of the app in operation.
Comments closedQuestion: How can I find and report on SQL Server tables with LOB columns but where the table has no PRIMARY KEY? I’m classing an LOB column as ‘TEXT’, ‘NTEXT’,’IMAGE’ ,’XML’, ‘VARBINARY’,’NVARCHAR(MAX)’ & ‘VARCHAR(MAX)’.
Read on for the answer.
Comments closedLilliam Leme is building a serverless warehouse:
As organizations continue to collect and store large volumes of data in their data lakes, managing this data effectively becomes increasingly important. One key aspect of this is implementing Slow Change Dimension type 2, which allows organizations to track historical data by creating multiple records for a given natural key in the dimensional tables with separate surrogate keys and/or different version numbers. In this blog post we will address the following scenario: a customer wants to implement Slow Change Dimension type 2 on top of their data lake.
For this example, we will use Serverless SQL Pool to demonstrate how this can be done. Additionally, in the next post, we will explore how the same approach can be used with Spark.
This turns out to be more work than a classic SQL Server-based solution because of the fact that the serverless SQL pool is read-only, save for CETAS statements.
Comments closedAnna Hoffman gives us the latest news:
Let’s start with Azure SQL Managed Instance, which had several general availability (GA) announcements in April. First, the GA of Link feature for Azure SQL Managed Instance for SQL Server 2016 and 2019 happened. This capability allows you to set up near real-time replication between a SQL Server and SQL MI. You can use this link for scale, migration, read-only workloads, etc. To learn more, review the announcement blog. The team also announced the GA of CETAS. This stands for Create External Table As Select, which essentially means you can create an external table while in parallel exporting the results of a SELECT statement. This has been a customer ask and you can learn how to take advantage of it here.
Read on to learn more about what’s new with the rest of the Azure SQL landscape, and some things happening in the community.
Comments closedEric Svensen prettifies a slicer:
Yesterday I worked on a Power BI report where the client wanted to add vertical bar next to the slicer in order to make the design of the slicers a little bit nicer and also to make the slicers recognizable cross pages by using the same coloring.
Click through for two ways to do it, one of which is definitely better than the other.
Comments closed