Looks like this site has a good workup on managed tables too. As I assumed, they all live within Azure Data Lake Analytics that sit on top of Azure Data...

What I do is store data files down to the YYYY/MM/DD hierarchy. I also create two main splits, RAW and PROCESSED. The raw structure is for all the data you...

I personally love ETL and agree with Andy, it can be a full-time role that someone who has the right mentality, should work solely as the ETL developer for organizations....

Is there any overhead time when executing the SSIS package here or is it pretty instant once the factory job is made?

When I started out in data, I was lucky enough to hire a SQL Server DBA veteran of like 10+ years experience. He was what I consider a legit DBA...

Have used WordPress for all my blogs. I like them. The only issue I hate with it is how complicated it can be to customize as well secure as WordPress...

I've said it in other threads, did not like the write performance of a clustered or non-clustered GUID (non-unique) on billions of records in a single fact table within a...

I consider myself full stack in my current role as the data architect. I championed and deployed the entire data environment within the cloud for the data science team. This...