2008, 2018

Profiling Slow MySQL Queries In Azure With EXPLAIN

By |August 20th, 2018|Azure How To, IT Management, Microsoft Azure|0 Comments

 

Azure Database for MySQL is a PaaS (Platform as a Service) solution that Microsoft offers on Azure. Using Azure managed services for MySQL enables one to easily build an intelligent and secure application.

It often happens that a simple query can become a bottleneck impacting the entire database performance. MySQL integrates a very useful tool – the EXPLAIN […]

2706, 2018

Features of the Default Compatibility Level 140 for Azure SQL Database

By |June 27th, 2018|Azure News, Microsoft Azure|0 Comments

Compatibility Level 140 has become a part of Azure default features and users can automatically get it once they create a database in Azure. The service is available in most regions and the number of databases running on Azure has reached up to 539, 903.

Compatibility Level 140  Features:

Exclusive Features: adaptive query processing is a major […]

211, 2017

Features of Azure SQL Database and Data Warehouse VNET Service Endpoints Public Preview

By |November 2nd, 2017|Azure News, Microsoft Azure, New Features|0 Comments

Azure SQL Database and Data Warehouse endpoint services let you isolate the connectivity of your SQLDB and subnets within the VNET. The availability of services is limited only to West Central US, East US1, and West US2 regions. The traffic will remain with the Azure network irrespective of connectivity that is present on Azure SQL […]

1409, 2017

Performance and Storage Upgrades in Azure SQL Database

By |September 14th, 2017|Azure News, Microsoft Azure, New Features|0 Comments

Up till the recent developments in Azure SQL, the maximum performance cornerstone for a single data repository located in the standard tier was marked to 100 DTUs. Now, the rate at which the latest updates have increased the performance markup is a whopping 30 times thus making it around 3000 DTUs. The latest S4-S12 performance […]

301, 2017

CloudMonix vs native Azure Monitoring

By |January 3rd, 2017|Cloud Automation, Cloud Monitoring, General, Microsoft Azure, News & Press|0 Comments

CloudMonix monitors a wide range of data, offering a comprehensive overview of both Azure and standalone resources. Much of the information tracked by CloudMonix is not available in Azure Portal. A comprehensive list of differences by each resource is outlined later in this article.

In addition to monitoring, CloudMonix offers a number of unique automation features […]

3110, 2016

CloudMonix New Features: Auto-scaling of SQL Azure and SQL Data Warehouse

By |October 31st, 2016|Azure How To, Cloud Automation, Cloud Monitoring, Cloud Platforms, IT Management, Microsoft Azure, New Features, News & Press|0 Comments

Over the weekend of October 28th, CloudMonix team released a number of important features for monitoring and automating of SQL Azure and SQL Data Warehouse databases. In addition, a few new integrations have been enabled.

– Azure SQL Databases are one of the most popular ways to store relational data in the Microsoft Azure […]

1211, 2015

The Ultimate list of Top SQL Monitoring Tools

By |November 12th, 2015|Cloud Monitoring, Cloud Platforms, IT Management|23 Comments

SQL Monitoring tools help monitor, optimize and automate day to day database administration and management operations.  They provide database administrators, designers and engineers with knowledge and power to optimize their database systems for optimal business performance in diverse, complex production environments.

Whether your needs are for on premises, cloud or hybrid database infrastructures,  SQL Monitoring Tools can […]

1407, 2015

How to copy SQL Azure database to local development server?

By |July 14th, 2015|Azure How To, Microsoft Azure|0 Comments

SQL Azure Database provides all the essential database creation, querying, testing and optimization tools from the Azure Cloud Service Platform. However, there are times when you do need to work on database hosted on Azure from your local development server.

So how would you copy and transfer database from SQL Azure to your locally hosted SQL […]

704, 2015

Top SQL Azure metrics to monitor

By |April 7th, 2015|Cloud Monitoring, General|0 Comments

Ensuring that database tier is always available and performing optimally is one of the most important tasks for engineers running apps in the Microsoft Azure cloud. Performance slowdowns or outages in the database tier typically impact overall applications in most fundamental ways. In this blog entry, we’ll highlight the secret sauce behind some of the […]