Long time since I blogged – lots has happened in the SQL Server World
I have not had the opportunity to blog in the last month and this has partly been due to a busy work schedule, however the greater reason was a technological one. This of course was the release of the Surface. I had pre-ordered mine and it was always my intent to use it as my main machine, which I have been successful at till date.
With the transition to Windows RT I have had to work out what are alternate Apps to be productive in my job. With Office 2013 being included in the Surface this covered most of my work which is to create PowerPoint presentations and writing this blog post in Word 2013. In my role I also have to demonstrate features of SQL Server and the Microsoft BI stack, including integration with Hadoop, you may wonder how I can do this on a Windows 8 RT device. Well with Remote Desktop to an Azure VM and Internet access it is Q.E.D (quiet easily done). I am really living the device + services life were I use the device to access my resources that are in the cloud.
Enough about my new device and now onto the world of data platform and what has taken place in the last month:
SQL PASS Conference
SQL PASS – the largest conference for users of SQL Server took place in the USA and there were many major announcements including the following:
- Project Hekaton – this in a nutshell was the announcement of a feature that will be part of the next major release of SQL Server which will enable in-memory OLTP databases on commodity hardware (no requirement for specialized appliances or flash cache, etc). For more information see - http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/08/breakthrough-performance-with-in-memory-technologies.aspx
- Parallel Data Warehouse v2 (MPP architecture appliance) –the next version of Microsoft's enterprise-class appliance, will be available during the first half of 2013. SQL Server 2012 PDW includes PolyBase, a fundamental breakthrough in data processing that will enable queries across relational data and non-relational Hadoop data. For more information on PolyBase and other enhancements in PDWv2 see http://blogs.technet.com/b/dataplatforminsider/archive/2012/11/09/seamless-insights-on-structured-and-unstructured-data-with-sql-server-2012-parallel-data-warehouse.aspx
- SQL Server 2012 SP1 – was officially released during the week of SQL PASS, below are the major highlights of SP1:
- BI Functionality update for Office 2013
- xVelocity integration – natively baked into Excel
- Power View integration
- PowerPivot integration
- SharePoint 2013 – upgraded support for Power View, Power Pivot, and interactivity to Excel Services
- SQL Server Database Engine updates
- AlwaysON AG OS Upgrade – minimize downtime while upgrading to Windows Server 2012
- Selective XML Index Performance Update – allowing users to promote certain paths from XML documents
- SSMS Complete in Express – full capabilities of SSMS in Express
- SlipStream Full Installation
- Other performance, bug & security fixes - http://support.microsoft.com/kb/2674317
- BI Functionality update for Office 2013
Microsoft BI Poster
Ever wanted to know what Microsoft BI solution looks like. Download this poster (pdf file) http://sdrv.ms/Um0av0 and it has a great overview of all the components and capabilities of the Microsoft BI platform.
Microsoft BI in Windows Azure VM
Liked what you see in the poster and now want to implement it but don't have the appropriate versions of software. Leverage the Virtual Machines available in Windows Azure. I have put together an easy to follow power point deck that goes through the steps. Download it from http://sdrv.ms/TKxvB3. It even includes Powershell script to turn off the VM and remove it to save you costs when you are not using it.
Master Data Services Whitepapers
We've heard from customers that they can be confused about how SQL Server 2012 Master Data Services and Data Quality Services work together and how they differ. The following white paper indicates how you can use MDS, DQS, and SSIS together to ensure the quality of master data. It addresses scenarios for building and cleansing a new master data entity using interactive processes, updating master data using an automated process, and performing matching, both in an automated process and interactively. The white paper also compares MDS and DQS use, such as how you can import and export data to a knowledge base or an entity, and the difference in how they use rules.
Whitepaper link: Cleanse and Match Master Data by Using EIM" white paper at http://msdn.microsoft.com/en-us/library/jj836269.aspx
A tutorial is also available that walks through the implementation of the materials discussed in the whitepaper. This is available from http://www.microsoft.com/en-us/download/details.aspx?id=35462.
Big Data Case Study - Yahoo
The Yahoo! 24TB Analysis Services / Big Data Case Study is now live:
This shows a real life integration of SQL Server and Hadoop. Some key numbers from this case study include:
- 24TB Analysis Services MOLAP cube
- 2PB source data of a 14PB Hadoop cluster
- 700M unique users, 47% of the global online population
- 3.5B ad impressions/day
The key quote is:
"Yahoo! can now provide more relevant advertising data which has increased advertising spending and campaign effectiveness. We have achieved this by combining Hadoop and Hive technologies that handle large data sets with the powerful analytic insight provided by the Microsoft BI platform." -- Dianne Cantwell, Lead TAO Developer, Yahoo!
To dive deeper, check out the PASS session: Tier-1 BI in the world of Big Data (the Yahoo! Case study starts at slide 38).