Recently I presented the topic of SQL Server in the AWS Cloud to the Queensland SQL Server User Group. The presentation provided an overview of the potential SQL Server application use cases for the AWS Cloud, in particular, I demo-ed an AlwaysOn Availability Group failover from a AWS EC2 instance to a on-premise SQL
One of the exciting new features coming out of the SQL Server 2014 release is the Buffer Pool Extension (BPE) option. BPE allows you extend the SQL Server Buffer Pool to fast IO devices like SSDs and therefore provides the equivalent of a level 2 cache. Basically SQL Server doesn’t have to retrieve data from slower disks for frequently
The Cloud IaaS market is constantly on the move so an IaaS Provider’s positioning can change within a short period of time.
According to the Gartner Group, Amazon Web Services (AWS) is still way ahead of all competitors and sits in the sweet spot of Magic Quadrant.