I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-10-10 (first published: 2019-10-02)
388 reads
At a project, we asked if we could get a SQL Server login/user so we could make a connection from an Apache Airflow pipeline to the SQL Server instance....
2019-09-24
99 reads
Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform conference of the BeNeLux. I’ll be giving a session...
2019-09-12
4 reads
If you’re interested in Power BI (or the Power platform in general), you might be interested in checking out the release overview guides of “2019 release wave 2” for...
2019-09-02
154 reads
If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines...
2019-07-09 (first published: 2019-06-19)
299 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-07-02 (first published: 2019-06-18)
528 reads
I’m delighted to announce I’ll be giving a webinar for MSSQLTips.com about SQL Server Development Best Practices. Aka writing T-SQL and stuff ?? The webcast is the 13th of...
2019-05-27
25 reads
Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory)....
2019-05-25
28 reads
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an...
2019-04-25
1,176 reads
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to...
2019-04-23 (first published: 2019-04-15)
672 reads
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Those my friends are, in my opinion, one of the single most wonderful things...
SQL Saturday Oregon — in the city of Portland — is taking place next...
Hello everyone, I have a table with a field "shape" which is geometry. I...
hi there, am new to SQL and now am trying to do row split....
Ask SSC