Knowledge Base
Search Results ...
SQL Server TempDB Performance: Fabric vs On-Prem
In the world of data management, SQL Server TempDB performance is a topic of critical importance. It is a system database that comes into play for a variety of tasks such as sorting large result sets, storing temporary tables, and much more. The performanc[.....]
Understanding Elastic Pools in Azure SQL
The era of cloud databases has brought about many innovations, with one of the standout features being Elastic Pools in Azure SQL. Elastic Pools are a cost-effective solution for managing and scaling multiple databases with varying and unpredictable usage[.....]
Custom T-SQL Profiling with Extended Events and ML
In an era where data is the new oil, optimizing SQL Server operations is more critical than ever. SQL Server 2022, Azure SQL, and the vast array of Microsoft technologies provide a robust platform for managing and deriving insights from our data. However,[.....]
Using dbt with SQL Server in Fabric Pipelines
Welcome to another blog post on SQLSupport.org. Today, we will explore the exciting combination of dbt (data build tool) with SQL Server in Fabric pipelines. As we all know, dbt is an open-source, command-line tool that enables data analysts and engineers[.....]