Pros and Cons of Approval Workflows in Purview Data Governance
I’ve been doing some work with Purview Data Governance recently including evaluating the new workflow based approvals released into preview which can be used to add a customised approval process to the publication of data products and glossary terms. The customer on the project kindly gave me permission to share some of the insights and…
How to fix the error “cannot create property ‘groupid’ on string ‘” In Azure Data Studio
This is a solution to a bug I’ve encountered in Azure Data Studio when trying to create new connections. that leads to an error message of cannot create property ‘groupid’ on string ‘. File this post under “things I couldn’t find a neat answer to in Google so I figure I’d best create a page…
T-SQL Tuesday #168 – FIRST_VALUE, LAST_VALUE and NULL Handling
FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let’s take a look at some examples of why.
Using Metadata To Dynamically Analyze SQL Server Table Contents
A helpful script to allow you get a feel for a table’s contents on SQL Server.
Something went wrong. Please refresh the page and/or try again.