Skip to main content

Posts

Showing posts from October, 2020

[Post Event] MS Community BiH Conference 2020

It was my first time when I participate at a conference in Bosnia and Herzegovina (an online version of course). This week a participate at  MS Community BiH Conference  where I had the opportunity to deliver a session about Azure security from the development point of view.  The content of the sessions was amazing and the team that is behind the event took care of all the details. It was a pleasure to be part of it. You can find below details related to my session. Title : Cloud security fundamentals – Developer View Abstract : Do you want to improve cloud security? I thought so. Then why not join this session and build your fundamentals knowledge related to cloud security. We have a lot of demos and hands-on expertise from Microsoft Azure and AWS. Slides :  https://www.slideshare.net/raduvunvulea/cloud-security-fundamentals-developer-view

[Post Conference] API Testing Panel during Commited 2021

During Commited 2021 edition I had the opportunity to be part of the speakers of the testing panel. For two hours we talked about REST Assured, Pact, SoapUI, and different tools for API testing of on-premises or cloud endpoints.  It was an interesting discussion, related to how we shall do API testing and the available tools that are on the market.

Keep your cloud secrets away from the source control repo

I am sure that you are doing many things to secure your cloud applications and your public endpoint.  Are you doing the same things for the code that you push to a repo?  In this article, we discover what are the tools and what are the actions that can be done to ensure that no password, no access token or string configuration reach the repository.  Scenario Imagine that you are a developer working for a customer application hosted inside Azure. The new feature that you are working on includes premium media content available only for users who pay the subscription.  You design the application so that premium users get access to the content using a Shared Access Signature. Meanwhile, you keep the storage account key for production environments in a separate configuration pipeline script. The account key is used to generate a Shared Access Signature Token. Once the configuration pipeline script is working, you push to the public repository. Boom! in a few seconds, the storage account key

PowerBI - Combine multiple column inside the same chart

 Let's assume that we have a table with the below heather: EmployeeID | Location | Skill1Level | Skill2Level | Skill3Level | Skill4Level The Location field contains the name of the city where he is based and each skill level is a value between 1 to 5. What we want to achieve We need to show in a chart what are the skills level in a specific location. Additional to this, we need to have a line chart that shows all the skills cross locations and the ability to specify what skills and location to show on the charts (Slicer) Problem Except for the Splicer, we could drag and drop all the columns inside the Values of each chart to get what we want. The input table has data already pivoted and makes it almost impossible for us to generate and make the Slicer to work. Solution I found multiple solutions, but the one that was recommended by one of my co-workers was to do an unpivot to the table. The solution is simple, clean and you end up with your input data in a format easy to manage and

PowerBI - Split a column in multiple rows when newline is the value delimiter

I started to use PowerBI for reporting for more than 1 year. Because of my lack of deep knowledge of PowerBI and time limitations I preferred to have the following approach for data consolidation. What is important to mention is: Azure SQL DB was not running all the time, the DB was started only when I wanted to import a new version of data The stored procedures were doing a lot of reformating, cleanup, transformation and data rotation The real blocker, that forced me to use Azure SQL DB was of the columns where the data were a list of items that were separated by the new-line. For each item on the list, I had to expend the table with an additional row.   A few months ago I had some time and I decided to look at how: Split a column by a specific delimiter Do a column rotation (unpivotal). The solution that I found is based on three specific actions: Table.SplitColumn that enables us to split a column based on a delimiter Table.SplitColumn(#"Filtered Rows", "Column name&