RSS

Tag Archives: etl

Introduction to Azure Databricks Presentation – Video Recording

Introduction to Azure Databricks Presentation – Video Recording

I presented an introduction to Azure Databricks on May 22, 2020 to one of our local SQL Server User Groups here in the Washington DC area. It was done online due to the Covid19 restrictions on gatherings. The good that came out of doing it online was that it was recorded and published on YouTube. Here is the video, I hope you enjoy learning!

Code can be found at my new GitHub Repo:

https://github.com/thesqlpro/blog

 
Leave a comment

Posted by on May 28, 2020 in Other

 

Tags: , , , , , , , ,

Finding and removing hidden characters in your data using dynamic T-SQL


It has been a long morning for me. It was supposed to be a standard run for our quarterly data aggregations but one of the data import SSIS packages kept failing. The problem was a conversion problem from varchar type to float and I kept getting the following error:

Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to float.

However, my data was numeric I checked it many times… or was it really 100% numeric?

Read the rest of this entry »

 

Tags: , ,

 
<span>%d</span> bloggers like this: