Knowledge Base
Search Results ...
Deploying Metadata-Driven ETL in Delta Lake
In the rapidly evolving world of data science, the need for scalable and reliable data processing solutions is more critical than ever. One such solution is Delta Lake, an open-source storage layer that brings reliability to data lakes. It provides ACID tr[.....]
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[.....]
Configuring Ledger Tables for Compliance Reporting
In the ever-changing landscape of data management and compliance reporting, it's vital to ensure that your data is both secure and easily accessible for audit purposes. Ledger tables, an integral part of any SQL Server 2022 or Azure SQL database, are an ex[.....]
Optimizing Power BI Performance with Star Schemas
As data volumes continue to grow exponentially, optimizing the performance of your Power BI reports and dashboards has never been more critical. One strategy that can significantly enhance your Power BI performance is the use of star schemas. In this blog[.....]
Event-Driven SQL with Azure Event Grid
In the ever-evolving world of data, the traditional method of polling and querying databases for changes is becoming increasingly inefficient. This is where the power of event-driven architecture comes into play. With Azure Event Grid, an intelligent event[.....]
Fabric Lakehouse Integration with Legacy SQL Systems
The digital world is evolving rapidly, and so is data management, with the development of SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake and Databricks. Today, we will discuss how to integrate Fabric Lakehouse with legacy SQL systems. Fabric Lake[.....]
Using PolyBase to Bridge On-Prem and Cloud SQL
The rise of cloud technologies has revolutionized the way we approach data management, with an increasing number of companies migrating their databases to the cloud. However, on-premise SQL Server databases continue to play a crucial role in many organizat[.....]