If you’ve ever run a SQL query that looks simple but takes longer than expected, one likely culprit is the…
Browsing: SQL
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data platform. This platform integrates various data…
If you’ve ever run a SQL query that looks simple but takes longer than expected, one likely culprit is the…
Permission Levels in Microsoft Fabric In Microsoft Fabric, permissions can be assigned at two levels: workspace and Lakehouse. Each level…
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure Data Factory (or Synapse Pipelines). This…
The Distributed Availability Group Dashboard can be downloaded from our GitHub repo. https://github.com/SQLUndercover/UndercoverToolbox/blob/master/DAG%20Dashboard.pbix.This comes off of the back of my…
A customer asked if they needed to restore a database from backup to compare the schema in a database. They…
We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as…
From Stale Repositories to Living Ecosystems An Evolving Yet Fundamental Concept Data catalogs have been around for years, and despite…
Low-code solutions often accelerate development and make tasks accessible to people who can’t or don’t want to write their own…