Long time since I blogged – lots has happened in the SQL Server World

  • Article

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:

Microsoft BI Poster

Ever wanted to know what Microsoft BI solution looks like. Download this poster (pdf file) https://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 https://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 https://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 https://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:

Yahoo! Improves Campaign Effectiveness, Boosts Ad Revenue with Big Data Solution

 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).