Dennes Torres

Dennes Torres is a Data Platform MVP and Software Architect living in Malta who loves SQL Server and software development and has more than 20 years of experience. Dennes can improve Data Platform Architectures and transform data in knowledge. He moved to Malta after more than 10 years leading devSQL PASS Chapter in Rio de Janeiro and now is a member of the leadership team of MMDPUG PASS Chapter in Malta organizing meetings, events, and webcasts about SQL Server. He is an MCT, MCSE in Data Platforms and BI, with more titles in software development. You can get in touch on his blog https://dennestorres.com or at his work https://dtowersoftware.com

Follow Dennes Torres via
15 November 2021
15 November 2021

Dependency Hell: Past and Future

0
2
Saying that I’m from the time of the MDAC would be to break the main rule of never reveal our age. However, who really remembers Microsoft Data Access Components – MDAC – today ? Microsoft had ODBC and it was good. Out of the blue came Borland with a thing called BDE that was way … Read more
0
2
18 October 2021
18 October 2021

Creating Views in Azure Portal

0
1
Resource groups and subscriptions sometimes are not enough to organize the content of our Azure Portal. I was preparing for a presentation and looking into a lot of resource groups, but during the presentation only a few of them should appear for me. How could I control this? The need is the mother of the … Read more
0
1
11 October 2021
11 October 2021

ARM Template Visualizer

0
3
Recently a new feature appeared in Azure Portal, an ARM Template Visualizer, capable to show a graphic view of the resources inside an ARM template. The feature appears as a new button in screens where we are editing or downloading templates. These are some of the screens where you will see the new button: When … Read more
0
3
04 October 2021
04 October 2021

Template Specs: Storing ARM templates on Azure

0
1
Infrastructure as code is evolving in large steps to improve the way we build and manage cloud infrastructure. ARM templates is the Azure way to code the infrastructure, besides the fact it’s evolving towards BICEP. Since January, a new feature to manage ARM templates is being tested and made available in Azure Portal: ARM Template … Read more
0
1
27 September 2021
27 September 2021

10 things everyone needs to know about Azure Cost management

0
2
1 – Azure Hybrid Benefit Azure services related to servers and direct infrastructure reservation require software licenses, such as Windows Server and SQL Server. Microsoft offers what’s called Hybrid Benefit. When the software license is required, the service provisioning process asks if you would like to use the hybrid benefit. If you already have on … Read more
0
2
06 September 2021
06 September 2021

Using Power BI to Analyse Azure Costs

0
6
Azure Cost Management is in constant evolution to help manage the cost of services in the cloud. Microsoft provides the Azure Cost Management Power BI App to manage cloud costs, but this app only works with Enterprise Agreement accounts. This was a considerable limitation, since many companies use the cloud using Customer Agreement instead of … Read more
0
6
30 August 2021
30 August 2021

5 SSIS tricks you would like to know

0
4
How to make conditional decisions in a package It may seems strange the lack of a decision task for the control flow. However, there is a work around to allow us achieve the same effect we would have with a “decision task”. The precedence control between tasks can be based on an expression. Building the … Read more
0
4
23 August 2021
23 August 2021

Change Delete Behavior and more on EF Core

0
4
Entity Framework had objects called conventions. These objects can be used to make configurations on the entity framework context to change its default behavior. Two examples of behaviors we usually configure are the pluralize behavior for object names and delete cascade for foreign keys. Entity Framework Core, on the other hand, doesn’t have conventions. How … Read more
0
4
16 August 2021
16 August 2021

Creating functions in Kusto Queries

0
2
In the previous blog, I illustrated how to create sub-queries in Kusto. However, sometimes we may face even more complex situations and we may need to create not only a sub-query, but a function. Another way to think about a function inside a Kusto query is like a parameterized sub-query. Let’s review the query from … Read more
0
2
09 August 2021
09 August 2021

Creating Kusto sub-queries

0
14
In the same way as other query environments, Kusto queries in Log Anaytics can become complex. We need similar features in Kusto as we have in SQL Queries and one of these features is sub-queries. The Problem On the example below I’m building a query over my blog’s Log Analytics Data to identify the amount … Read more
0
14