Knowledge Base
Search Results ...
SQL Server Scheduler Performance Deep Dive
In today's data-driven world, SQL Server performance is crucial to the success of any business. One of the key components impacting the performance of SQL Server is its scheduler. In this blog post, we'll take a deep dive into SQL Server Scheduler performa[.....]
Azure Defender for SQL: Advanced Threat Protection
As we navigate through the rapidly evolving digital landscape, the importance of database security is more prominent than ever. The advent of new technologies has presented us with potent tools to safeguard our data, one of which is Azure Defender for SQL.[.....]
Enterprise SQL Code Standards for 2026
Welcome to SQLSupport.org, your trusted source for all things SQL. Today, we will delve into the topic of enterprise SQL code standards for 2026, ensuring you're up-to-date with the best practices in today's fast-evolving data landscape. As we move forward[.....]
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[.....]