Execution timeout in SSMS are a small but important feature that can help you manage query performance. By default, SSMS…
Browsing: SQL
ANSI PADDING is an often-overlooked yet impactful setting in SQL Server that determines how trailing spaces are handled in CHAR…
If you’ve ever run a SQL query that looks simple but takes longer than expected, one likely culprit is the…
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…