SQL in Seattle – My PASS Summit 2016
November 20th, 2016 in Blog, Community, Just For FunThis year was my first time at the PASS summit in Seattle. I’d of course been to plenty of other community events and conferences, but this was the big one! Spanning 3x days with 15x tracks to choose from in 4x rounds of sessions per day. Excluding precons. Really words don’t do the event or the venue justice. It’s massive. You basically need to see it for yourself. Which leads to the question, why write a blog post about it?…
» Read moreCreating Azure Data Factory Custom Activities
November 4th, 2016 in Azure, Blog, C#, JSON, Visual StudioWhen creating an Azure Data Factory (ADF) solution you’ll quickly find that currently it’s connectors are pretty limited to just other Azure services and the T within ETL (Extract, Transform, Load) is completely missing altogether. In these situations where other functionality is required we need to rely on the extensibility of Custom Activities. A Custom Activity allows the use of .Net programming within your ADF pipeline.…
» Read moreMy SQL Relay 2016
October 12th, 2016 in Blog, Community, IoT, Just For Fun, Purple Frog SystemsIn 2015 I attended a SQL Relay day in Birmingham, as a humble attendee with a colleague. I sat on the edge of my seat in every session soaking up all I could from the speakers. I remember being in awe of these technical rock stars that gave their knowledge to the community. A community that was strongly bonded and recognised by many sponsors. In 2016 the humble attendee was long gone. I was now heavily involved supporting operational…
» Read moreAzure Stream Analytics Windowing Queries
September 23rd, 2016 in Azure, Blog, Real-time DataWarning, this is going to be a dry post. Beer or water required before you continue reading. For those that don’t already know Azure Stream Analytics is Microsoft’s cloud based service for the handling and manipulation of data feeds, predominantly in real-time. However the service has many applications with the ability to ingest a wide variety of data sources. One such use case for the analysis of data using the service comes…
» Read moreChanging the Start Up App on Windows 10 IoT Core
August 19th, 2016 in Blog, IoT, PowerShell, UWP, Visual Studio, WindowsChanging the start up application on your IoT device running Windows IoT Core seems to be a common requirement once the device is out in the field so I hope this post exploring a few different ways of doing this will be of value to people. To clarify the behaviour we will achieve below is from device power on our Windows 10 IoT Core operating system will boot up. But instead of starting the default application which is originally named…
» Read moreInstalling Windows 10 IoT Core On Your Raspberry Pi
August 15th, 2016 in Blog, IoT, Raspberry Pi, WindowsAt a recent SQL Server User Group in Birmingham I presented an end to end IoT solution streaming data from sensors on a Raspberry Pi 3. What followed the talk was a very simple question from an audience member asking basically; how do you get started with doing this? It then occurred to me that I had missed out the vital information for getting the Windows 10 IoT Core operating system (OS) onto the device. In the following article I hope to…
» Read moreWindows IoT UWP Tasks Tickers and Threading
July 22nd, 2016 in Azure, Blog, C#, IoT, JSON, UWP, WindowsUpon entering the IoT revolution a few things immediately became apparent; We now had the ability to collect and handle more sensor data than we’d ever before possibly conceived. These sensors and there data will/are going to change the very way we live… Not convinced by this one? Talk to anybody that has a Fitbit attached to their wrist about how many steps they do each day! More relevant to this article. The procedural tools we…
» Read moreAzure Virual Machine CPU Cores Quota
June 25th, 2016 in Azure, Blog, JSONDid you know that by default your Azure subscription has a limit on the number of CPU cores you can consume for virtual machines? Until recently I didn’t. Maybe like you I’d only ever created one of two small virtual machines (VMs) within my MSDN subscription for testing and always ended up deleting them before coming close to the limit. Per Azure subscription the default quota for virtual machine CPU cores is 20. To clarify because…
» Read moreControlling Your Windows 10 IoT Core Device
June 16th, 2016 in Blog, IoT, PowerShell, Raspberry Pi, WindowsIf like me you have a several Raspberry Pi’s doing different things and running different operating systems controlling them can sometimes be a bit of a challenge, especially with a wealth of remote control protocols and command line tools to choose from. In this post I’m specifically exploring the different ways to control your Raspberry Pi running Windows 10 IoT Core. The thing that surprised me…
» Read moreSQL Battleships
June 2nd, 2016 in Blog, Community, Just For Fun, SQL ServerWhen Battleships Met SQL Server, like Bailys meeting Coffee, but better. Do you have an equal love of the classic two player board game Battleship and also SQL Server database development? If the answer is yes (which it obviously should be) then this is the blog post for you! The next question that I’m more than happy to answer for you is; how can I combine these 2x loves?… Well my friend, please continue reading to find out. So, let’s…
» Read more
Call today 0845 643 6463
