Query Store for Azure SQL Data Warehouse is generally available now

 

Since the recent preview, Query Store raised great interest among users as an effective solution to provide insight on query performance. Microsoft announced the general availability of Query Store for Azure SQL Data Warehouse worldwide.

When monitoring a data warehouse, Query Store captures query history, separates the data by time slots and provides an overview of the database usage patterns.
Advantages of using […]

By |February 28th, 2019|IT Management, Microsoft Azure|0 Comments

PostgreSQL Read Replicas Preview

This blog post is about the Read Replicas for Azure Database for PostgreSQL which Microsoft recently announced in a preview.

Azure Database for PostgreSQL now supports continuous, asynchronous data replication from the master Azure Database for PostgreSQL server to up to five Azure Database for PostgreSQL servers located in the same region. These read replicas allow […]

By |February 21st, 2019|Azure News, General, IT Management, Microsoft Azure|0 Comments

New Availability Zones in Azure Service Bus and Event Hubs

 

In June 2018 Microsoft released a preview of Azure Service Bus Premium tier for Availability Zones and Azure Event Hubs Standard tier in 3 regions – Central US, East US 2, and France Central. Now Availability Zones support for Azure Service Bus Premium and Azure Event Hubs Standard is also available in the following regions:

East US 2
West US […]

By |February 12th, 2019|Azure News, IT Management, Microsoft Azure|0 Comments

PowerShell and ACLs in Azure Backup

This blog post explains a set of new features that Microsoft recently revealed. These features allow backing up Microsoft Azure file shares natively using Azure Backup. These features also support file shares connected to Azure File Sync.
Azure files with NTFS ACLs
Microsoft has recently announced the preview of preserving and restoring new technology file system (NTFS) access control lists (ACL) for Azure files. Now […]

By |February 5th, 2019|IT Management, Microsoft Azure, New Features|0 Comments

Azure firewall for virtual machines backup

In this blog post we will explain how to leverage Azure Backup and Azure Firewall to ensure ultimate protection for your data. Azure Backup and Azure Firewall complement each other well to provide complete protection to resources and data in Azure. With the general availability of Azure Firewall Microsoft now provides a fully stateful firewall as a service that allows cloud […]

By |January 31st, 2019|Azure How To, IT Management, Microsoft Azure|0 Comments

Set alerts on metrics with Azure Database for MariaDB

 

With the recent announcement of the general availability of MariaDB we would like to share some best practices for alerting on the most commonly monitored metrics for the database.

Monitoring databases is an essential part of maintaining server reliability, availability, and performance and Microsoft provides various metrics for MariaDB to get insights into the behavior of the server. Azure Portal, as […]

By |January 22nd, 2019|Microsoft Azure|0 Comments

Monitor data factory pipelines with proactive alerts

 

Complex data integrations help businesses combine data and business processes in hybrid data environments. Recent data increase in volume, variety, and velocity has resulted in the delays in monitoring and issue resolution. Nowadays organizations look to reduce and mitigate the risks of data integration activity failures along with the impact they cause to other downstream processes. […]

By |January 17th, 2019|IT Management, Microsoft Azure|0 Comments

Configure automated availability deployments for SQL Server on Azure VMs

 

The high availability architectures are designed to be available even during the hardware, database or network failures. Azure VM instances offer 99.9% availability impacted by the SLA in three scenarios:

unplanned hardware maintenance
unexpected downtime
planned maintenance

To maintain redundancy one can group virtual machines into Availability Sets so that when a planned or unplanned event occurs at […]

By |January 10th, 2019|IT Management, Microsoft Azure|0 Comments

Azure SQL Data Warehouse automatic performance monitoring

 

Data warehouse performance monitoring and management are crucial for the overall health of the data environment and impact users’ ability to efficiently draw meaningful data insights.

Announced for preview Query Store feature provides customers with insight on query plan choice and performance by tracking queries, query plans, runtime statistics, and query history. Query Store combines a set of internal stores and […]

By |December 21st, 2018|Cloud Monitoring, Microsoft Azure|0 Comments

Automatic updates for Azure Site Recovery

 

Staying up-to-date with the latest software releases is one of the biggest hassles for administrators of the cloud services. Downloading the latest software and performing frequent upgrades is even more cumbersome if downtime is involved in the process.

Azure Site Recovery provides a monthly release with the latest features and enhancements. This means one would need to […]

By |December 19th, 2018|IT Management, Microsoft Azure|0 Comments