The Journey to SQL Server 2019 – where does your own journey start?

[read this post on Mr. Fox SQL blog]

A couple of weeks back I presented the keynote at SQL Server Saturday Sydney, which was an absolute blast. It was my first keynote, so honestly I wasn’t quite sure what to talk about. Now I’ve been to many seminars, conferences, etc and seen many, many key notes – and so in the end I decided to have a bit of “light-hearted” fun and simply tell a story!

So I decided to talk about SQL Server – yes, I know its exciting – but moreso about how it is that we all got to be there in that very room that morning, listening to some guy present a keynote on SQL. And most importantly how everyone else in that room had their own related personal journey with SQL Server.

And so – this journey starts all the way back in 1989; 3 great friends got together one summer and built something AMAZING; SQL Server 1.0. And it ends some 30 years and 13 versions later with SQL Server 2019more amazing than anyone could have imagined when they cut that code all those years before.

So sit back, reminisce, and have fun!

Continue reading

Using Elastic Query to Support SQL Spatial in Azure SQL DW

[read this post on Mr. Fox SQL blog]

Recently we had a requirement to perform SQL Spatial functions on data that was stored in Azure SQL DWSeems simple enough as spatial has been in SQL for many years, but unfortunately, SQL Spatial functions are not natively supported in Azure SQL DW (yet)!

If interested – this is the link to the Azure Feedback feature request to make this available in Azure SQL DW – https://feedback.azure.com/forums/307516-sql-data-warehouse/suggestions/10508991-support-for-spatial-data-type

AND SO — to use spatial data in Azure SQL DW we need to look at alternative methods.  Luckily a recent new feature in Azure SQL DB  in the form of Elastic Query to Azure SQL DW now gives us the ability to perform these SQL Spatial functions on data within Azure SQL DW via a very simple method!

So the purpose of this blog is to show how to perform native SQL Spatial functions on data within Azure SQL DW.

Continue reading