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

PASS is Dead – Long Life to SQLFamily

0
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
24 August 2020
24 August 2020

Responsible AI news from Build

0
Microsoft Build took place more than a month ago, but only now I’m writting about it. I’m facing the danger of being nicknamed as one famous Brazilian formula 1 pilot. Internal Brazilian joke. Build is a historical mark among community events. It implemented many new techniques to make an online event closer to an in-person … Read more
0
29 March 2020
29 March 2020

Microsoft Data Platform 2020

0
From last November 4 to 8 I have been at PASS Summit in Seattle, attending excellent technical sessions and having the honour to deliver a  lightning session, which is a small 10 minutes presentation. Why should you read this? Being one of the biggest data events in the world, PASS Summit usually exposes the present and … Read more
0
21 February 2020
21 February 2020

SQL Server Machine Learning 2019: Working with Security Changes

0
SQL Server Machine Learning allows you to run R and Python scripts from SQL Server. When SQL Server 2019 was released, Microsoft enhanced the security for this functionality, but it caused some existing code writing to the file system to to break. In this article, Dennes Torres explains the security enhancement and describes three ways to work with it. … Read more
0
02 January 2020
02 January 2020

Power BI and Excel

0
Power BI and Excel are tools so close to each other that Power BI was born inside Excel. Power Query, Power Pivot, Power View, they were all Excel plugins before being united and become Power BI. The ability to build an ETL, design a model and generate reports and dashboards with great storytelling make Power … Read more
0
13 April 2019
13 April 2019

Extract the Path from Filename in SQL

0
While I was preparing an article, I faced the challenge to extract the path from a filename in SQL Server. It’s an interesting challenge with many possible uses, so I decided to create a function to solve this problem. The Main Expression First, let’s understand the main expression to solve the problem. The path is everything … Read more
0