Data engineering
SQL
noSQL
database administration
data analysis
reporting
big data
analytics
data warehouse
data lake
Introduction Suppose you are facing a performance bottleneck in an on-premises or cloud infrastructure, which after troubleshooting, gets down to being related to storage performance. Some storage subsystem(s) and/or disk appliances or virtual disks are misbehaving or under-performing. You need to monitor disk IOPS performance in detail and detect the root cause of storage performance. ... Read more
Introduction to Datacenter Technology This article provides a technical overview of datacenter technologies and systems. Datacenters form the backbone of the digital world, acting as the central hubs where computing resources are concentrated for remote access. These sprawling complexes of servers, networking equipment, and other hardware allow for the seamless delivery and storage of data, ... Read more
This article describes the Backup items in a business continuity and disaster recovery plan. What is a business continuity and disaster recovery (BCDR) plan? A business continuity and disaster recovery (BCDR) plan is a document which describes how a company or organization will continue to operate during and after an unplanned disruption in service. The ... Read more
Introduction When planning for the deployment or migration to any Azure storage type, there are a number of design factors to take into account. The current post lists Azure Storage design considerations and can be used as a design guide by Azure architects and pre-sales engineers when designing Azure storage solutions. Azure storage account types ... Read more
Azure database for MySQL zone and region disaster recovery The Azure database for MySQL instance can be scaled up and down depending on your organization requirements without downtime, as described at: . This article describes all possible failure events (except for region-level failure), which are automatically managed by the Azure database for MySQL service, without ... Read more
Introduction This article provides a high-level overview of services for hosting SQL Server workloads in the Azure Cloud. Microsoft Azure offers a handful of cloud services for hosting your SQL as well as NoSQL databases and in-memory databases. The supported SQL databases are SQL Server, Oracle database, MySQL, PostGreSQL and MariaDB. Hosting SQL databses in ... Read more
This article provides a high-level analysis of the Exchange Online and SharePoint Online data protection mechanisms. After migrating to Exchange Online and SharePoint Online, you need to consider the available Exchange Online and SharePoint Online data protection mechanisms. All Office365 components are adequately protected from accidental deletion via the usage of various Office365 features. The ... Read more
This post discusses recommended services for on-prem virtualization infrastructures. The post is also available in my podcast. When deploying an on-premises virtualization infrastructure (which could also be thought of as a private cloud with the sole customer being the enterprise/organization itself) there are services and server roles which should be considered in order to achieve ... Read more
Cloud infrastructure architecture and application/software architecture diagram software is very important when designing and communicating the architecture of a new or existing infrastructure, whether that be cloud, on-prem or hybrid. Microsoft Visio Microsoft Visio is one of the leading software packages for data center diagram design. A Visio stencil is a collection of masters associated ... Read more
This article provides Dell server and storage capacity planning resources. When designing server and storage solutions from Dell, the following Web resources are highly useful:
