Knowledge Base
Search Results ...
Using Azure Monitor Logs with SQL Performance Insights
In this increasingly data-driven world, SQL Server 2022 and Azure SQL have become essential tools for many businesses. They provide robust, scalable solutions for managing and analyzing vast amounts of data. However, maintaining optimal performance can be[.....]
SSIS and Azure Key Vault for Secure Credential Storage
In the world of data integration and transformation, SQL Server Integration Services (SSIS) remains a robust and feature-rich platform. However, as organisations transition to cloud-based data solutions, there's a growing need to securely manage and store[.....]
Implementing Classification Policies in Azure SQL
In today's data-driven world, securing sensitive data has become a top priority. With the advent of cloud-based services like Azure SQL, managing and implementing classification policies to protect data is easier than ever. In this blog post, we will delve[.....]
Monitoring Azure SQL with Log Analytics
In today's data-driven world, monitoring your database server is crucial to ensure optimal performance and quick troubleshooting. For Azure SQL users, Microsoft has provided a powerful tool, Azure Log Analytics, which can be used to monitor, analyze, and o[.....]
Configuring Azure SQL Firewall Rules
Azure SQL Server, a fully managed relational database service from Microsoft Azure, provides a broad range of SQL Server functionalities on the cloud. One of the fundamental aspects of managing your Azure SQL Server instance is setting up firewall rules. T[.....]
Azure SQL Database DTU vs vCore Explained
In the world of cloud databases, Azure SQL Database presents two pricing models: Database Transaction Unit (DTU) and vCore. Both models offer a variety of service tiers to accommodate different requirements and budgets. But which one is best for your busin[.....]
Configuring Azure SQL Alerts for Resource Governance
When it comes to managing your SQL Server instances, whether they reside on SQL Server 2016, SQL Server 2017 or even MySQL 5.7 and DB2 11.1, resource governance is crucial. However, when these instances are hosted on Azure SQL, you gain a host of cloud-bas[.....]