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[.....]
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[.....]
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[.....]
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[.....]
Best Practices for CI/CD in SQL Server Projects
The world of database development has experienced significant changes over the years, especially with the introduction of continuous integration and continuous deployment (CI/CD) pipeline. This has enabled developers to automate the stages of application p[.....]
New Query Store Enhancements in SQL Server 2022
Welcome to another insightful article on SQLSupport.org. Today, we are going to explore the new Query Store enhancements introduced in SQL Server 2022. Over the years, SQL Server has evolved to offer a more robust, high-performing, and secure data platform[.....]
Automating Index Recommendations with SQL Server 2022
Welcome to another insightful post on SQLSupport.org. Today, we delve into the realm of SQL Server 2022 and its impressive new features. Our focus will be on exploring how to automate index recommendations using SQL Server 2022. This latest version of SQL[.....]
SQL Server and AI Embedding Solutions for Search Note from the Data Whisperer
Welcome to another insightful post from SQLSupport.org, your trusted partner in all SQL-related matters. Today, we delve into the future of databases by exploring SQL Server and AI embedding solutions for search notes from the Data Whisperer. We're going t[.....]
SQL Server Temporal Table Cleanup and Audit Use
One of the most powerful features of SQL Server 2022 and Azure SQL is the ability to create temporal tables. A temporal table is an extension of a regular table that allows you to keep a history of data changes. However, like any powerful tool, temporal ta[.....]
SQL Server 2022: Ledger Tables for Compliance Use Cases
In the era of data-driven decision making, the need for data integrity and compliance is paramount. With the release of SQL Server 2022, Microsoft introduced a new feature, Ledger Tables, to address this need. Ledger tables provide an immutable, tamper-evi[.....]