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



Wednesday, 1 February 2017

Keeping Data Skills Up To Date in a Rapidly Changing World


Keeping up to date with rapid technological advances has become a real issue, especially with the adoption of cloud technologies. Gone are the days when traditional learning methods can be applied. It is possible that, if a group of people need to skill up on cloud data technology, and the training of people is staggered over several months that the first people are already out of date by the time the last person is trained.  Another issue is the prolific number of cloud technologies, tools, services and products that are changing at speed, so much so, that some products may only be around for one year before the consumer has to face a rapid migration process to a new solution.

To address these rapid changes it is necessary to adopt an adaptive learning style that is not only updated by exam every 3 years. It is necessary to have your own individual learning plan which has daily options, weekly options, monthly options and certification tracks. The key is to remain agile and build learning into your everyday routine.

My routine for keeping my specialism up to date involves

  • Daily twitter reading and posting
  • Blog post reading and writing
  • Watching webcasts
  • Free online courses
  • Reading free ebooks 
  • Reading Communications of the ACM 
  • Reading of SIGMOD Record
  • Attending conferences
  • Attending free vendor days
  • Practical practice using existing skills
  • Practical practice of new skills
  • Documenting things I learn
  • Keeping certifications up to date

As part of that learning plan there has to be three elements: research, theory and practice.

There are always changes to vendor certifications to keep them relevant. The newer MSCE exam, Data Management and Analytics certification are to be taken each calendar year and you have the opportunity to earn the certification to receive an additional entry on your transcript. The Microsoft solution expert exams demonstrate your broad skill sets in SQL administration, building enterprise-scale data solutions, and leveraging business intelligence data—both on-premises and in cloud environments. Amazon do not have the same breadth of data certifications yet with the AWS certification being for Big Data only.

Two new Microsoft data exams:
70-473: Designing and Implementing Cloud Data Platform Solutions
70-475: Designing and Implementing Big Data Analytics Solutions
Amazon exams:
AWS Certified Big Data Certification – Specialty Beta Exams
Requires a current Associate level AWS Certified Solution Architect Certification

Thursday, 5 January 2017

DBMS of the Year

SQL Server is the DBMS of the Year.
http://db-engines.com/en/blog_post/67

DB-Engines.com write "Microsoft SQL Server is the database management system that gained more popularity in our DB-Engines Ranking within the last year than any of the other 315 monitored systems. We thus declare Microsoft SQL Server as the DBMS of the Year 2016"

Wednesday, 4 January 2017

Cloud Platform Comparison Chart















2017 begins with a cloud platform comparison chart created by Endjin for services by Microsoft, Amazon and Google. It can be downloaded from
https://endjin.com/thought-leadership/cloud-platform-comparison

Cortana Intelligence and Machine Learning 2016 Blog Review

The Cortana Intelligence and Machine Learning Blog shared a summary of the top 10 posts of 2016. They included:










10. Recent Updates to the Microsoft Data Science Virtual Machine
9. Introducing Microsoft R Server 9.0
8. Microsoft and Liebherr Collaborating on New Generation of Smart Refrigerators
7. Introducing the Team Data Science Process from Microsoft
6. Game On! Introducing Cortana Intelligence Competitions
5. A One-Step Program for Becoming a Data Scientist
4. Building Deep Neural Networks in the Cloud with Azure GPU VMs, MXNet and Microsoft R Server
3. Data Science with Microsoft SQL Server 2016 – Free eBook
2. Announcing R Tools for Visual Studio
1. Making R the Enterprise Standard for Cross-Platform Analytics, Both On-Premises and in the Cloud

Read more about the articles here.

Monday, 12 December 2016

Data past, data present and data future

Database and data management practices are changing and new practices need to be adaptive and agile. Here are a few data thoughts for data past, data present and data future.



















Data of Christmas Past
  •  Reports and dashboards have become standard place within the business. 
  •  Big data is just the new look of data.
  • DevOps has become mainstream.
Data of Christmas Present
  • There is an increasing plethora of database architecture designs to choose from which means selecting the right design and database engine for the right job is harder than before.
  • Business is driving the need for data. 
  • Best practice delivery is hard in a fast changing environment. 
  • Complexity is increasing in a diverse landscape.
Data of Christmas Yet to Come 
  • The face of database administration is changing with multiple of types of engines, tools, applications and cloud offerings. 
  •  It is necessary to have broad range of database knowledge to ensure best practice configurations are deployed for the plethora of tools.  
  • Predicative analytics are becoming critical for business. 
  • Deep learning utilizes machine learning to model data at high levels of abstraction which will transform how we live.
  • Research is starting to become embedded in industry with the need to drive the next innovation.

Thursday, 17 November 2016

SQL Server vNext

Microsoft announced the next version SQL Server for Windows and Linux http://tcrn.ch/2f4oUND

You can now download the SQL Server vNext community technology preview. The preview doesn’t include the business intelligence stack yet but will include improved support for R Services and a number of new machine learning and deep neural networking features.