未加星标

SQL Relay 2016

字体大小 | |
[系统(windows) 所属分类 系统(windows) | 发布者 店小二05 | 时间 2016 | 作者 红领巾 ] 0人收藏点击收藏

Surprisingly this conference had more to do with Microsoft’s Azure than SQL itself. The slides should be published sometime next week.

Azure Machine Learning

The point of this demonstration is that one doesn’t need to be a data scientist in order to apply Azure’s machine learning to data sets. All that’s needed is a general understanding of the available algorithms to determine which is best ( a cheat sheet is available for this), and some fine tuning of the machine learning model.

This included a run-through of creating a Microsoft Azure Machine Learning Studio project using the tutorial and readily-available data sets.


SQL Relay 2016

After describing the main algorithms (clustering, tree, etc.), Andre Melancia took us through the Experiment Tutorial that performed income predictions based on a database of demographics, and showed us how the machine learning model can be tuned for greater accuracy.


SQL Relay 2016

Web Services can be created to enable other applications to use the machine learning model, and no coding is required for this either the input and output components are simply dropped into the graphical editor.

Career Development and the Cloud

Ryan Yates , one of the main founders of the PowerShell community in the UK, gave us some words of wisdom on career development the main one being that a typical IT professional must become increasingly multi-skilled to survive. Which is very true, within reason. I’d counter that some recruiters, for lack of understanding, grossly underestimate what it takes to develop and maintain technical expertise. It’s kind of unrealistic to expect anyone to be a ‘full stack engineer’, to match the collective expertise of a team of specialists. Just a few days ago some recruiter contacted me for advised on LinkedIn, because he couldn’t find someone experienced in systems administration, DevOps, and some vendor-specific infrastructure management things.

We also had some pointers to developer communities and conferences.

Internet of Things, Rasberry Pi, Azure and Analytics

Basically how to make a Rasberry Pi stream data to the Azure IoT Hub and get some analytics. At some point I might replicate this demo to show what actually happens behind the Internet of Things. Or perhaps to show how IoT data streams could be used with a machine learning model.

I didn’t know it was possible to install windows 10 on a Rasberry Pi . Well, it’s actually a scaled-down version of it called ‘ Windows 10 IoT Core ‘, and it requires Windows 10 on the development machine also, unless you’re using the NOOBS installer. Once it’s loaded, Windows IoT Core runs a Web server and RDP server either can be used to manage the device. What Paul Andrew did was set this up, on a Pi with a sensor board, and basically get it streaming data to Azure.

On the Azure side, there’s an ‘Azure IoT Hub’, which mediates between the device and the Stream Analytics feature. It’s also where the device is registered and the connection string to the Azure service is acquired.


SQL Relay 2016

Result? The whole setup worked flawlessly, and Andrew ended up with a dashboard showing the temperature and light sensor readings from the Pi.

Microsoft Data Platform

Essentially an hour-long marketing session with a few cringeworthy videos thrown in, but it’s an exposition of the direction Microsoft’s technologies/services are progressing. The long and short of this was that things are moving away from on-premises servers to Azure, and from the old analytics to machine learning and the Cortana Intelligence Suite .

Also important to note is that almost all the businesses sponsoring this event specialise in analytics services.

How not to do Collaboration

There’s not much to say about this, but it’s about how not to communicate if you want to get things done. Richard Munn was entertaining nonetheless. The points I can recall:

* How teleconferencing doesn’t work with too many people.

* Don’t give meeting rooms stupid names that don’t indicate their location. Think about whether you actually need to have a meeting in the first place, and definitely don’t arrange meetings for the first thing in the morning, or last thing on Friday.

* Developers and project managers have different ideas of what Agile is.

* Products/solutions should be piloted by the people expected to use them.

* Collaboration isn’t the same thing as management, and likely shouldn’t involve hierarchy.

Summary

That the conference focussed primarily on Azure rather than SQL itself is important. In Microsoft’s data platform vision, SQL is just one of several components, an enabler for the analytics, machine learning and other abstractions that businesses are expected to make use of. As such, a much broader range of skills would likely be expected of future database admins.

本文系统(windows)相关术语:三级网络技术 计算机三级网络技术 网络技术基础 计算机网络技术

主题: SQLWindowsPowerShellLinkedIn
分页:12
转载请注明
本文标题:SQL Relay 2016
本站链接:http://www.codesec.net/view/480830.html
分享请点击:


1.凡CodeSecTeam转载的文章,均出自其它媒体或其他官网介绍,目的在于传递更多的信息,并不代表本站赞同其观点和其真实性负责;
2.转载的文章仅代表原创作者观点,与本站无关。其原创性以及文中陈述文字和内容未经本站证实,本站对该文以及其中全部或者部分内容、文字的真实性、完整性、及时性,不作出任何保证或承若;
3.如本站转载稿涉及版权等问题,请作者及时联系本站,我们会及时处理。
登录后可拥有收藏文章、关注作者等权限...
技术大类 技术大类 | 系统(windows) | 评论(0) | 阅读(32)