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[.....]
Troubleshooting SQL Server Deadlocks with Graph Visualizations Note from the Data Whisperer
Understanding and resolving SQL Server deadlocks can be a challenging task. The traditional text-based deadlock graphs can be difficult to interpret and may not provide enough information to diagnose and resolve the problem effectively. However, SQL Server[.....]
Securing SQL Pipelines with Managed Identities
In the continually evolving landscape of database technologies, security remains a paramount concern for everyone from database administrators to developers. Today, we're going to discuss a crucial aspect of database security: securing SQL pipelines with m[.....]
Custom Alerting in SQL Server with Python Scripts
SQL Server 2022, Azure SQL, Microsoft Fabric, Delta Lake, OpenAI + SQL, and Databricks are powerful tools that can be harnessed to facilitate efficient database management. One of the areas where these technologies can be utilized is in custom alerting. Th[.....]
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[.....]
SQL Server and Python: Using ML Services Effectively
In the world of data analysis, the blending of SQL Server and Python has created a powerful tool for machine learning services. In this article, we will examine how you can use these ML services effectively, with a particular focus on SQL Server 2022, Azur[.....]
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[.....]
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[.....]