Welcome to BlobEater

Featured

I am passionate about using Microsoft Technology to maximise business benefit. Specialising in the Data Platform – SQL server, Azure SQL DB, Azure SQL DW, elastic pools, managed instances, Azure Databricks, basically anything about Data.

So any questions/ feedback – please Get In Touch

Copyright ©  in accordance with the Copyright, Designs and Patents Act 1988. All rights reserved. You are free to use any of the content here for personal use but need permission to use it anywhere or by any means (electronic, mechanical, photocopying, recording or otherwise).

 

Azure Data Engineer Associate

You can read about all the new role based qualifications from Microsoft here – https://www.microsoft.com/en-us/learning/certification-overview.aspx

Continue reading

Azure SQL Database Networking

Have you realised the changes Microsoft have made to the firewall and networking section of Azure SQL Database? I found this quite stealthy and took me by surprise. I did encounter an edge case scenario where it lead to issues once I made some tweaks but that was a rare thing.

Continue reading

Tips and Tricks Azure Databricks

It has been a while since I posted an entry for TSQL Tuesday, which, for today is hosted by Kenneth . The subject being a non SQL Server tip. For a while now I have been using other technologies besides SQL Server and recently Azure Databricks and I have a handy tip for when starting this journey. It is not ground breaking but useful!

logo

Continue reading

Azure Databricks to Azure SQL DB

Recently I got to a stage where I leveraged Databricks to the best of my ability to join couple of CSV files together, play around some aggregations and then output it back to a different mount point ( based on Azure Storage) as a parquet file, I decided that I actually wanted to move this data into Azure SQL DB, which you may want to do one day.

Continue reading

SQL Server 2019 Linux On Azure

It was just a matter of time until I started combining my cloud experience with “different” flavours of SQL Server. I haven’t used Linux since my university days (Oracle – errgh) but recently some Friends of mine ( using LAMP stack ) asked me couple of questions about SQL Server Linux.

Continue reading

SQL Server 2019 Overview

There are many quality resources regarding SQL Server 2019, from eBooks to videos about the newest features and how one would implement these within your business. I recommend the following book, not because I was co-author, more so of the fact that the other authors have brilliant chapters giving quality high level information (with enough detail) to understand SQL Server 2019.

I mean, who better than Buck Woody to talk about Big Data Clusters???!

Continue reading