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
08 June 2021
08 June 2021

How Essential Are Azure Policies

0
1
Policies in Azure are like Wally. They are there, but not obvious to find, hidden in the middle of many services, waiting for someone recognize their importance. Why do we need Policies Billing The billing control in Azure has by itself many different reasons to enforce policies. You, with your single Azure subscription, may think … Read more
0
1
24 May 2021
24 May 2021

Using Power BI to Query Log Analytics

0
1
Log Analytics is a basic tool for the entire Azure environment, I wrote about it before. The possibility to access log analytics data from a tool for analysis, such as Power BI, only increases its importance. There are some options to make this access and we expect these options to improve very soon. Using Notebooks … Read more
0
1
01 May 2021
01 May 2021

Saving money with Log Analytics

0
1
Azure Monitor and Log Analytics are a very important part of Azure infrastructure. In my opinion, the adoption of these tools should start before a company starts its migration to azure. Using these tools over on premises servers can generate a performance baseline to be used when migrating the servers, ensuring the environment will be … Read more
0
1
26 April 2021
26 April 2021

Malta Data Saturday and Our New Era

0
1
The Malta Data Saturday is finishing. I still need to compile the numbers, but the comments and feedback are great. Let’s talk a bit about the story of this conference and I hope this story can provide it’s 2 cents to the build of our new era, at least starting many discussions about do’s and don’ts … Read more
0
1
19 April 2021
19 April 2021

Denormalization in Production: Common Problem and Solution

0
4
After a young developer (or database developer) learns about normalization, the quality of his databases increases a lot, there is no doubt about that. However, sometimes we need some denormalization, even in production databases. I faced some experienced developers that, although, they would agree this should be analyzed in a case-by-case scenario, they never saw … Read more
0
4
15 March 2021
15 March 2021

Count Distinct and Window Functions

0
5
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
0
5
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
0
4
15 February 2021
15 February 2021

Custom Binding for Azure Functions

0
4
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
0
4
01 February 2021
01 February 2021

Azure SQL and Managed Identity

0
8
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
0
8
04 January 2021
04 January 2021

PASS is Dead – Long Life to SQLFamily

0
2
This new year start with the death of PASS, the professional association that for so many years supported the SQLFamily around the world and helped so many to achieve their professional goals. You can still read the communication, but PASS is ‘going dark’ on January 15, meaning none of its features and resources will be … Read more
0
2