Highly Available SQL 2012 across Azure VNET (Part 2)

5th of August, 2014 / / 1 Comment

Part 1 can be found here.

In this Part 2 we will discuss:

  • Create DC on Azure and confirm VNET to VNET connectivity
  • SQL VMs
  • Configure WSFC and lastly configure AAG

DC and Connectivity VNET to VNET

First thing first, we need VMs for the Domain Controller (DC) and SQL Server 2012. I will use my script below to create few VMs

I created 2 DC , one on each VNET: AZSEDC001 and AZUSDC001
I registered both as DNS on Azure.… [Keep reading] “Highly Available SQL 2012 across Azure VNET (Part 2)”

Highly Available SQL 2012 across Azure VNET (Part 1: VNET Peering)

1st of August, 2014 / / 1 Comment

Just over a year Microsoft announced the support of SQL Server AlwaysOn Availability Groups (AAG) on Microsoft Azure IaaS. Last month, Microsoft announced the support of SQL AAG between Azure Regions. This is a great news for great technology like SQL Server 2012 for highly available and disaster recovery scenario. SQL AAG released in SQL 2012 and enhanced in SQL 2014. AAG will detect anomaly which will impact SQL availability. When We will discuss how to do this in two blog posts:

  • Part1: Design SQL 2012 AAG across Azure VNET and How to create Microsoft Azure VNET to VNET peering
  • Part2: SQL, WSFC, Configure Quorum and Voting (SQL) and Configure AAG

Part1 SQL 2012 AAG across Azure VNET SQL 2012 AAG is designed to provide high availability for SQL database and Azure IaaS is great place where this technology can live.… [Keep reading] “Highly Available SQL 2012 across Azure VNET (Part 1: VNET Peering)”

Azure Mobile Services and the Internet of Things

30th of July, 2014 / / 11 Comments

The IT industry is full of buzzwords and “The Internet of Things” (IoT) is one that’s getting thrown about a lot lately. The IoT promises to connect billions of devices and sensors to the internet. How this data is stored, sorted, analysed and surfaced will determine the amount of value it is to your business. With this in mind I thought it’s time to start playing around with some bits and pieces to see if I could create my very own IoT connected array of sensors.… [Keep reading] “Azure Mobile Services and the Internet of Things”

Static DIP Request, VIP Reservation on Microsoft Azure

18th of July, 2014 / / No Comments

 

Firstly, what is Azure VIP (Virtual IP address) and DIP (internal IP address assigned by Azure DHCP) on Microsoft Azure?

Microsoft Azure VM has two known IP addresses:

  • VIP: Public IP address pointing to Azure Cloud Service where VM is deployed. Every Cloud Service has a VIP and every Cloud Service can have several VMs. A VIP assigned to Cloud Service won’t be released until last VM on that Cloud Service is Stopped (De-allocated)
    or Deleted
  • DIP: Internal IP address assigned to the VM by Azure DHCP.
… [Keep reading] “Static DIP Request, VIP Reservation on Microsoft Azure”

Portable Inversion of Control (IoC) Container for Mobile Development

4th of July, 2014 / / 3 Comments

TDD in Mobile Development – Part 2

This post is the second in a series that talks about TDD in Mobile Development, the links below show the other parts of the series.

TDD in Mobile Development
1. Unit Testing of Platform-Specific Code in Mobile Development.
2. Portable IoC (Portable.TinyIoC) for Mobile Development
3. Mobile Test-Driven Development – Running your unit tests from your IDE

[Update Date = 3rd July 2015]

I wrote this post sometime back when TinyIoC was the only one that I know that worked well on Xamarin.… [Keep reading] “Portable Inversion of Control (IoC) Container for Mobile Development”

TDD for Mobile Development – Part 1

29th of June, 2014 / / 5 Comments

TDD for Mobile Development – Part 1
1. Unit Testing of Platform-Specific Code in Mobile Development.
2. Portable IoC (Portable.TinyIoC) for Mobile Development
3. Mobile Test-Driven Development – Running your unit tests from your IDE

jenkins-tests

This post aims at exploring the best practices in terms of code quality and testability for mobile development.
It is part of a series that talks about Unit and Integration Testing in the Mobile space. In particular, I focus on Android and iOS.… [Keep reading] “TDD for Mobile Development – Part 1”

Cloud Strategy – do you need one?

20th of June, 2014 / / No Comments

Today’s organisations demand that their services perform better, cost less, are more reliable and offer greater flexibility than ever before. With high quality and quickly evolving consumer technologies, the expectation of IT services in the workplace is that they now reflect the same calibre of tools available to people outside of the office.

With common perceptions that business IT capabilities are too far behind, many departments look to acquire and provision cloud services themselves, without involving the IT organisation.… [Keep reading] “Cloud Strategy – do you need one?”

Remote desktop client randomly unable connect to the RDS farm

15th of April, 2014 / / 5 Comments

Recently I ran into a problem with an existing Remote Desktop Services 2012 R2 at a client site. The error occurred intermittently and after a number of retries, client could establish connection normally making the issue not always reproducible.  This blog summarises the process of identifying the symptoms, possible causes, and the resolution steps.

Some Background

The RDS farm consisted of two connection broker servers and two session hosts.  The Remote Desktop Connection Broker is configured in HA mode using two DNS records pointing to two broker nodes for round robin. … [Keep reading] “Remote desktop client randomly unable connect to the RDS farm”

MEC ‘14

15th of April, 2014 / / No Comments

Earlier this month I attended the Microsoft Exchange Conference in Austin, Texas, which was a fantastic opportunity to find out what is in store for the future of Exchange and to connect with other peers and people from the product groups at Microsoft. There were over 100 sessions meaning MEC was packed with loads of quality information – although it was impossible to get to see it all. It was great to see these sessions presented by the Program Managers, Lead Developers, MVPs and Masters.… [Keep reading] “MEC ‘14”

AWS Web Architecture 101 – Lessons Learned

24th of July, 2013 / / No Comments

This blog discusses some of the lessons learned in implementing a Web Architecture with RDS. We walk through some key elements and highlight some gotchas  to be mindful of.

Scenario

The components for this scenario include:

  • Virtual Private Cloud (VPC) with a public subnet and a private subnet.
  • ELB for  Web Traffic
  • IIS Web Server instance
  • MS SQL RDS instance
  • Jump box for management connectivity

One of the first implementation considerations in AWS is how you will setup your network.… [Keep reading] “AWS Web Architecture 101 – Lessons Learned”