Welcome

Passionately curious about Data, Databases and Systems Complexity. Data is ubiquitous, the database universe is dichotomous (structured and unstructured), expanding and complex. Find my Database Research at SQLToolkit.co.uk . Microsoft Data Platform MVP

"The important thing is not to stop questioning. Curiosity has its own reason for existing" Einstein



Showing posts with label Cortana Analytics Suite. Show all posts
Showing posts with label Cortana Analytics Suite. Show all posts

Friday, 15 September 2017

Research meets Industry



Academic research and industry have often had siloed approaches. Academic research is essential to drive an industrial innovation. Often this research takes many years and may or may not result in commercial application. Over the last few years universities have been changing their old mind set and presentation, trying to raise the profile of their research and create impact in the community. It is about telling the story of the research and how that impacts society, that is key.

Large organisations in industry are beginning again to have their own research departments. In the last decade we saw the closure of many industry research laboratories as they were seen as a luxury and not fully integrated with businesses. Academic research has often not addressed the individual needs of industry and has, in some cases, not been keeping up with the speed of change in industry. There is a revival of organisations creating research facilities or investing in research and development. Those smaller to medium companies which had research divisions, are also revamping their presence. Competitive advantage can be obtained through the results of innovation.

Artificial Intelligence (AI) brings new challenges to research. Collaboration between big players, such as Microsoft Cortana and Amazon Alexa, aim to drive innovation forward. Once AI starts to be integrated into products and businesses, the insights and intelligence it brings, will begin to shape a new way of creating commercial applications and possibilities for innovation.

The world today is full of complexity and data is the fuel that helps drive intelligent action. Using data science, it helps breach that multi-disciplinary area to benefit all. Businesses must be grounded in accurate data to produce the next industrial revolution, through innovation and AI.

There is a new computational research centre of excellence (CoSeC) in the UK. The centre is bringing together leading UK expertise in key fields of computational research to tackle large-scale scientific software development, maintenance and distribution. This will improve scientific research software, that is relied upon worldwide, by universities and industries.

Thus, having a clear agenda that combines research and industry is the route to successfully navigating the fast moving business landscape.


Wednesday, 19 April 2017

Microsoft DataAmp – SQL Server 2017

The DataAmp webcast was packed full of announcements. The Webcast was delivered by Scott Guthrie and Joseph Sirosh. The SQL Server product delivering intelligence, trust and flexibility.

Microsoft confirmed that the next version of SQL Server is SQL Server 2017 and will be available simultaneously on Windows, Linux and Docker. Download the SQL Server 2017 datasheet.  It will be the first RDBMS to deliver AI with data. There is a convergence of cloud, data and intelligence. Delivering AI with data: the next generation of Microsoft’s data platform blog shares more information.  SQL Server 2017 Community Technology Preview 2.0 now available.

There were so many new features announced only a few are mentioned below.  There are adaptive query processing improvements which will enhance the performance of workloads. There is a You Tube video SQL Server 2017: Adaptive Query Processing discussing this. Threat detection is now in Azure SQL Database and is straight forward to configure. 



Hybrid Cloud just got easier to adopt with the new Azure migration resources and tools. To help with SQL Server migrations to the cloud features such as Service Broker, SQLAgent, Profiler etc. are now available in Azure. There is a new data migration service for automatic migration for SQL Server, Oracle and MySQL in Azure .

SQL Graph
Storing and analyzing graph data relationships. This includes full CRUD support to create nodes and edges and T-SQL query language extensions to provide multi-hop navigation using join-free pattern matching.  The SQL Server engine integration enables querying across SQL tables and graph data.

SQL Server on Linux
 

The official Microsoft repository for SQL Server in Docker containers is here.

Here are a few videos to help get you started with Linux:

Analytics 

SQL Server is the first commercial database to include Deep Learning algorithms, with the announcement of the Microsoft Cognitive Services general availability of the FACE API and Computer Vision API.
Azure Data Lake Services now have petabyte scale.
Azure Analysis Services became generally available. You Tube video: SQL Server 2017: BI enhancements.  
You can use Python for advanced analytics, You Tube video: SQL Server 2017: Advanced Analytics with Python


Azure DocumentDB

Azure DocumentDB is globally distrubuted and offer limitless scale of throughput and storage. It can be used for things such as IoT applications that need low response times and need to handle massive amounts of reads and writes.



Cortana Intelligence Solution Templates
You can now quickly build Cortana Intelligence Solutions from preconfigured solutions, reference architectures and design patterns. Some are released with more to follow.

The really important thing that I am excited about is the flexibility of choice within the SQL Server product.




Joseph Sirosh concluded comparing the industrial revolution with the intelligence revolution of today.