I was building a CI/CD pipeline in Azure Devops, where I was building my SSDT project into a DACPAC file and then deploying it to the development server. For...
2022-04-20 (first published: 2022-04-07)
358 reads
Yet another book review! I just finished the book Pro Serverless Data Handling with Microsoft Azure: Architecting ETL and Data-Driven Applications in the Cloud (what a title :), written...
2022-04-22 (first published: 2022-04-05)
203 reads
When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is not as straight forward as it is in SQL...
2022-04-13 (first published: 2022-04-02)
205 reads
I just finished the book Azure Data Factory by Example: Practical Implementation for Data Engineers by Richard Swinbank. The book was not exactly what I was expecting, but that’s...
2022-03-29
30 reads
Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the...
2022-03-28
35 reads
Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always give honest feedback 🙂 I had the pleasure of...
2022-03-23
7 reads
Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused...
2022-03-13
21 reads
AFAS is a Dutch business software company, proving companies with ERP and HR software-as-a-service. You can extract data from the service using a REST API (there are also SOAP...
2022-03-07
8 reads
We’re reading in some JSON files in Azure Data Factory (ADF), for example for a REST API. We’re storing the data in a relational table (SQL Server, Azure SQL...
2022-02-28
20 reads
Linting is a process where a code analyzer is run to find programmatic errors, bugs, “stylistic constructs” or anti-patterns. For example, in Python there are specific modules that help...
2022-02-28
27 reads
By Steve Jones
I have been experimenting a bit with graph databases, trying to learn more about...
By Steve Jones
Thanks to everyone who attended my talk at VS Live Las Vegas 2023 on...
By Steve Jones
I delivered my talk on Architecting Zero Downtime Deployments yesterday at VS Live Las...
Để chuẩn bị cho một chuyến đi hoàn hảo, bạn nên tìm hiểu trước...
Nấm lim xanh rừng nổi tiếng với những công dụng tuyệt vời đối với...
Comments posted to this topic are about the item How to Connect SQL Server...
Ask SSC