Data engineering
SQL
noSQL
database administration
data analysis
reporting
big data
analytics
data warehouse
data lake
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 that outlines how an organization will continue to operate during an unplanned disruption in service. The plan should include procedures … 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
Introduction to the Microsoft DP-900 certification exam This article provides information about the Microsoft DP-900 certification exam study guide. The Microsoft DP-900 measures the following skills: The passing score for the DP-900 exam is 700. As of this writing (December 2022) the English version of the DP-900 exam was last updated on August 4, 2022. … Read more
World Backup Day – 31st March World Backup Day is a day for people to learn about the increasing role of data in our lives and the importance of regular backups. This independent initiative to raise awareness about backups and data preservation started out on reddit by a couple of concerned users. The World Backup … Read more
Introduction Power BI is a cloud-based suite of business analytics tools that lets anyone connect to, visualize, and analyze data with greater speed, efficiency, and understanding. It connects users to a broad range of live data through easy-to-use dashboards, provides AI-infused automated insights, embedded and interactive reports, and delivers compelling visualizations that bring data big … 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 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 with a particular Microsoft … Read more
