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



Thursday, 14 January 2021

Data Toboggan 12 hours of Azure Synapse

Data Toboggan are running a 12 hours of Azure Synapse conference touching on almost every aspect of it, Workspace Dedicated Pools, Serverless Pools, Spark, Integrate Synapse Link and more.   

Register now : 30 Jan 2021 (8am-8pm GMT) http://bit.ly/datatobregister 

The Agenda:  http://bit.ly/datatobagenda

Read the blog Get to grips with Azure Synapse with this free digital event to find out more about the event.


Friday, 8 January 2021

Polaris The Distributed SQL Engine in Azure Synapse

 Very Large Data Base Endowment Inc. (VLDB Endowment) is a non-profit organisation incorporated in the United States for the sole purpose of promoting and exchanging scholarly work in databases and related fields throughout the world. The VLDB conference, usually annually, is an academic conference focusing on data management technology.

The academic papers that they publish are all available online for free. One such paper describes the SQL query engine, Polaris, in Azure Synapse. The academic paper can be read here.

Josep Aguilar-Saborit, Raghu Ramakrishnan, Krish Srinivasan, Kevin Bocksrocker, Ioannis Alagiannis, Mahadevan Sankara, Moe Shafiei, Jose Blakeley, Girish Dasarathy, Sumeet Dash, Lazar Davidovic, Maja Damjanic, Slobodan Djunic, Nemanja Djurkic, Charles Feddersen, Cesar Galindo-Legaria, Alan Halverson, Milana Kovacevic, Nikola Kicovic, Goran Lukic, Djordje Maksimovic, Ana Manic, Nikola Markovic, Bosko Mihic, Ugljesa Milic, Marko Milojevic, Tapas Nayak, Milan Potocnik, Milos Radic, Bozidar Radivojevic, Srikumar Rangarajan, Milan Ruzic, Milan Simic, Marko Sosic, Igor Stanko, Maja Stikic, Sasa Stanojkov, Vukasin Stefanovic, Milos Sukovic, Aleksandar Tomic, Dragan Tomic, Steve Toscano, Djordje Trifunovic, Veljko Vasic, Tomer Verona, Aleksandar Vujic, Nikola Vujic, Marko Vukovic, and Marko Zivanovic. 2020. POLARIS: the distributed SQL engine in azure synapse. Proc. VLDB Endow. 13, 12 (August 2020), 3204–3216. DOI:https://doi.org/10.14778/3415478.3415545 


The paper shares information on the new serverless SQL Pools service within Azure Synapse. It is an interesting read. Simon Whiteley discusses this paper which can be seen on You Tube


Friday, 1 January 2021

2021 The year of hope and change

Happy New Year. It is 2021 already with a sense of hope.  The dawn of a new year brings excitement of what lays ahead and what changes we will bring into our lives. The world has changed in incomprehensible ways and i'm not sure it will ever go back to the way it was. A sense of family and local community connectedness has grown throughout last year and I hope this is a positive out of the dark days. A great sense that ripples around us is that protecting the environment should be a core of our everyday lives.  

Whilst we have a difficult few months ahead there is light at the end of the tunnel. 

I watched an inspirational film over Christmas Hidden Figures (2016). I hadn't seen it before. It was about an African American female mathematicians who worked at the National Aeronautics and Space Administration (NASA) during the Space Race from a book by Margot Lee Shetterly. I must read the book. 

I wish everyone a safe, healthy and prosperous new year.