• Sampling data in Data Lake U-SQL for Power BI

    Being able to hook Power BI directly into Azure Data Lake Storage (ADLS) is a very powerful tool (and it will be even more so when you can link to ADLS files that are in a different Azure account!! – not yet available as at January 2017). However there is a problem, Data Lake is designed to scale to petabytes of data whereas Power BI has a 10GB limit. Yes this is compressed, so we’d expect around 100GB of raw data, however to load…

    » Read more
  • Showing December to December to see opening values for a year in SSAS/MDX

    I came across an interesting MDX challenge this week; within a cube’s Date dimension, how to show December twice, once where it should be and again as the opening value for the following year. i.e. for each year I need to show Dec (prev yr), Jan, …, Nov, Dec. Why? Well if you consider the following pivot chart, you can clearly see growth from Jan to Feb, Feb to Mar, etc., but it’s very difficult to see the growth between Dec…

    » Read more
  • SQL Server 2016 Licensing Changes, SP1, v.Next CTP1, etc.

    By now you’ve probably heard the exciting news announced at today’s Microsoft Connect conference; SQL Server licensing is changing, significantly, from SQL 2016 SP1. The functionality of SQL Server Standard, Web & Express editions are being brought up to [almost, 99%] match that of Enterprise Edition. This has a number of critical impacts: Developers can write applications using a single set of SQL Server functionality, and can…

    » Read more
  • SQL Saturday 543 Sponsorship in Manchester

    On Saturday 22nd July Purple Frog Systems were the proud sponsors of SQL Saturday 543 held in Manchester. The day started with the key note from Microsoft’s Andrew Fryer on the middle floor of the venue, seen below. Then the Purple Frog team were out in force with Alex Whittles speaking in two sessions; A Drive Into SSIS and An Introduction to U-SQL. Paul Andrew was manning the sponsor stand with an excellent IoT real-time data…

    » Read more
  • SQL Saturday Manchester Sponsorship

    We’re delighted to be partnering with the next SQL Saturday event in Manchester on 25th July 2015. As a Gold partner, we’ll be there for the duration, and look forward to meeting you there. For more information, take a look at their website: click here

    » Read more
  • STEM – Weston Road Academy SQL Server Introduction

    As part of the STEM ambassador programme on Friday 8th July Purple Frog’s Paul Andrew went along to Weston Road Academy in Stafford to teach the Year 10 ICT class basic T-SQL syntax  using the latest Microsoft SQL Server 2016 technology. Due to limitations on the local school network we weren’t able to get SQL Server Express installed. This presented the perfect opportunity to use the power and elasticity of the Microsoft Azure cloud by…

    » Read more
  • What is U-SQL?

    By now you may have heard about U-SQL, the new kid on the query language block. But what is U-SQL? Where is it? What’s it for? I was lucky enough to be at the 2015 MVP Summit in Redmond, at which one of the sessions was hosted by Michael Rys (@MikeDoesBigData), talking about U-SQL. As it’s creator, there’s no-one better to learn the ropes from. I was pretty much blown away by what it can do and the ease of access, so I’ve…

    » Read more
  • PASS Summit and MVP Summit 2015

    I’m currently sitting in Seattle-Tacoma airport waiting for BA048 to take me home, and coming to terms with what an amazing couple of weeks I’ve been fortunate to have. The PASS Summit I had the honour of being selected to speak at the PASS Summit last week, the biggest SQL Server conference in the World, with I believe in the region of 5,500 attendees. I’ve been a regular speaker at lots of the European events (SQL Bits, SQL…

    » Read more
  • MDX Compare or Rank Similar Members

    Or should this be called: “Recreating DAX’s EARLIER function in MDX” – either way, a useful technique that solves a problem… MDX makes it very easy for us to compare one member against others, using functions such as RANK() etc. But how do we dynamically compare a member against a subset of other members? I came across a customer requirement recently where we had to rank a member against other members that had…

    » Read more
  • Excel crashes when enabling macros

    I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades out, goes unresponsive and then crashes with a glorious “Microsoft Excel has stopped working, Windows is checking for a solution to the problem” message. Unfortunately Windows never seems to be able to find the elusive solution that we…

    » Read more