Knowledge Base
Search Results ...
Metadata-Driven SQL Automation Using YAML
Welcome to another blog post from SQLSupport.org. Today, we're going to touch on an exciting topic that has been gaining traction in the SQL world: Metadata-Driven SQL Automation Using YAML. Leveraging advanced technologies such as SQL Server 2022, Azure S[.....]
Delta Sharing and Data Contracts
Delta Sharing, an open-source project by Databricks, is revolutionizing the way organizations share and access data across the globe. It provides a simple, secure, and open protocol to share data between organizations, regardless of the platform or the typ[.....]
Tuning Composite Models in Power BI
Power BI, Microsoft's suite of business analytics tools, has brought forth an era of democratized data analysis. Composite models in Power BI allow users to have tables in their reports that are DirectQuery and Import at the same time. Thus, optimizing the[.....]
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[.....]
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[.....]
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[.....]
Monitoring Always On Health with Custom Dashboards
In an era of increased data consumption and reliance, the need for real-time monitoring of database health has become paramount. SQL Server 2022, combined with Azure SQL, Microsoft Fabric, and other technologies, offers robust tools to help you monitor the[.....]
Using OpenAI Embeddings for Query Similarity
In the continuously advancing world of database technologies, the ability to identify similar queries can be of immense value in optimizing database performance, improving query debugging, and even enhancing AI-based predictive analytics. Microsoft SQL Ser[.....]
SSRS Cascading Parameters with Multi-Value Defaults
In the world of SQL Server Reporting Services (SSRS), handling parameters is a crucial and often complex task. One such challenging task is the management of cascading parameters with multi-value defaults. With the advent of SQL Server 2022, Azure SQL, and[.....]