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

Responsible AI news from Build

0
1
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
1
03 August 2020
03 August 2020

How to not go mad with schema compare in SSDT

0
11
SSDT (SQL Server Data Tools) is really great to manage database schema changes. However, due to a disappeared feature, SSDT can make you go mad very easily. The schema compare has a lot of configurations. A really lot of configurations. You start the schema compare using the right-click on the SSDT project. Before starting the … Read more
0
11
29 March 2020
29 March 2020

Microsoft Data Platform 2020

0
2
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
2
21 February 2020
21 February 2020

SQL Server Machine Learning 2019: Working with Security Changes

0
7
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
7
02 January 2020
02 January 2020

Power BI and Excel

0
4
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
4
13 April 2019
13 April 2019

Extract the Path from Filename in SQL

0
12
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
12
26 February 2019
26 February 2019

Identifying Page Information in SQL Server 2019

0
3
SQL Server 2019 has some new and very interesting functions to identify information about pages. Many operations, such as analyzing current activities, locks or deadlocks, may result in some metadata pointing/blaming one page in the database. However, how to translate this information to get a database and object name? The image below is an example of … Read more
0
3
10 February 2019
10 February 2019

6 SSMS features that deserve some attention

0
5
SSMS new versions are full of very interesting features. With SQL Server 2019 arriving, it’s normal that our focus is captured by the new features in the database engine, however, SSMS has also a lot to offer. Let’s highlight some very interesting features this tool has to offer on its new versions. Vulnerability Assessment Sometimes … Read more
0
5