Hello world! Welcome to AzureCAT Guidance!


azurecatandsqlcat_logo

Welcome to the AzureCAT Guidance blog!

What is AzureCAT? CAT stands for “Customer Advisory Team.” We work with customers who act as feedback Advisors back to our product teams, by working on engagements with those customers and building ground-breaking solutions! We then have unique lessons we’ve learned from those solutions. And, thus, we publish them back to you to show you these insights, architectures, lessons learned, best practices, and emerging patterns, with Microsoft products, like Azure, SQL Server, Power BI, Visual Studio (and dev tools), and more!

The CATalogue

Today’s post is our gallery of AzureCAT content, lovingly referred to as the CATalogue. Scroll down to find a wealth of resources. Ask us any questions in the comments. Let us know if you find these resources helpful!

This blog will cover what’s new with our content at AzureCAT:

The SQLCAT content can be found over at the SQLCAT blog:

We have a team dedicated to SAP workloads on Microsoft technologies:

And AzureCAT also includes our sub-team, patterns & practices. They own and run the Azure Architecture Center. Their content can be found here:

Table of Contents

  1. patterns & practices
    1. Reference Architectures
    2. Cloud Design Patterns
    3. Best Practices for Cloud Applications
    4. Checklists
    5. Design for Resiliency
    6. Scenario Guides
    7. Videos
  2. AzureCAT Guidance
    1. Technical Customer Profiles
    2. How To Guides
    3. Conceptual Articles
    4. Troubleshooting Articles
    5. Templates
    6. Code Samples
    7. Tools
    8. Announcements
  3. HybridCAT: Building Clouds
    1. How-To Guides
    2. Conceptual Articles
    3. Troubleshooting Articles
    4. Videos
    5. Templates
    6. Code Samples
    7. Announcements
  4. SQLCAT Guidance
    1. Technical Customer Profiles
    2. How To Guides
    3. Conceptual Articles
    4. Explains
    5. Troubleshooting Articles
    6. Announcements
  5. Why Blog?

Let’s dig into our current content!

 

=========================

 

patterns & practices

Azure Architecture Center (the team owns and runs this site)

Reference Architectures

Windows VM workloads: (new; added 3/16)

  1. Single VM (Windows)
  2. Load balanced VMs (Windows)
  3. N-tier application (Windows)
  4. Multi-region application (Windows)

Linux VM workloads: (new; added 3/16)

  1. Single VM (Linux)
  2. Load-Balanced VMs (Linux)
  3. N-tier application (Linux)
  4. Multi-region application (Linux)

Hybrid network: (new; added 3/16)

  1. Choose a hybrid network
  2. VPN
  3. ExpressRoute
  4. ExpressRoute with VPN failover

Network DMZ: (new; added 3/16)

  1. DMZ between Azure and on-premises
  2. DMZ between Azure and the Internet
  3. Highly available NVA (new; added 3/16)

Identity management: (new; added 3/16)

  1. Integrate on-premises AD with Azure AD
  2. Extend AD DS to Azure
  3. Create an AD DS forest in Azure
  4. Extend AD FS to Azure

Managed web application: (new; added 3/16)

  1. Basic web application
  2. Improved scalability
  3. Multi-region deployment

Cloud Design Patterns

  1. Availability patterns (new; added 3/16)
    1. Health Endpoint Monitoring (new; added 3/16)
    2. Queue-Based Load Leveling (new; added 3/16)
    3. Throttling (new; added 3/16)
  2. Data Management patterns (new; added 3/16)
    1. Cache-Aside (new; added 3/16)
    2. CQRS (new; added 3/16)
    3. Event Sourcing (new; added 3/16)
    4. Index Table (new; added 3/16)
    5. Materialized View (new; added 3/16)
    6. Sharding (new; added 3/16)
    7. Static Content Hosting (new; added 3/16)
    8. Valet Key (new; added 3/16)
  3. Design and Implementation patterns (new; added 3/16)
    1. Compute Resource Consolidation (new; added 3/16)
    2. External Configuration Store (new; added 3/16)
    3. Leader Election (new; added 3/16)
    4. Pipes and Filters (new; added 3/16)
    5. Runtime Recongifuration (new; added 3/16)
  4. Messaging patterns (new; added 3/16)
    1. Competing Consumers (new; added 3/16)
    2. Priority Queue (new; added 3/16)
    3. Scheduler Agent Supervisor (new; added 3/16)
  5. Management and Monitoring patterns (new; added 3/16)
  6. Performance and Scalability patterns (new; added 3/16)
  7. Resiliency patterns (new; added 3/16)
    1. Circuit Breaker (new; added 3/16)
    2. Compensating Traction (new; added 3/16)
    3. Retry (new; added 3/16)
  8. Security patterns (new; added 3/16)
    1. Federated Identity (new; added 3/16)
    2. Gatekeeper (new; added 3/16)

Best Practices for Cloud Applications

  1. API design
  2. API implementation
  3. API security
  4. Autoscaling
  5. Background jobs
  6. Caching
  7. Content Delivery Network (CDN)
  8. Data partitioning
  9. Monitoring and diagnostics
  10. Naming conventions
  11. Retry guidance for specific services
  12. Transient fault handling

Checklists

  1. Availability checklist
  2. Resiliency checklist
  3. Scalability checklist

Design for Resiliency

  1. Designing resilient applications
  2. Resiliency checklist
  3. Failure mode analysis

Additional guidance:

  1. Disaster recovery (new; added 3/16)
  2. Disaster recovery and high availability (new; added 3/16)
  3. High availability (new; added 3/16)
  4. High availability checklist (new; added 3/16)
  5. Recovery from data corruption or accidental deletion (new; added 3/16)
  6. Recovery from local failures (new; added 3/16)
  7. Recovery from a region-wide service disruption (new; added 3/16)
  8. Recovery from on-premises to Azure (new; added 3/16)

Scenario Guides

Run Elasticsearch on Azure:

  1. Elasticsearch on Azure – Get started
  2. Tune data ingestion performance
  3. Tune data aggregation and query performance
  4. Configure resilience and recovery
  5. Create a performance testing environment
  6. Implement a JMeter test plan
  7. Deploy a JMeter JUnit sampler for testing
  8. Run the resiliency tests
  9. Run the performance tests

Azure for AWS Professionals:

  1. Introduction to Azure for AWS experts (new; added 3/16)
  2. Azure and AWS services comparison (new; added 3/16)

Identity Management for Multitenant Applications:

  1. Manage Identity in Multitenant Applications – Introduction
  2. The Tailspin scenario
  3. Authentication using Azure AD and OpenID Connect
  4. Claims-based identity
  5. Tenant sign-up
  6. Application roles
  7. Role-based and resource-based authorization
  8. Secure a backend web API
  9. Cache access tokens
  10. Client assertion
  11. Use Azure Key Vault to protect application secrets
  12. Federate with a customer’s AD FS

Additional Scenario Guides:

  1. Migrate from Cloud Services to Service Fabric (new; added 3/16)
  2. Developing big data solutions

Videos

 

=========================

 

azurecat_icon

AzureCAT Guidance

“Hands-on solutions, with our heads in the Cloud!”

Technical Customer Profiles

Service Fabric:

  1. BMW – Ed Price, Stas Kondratiev
  2. Digamore Entertainment – Ed Price (new; added 3/16)
  3. Mesh Systems – Michael Thomassy, Stas Kondratiev, Ed Price
  4. P2ware – Ed Price (new; added on 3/29)
  5. Proactima Solutions – Ed Price, Paolo Salvatori
  6. Quorum Business Solutions – Michael Thomassy, Ed Price
  7. Schneider Electric – James Podgorski, Ed Price
  8. Talk Talk TV – Ewan Fairweather

SAP to Azure:

How-To Guides

Active Directory:

  1. How to Set Up Identity with Azure AD and Office 365 APIs (.NET)

App Service:

  1. Using Web API 2 with Entity Framework 6 (new; added 4/5)
    1. Add Models and Controllers (new; added 4/5)
    2. Use Code First Migrations to Seed the Database (new; added 4/5)
    3. Handling Entity Relations (new; added 4/5)
    4. Create Data Transfer Objects (DTOs) (new; added 4/5)
    5. Create the JavaScript Client (new; added 4/5)
    6. Create the View (UI) (new; added 4/5)
    7. Display Item Details (new; added 4/5)
    8. Add a New Item to the Database (new; added 4/5)
    9. Publish the App to Azure Azure App Service (new; added 4/5)
  2. How to Provision ARM (.NET)
  3. How to use SQL Always Encrypted with Azure Web App Service

Application Insights:

  1. How to Monitor with Application Insights (.NET)

Automation:

  1. Deploy the Mobility service with Azure Automation DSC for replication of VM (new; added 4/10/17)
  2. Azure Automation & Hybrid Cloud Management: Automating deployment of a VM in Amazon Web Services (new; added 4/10/17)

Azure Portal:

  1. How to Set Up a Developer Environment (.NET)
  2. How to Monitor with Application Insights (.NET) (How to Monitor with Application Insights (Java)

Azure Resource Manager (ARM):

  1. ARM concepts in Azure Stack for the WAP Administrator – In-guest configuration with ARM, and technologies such as Virtual Machines Extensions, including PowerShell Desired State Configuration (DSC) (new; added 4/10/17)
  2. Creating and Connecting an ExpressRoute Circuit with Azure Resource Manager (new; added 4/10/17)
  3. Simple deployment of a VM Scale Set of Linux VMs with a jumpbox (new; added 3/29)
  4. Simple Cluster with ANSYS installed (new; added 3/29)
  5. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  6. Simple VMSS Cluster with Exa Powerflow installed (new; added 3/29)
  7. Simple VMSS Cluster with OpenFOAM installed (new; added 3/29)
  8. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  9. Azure CentOS 6&7 HPC ARM Template (new; added 3/29)
  10. Deploy a simple cluster with Open Source Software (new; added 3/29)
  11. Deploy a Torque cluster (new; added 3/29)
  12. Simple Cluster with DataSynapse installed (new; added 3/23)
  13. How to Provision ARM (.NET)

Backup:

  1. Taking backup of encrypted Azure VMs with ADE (Azure Disk Encryption) using Azure Backup in OMS (new; added 4/10/17)

Development Setup:

  1. How to Set Up a Developer Environment (.NET)
  2. How to Develop Modern Apps (.NET) (How to Develop Modern Apps (Java)
  3. How to Set Up Identity with Azure AD and Office 365 APIs (.NET)
  4. How to Set Up DevOps with Visual Studio Team Services (.NET)
  5. How to Provision ARM (.NET)
  6. How to Monitor with Application Insights (.NET)

DocumentDB:

  1. How to Set Up Identity with Azure AD and Office 365 APIs (.NET)

Event Hubs:

  1. How to store Event Hub events to Azure SQL Database
  2. How to read events off of Event Hubs from an IoT Hub with the Service Bus Explorer

IoT Hub:

  1. IoT Sample with Service Fabric and IoT Hub
  2. How to read events from an IoT Hub with the Service Bus Explorer
  3. IoT Sample with Service Fabric and Event Hubs

Key Vault:

  1. More Questions From Customers About SQL Server Transparent Data Encryption – TDE + Azure Key Vault (new; added 4/5)

Redis Cache:

  1. How to Develop Modern Apps (.NET)

Service Bus:

  1. How to implement a partitioned SendBatch method for Azure Service Bus entities
  2. How to read events from an IoT Hub with the Service Bus Explorer
  3. How to create a Service Bus Namespace and an Event Hub using a PowerShell script
  4. How to create Service Bus queues, topics and subscriptions using a PowerShell script
  5. How to handle Service Bus Relay Services in a multi-tenant environment

Service Fabric:

  1. Using a custom Service Fabric configuration provider with ASP.NET Core (new; added 4/10)

Site Recovery:

  1. Deploy the Mobility service with Azure Automation DSC for replication of VM (new; added 4/10/17)
  2. Add Azure automation runbooks to recovery plans (new; added 4/10/17)

SQL Data Warehouse:

  1. Azure SQL DW: How to move to a different region with restore from backup option

SQL Database:

  1. How to store Event Hub events to Azure SQL Database

Storage:

  1. How to Develop Modern Apps (.NET)

Stream Analytics:

  1. How to normalize incoming events in a Stream Analytics job
  2. How to find absence of signal in a Stream Analytics job

Virtual Machines (VMs):

  1. Implementing GlusterFS on Azure (new; added 4/5)
  2. Taking backup of encrypted Azure VMs with ADE (Azure Disk Encryption) using Azure Backup in OMS (new; added 4/10/17)
  3. ARM concepts in Azure Stack for the WAP Administrator – In-guest configuration with ARM, and technologies such as Virtual Machines Extensions, including PowerShell Desired State Configuration (DSC) (new; added 4/10/17)
  4. Simple deployment of a VM Scale Set of Linux VMs with a jumpbox (new; added 3/29)
  5. Simple Cluster with ANSYS installed (new; added 3/29)
  6. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  7. Simple VMSS Cluster with Exa Powerflow installed (new; added 3/29)
  8. Simple VMSS Cluster with OpenFOAM installed (new; added 3/29)
  9. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  10. SQL Server Availability Groups in Azure VM setup with AAD Domain Services (new; added 3/23)
  11. Deploy the Mobility service with Azure Automation DSC for replication of VM (new; added 4/10/17)
  12. How to Set Up a Developer Environment (.NET)
  13. How to Size SAP Systems Running on Azure VMs

Visual Studio Team Services:

  1. How to Set Up DevOps with Visual Studio Team Services (.NET)

Conceptual Articles

Azure Active Directory (AAD):

  1. Identity In Hybrid Cloud (Download Whitepaper) (new; added 4/10/17)

Azure Resource Manager (ARM):

  1. ARM concepts in Azure Stack for the WAP Administrator–Introduction Post (new; added 4/10/17)
    1. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack (new; added 4/10/17)
    2. ARM concepts in Azure Stack for the WAP Administrator – Multi-tier applications (new; added 4/10/17)
    3. ARM concepts in Azure Stack for the WAP Administrator – Packaging and publishing templates in Azure Stack (new; added 4/10/17)
    4. ARM concepts in Azure Stack for the WAP Administrator – Resource Deployment (new; added 4/10/17)
    5. ARM concepts in Azure Stack for the WAP Administrator — Offers, Plans, and Subscriptions (new; added 4/10/17)
    6. ARM concepts in Azure Stack for the WAP Administrator — Cloud Service Delivery (new; added 4/10/17)
  2. Tool: ARM Template Checker for Microsoft Azure Stack (new; added 4/10/17)
  3. New Azure PowerShell cmdlets for Azure Enhanced Monitoring

PowerShell:

  1. New Azure PowerShell cmdlets for Azure Enhanced Monitoring

Premium Storage:

  1. Where can I find documentation or information for SAP workloads on Azure?
  2. Azure Premium Storage is available for SAP workloads

SAP HANA:

  1. Backup guide for SAP HANA on Azure Virtual Machines (new; added 4/5)
  2. SAP HANA Azure Backup on file level (new; added 4/5)
  3. SAP HANA backup based on storage snapshots (new; added 4/5)
  4. Overview and Architecture of SAP HANA on Azure (Large Instances)
  5. Infrastructure and Connectivity to SAP HANA on Azure (Large Instances)
  6. Install SAP HANA on SAP HANA on Azure (Large Instances)
  7. High Availability and Disaster Recovery of SAP HANA on Azure (Large Instances)
  8. Troubleshooting and Monitoring of SAP HANA on Azure (Large Instances)

SAP on Azure:

  1. Top 14 Updates and New Technologies for Deploying SAP on Azure
  2. Where can I find documentation or information for SAP workloads on Azure?
  3. More offers in SAP Cloud Appliance Library for Azure
  4. New Azure PowerShell cmdlets for Azure Enhanced Monitoring
  5. Azure Quickstart Templates for SAP
  6. Protecting SAP Systems Running on VMware with Azure Site Recovery
  7. Distribution Standard Application Benchmark for SAP cloud deployments released using Azure IaaS VMs
  8. How to Size SAP Systems Running on Azure VMs
  9. Top 10 Key Considerations for Deploying SAP Applications on Azure
  10. Azure Premium Storage is available for SAP workloads

Site Recovery:

  1. Protecting SAP Systems Running on VMware with Azure Site Recovery

SQL Data Warehouse:

  1. Migrating data to Azure SQL Data Warehouse in practice
  2. Azure SQL Data Warehouse loading patterns and strategies
  3. Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

SQL Database:

  1. Migrating from SQL Server to Azure SQL Database using Bacpac Files
  2. Determining Database Size in Azure SQL Database V12
  3. Azure SQL DB: Unexpected Database Maximum Size Limit
  4. Connect to Azure SQL Database V12 via Redirection
  5. Using Table Valued Parameters with Always Encrypted in Azure SQL Database
  6. Azure SQL Database Security Features

Storage:

  1. Parallel File Systems for HPC Storage on Azure (new; added 3/23)

Virtual Machines:

  1. Parallel File Systems for HPC Storage on Azure (new; added 3/23)
  2. Top 14 Updates and New Technologies for Deploying SAP on Azure
  3. Where can I find documentation or information for SAP workloads on Azure?
  4. More offers in SAP Cloud Appliance Library for Azure
  5. Azure Quickstart Templates for SAP
  6. Protecting SAP Systems Running on VMware with Azure Site Recovery
  7. Distribution Standard Application Benchmark for SAP cloud deployments released using Azure IaaS VMs
  8. How to Size SAP Systems Running on Azure VMs
  9. Top 10 Key Considerations for Deploying SAP Applications on Azure

Windows:

  1. SAP GUI is supporting Windows 10 as operating system

Troubleshooting Articles

Azure Resource Manager (ARM):

  1. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack (new; added 4/10/17)

SQL Database:

  1. Azure SQL DB: Unexpected Database Maximum Size Limit

Storage:

  1. Backing up a VLDB to Azure Blob Storage (new; added 3/23)

Training

Azure Resource Manager:

  1. Azure Resource Manager Inside-Out (new; added 4/10/17)

Templates

  1. Microsoft OMS Quickstart Template (new; added 4/10/17)
  2. Deploy Host Guardian Service (HGS) For Shielded VM in Windows Server 2016 (new; added 4/10/17)
  3. Simple Cluster with DataSynapse installed (new; added 3/29)
  4. Simple deployment of a VM Scale Set of Linux VMs with a jumpbox (new; added 3/29)
  5. Simple Cluster with ANSYS installed (new; added 3/29)
  6. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  7. Simple VMSS Cluster with Exa Powerflow installed (new; added 3/29)
  8. Simple VMSS Cluster with OpenFOAM installed (new; added 3/29)
  9. Simple VMSS Cluster with StarCCM+ installed (new; added 3/29)
  10. Azure CentOS 6&7 HPC ARM Template (new; added 3/29)
  11. Deploy a simple cluster with Open Source Software (new; added 3/29)
  12. Deploy a Torque cluster (new; added 3/29)

Code Samples

  1. Using a custom Service Fabric configuration provider with ASP.NET Core (new; added 4/10)
  2. Secure a Web API with Individual Accounts and Local Login (new; added 4/5)
  3. BookService (Azure App Service & SQL Server) (new; added 4/5)
  4. IoT Sample with Service Fabric and IoT Hub
  5. IoT Sample with Service Fabric and Event Hubs
  6. Azure Service Fabric: Asynchronous Computing Actors
  7. Azure Service Fabric: Observer Sample
  8. IoT Sample: Reading events from an IoT Hub
  9. Event Hub Sample: Storing Event Hub events to Azure SQL Database
  10. Service Bus Sample: Handling Service Bus Relay Services in a multi-tenant environment

Tools

  1. Service Bus Explorer
  2. Service Bus Extensions
  3. Service Bus PowerShell Scripts

Announcements

Azure Resource Manager (ARM):

  1. Tool: ARM Template Checker for Microsoft Azure Stack (new; added 4/10/17)

SAP on Azure:

  1. SAP Business Objects support of SQL Server 2016 and Azure products (new; added 3/23)
  2. SAP Now Supports Azure Resource Manager (ARM) for Windows and Linux
  3. Top 14 Updates and New Technologies for Deploying SAP on Azure
  4. More offers in SAP Cloud Appliance Library for Azure
  5. New Azure PowerShell cmdlets for Azure Enhanced Monitoring
  6. Azure Premium Storage is available for SAP workloads

Windows Server 2016:

 

=========================

 

buildingclouds_icon

HybridCAT: Building Clouds

“Building hybrid clouds that can support any device from anywhere”

How-To Guides

Azure Pack:

  1. Extending Windows Azure Pack Using Service Management API (Whitepaper, GitHub) (new; added 4/10/17)

Azure Stack:

  1. Azure Stack API’s – Working directly with the Resource Manager API Layer (Technical Preview 1) (new; added 4/10/17)
  2. ARM concepts in Azure Stack for the WAP Administrator – In-guest configuration with ARM, and technologies such as Virtual Machines Extensions, including PowerShell Desired State Configuration (DSC) (new; added 4/10/17)

Operations Management Suite (OMS):

  1. Deploy the Mobility service with Azure Automation DSC for replication of VM (new; added 4/10/17)
  2. Monitoring your home IP security cameras with OMS Log Analytics (new; added 4/10/17)
  3. Taking backup of encrypted Azure VMs with ADE (Azure Disk Encryption) using Azure Backup in OMS (new; added 4/10/17)
  4. Using the OMS Search API with native PowerShell cmdlets (new; added 4/10/17)

PowerShell:

  1. Post notifications to Microsoft Teams using PowerShell (new; added 4/10/17)
  2. Monitoring your home IP security cameras with OMS Log Analytics (new; added 4/10/17)
  3. ARM concepts in Azure Stack for the WAP Administrator – In-guest configuration with ARM, and technologies such as Virtual Machines Extensions, including PowerShell Desired State Configuration (DSC) (new; added 4/10/17)
  4. Azure Automation & Hybrid Cloud Management: Automating deployment of a VM in Amazon Web Services (new; added 4/10/17)
  5. Using the OMS Search API with native PowerShell cmdlets (new; added 4/10/17)
  6. Creating and Connecting an ExpressRoute Circuit with Azure Resource Manager (new; added 4/10/17)

System Center:

  1. Updated White Paper – Enabling Database as a Service Enabling Database as a Service with the Microsoft Private Cloud Stack (Download Whitepaper) (new; added 4/10/17)

Windows Server:

  1. Part – 1: Nano Server Domain Join – Introduction (new; added 4/10/17)
  2. Part – 2: How to build a Windows PE and Nano Server image to deploy Nano Server-at-a-scale (new; added 4/10/17)
  3. Part  3: How to configure WDS, Unattend.xml file, Windows PE Image, and Nano Server image to deploy a Nano Server at-a-scale (new; added 4/10/17)

Conceptual Articles

Azure Pack:

  1. Windows Azure Pack Database as a Service and Websites available for deployment on Cloud Platform System Premium (new; added 4/10/17)
  2. Windows Azure Pack – Using the new AD Security Groups based Plan filtering feature in UR7 (new; added 4/10/17)
  3. Self-service deployment of Microsoft workloads on Cloud Platform System (and other systems with Windows Azure Pack) – Part 4 (new; added 4/10/17)

Azure Stack:

  1. ARM concepts in Azure Stack for the WAP Administrator–Introduction Post (new; added 4/10/17)
  2. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack (new; added 4/10/17)
  3. ARM concepts in Azure Stack for the WAP Administrator – Multi-tier applications (new; added 4/10/17)
  4. ARM concepts in Azure Stack for the WAP Administrator – Packaging and publishing templates in Azure Stack (new; added 4/10/17)
  5. ARM concepts in Azure Stack for the WAP Administrator – Resource Deployment (new; added 4/10/17)
  6. Tool: ARM Template Checker for Microsoft Azure Stack (new; added 4/10/17)
  7. ARM concepts in Azure Stack for the WAP Administrator — Offers, Plans, and Subscriptions (new; added 4/10/17)
  8. ARM concepts in Azure Stack for the WAP Administrator — Cloud Service Delivery (new; added 4/10/17)

Operations Management Suite (OMS):

  1. Backup & Site Recovery (OMS)
  2. Whitepaper – Architecting Hybrid Cloud Environments (Download Whitepaper) (new; added 4/10/17)
  3. Security Threat Analysis – Using Operations Management Suite (new; added 4/10/17)

PowerShell:

  1. Whitepaper – Architecting Hybrid Cloud Environments (Download Whitepaper) (new; added 4/10/17)

System Center – Cloud Platform System:

  1. Automated deployment of workloads: new solutions for centralized desktops (new; added 4/10/17)
  2. Windows Azure Pack Database as a Service and Websites available for deployment on Cloud Platform System Premium (new; added 4/10/17)
  3. Microsoft CPS Pre-Validated For FedRAMP Compliance (new; added 4/10/17)
  4. Whitepaper – Designing Your Network Infrastructure For Disaster Recovery (Download Whitepaper) (new; added 4/10/17)
  5. Self-service deployment of Microsoft workloads on Cloud Platform System (and other systems with Windows Azure Pack) – Part 4 (new; added 4/10/17)

Windows Server:

  1. Introducing the updated JEA Helper Tool (new; added 4/10/17)
  2. Windows Server Containers, what are they and where do they fit? (new; added 4/10/17)
  3. Whitepaper – Designing Your Network Infrastructure For Disaster Recovery (Download Whitepaper) (new; added 4/10/17)
  4. Identity In Hybrid Cloud (Download Whitepaper) (new; added 4/10/17)

Explains

Short descriptions and explanations.

Azure Stack:

  1. Microsoft Azure Stack Advanced Scenarios for TP1: Beyond the Basics (new; added 4/10/17)
  2. Microsoft Azure Stack Advanced Scenarios: Fundamentals (new; added 4/10/17)

System Center – Cloud Platform System:

  1. Automation of Remote Console deployment for CPS Standard (new; added 4/10/17)

Troubleshooting Articles

Azure Stack:

  1. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack (new; added 4/10/17)

Training

Azure Stack:

  1. Azure Resource Manager Inside-Out (new; added 4/10/17)

Videos

Operations Management Suite (OMS):

  1. (Part 1) Microsoft Operations Management Suite: Simplified IT Management for Any Enterprise (new; added 4/10/17)
  2. (Part 2) Microsoft Operations Management Suite: Simplified IT Management for Any Enterprise (new; added 4/10/17)

Templates

Operations Management Suite (OMS):

  1. Microsoft OMS Quickstart Template (new; added 4/10/17)

Windows Server:

  1. Deploy Host Guardian Service (HGS) For Shielded VM in Windows Server 2016 (new; added 4/10/17)

Code Samples

Azure Pack:

  1. Extending Windows Azure Pack Using Service Management API (Whitepaper, GitHub) (new; added 4/10/17)

Announcements

Azure Stack:

  1. Tool: ARM Template Checker for Microsoft Azure Stack (new; added 4/10/17)

Operations Management Suite (OMS):

  1. Backup & Site Recovery (OMS) (new; added 4/10/17)
  2. Channel 9 Series on Operations Management Suite (new; added 4/10/17)

System Center – Cloud Platform System:

  1. Automation of Remote Console deployment for CPS Standard (new; added 4/10/17)
  2. Microsoft and HPE partner to bring Azure in your datacenter with hyper-converged CPS Standard solution (new; added 4/10/17)
  3. Automated deployment of workloads: new solutions for centralized desktops (new; added 4/10/17)
  4. Windows Azure Pack Database as a Service and Websites available for deployment on Cloud Platform System Premium (new; added 4/10/17)
  5. Microsoft and Dell Extend Hybrid Cloud System Family with CPS Standard (new; added 4/10/17)
  6. CPS Update 2 Released (new; added 4/10/17)
  7. Microsoft CPS Pre-Validated For FedRAMP Compliance (new; added 4/10/17)

Windows Server:

  1. Windows 2016 is now Generally Available for SAP (new; added 3/23)
  2. Introducing the updated JEA Helper Tool (new; added 4/10/17)

 

=========================

 

sqlcat_icon

SQLCAT Guidance

Technical Customer Profiles

SQL Server:

How-To Guides

SAP on SQL Server:

  1. More Questions From Customers About SQL Server Transparent Data Encryption – TDE + Azure Key Vault (new; added 4/5)
  2. How to install or upgrade SAP Systems to SQL Server 2016
  3. How to slow down a SQL Server Database Backup

SQL Server:

  1. Azure SQL DW: How to move to a different region with restore from backup option
  2. How to improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
  3. How to deploy SQL Server R Services without Internet access
  4. How to Determine Database Sizes in Azure SQL Database V12
  5. How to use SQL Always Encrypted with Azure Web App Service
  6. How to slow down a SQL Server Database Backup
  7. How to Install SQL Server 2016 RTM
  8. How to assign surrogate keys to dimension tables in SQL DW and APS

Conceptual Articles

AlwaysOn:

  1. SQL Server 2016 AlwaysOn for SAP
  2. SQL Server 2012 AlwaysOn: Performance Aspects and Performance Monitoring II
  3. Reading from Database Mirroring or AlwaysOn Secondary Replicas in SAP Configurations

Azure SQL Data Warehouse:

  1. Migrating data to Azure SQL Data Warehouse in practice
  2. Azure SQL Data Warehouse loading patterns and strategies
  3. Choosing hash distributed table vs. round-robin distributed table in Azure SQL DW Service

Azure SQL Database:

  1. Migrating from SQL Server to Azure SQL Database using Bacpac Files
  2. Azure SQL DB: Unexpected Database Maximum Size Limit
  3. Connect to Azure SQL Database V12 via Redirection
  4. Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database

R Services:

  1. SQL Server 2016 R Services makes you a smarter T-SQL Developer
  2. Early Customer Experiences with SQL Server R Services

SAP on SQL Server:

  1. SAP on SQL: General Update for Customers & Partners March 2017 (new; added 4/5)
  2. SAP Business Objects support of SQL Server 2016 and Azure products (new; added 3/29)
  3. BW Queries by factors faster using FEMS-pushdown (new; added 3/23)
  4. Recent SAP BW improvements for SQL Server
  5. SQL Server: Improved SAP compression tool MSSCOMPRESS
  6. Whitepaper: SAP OS/DB Migration to SQL Server–FAQ v6.1 November 2016
  7. Moving from SAP 2-Tier to 3-Tier configuration and performance seems worse
  8. SQL Server: Simplified and faster SAP BW Process Chains
  9. SAP on SQL: General Update for Customers & Partners June 2016
  10. SQL Server 2016 Distributed Availability Groups for SAP
  11. SQL Server 2016 AlwaysOn for SAP
  12. Whitepaper: SAP on SQL Server 2012 and SQL Server 2014
  13. SQL Server: Improvements of SAP (BW) System Copy
  14. Distribution Standard Application Benchmark for SAP cloud deployments released using Azure IaaS VMs
  15. SQL Server 2012 AlwaysOn: Performance Aspects and Performance Monitoring II
  16. Reading from Database Mirroring or AlwaysOn Secondary Replicas in SAP Configurations

SQL Server 2016:

  1. SQL Server Availability Groups in Azure VM setup with AAD Domain Services (new; added 3/23)
  2. SQL Server: Oops Recovery with Temporal Tables
  3. SQL Server 2016: Supporting UTF-8 data for Bulk Insert or bcp utilities
  4. SQL Server 2016: Scripting Always Encrypted operations
  5. How SQL Server 2016 Cumulative Update 2 (CU2) can improve performance of highly concurrent workloads
  6. SQL Server 2016: Install Option for Instant File Initialization
  7. Using Table Valued Parameters with Always Encrypted in SQL Server 2016 and Azure SQL Database
  8. Changes in SQL Server 2016 Checkpoint Behavior
  9. Real World Parallel INSERT…SELECT: What else you need to know
  10. SQL Server 2016 R Services makes you a smarter T-SQL Developer
  11. SQL Server 2016: Parallel INSERT … SELECT
  12. SQL Server 2016:  Groups Automatic Seeding
  13. Early Customer Experiences with SQL Server R Services
  14. Checkpoint process for memory-optimized tables in SQL 2016 and implications on the log
  15. SQL Server 2016 Distributed Availability Groups for SAP
  16. SQL Server 2016 AlwaysOn for SAP
  17. SQL Server 2016: SSIS Data Flow Buffer Auto Sizing benefits data loading on Clustered Columnstore tables
  18. Soften the RBAR impact with Native Compiled UDFs in SQL Server 2016
  19. SQL 2016: Columnstore row group Merge policy and index maintenance improvements
  20. SQL Server and ‘Instant File Initialization’: Buffer Pool Extension
  21. SQL Server and ‘Instant File Initialization’: What happens when a database file is created
  22. SQL Server and ‘Instant File Initialization’: Physical and Valid Data Sizes

SSIS:

  1. SQL Server 2016: SSIS Data Flow Buffer Auto Sizing benefits data loading on Clustered Columnstore tables

T-SQL:

  1. SQL Server 2016 R Services makes you a smarter T-SQL Developer
  2. T-SQL ranking functions

Explains

Short descriptions and explanations:

  1. What is a DAX Expression?
  2. Determining Database Sizes in Azure SQL Database V12
  3. SQL Server 2016: DBCC CHECKDB with MAXDOP
  4. SQL Server 2016: TRUNCATE Selected Partitions
  5. The ‘aggregate concatenation’ T-SQL (anti-)pattern
  6. Common sub-expression elimination in SQL Server
  7. Finding SQL Server queries with large memory grants
  8. Azure SQL Database Security Features

Troubleshooting Articles

  1. Backing up a VLDB to Azure Blob Storage (new; added 3/23)
  2. Azure SQL DB: Unexpected Database Maximum Size Limit
  3. Transaction dependency limits with memory optimized tables – Error 41839
  4. PolyBase Setup Errors and Possible Solutions
  5. Considerations around validation errors 41305 and 41325 on memory optimized tables with foreign keys

Announcements

SAP on SQL Server:

  1. SAP on SQL: General Update for Customers & Partners March 2017 (new; added 4/5)
  2. SAP Business Objects support of SQL Server 2016 and Azure products (new; added 3/23)
  3. Recent SAP BW improvements for SQL Server
  4. SQL Server 2016 improvements for SAP (BW)

SQL Server 2016:

  1. SQL Server 2016: DBCC CHECKDB with MAXDOP
  2. SQL Server 2016: TRUNCATE Selected Partitions
  3. Azure SQL Database Security Features

Windows Server 2016:

    Leave us comments to let us know what you think and what content is helpful!

    =========================

    Why Blog?

    To share content! To share solutions! Like our tag line says, we offer “Hands-on solutions, with our heads in the Cloud.”

    But, yes, somewhere deep down, we enjoy our solutions, and whatever is in our heads should be shouted out to everyone else as well, right?

    So, with that in mind, we can’t publish a “Hello World” blog without digging into Scott Adam’s own musings about why blogs exist…

    MY OWN DILBERT BLOG

     When I see news stories about people all over the world who are experiencing hardships, I worry about them, and I rack my brain wondering how I can make a difference.  So I decided to start my own blog.  That way I won’t have time to think about other people.

     People who are trying to decide whether to create a blog or not go through a thought process much like this:

    1. The world sure needs more of ME.
    2. Maybe I’ll shout more often so that people nearby can experience the joy of knowing my thoughts.
    3. No, wait, shouting looks too crazy.
    4. I know—I’ll write down my daily thoughts and badger people to read them.
    5. If only there was a description for this process that doesn’t involve the words egomaniac or unnecessary.
    6. What? It’s called a blog?  I’m there!

     The blogger’s philosophy goes something like this:

    •      Everything that I think about is more fascinating than the <poopy> in your head.

     The beauty of blogging, as compared to writing a book, is that no editor will be interfering with my randumb spilling and grammar yes, my complete disregard for the facts (blogs get you rich), and my wandering sentences that seem to go on and on and never end so that you feel like you need to take a breath and clear your head before you can even consider making it to the end of the sentence that probably didn’t need to be written anyhoo.

    The Dilbert Newsletter, The Official Publication of Dogbert’s New Ruling Class, October 25, 2005, Issue 61

    http://www.unitedmedia.com/comics/dilbert/dnrc/html/newsletter61.html (it used to be there)

    And… I may have embellished his jokes a tad. You’ll never know that, though!

    Leave us comments to let us know what you think and what content is helpful! As well as your own musings about why blogs exist. =^)

    – Ninja Ed

    Comments (41)

    1. UPDATE: I added 29 more links to articles, designated with “new; added 1/5”

    2. pituach says:

      Impressive! I see lot of posts on the list that seem very interesting (at least their titles… now I need to find the time to read all their the content 🙂 )

      1. Cool. Well, let me know if anything jumps out at you. I imagine especially in the SQL space (since that’s your MVP focus area). We can get your response or feedback to the author. Thanks, Pituach!

        1. Awesome Image Ed on this Great Blog ! I Like it 😉
          I will also Share this information in the Netherlands with Education ( Teachers and Students ) to Learn from.
          Best Regards, James

          1. Thank you James, for sharing this with the teachers in Netherlands!

    3. UPDATE: I added a definition at the top for what CAT stands for.

    4. Great stuff, ed!

      I love how the Azure team has moved all of their docs onto GitHub. It makes contributing to the official documentation so much easier than leaving a comment that ‘may’ get read be someone and then acted upon.

    5. UPDATE: I added 32 more links to articles, designated with “new; added 1/6”

    6. Wow, that’s a lot content. I see I have some catching up to do. Do you read all these articles yourself Ed, or do you have a couple of assistants feeding them to you? 🙂

      1. I read everything! Mwahahahaha!

        Sort of, kind of, maybe. =^)
        I guess it depends on the definition of “read”.

    7. Wolfgang says:

      Wow Ed and Azure/SQLCat team!

      Impressive list.. now I only need time to read through all those interesting articles!

      Thanks,
      Wolfgang

      1. Thanks Wolfgang! Let me know which articles help you out!

    8. Nathan says:

      Lots of great content here, but this page is in dire need of an RSS feed for new content!

      1. Indeed it is! I’ll be experimenting with RSS to see what WordPress has available. Thanks, Nathan!

    9. Mattthew Teeter says:

      How to use SQL Always Encrypted with Azure Web App Service is pointing to the wrong link

      1. Alrighty. I think we’re all fixed. Much appreciated, Matthew!

    10. Thank you Azure CAT & SQL CAT and Ed Price for sharing this Awesome content !
      Shared it with the Community and made a link on my blogrole 😉
      Best Regards,
      James

      1. Awesome, thanks for the share, James!

      2. James, that splash image you made is awesome. I updated this article with it. Please review the change and let me know what you think. Thank you!

    11. Arlan Nugara says:

      Thanks Ed for compiling such a fantastic set of resources for Azure! I may have to retire some of my own blog postings on some of these topics and point them to some of these articles instead. I will also start to include this on my end slide at my presentations as a must view set of resources for learning and working with Azure.

      1. Arlan, we greatly appreciate it. Let us know if you have any suggestions.

    12. UPDATES: I added the splash image at the top.

      I embellished the CATalogue section at the top, including adding a link to the SAP CAT blog:

      http://aka.ms/SAPCAT

      I added another content piece, the Service Fabric Customer Profile for Proactima Solutions:

      https://blogs.msdn.microsoft.com/azureservicefabric/2017/01/06/service-fabric-customer-profile-proactima-solutions/

      I also removed the “New” flag for the 1/5 additions, since those are no longer newly added.

    13. UPDATE: I added 5 SAP HANA articles.

      Here is the first article in that series: https://docs.microsoft.com/en-us/azure/virtual-machines/linux/sap-hana-overview-architecture?toc=%2fazure%2fvirtual-machines%2flinux%2ftoc.json

      I also broke up the SQL CAT section called “Conceptual Articles & Whitepapers” into multiple sub-categories: AlwaysOn, Azure SQL Data Warehouse, Azure SQL Database, R Services, SAP on SQL Server, SQL Server 2016, SSIS, and T-SQL.

    14. UPDATES:

      I added 6 How-To articles about setup for Azure Development. Here is one example: https://github.com/AzureCAT-GSI/DevCamp/tree/master/HOL/dotnet/01-developer-environment

      Each article is available in 3 programming languages/flavors (.NET, Java, NodeJS), and so I added the different links in.

      I also finally got the TOC to work on this page. Click a link at the top to pop down to that section.

      And I removed the “new” tags next to the articles that I added on 1/6. Because they aren’t new anymore.

      Next: I have some workshops to add in.

    15. Hello Ed, I’m linking every blogpost I made to this site with my new Azure Advisor Banner 😉
      (See here for your self, just hit the banner under in the blogpost.)
      https://mountainss.wordpress.com/2017/02/11/microsoft-map-toolkit-9-6-now-available-winserv-sql2016-azure-office365-cloud-tool/

      1. That’s great. Thanks, James!

    16. skeeler says:

      Hi Ed, great content! Is it possible to get an RSS feed for the site?

      1. There is only an RSS feed for the blog: https://blogs.msdn.microsoft.com/azurecat/feed/

        We’re making requests for the individual pages. Thanks!

    17. Awesome job Ed!
      This is phenomenal effort… this was missing piece between AWS and Azure. Good documentation and great architecture whitepapers.

      One more suggestion if possible please connect dots between 2 teams. Microsoft Marketing is working on pathfinder (https://www.azurepathfinder.com/) & its a great presales effort. if you can connect with path finder the appropriate solution and also provide a estimated TCO using Azure Calc… it would be elegant sales + delivery tool for Partners TSP’s & CSA’s and Microsoft TSP’s & CSA’s and Customer Azure Teams.

      1. Cool. Thanks, Balkrishna!

        Pathfinder is a service recommendation tool. How would it connect with our content library?

        Oh you just mean in general that Pathfinder and Calc should work together? Here is Azure Calculator: https://azure.microsoft.com/en-us/pricing/calculator/

        I can pass on that feedback. Thanks!

        Thanks again!

    18. UPDATES: You can check the dates to see what I added over the last two weeks. Here is the breakdown of the patterns & practices new articles (found on http://aka.ms/Architecture)…

      Reference Architectures
      – Windows VM workloads: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/virtual-machines-windows/index
      – Linux VM workloads: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/virtual-machines-linux/
      – Hybrid network: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/
      – Network DMZ: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/dmz/index
      – Highly available NVA (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/dmz/nva-ha
      – Identity management: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/identity/index
      – Managed web application: (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/managed-web-app/index

      Cloud Design Patterns
      – Availability patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/availability
      – Health Endpoint Monitoring (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/health-endpoint-monitoring
      – Queue-Based Load Leveling (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/queue-based-load-leveling
      – Throttling (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/throttling
      – Data Management patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/data-management
      – Cache-Aside (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/cache-aside
      – CQRS (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/cache-aside
      – Event Sourcing (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/event-sourcing
      – Index Table (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/index-table
      – Materialized View (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/index-table
      – Sharding (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/sharding
      – Static Content Hosting (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/static-content-hosting
      – Valet Key (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/valet-key
      – Design and Implementation patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/design-implementation
      – Compute Resource Consolidation (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/compute-resource-consolidation
      – External Configuration Store (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/external-configuration-store
      – Leader Election (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/compute-resource-consolidation
      – Pipes and Filters (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/pipes-and-filters
      – Runtime Recongifuration (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/runtime-reconfiguration
      – Messaging patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/messaging
      – Competing Consumers (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/competing-consumers
      – Priority Queue (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/priority-queue
      – Scheduler Agent Supervisor (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/scheduler-agent-supervisor
      – Management and Monitoring patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/management-monitoring
      – Performance and Scalability patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/performance-scalability
      – Resiliency patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/resiliency
      – Circuit Breaker (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/scheduler-agent-supervisor
      – Compensating Traction (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/compensating-transaction
      – Retry (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/retry
      – Security patterns (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/category/security
      – Federated Identity (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/federated-identity
      – Gatekeeper (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/patterns/gatekeeper

      Design for Resiliency
      – Disaster recovery (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/disaster-recovery-azure-applications
      – Disaster recovery and high availability (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/disaster-recovery-high-availability-azure-applications
      – High availability (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/high-availability-azure-applications
      – High availability checklist (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/high-availability-checklist
      – Recovery from data corruption or accidental deletion (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/recovery-data-corruption
      – Recovery from local failures (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/recovery-local-failures
      – Recovery from a region-wide service disruption (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/recovery-loss-azure-region
      – Recovery from on-premises to Azure (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/resiliency/recovery-on-premises-azure

      Azure for AWS Professionals:
      – Introduction to Azure for AWS experts (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/aws-professional/
      – Azure and AWS services comparison (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/aws-professional/services

      Additional Scenario Guides:
      – Migrate from Cloud Services to Service Fabric (new; added 3/16) https://docs.microsoft.com/en-us/azure/architecture/service-fabric/migrate-from-cloud-services

      Whooo! That’s a lot! That’s just from the patterns & practices team! Find all their work over at the new Azure Architecture Center: http://aka.ms/Architecture

      It doesn’t include our recent additions from our other two Azure CAT groups (Azure CAT Guidance and SQLCAT Guidance)!

    19. Very detailed information Ed Price. Thanks for sharing helpful content.

      1. My pleasure, Amjad. Thanks for checking out the articles!

    20. AZURECAT UPDATES: Last week I commented on all the updates over the last few weeks, that came from our patterns & practices team, over on the Azure Architecture Center. This comment is going to show all the new articles added recently from our AzureCAT team:

      TECHNICAL CUSTOMER PROFILES:

      Service Fabric:
      – Digamore Entertainment (new; added 3/16) – https://blogs.msdn.microsoft.com/azureservicefabric/2017/03/03/service-fabric-customer-profile-digamore-entertainment-gmbh/
      – P2ware (new; added on 3/29) – https://blogs.msdn.microsoft.com/azureservicefabric/2017/03/24/service-fabric-customer-profile-p2ware/

      SAP to Azure:
      – BNW Consulting + Large Australian Energy Company (new; added 3/29) – https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/27/large-australian-energy-company-modernizes-sap-applications-moves-to-azure-public-cloud/

      HOW-TO-GUIDES:

      App Service:
      – Using Web API 2 with Entity Framework 6 (new; added 4/5) – https://docs.microsoft.com/en-us/aspnet/web-api/overview/data/using-web-api-with-entity-framework/part-1

      Azure Resource Manager (ARM):
      – Simple Cluster with DataSynapse installed (new; added 3/23) – https://github.com/tanewill/5clickTemplates/tree/master/DataSynapse
      – Simple deployment of a VM Scale Set of Linux VMs with a jumpbox (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawClusterV2
      – Simple Cluster with ANSYS installed (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawANSYSCluster
      – Simple VMSS Cluster with StarCCM+ installed (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawAbqCluster
      – Simple VMSS Cluster with Exa Powerflow installed (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawExaCluster

      Key Vault:
      – More Questions From Customers About SQL Server Transparent Data Encryption: TDE + Azure Key Vault (new; added 4/5) – https://blogs.msdn.microsoft.com/saponsqlserver/2017/04/04/more-questions-from-customers-about-sql-server-transparent-data-encryption-tde-azure-key-vault/

      Virtual Machines:
      – Implementing GlusterFS on Azure (new; added 4/5) – https://blogs.msdn.microsoft.com/azurecat/2017/03/31/implementing-glusterfs-on-azure-hpc-scalable-parallel-file-system/
      – SQL Server Availability Groups in Azure VM setup with AAD Domain Services (new; added 3/23) – https://blogs.msdn.microsoft.com/sqlcat/2017/02/23/sql-server-availability-groups-in-azure-vm-setup-with-aad-domain-services/

      CONCEPTUAL ARTICLES:

      SAP HANA:
      – Backup guide for SAP HANA on Azure Virtual Machines (new; added 4/5) – https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-hana-backup-guide
      – SAP HANA Azure Backup on file level (new; added 4/5) – https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-hana-backup-file-level
      – SAP HANA backup based on storage snapshots (new; added 4/5) – https://docs.microsoft.com/en-us/azure/virtual-machines/workloads/sap/sap-hana-backup-storage-snapshots

      Storage/Virtual Machines:
      – Parallel File Systems for HPC Storage on Azure (new; added 3/23) – https://blogs.msdn.microsoft.com/azurecat/2017/03/17/parallel-file-systems-for-hpc-storage-on-azure/

      TROUBLESHOOTING ARTICLES:

      Storage:
      – Backing up a VLDB to Azure Blob Storage (new; added 3/23) – https://blogs.msdn.microsoft.com/sqlcat/2017/03/10/backing-up-a-vldb-to-azure-blob-storage/

      TEMPLATES:

      – Simple VMSS Cluster with OpenFOAM installed (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawOpenFOAMCluster
      – Simple VMSS Cluster with StarCCM+ installed (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/RawStarCCMCluster
      – Azure CentOS 6&7 HPC ARM Template (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/SLURM_CentOS
      – Deploy a simple cluster with Open Source Software (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/SimpleOSSCluster
      – Deploy a Torque cluster (new; added 3/29) – https://github.com/tanewill/5clickTemplates/tree/master/torque-cluster-custom-image

      CODE SAMPLES:

      – Secure a Web API with Individual Accounts and Local Login (new; added 4/5) – https://github.com/MikeWasson/LocalAccountsApp
      – BookService (Azure App Service & SQL Server) (new; added 4/5) – https://github.com/MikeWasson/BookService

      ANNOUNCEMENTS:

      SAP on Azure:
      – SAP Business Objects support of SQL Server 2016 and Azure products (new; added 3/23) – https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/09/sap-business-objects-support-of-sql-server-2016-and-azure-products/

      Windows Server 2016:
      – Windows 2016 is now Generally Available for SAP (new; added 3/23) – https://blogs.msdn.microsoft.com/saponsqlserver/2017/03/07/windows-2016-is-now-generally-available-for-sap/

      ===================================

      There you go! Lots of new articles from AzureCAT! The patterns & practices team focuses on writing content for the Azure Architecture Center. The AzureCAT bucket is content written by our program managers who are running customer engagements and building solutions. So you get it straight from the experts!

    21. UPDATES: I added the “HybridCAT: Building Clouds” section, with 50+ new articles on Azure Pack, Azure Stack, OMS (Operations Management Suite), and Azure integration with PowerShell, Windows Server, and System Center. HybridCAT was formerly WSSC CAT (WSSC stands for Windows Server + System Center), and the team is now part of the AzureCAT group!

      1. Martin Raja says:

        I am new to Azure services. Happy to see a lot of content for Architecture community. I am looking for the details od Azure Apps Service environments Good practicses and design patterns. I see architecture diagrams for web apps but I need details around ASE and options with Secured Access (Private Vnet).

        1. chilberto says:

          Hello Martin, You might want to take a look at a series of posts by Olivier Martin. From there you can jump to specific documentation that should help with what you are looking for.

            1. Great resource! Thanks, Chilberto!

    Skip to main content