17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
James_Rowland-Jones.jpg

James Rowland-Jones

James Rowland-Jones is a Principal Consultant for The Big Bang Data Company. His focus and passion is to architect and deliver highly scalable analytical platforms that are creative, simple, and elegant in their design. James specializes in big data warehouse solutions that leverage both SQL Server Parallel Data Warehouse and Hadoop ecosystems. James is a keen advocate for the SQL Server community; both internationally and in the UK. He currently serves on the Board of Directors for PASS and sits on the organising committee for SQLBits - Europe's largest event for the Microsoft Data Platform. James has been awarded Microsoft’s MVP accreditation since 2008 for his services to the community.

 

You can find James on twitter @jrowlandjones or www.linkedin.com
http://www.bigbangdata.co.uk
James Rowland-Jones has submitted 4 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

Embrace the change and accelerate your migration to PDW - the only relational scale out data warehouse solution in the Microsoft Data Platform. Get practical advice, tips and recommendations that will help ensure your migration project is a success.
Join me as I share with you the new features of PDW 2012 in Appliance Update 1 – the next update to PDWs functionality. In one short hour I will highlight all of PDW’s new features paying special attention to my favourite PDW feature : Polybase.
Distributed databases need to be able to dynamically move data in order to resolve queries. PDW is no different. In this session you will learn all about how PDW performs data movement; digging into the DMVs to get valuable insight under the hood
Polybase is one of the most exciting, innovative features in PDW; enabling transparent data integration with Hadoop's distributed file system (HDFS) and soon Windows Azure Storage Blobs (WASB). See it in action.

Previous Sessions

SQL Server 2008 has a ton of great features to help you in your data warehousing endeavours. In this session find out what they are and how you can best use them.
Learn all about Optimistic Concurrency and how it works under the hood in this one hour session.
Data warehousing features in SQL 2008
Fast Track is a new reference data warehousing architecture provided by Microsoft. More than this it represents a new way of thinking about data warehousing. A Fast Track system is measured by its raw compute power - not by a DBAs ability to tune an index. Fast Track is an appliance-like solution that delivers phenomenal performance from a pre-defined, balanced configuration of CPU, memory and storage using nothing but commodity hardware. Of particular interest in a Fast Track system is the way in which the storage and SQL Server are configured. To achieve the fantastic throughput without using SSDs requires some careful configuration. This configuration is designed to make use of Sequential I/O to dramatically improve disk I/O performance. Interested? If you have a large data warehouse that's seen better days or perhaps you are about to embark on a new warehousing project then you should be! Fast Track is a great solution with a fantastic value proposition. In this one hour session we'll aim to get under the skin of Fast Track and get some answers as to how it delivers such great throughput on commodity hardware. In the process we'll aim to answer the following questions: * When might I need Fast Track? * What is Sequential I/O? * How does Sequential I/O improve performance? * What do I need to do to get Sequential I/O? * How can I monitor for Sequential I/O ? * What may I need to change in my ETL to get the benefit of sequential I/O? Still reading? I'll save you a front row seat....
When loading a Fast Track Data Warehouse it is important to ensure that your data is optimally laid out for Sequential I/O. Fragmentation is therefore the enemy. Know your enemy. Learn what it is, how it occurs and prevent it from happening to you!