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 Database Learning. Show all posts
Showing posts with label Database Learning. Show all posts

Monday, 28 June 2021

Distinguished Engineer and Research Fellows

I have always been fascinated by the job roles distinguished engineer and research fellows. To me it seems these role transcend research and industry. A distinguished engineer is a title applied to someone who is thought (by those conferring this title) to have achieved noteworthy technical, professional accomplishments while working as an engineer.  A research fellow is an academic research position at a university or research institution that is usually held by academic staff or faculty members. 

I came across a slide show on behaviours and qualities of an IBM Distinguished Engineer. An interesting quote is on the diagram "I want to be distinguished from the rest; to tell the truth, a friend to all mankind is not a friend for me" 





















Distinguished Engineer IBM Fellows are world famous inventors and theorists. A Distinguished Engineer has a unique and fascinating job that transcends many boundaries. A few of the attributes they mention:
 
  • Eminence takes responsibility 
  • Be learned, erudite 
  • Integrity and trust in all things
  • Learn from your mistakes
  • Apply common sense
  • Make decisions
  • Have a point of view
  • Provide hope
  • Inspire others
  • Be collaborative
  • Be optimistic and cheerful
  • Adapt proactively
  • Be curious and fearless
  • Build a track record and keep notes!
  • Know yourself and be true to you
  • Enhance your communication skills and image
  • Listen actively
  • Be a mentor and coach
  • Lead diverse teams
  • Be a member of a professional body 

Tuesday, 22 June 2021

Combining research and industry learning

I am very privileged to have an article about my career published in the ACM journal. Computing enabled me to... obtain a PhD. and a Career in Data.

The DOI reference for my paper is https://doi.org/10.1145/3464919 .

Communications of the ACM Volume 64 Issue 7 pp 7

About the journal

ACM, the world's largest educational and scientific computing society, delivers resources that advance computing as a science and a profession. ACM provides the computing field's premier Digital Library and serves its members and the computing profession with leading-edge publications, conferences, and career resources. They see a world where computing helps solve tomorrow’s problems – where we use our knowledge and skills to advance the profession and make a positive impact.

Research 

Being part of the research world is a huge part of who I am and it is very important to have research and industry working together to help shape the future of data innovation.

Wednesday, 17 February 2021

Azure Data Community Announcement

A special announcement was made by Buck Woody on Data Exposed. Microsoft expands on its announcement  last year following the collapse of PASS that is committed to the Data Community and say local users groups are the life blood of the community. The announcement is here 

Assets have been created that are Community-owned and Microsoft-empowered. These are resources and benefits to enable local community leaders to run their groups. 

Assets, Resources and Benefits 

Azure Data Community Gateway

It is a gateway not a destination. This resource is for community events, finding MVPs in the Azure data area and other resources such as diversity and inclusion that the community may find interesting.

Access to Meetup Pro

For qualified community groups to schedule, track events and for implementations of our local events

Microsoft Teams for Community Groups

Providing a full community Teams edition to qualifying community group leaders for chat, video, voice, file storage and applications. It comes with a predefined community template. It also allows you to connect with other community groups.

Community Leader Collaboration

Also Microsoft will be facilitating a periodic meeting of community group leaders to enable sharing of practices.

Resources for Self-Directed Local Groups

This is for established groups.

These resources and tools are for technologies focusing on











Effective community groups make it local, make it helpful for local jobs and improving your career and being champions for diversity and inclusion. Effective community groups are impactful.

The url is aka.ms/datacommunity

In summary this is an amazing resource for local community user groups to thrive, expand and encompass diversity and inclusion.

Azure Data Community FAQs

For answers to your questions 



Thursday, 2 July 2020

Microsoft MVP for a third year

During such a life changing time, I am over the moon with joy to be honoured with my third Microsoft Most Valuable Professional (MVP) award in recognition of exceptional technical community leadership for Data Platform for 2020-2021. How amazing to receive this. Thank you @MVPAward #MVPBuzz . There are so many amazing MVP's who help the community improve and grow their data platform knowledge. I am passionate about helping share the knowledge and experience I have gained.

This has been a strange period with many events cancelled and turned into virtual events. As an organizer of  Data Relay this year we cancelled our event to make way for SQLBits to move into the only viable slot this year. As things are still ongoing I think it is unlikely any in person conferences will continue this year.  However there are some amazing free online events to attend. My thoughts have been on helping and supporting the local community as well as the data community. 

Wednesday, 29 April 2020

Microsoft Ignite 2020

Microsoft Ignite will be back in September 2020. Microsoft Ignite will be launched as a complimentary digital event experience this September. Join them to learn innovative ways to build solutions, migrate and manage our infrastructure, and connect with Microsoft experts and other technology professionals from around the globe.

It is also possible to view all sessions from last year’s Microsoft Ignite.


Monday, 27 April 2020

Data Weekender

A Virtual Popup Microsoft Data Conference is happening on Saturday 2nd May 2020 https://www.dataweekender.com/

Data Community Weekender Europe is a new online conference hosted by various professionals from around Europe. With many events cancelled or postponed across Europe (and the world) in March, April and May, they wanted to put on an online data platform conference for the community to fill that void left by the cancelling of the in-person events on a day that hopefully, most people can attend.


This is set to be an amazing event.



Thursday, 23 April 2020

Microsoft Business Applications Summit

The Microsoft Business Applications Summit is now a digital event on May 6, 2020. Microsoft say get ready for the new digital event experience, with opportunities to hear from Microsoft executives, learn from experts, and connect with your community. Register today, at no cost to you!

The event will let you learn about the latest innovations and what is coming next in tools. Discover how Microsoft business applications work together to unify data to gain in-the-moment intelligence. In addition learn and explore the new capabilities across the Microsoft Power Platform.




Thursday, 9 April 2020

Spark AI Summit 2020

The largest data and machine learning conference, Spark and AI Summit brings together over 7,500 engineers, scientists, developers, analysts and leaders from around the world to San Francisco every year. Over four days, we shape the future of big data, analytics and AI as we share knowledge, hear from thought leaders and train on open-source technologies like Apache Spark, Delta Lake, MLflow, Koalas, TensorFlow and PyTorch. This year the virtual event for data teams has free general admission, 22-26 June.


Thursday, 2 April 2020

The Seattle Report on Data Research

I read with interest The Seattle Report on Data Research which presents the state of affairs for database systems. There are many interesting points raised about the diversity of the field and the challenges that are now apparent. These being:

  • Data Science having an emerging importance, 
  • HTAP (hybrid  transaction (OLTP) analytical processing (OLAP) creating real time operations to drive intelligent processing and reach, 
  • ethical responsibilities, 
  • scalable shareable data discovery 

This leads to the field having a bit of an identity crisis. We need to think about the end to end solutions that will provide insights whilst considering things such as data quality and data providence.

The question that we must all ask ourselves is, what is the vision for the future where data is all around us.


Thursday, 27 February 2020

SQL Bits 2020 Microsoft sessions

Here is a quick guide to a few of the Data and AI sessions from Microsoft at SQLBits.
Keynote: Join Gayle Sheppard, CVP, Azure Data for a keynote presentation on the journey of SQL Server from edge to cloud, packed with exciting demos and customer stories.
SQL Server 2019: The modern data platform: Bob Ward will give you the highlights, including the most exciting new features in SQL Server 2019 like Data virtualization, Big Data Clusters, Accelerated Database recovery, and more.
Sandboxing SQL Server 2019 Big Data Clusters: James Rowland Jones Big Data Clusters combine the power of SQL Server, Apache Spark, and HDFS to gain intelligence over all your data.
Modern Database design: Connor Cunningham will talk about improving the performance and scale of the databases in real-world scenarios using technologies including columnstore, in-memory tables, Azure SQL Database Hyperscale, Always On Availability Groups, and readable secondaries.
Azure Data Services on Azure Arc: Vin Yu talks about the newly launched hybrid service Azure Arc, which lets your run Azure Data Services anywhere. He will show you some of the management capabilities of Azure Arc such as elastic scale and automatic patching.
Azure Synapse Analytics:   Michael Rys brings together big data and data warehousing through new technology and a unified development experience.
Azure Data Studio features in 20 minutes: Vicky Harp will provide a quick refresher on the new features in Azure Data Studio.
10 DBA tasks for Azure SQL: Alain Dormehl and Rie Irish talk on the 10 most common DBA tasks for Azure SQL and how they differ from on prem DBA tasks.
Azure SQL Hyperscale Deep Dive: Alain Dormehl, Davide Mauri, and Denzil Ribeiro discuss how Hyperscale can enable you to innovate with nearly limitless storage in a future-proof, world class, fully managed database.
Microsoft Learn will showcase the complete offering of training and certifications available to the Data & AI professionals. 


Monday, 7 October 2019

Data Relay starts today

The week has finally arrived and it is Data Relay 2019. The agendas are here:

#Newcastle Mon 7 https://bit.ly/2mktU73 #Leeds Tues 8 https://bit.ly/2kP99jh  #Nottingham Wed 9 https://bit.ly/2kkct5P #Birmingham Thurs 10 https://bit.ly/2lRh6F2  #Bristol Fri 11 https://bit.ly/2kkcwi1

The sessions are covering a raft of exciting topics.


Thursday, 19 September 2019

Data Relay 2019

Data Relay is only a few weeks away. The agendas for the events are:

The Newcastle agenda  https://bit.ly/2mktU73 Register now for the event Mon 7 http://bit.ly/datarelaynew

The Leeds agenda https://bit.ly/2kP99jh Register now for the event Tues 8 http://bit.ly/datarelayleeds

The Nottingham agenda https://bit.ly/2kkct5P Register now for the event Wed 9 http://bit.ly/datarelaynott 

The Birmingham agenda https://bit.ly/2lRh6F2 Register now for the event Thurs 10 http://bit.ly/datarelaybham

The Bristol agenda  https://bit.ly/2kkcwi1 Register now for the event Fri 11 http://bit.ly/datarelaybsl
 

Saturday, 7 September 2019

The big data and database management paradigm shift

I am really pleased to be speaking at Data Relay this year in Bristol on Friday 11 October. The agenda is here . The abstract for my session is below

With the emergence of big data this has created a new paradigm for data and database management.  Structured and unstructured data must now work together to produce actionable insights. This session will share details on how to embrace this new era of database management, to prepare you for SQL Server 2019.


Saturday, 16 March 2019

Data Relay Session Submission is Open

It is that time of year again already. Data Relay session submission is open. There is a great blog post talking about Why to speak at Data Relay. Submit your sessions and start your journey.


Sunday, 3 March 2019

Tree of Learning sculpture



The Tree of Learning sculpture is a stunning celebration of the last 50 years of The Open University and an inspiration for the future. As part of the 50th Anniversary celebrations the “Tree of Learning” sculpture is being created and will be installed on campus, later in the Anniversary year. It will contain of hundreds of individually personalised gold-coloured OU logo-shaped shields hung as leaves on the tree.  
If you’ve studied with, worked with or been involved in some way with The Open University, it is a great way to still be a part of the amazing story to come. I am proud to have been a part of The Open University for over 13 years.

Wednesday, 6 February 2019

Improved Microsoft Docs


A cool image from http://www.thinksinc.org/ about Microsoft Docs.

I was looking at the Microsoft Docs pages and its new design. I have found it is much easier to navigate which speeds up searching.

At the top of the page there are 3 helpful options 

  • Download SQL Server
  • Get an Azure VM with SQL Server
  • Download SQL Server Management Studio


Then the Microsoft SQL Documentation has 3 categories covering on premises and cloud.
  • SQL Server on Windows
  • SQL as an Azure Service
  • SQL Server on Linux
There are technology areas to drill down further.

Then a further collection of links to enable a deeper dive into the technology.

  • Design
  • Tools
  • Reference
  • Reporting
  • Data Analytics
  • AI and Machine Learning
I was looking for design documentation and the link takes you to a page with easy to select image and text.























Thursday, 12 April 2018

Microsoft Professional Program for Artificial Intelligence

With Artificial Intelligence (AI) defining the next generation this Microsoft course seems a great way to jump start your skills.



The course covers these modules

  • Introduction to AI
  • Use Python to Work with Data
  • Use Math and Statistics Techniques
  • Consider Ethics for AI
  • Plan and Conduct a Data Study
  • Build Machine Learning Models
  • Build Deep Learning Models
  • Build Reinforcement Learning Models
  • Develop Applied AI Solutions
  • Final Project
At the end you gain the Microsoft Professional Program Certificate in Artificial Intelligence.

Monday, 9 April 2018

The PhD Bookshelf

Following on from the creation of a literature map for my PhD, I started to formulate a plan of literature to read. These are some of the books on my bookshelf.


I also read many academic papers, stored in seven box files and in Mendeley. 

Mendeley is a free reference manager.  It enables you to manage your research, showcase your work, connect and collaborate with over six million researchers worldwide.

I found the Communications of the ACM journal and SIGMOD, the ACM Special Interest Group on Management of Data journal great reads.

Sunday, 1 April 2018

Literature Map


When you start any research project, you need to set the research in the context of the current literature. This will establish a framework for the importance of the study. This document was the starting place for organizing the literature of interest in my research.

Thesis Title: A Study in Best Practices and Procedures for the Management of Database Systems



Saturday, 24 February 2018

SQL Relay 2018

If you enjoyed SQLBits come to SQLRelay in October 8-12. We are visiting 5 venues around the UK. More details will follow in due course. We look forward to seeing you there,