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:

We publish our Whitepapers and E-books on Azure.com:

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:

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

Linux VM workloads:

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

Hybrid network:

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

Network DMZ:

  1. DMZ between Azure and on-premises
  2. DMZ between Azure and the Internet
  3. Highly available NVA

Identity management:

  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:

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

Cloud Design Patterns

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

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
  2. Disaster recovery and high availability
  3. High availability
  4. High availability checklist
  5. Recovery from data corruption or accidental deletion
  6. Recovery from local failures
  7. Recovery from a region-wide service disruption
  8. Recovery from on-premises to Azure

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
  2. Azure and AWS services comparison

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
  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
  3. Mesh Systems - Michael Thomassy, Stas Kondratiev, Ed Price
  4. P2ware - Ed Price
  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
    1. Add Models and Controllers
    2. Use Code First Migrations to Seed the Database
    3. Handling Entity Relations
    4. Create Data Transfer Objects (DTOs)
    5. Create the JavaScript Client
    6. Create the View (UI)
    7. Display Item Details
    8. Add a New Item to the Database
    9. Publish the App to Azure Azure App Service
  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
  2. Azure Automation & Hybrid Cloud Management: Automating deployment of a VM in Amazon Web Services

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)
  2. Creating and Connecting an ExpressRoute Circuit with Azure Resource Manager
  3. Simple deployment of a VM Scale Set of Linux VMs with a jumpbox
  4. Simple Cluster with ANSYS installed
  5. Simple VMSS Cluster with StarCCM+ installed
  6. Simple VMSS Cluster with Exa Powerflow installed
  7. Simple VMSS Cluster with OpenFOAM installed
  8. Simple VMSS Cluster with StarCCM+ installed
  9. Azure CentOS 6&7 HPC ARM Template
  10. Deploy a simple cluster with Open Source Software
  11. Deploy a Torque cluster
  12. Simple Cluster with DataSynapse installed
  13. How to Provision ARM (.NET)

Backup:

  1. Taking backup of encrypted Azure VMs with ADE (Azure Disk Encryption) using Azure Backup in OMS

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

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

Site Recovery:

  1. Deploy the Mobility service with Azure Automation DSC for replication of VM
  2. Add Azure automation runbooks to recovery plans

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
  2. Taking backup of encrypted Azure VMs with ADE (Azure Disk Encryption) using Azure Backup in OMS
  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)
  4. Simple deployment of a VM Scale Set of Linux VMs with a jumpbox
  5. Simple Cluster with ANSYS installed
  6. Simple VMSS Cluster with StarCCM+ installed
  7. Simple VMSS Cluster with Exa Powerflow installed
  8. Simple VMSS Cluster with OpenFOAM installed
  9. Simple VMSS Cluster with StarCCM+ installed
  10. SQL Server Availability Groups in Azure VM setup with AAD Domain Services
  11. Deploy the Mobility service with Azure Automation DSC for replication of VM
  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
    1. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack
    2. ARM concepts in Azure Stack for the WAP Administrator – Multi-tier applications
    3. ARM concepts in Azure Stack for the WAP Administrator – Packaging and publishing templates in Azure Stack
    4. ARM concepts in Azure Stack for the WAP Administrator – Resource Deployment
    5. ARM concepts in Azure Stack for the WAP Administrator — Offers, Plans, and Subscriptions
    6. ARM concepts in Azure Stack for the WAP Administrator — Cloud Service Delivery
  2. Tool: ARM Template Checker for Microsoft Azure Stack
  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
  2. SAP HANA Azure Backup on file level
  3. SAP HANA backup based on storage snapshots
  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

Virtual Machines:

  1. Parallel File Systems for HPC Storage on Azure
  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

SQL Database:

  1. Azure SQL DB: Unexpected Database Maximum Size Limit

Storage:

  1. Backing up a VLDB to Azure Blob Storage

Training

Azure Resource Manager:

  1. Azure Resource Manager Inside-Out

Templates

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

Code Samples

  1. Using a custom Service Fabric configuration provider with ASP.NET Core
  2. Secure a Web API with Individual Accounts and Local Login
  3. BookService (Azure App Service & SQL Server)
  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

SAP on Azure:

  1. SAP Business Objects support of SQL Server 2016 and Azure products
  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)

Azure Security & Operations Management / Operations Management Suite (OMS):

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

Azure Stack:

  1. Azure Stack API’s – Working directly with the Resource Manager API Layer (Technical Preview 1)
  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)

PowerShell:

  1. Post notifications to Microsoft Teams using PowerShell
  2. Monitoring your home IP security cameras with OMS Log Analytics
  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)
  4. Azure Automation & Hybrid Cloud Management: Automating deployment of a VM in Amazon Web Services
  5. Using the OMS Search API with native PowerShell cmdlets
  6. Creating and Connecting an ExpressRoute Circuit with Azure Resource Manager

System Center:

  1. Updated White Paper – Enabling Database as a Service Enabling Database as a Service with the Microsoft Private Cloud Stack (Download Whitepaper)

Windows Server:

  1. Part – 1: Nano Server Domain Join – Introduction
  2. Part – 2: How to build a Windows PE and Nano Server image to deploy Nano Server-at-a-scale
  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

Conceptual Articles

Azure Pack:

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

Azure Security & Operations Management / Operations Management Suite (OMS):

  1. Backup & Site Recovery (OMS)
  2. Whitepaper – Architecting Hybrid Cloud Environments (Download Whitepaper)
  3. Security Threat Analysis – Using Operations Management Suite

Azure Stack:

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

PowerShell:

  1. Whitepaper – Architecting Hybrid Cloud Environments (Download Whitepaper)

System Center - Cloud Platform System:

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

Windows Server:

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

Explains

Short descriptions and explanations.

Azure Stack:

  1. Microsoft Azure Stack Advanced Scenarios for TP1: Beyond the Basics
  2. Microsoft Azure Stack Advanced Scenarios: Fundamentals )

System Center - Cloud Platform System:

  1. Automation of Remote Console deployment for CPS Standard

Troubleshooting Articles

Azure Stack:

  1. ARM concepts in Azure Stack for the WAP Administrator – Troubleshooting IaaS in Azure Stack

Training

Azure Stack:

  1. Azure Resource Manager Inside-Out

Videos

Azure Security & Operations Management / Operations Management Suite (OMS):

  1. (Part 1) Microsoft Operations Management Suite: Simplified IT Management for Any Enterprise
  2. (Part 2) Microsoft Operations Management Suite: Simplified IT Management for Any Enterprise

Templates

Azure Security & Operations Management / Operations Management Suite (OMS):

  1. Microsoft OMS Quickstart Template

Windows Server:

  1. Deploy Host Guardian Service (HGS) For Shielded VM in Windows Server 2016

Code Samples

Azure Pack:

  1. Extending Windows Azure Pack Using Service Management API (Whitepaper, GitHub)

Announcements

Azure Security & Operations Management / Operations Management Suite (OMS):

  1. Backup & Site Recovery (OMS)
  2. Channel 9 Series on Operations Management Suite

Azure Stack:

  1. Tool: ARM Template Checker for Microsoft Azure Stack

System Center - Cloud Platform System:

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

Windows Server:

  1. Windows 2016 is now Generally Available for SAP
  2. Introducing the updated JEA Helper Tool

 

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

 

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
  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
  2. SAP Business Objects support of SQL Server 2016 and Azure products
  3. BW Queries by factors faster using FEMS-pushdown
  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
  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
  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
  2. SAP Business Objects support of SQL Server 2016 and Azure products
  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

Azure CAT Guidance

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