Knowledge Base
Search Results ...
Running SQL Server on ARM-Based Azure VMs
In recent years, the advancement of ARM-based servers has taken the tech world by storm. These servers are not only more energy-efficient, but they also deliver competitive performance for diverse workloads. Recognizing this trend, Microsoft has embraced A[.....]
Fabric Real-Time Streaming with SQL Integration
In the world of data management and processing, real-time streaming has become a necessity. With Microsoft Fabric, SQL Server 2022, and Azure SQL, you can leverage the power of real-time analytics. Microsoft Fabric, a distributed systems platform, facilita[.....]
Horizontal Partitioning vs Delta Partitioning
In the world of database management, partitioning is a critical procedure that separates the database into smaller, more manageable parts. Two dominant types of partitioning are horizontal partitioning and delta partitioning. Let's delve deeper into these[.....]
Dimensional Modeling Updates for Fabric Reporting
As the technological landscape continues to evolve at an exponential pace, SQL Server 2022, Azure SQL, Microsoft Fabric, OpenAI, Databricks, and Delta Lake are leading the transformation in how we manage, analyze, and generate insights from data. Specifica[.....]
Using OpenTelemetry for SQL Server Telemetry Tracing
OpenTelemetry is an open-source platform that allows users to generate, collect, and describe telemetry data for observability. It provides a single set of APIs, libraries, agents, and collector services to capture distributed traces and metrics from your[.....]
Advanced Date and Time Handling in ETL Pipelines Note from the Data Whisperer
Welcome back, data enthusiasts! Today, we’re diving deep into advanced date and time handling in ETL (Extract, Transform, Load) pipelines. As you all know, managing date and time effectively is critical in ensuring your data is accurate and reliable. The c[.....]
SQL Server Encryption: Transparent, Always Encrypted, and Beyond
Welcome to SQLSupport.org, where we bring you the latest and most relevant discussions on SQL technologies. Today, we are going to delve into the realm of SQL Server encryption, with a focus on Transparent Data Encryption (TDE), Always Encrypted, and the f[.....]
AI-Powered Query Rewrite Suggestions
In the ever-evolving world of data, it is crucial to stay ahead of the curve. Advanced technologies like Microsoft's SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake, and Databricks are at the forefront of this evolution. These platforms not only s[.....]
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[.....]