Azure Network Latency & SQL Server Optimization

During some of my recent partner engagements, I had the opportunity to test deeply the Azure network performances and latency impact on SQL Server in Azure Virtual Machines (IaaS VM), now in this blog I’m going to unveil some interesting findings, testing methodology and comparison with other Cloud providers. Finally, I will show you an…

0

Azure Architectural Pattern – Implementing Master-Slave Model in IaaS

During the last two years, I had the privilege to work with some important Microsoft Global Partners, all over the world, on several important Azure projects. Since I personally like to share my findings and let the broader community to learn from my experiences, in this blog post I decided to discuss an interesting architectural…

4

How to create a SQL Server Linked Server to HDInsight HIVE using Microsoft Hive ODBC Driver

Last October 28th Microsoft finally released a new Azure service called “Windows Azure HDInsight Service”, that is our Hadoop offering in the Cloud: Announcing Windows Azure HDInsight: Where big data meets the cloud Along with this core service, a series of additional components has been also released to integrate Big Data world with Microsoft BI…

5

Create a SQL Server 2014 Database directly on Azure Blob storage with SQLXI

Last week, at SQL PASS summit, Microsoft announced availability of SQL Server 2014 CTP2, highlighting the following items: SQL Server 2014 CTP2 release – a feature complete CTP with new capabilities and enhancements for In-Memory technology that drives mission critical performance as well as new enhancements for hybrid cloud scenarios including backup to Windows Azure…

11

New Azure FastTrack VM image for SQL Server 2014 CTP2 (FTDW)

Hi all, I already covered in details, only five days ago, what is inside “Fast Track” VM available in the Azure Image Gallery in my previous blog post: Deep-dive on New Azure FastTrack VM image (FTDW) http://blogs.msdn.com/b/igorpag/archive/2013/10/11/deep-dive-on-new-azure-fasttrack-vm-image-ftdw.aspx In that post, I described the SQL Server 2012 version, but since this morning a new VM with…

0

Deep-dive on New Azure FastTrack VM image (FTDW)

If you are a regular Azure VM Image Gallery visitor like me, probably you noticed that we recently introduced a new image called “SQL Server 2012 SP1 for data warehousing on WS 2012”: That’s really nice, I can deploy in few minutes a fully configured Azure VM as dictated by “Fast Track” architecture best practices! For…

1

SQL Server VM Disaster Recovery between AZURE and AMAZON

Some days ago, a recent article from former Microsoft employee Michael Washam (http://michaelwasham.com) captured my attention: Connecting Clouds – Creating a site-to-site Network with Amazon Web Services and Windows Azure http://michaelwasham.com/2013/09/03/connecting-clouds-site-to-site-aws-azure Wow! Today we cannot (yet! ) have an Azure Virtual Network/VPN crossing more than one Azure datacenter, but we can have a Virtual Network/VPN…

1

SQL Server 2012 AlwaysOn Availability Group and Listener in Azure VMs: Notes, Details and Recommendations

If you are running, or going to run in the future, SQL Server inside Azure Virtual Machines, your favorite high availability solution (HA) is AlwaysOn Availability Groups (AG). Focusing on SQL Server 2012, why AG is or should be your favorite solution? Well, at least for these reasons: AG provides the fastest failover time compared to…

14

Manually adding a VPN Gateway to Azure Virtual Network

In this blog post, I’m going to show you how is possible to add a VPN Gateway, to an existing Azure Virtual Network, that is already used by some Virtual Machines. The entire procedure is not so complex, but due to the limitations of the Azure Portal GUI and Power Shell cmdlet, a specific procedure…

7

SQL Server Database Backup in Azure IaaS: performance tests….

In this blog post, I want to show you some performance test results obtained tweaking many different configuration options and playing with typical SQL Server native backup parameters and then checking the impact on the backup completion time and throughput. One key scenario tested is the usage of a new feature introduced with the recent…

0