29 March 2021
29 March 2021

Data Platform: Links to Study and Learn

0
1
Last Friday I appeared in the middle of a Brazilian Twitch live made by a friend and while they were talking and studying, I provided some links full of content to them. Nowadays, there are a lot of free content on internet. Not only free content, but also content well organized in a good sequence … Read more
15 March 2021
15 March 2021

Count Distinct and Window Functions

0
2
Or: How to make magic tricks with T-SQL Starting our magic show, let’s first set the stage: Count Distinct doesn’t work with Window Partition Preparing the example In order to reach the conclusion above and solve it, let’s first build a scenario. Using Azure SQL Database, we can create a sample database called AdventureWorksLT, a … Read more
12 March 2021
12 March 2021

Ways to get and deal with invalid node identifiers in SQL Server Edge references

One of the weirder things about graph tables in SQL Server is the mysterious backend implementation. The values you see when working with these objects look like this: {“type”:”node”,”schema”:”dbo”,”table”:”Node1″,”id”:0}, but when you get errors, you don’t see the json, you see what this represents (two integers for the object_id and unique id in the graph … Read more
08 March 2021
08 March 2021

The Game Changed: Power BI Premium per User

0
4
Until now, one common knowledge about Power BI was how Power BI Premium subscription is expensive. We, regular mortals, could only dream with the full set of features offered by Power BI Premium. The new announcement is a complete game changing for the enterprise self-service BI technology: Power BI Premium per User will be available … Read more
15 February 2021
15 February 2021

Custom Binding for Azure Functions

0
2
Azure Functions are a great development tool, allowing us to create serverless software. However, one detail was bothering me when I create a function: The HTTP Trigger receives a HTTPRequest object and we need to extract the parameters from the request. This becomes kind of a low-level code mixed with our business code. It’s like going … Read more
02 February 2021
02 February 2021

Deploying a NodeJS application from GitHub to AWS Elastic Beanstalk and creating a CI/CD AWS CodePipeline.

0
1
Goals In this article I will assist you to deploy a NodeJS application from GitHub into AWS Elastic Beanstalk and Building a CI/CD pipeline. What is Elastic Beanstalk ? Using Elastic Beanstalk you will be able to deploy and manage applications within the AWS Cloud without having knowledge about the infrastructure that execute those applications. … Read more
01 February 2021
01 February 2021

Azure SQL and Managed Identity

0
4
Azure SQL has a close relationship with Azure Storage. Features like Polybase, backups, extended events and more make use of Azure Storage. On Azure SQL Database, probably the most common use is Extended Events. When we create a file target, we need to point to the Azure Storage URL where the file will be stored. … Read more
26 January 2021
26 January 2021

Handling Textual Unstructured Data using DataStage

0
4
What is Unstructured Data? Structured data is represented by tables, rows, columns, attributes mostly like relational database. Many of us might have spent the better part of our careers working on structured data and it is heavily used for analytical purposes. Unstructured data is often best described in contrast to structured data. It is an … Read more