Archives

BI Corner – Enterprise BI Project using Microsoft Tools
Posted by Rob Risetto on November 22, 2014

Jen Underwood from the SQL Server BI Blog, describes her journey of evaluating Microsoft BI tool offerings to support the requirements of an Enterprise BI Project.

In the article Jen outlines the enterprise dashboard requirements that had to be supported and highlights (for her BI

Continue Reading

SQL in the AWS Cloud – SQL User Group PP Slides
Posted by Rob Risetto on November 08, 2014

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

Continue Reading

Buffer Pool Extension Feature Road Test on AWS
Posted by Rob Risetto on October 23, 2014

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

Continue Reading