Data Platform MVP
Dennes is a DBA and Data Platform MVP living in Malta who loves SQL Server and software development and has more than 20 years of experience. 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. He can be found working for DTower Software and speaking in SQL Saturdays around Europe
Area of Expertise
What was already good has become even better. We were already able to make ETL in PowerBI using M, now, using the PoweBI Data Flows we are able to store the ETL on the PowerBI Portal, control the ETL execution, the data among many ETL steps and share the result with many Power BI files, instead of having to duplicate M scripts across different.PBIX files
In this session, you will understand better what Data Flows can bring to our already powerful self-service BI tools
Power BI Datamarts was first announced almost an year ago and it's still cause lots os misunderstands. On this session we will explore where Datamarts fits on the data platform architecture and how this feature can improve your entire data environment.
One additional benefits of the datamarts is how easy it is to build aggregations using the datamarts. No more users trying to negotiate with the IT team to build them on the DW, now you have your own places for the aggregations
Power BI can now be integrated with Microsoft Office, allowing us to use Power BI visuals everywhere: Word, PowerPoint, Outlook.
This allows us to maximize the power of storytelling
SQL Server 2022 is using Query Store, released with SQL Server 2016, to improve even more the concept of Intelligent Query processing.
We have new features such as DOP Feedback, CE Feedback, Parameter sensitive plan optimization and more
Some of SQL Server 2022 new features requires an entire session for them, such as the Intelligent Query Processing, , SQL Ledger and Azure SQL Link.
But there are many more features in SQL Server 2022 that would be almost forgotten. WE will talk about them:
Concurrent GAM and SGAM
Auto Drop Statistics
Dynamic Data Masking Granular Permissions
Log Analytics is one of the basic Azure services which should be uses from day one when moving to the cloud.
It's a so interesting services that we can use even before going to the cloud and it makes way easier to generate a server baseline for our SQL Servers, a task all of us know it's important but we don't dedicate enough time for it
Many DBA's mistakenly think a Synapse SQL Dedicated Pool is just a regular SQL Server Database
This mistake can lead to below optimal configurations, bad performance and loose of investment.
In this session you will discover everything especial about SQL Dedicated Pool that makes it way more than a regular SQL Server Database and how to configure it for the maximum performance possible
Synapse SQL Link can integrate multiple SQL data sources inside a Synapse dedicated pool, allowing us to start a data warehouse from a single point
The support for Azure SQL, SQL Server 2022 and SQL Server 2022 on VM's provides us with a powerful tool to integrate multiple data sources
Query Store Hints are a great innovation to solve big problems on our queries.
Let's discover how the query store hints can help us to easily solve the so usual parameter sniffing problem and how can we manage the application of query store hints on our environment
Ingestion Architecture is an essential piece to work with Architecture. Power BI have an important role on this, working together Azure to ingest data and provide real time visualizations.
Come to this session to see a lambda architecture being built using Event Hub, Stream Analytics, Power BI and Synapse
Do you think you know Azure SQL?
You may be surprised with the number of secrets it has for you. Let's discover on this session how to make our Azure SQL better and more secure using these secrets on the best way possible.
Developing a solution with Power BI is like any other development process: We need to follow stages for the approval of solution, from development to production.
Let's see how the Deployment Pipelines in Power BI help us with this
Power BI Goals is a quite new and powerful feature to manage KPI's and incorporate KPI's in our analysis and Dashboards.
In this session you will discover how how Power BI Goals work and how they can be used to integrate KPI's in our analysis
Azure SQL Ledger is a great innovation to protect SQL Server data and ensures the safety for solutions that, otherwise, would be looking into other technologies.
Let's discover how Ledger works and how it can make your architecture easier
Log Analytics is in the core of Azure Monitoring solution for all Azure features and this includes Azure SQL as well.
We can use Log Analytics to achieve a great monitoring solution and easily build performance baselines for our Azure SQL Databases using Azure Log Analytics
Power BI is well-known as a self-service visualization tool, but many developers don't know how well power bi can fit in an enterprise environment.
Let's start from the basics and talk about power bi dataflows and other features that make power bi a great tool for an enterprise environment, working very well together data warehouse, big data and data lake house tools
There are many scenarios of data ingestion when we would like to see our real time data. Microsoft made a good work improving the features for real time data in power bi.
In this session we will talk about the existing features for real time data ingestion in Power BI, how they integrate with new applications or with existing real time data feeds
Azure Data Share appears to be a very simple solution, but it's easy to miss the potential this solution has to save money and work from development and dba teams.
There are many scenarios of data ingestion when we would like to see our real time data. Come to this session to learn how to build reports over real time data using power bi
These two features, composite models and aggregations, are great when used together, they can result in a great performance improvement, as you will see on this demo-full session
Let's talk what benefits we can get when using Power BI and Synapse together, using features such as the Synapse Performance Accelerator, besides other benefits for performance
Incremental Refresh is a very important feature to ensure we can read from the data source only the new data, instead of load everything all the time. This will improve a lot the refresh performance of your data
Provisioning an Azure SQL DB is very easy, but are the default configurations good for you? How to ensure our database is really safe? Come to this session to discover this and a lot more
The spark pool in Synapse allow us to build and manage a Data Lake and also supports Delta Lake features. After the integration with Azure ML was included, it became a very interesting option to manage our Data Lakes and extract intelligence from our data
Many DBA's mistakenly think a Synapse SQL Dedicated Pool is just a regular SQL Server.
This mistake can have expensive consequences. I already saw people complained about the performance of the SQL Dedicated pool, without realizing the default are not tuned for performance and the tables requires special and careful configuration.
In this session you will discover everything especial about SQL Dedicated Pool that makes it way more than a regular SQL Server.
On this session you will discover what's a Data Lake House, why we need it and how can we implement this solution in Azure Cloud
Let's discover the power of having the data on the right hands at the right time with a Data Lake House
What happens if suddenly someone asks you to adapt that wonderful dashboard for another data source?
Maybe you developed it over excel and someone imported the data into the cloud, or the opposite, someone exported the data to excel to make the dashboard more independent.
Will your dashboard survive this challenge? Is your development ready for this challenge? Let's discover!
Power BI is able to deal with huge amounts of data, but we need to take care with performance. Small differences in the way we build a dashboard can have huge impact on the solution performance.
Power BI has some tools to help us analyze the performance of the solution and when we need to go deeper, DAX Studio can point where the problem is
While Data Factory is the cloud ETL solution for Azure, Power BI has Power Query, a great self-service ETL tool based on M language.
In this session, you will discover why you still need Data Factory and Power BI together when you should use either Data Factory or Power Query and how to use both to build a great ETL solution.
Many companies believe administering a SQL Server in the cloud is the same as administering a SQL Server on premises and that is a big mistake.
Optimizing, Monitoring, Security, there are many differences on the administration you will learn during this session, allowing you to become a better cloud DBA.
Among PaaS and IaaS, we have many SQL Server Cloud options: Azure SQL Db, SQL Server Managed Instance and Virtual Machines. How should we choose between them? How should we manage them? Let's discover the best approaches to use SQL Server on the cloud
What was already good has became even better. We were already able to make ETL in Power BI using M, now, using the Power BI Data Flows we are able to store the ETL on the Power BI Portal, control the ETL execution, the data among many ETL steps and share the result with many Power BI files, instead of having to duplicate M scripts across different .PBIX files
This feature allow us to create a more complex and re-usable ETL solution, creating small dataflows and allowing them to be reused in a dataflow hierarchy, which can be re-used in many different datasets, creating a more robust and reusable architecture.
In this session you will understand better how the dataflows are an important feature in making Power BI go way beyond the self-service
Security is essential for our cloud applications, but the security in the cloud has many more challenges than on premises. Using Key Vault for passwords and keys, managed identity for cloud services, integrated authentication for Azure SQL and more.
In this session you will discover the differences between authentication on premises and in the cloud and you will learn how to go way beyond the basic user/password for authentication
The Power Query M language provides a very powerful way to develop ETL, way beyond the basic features you know.
We can create functions, reuse functions, create loops, everything to make our data transformations easier. During this session you will see many advanced techniques using M and Power Query
Since SQL Server 2017 the Graph Database feature was released, enabling us to mix the relational model with a Graph model. Some existing flaws in this release are being fixed in SQL Server 2019, bringing graph objects closer to SQL Serve reality.
In this session, you will discover how Graph Databases in SQL Server works and what's new for them in SQL Server 2019
Synapse Analytics is being announced as the new name of Azure SQL Datawarehouse, but it's not only that. There is a broader view in Synapse analytics, beyond Azure SQL Datawarehouse. Let's see in this session what was improved, what changed, and how synapse analytics fits in the data platform.
Cloud and globalization bring to us more and more challenges every day. With the increase in the volume of data, we are evolving from data warehouses to big data and data lake architectures. In this session, we will better understand the concept of data virtualization, data lake architectures and how SQL Server 2019 Big Data Cluster can help us with these challenges
Starting from the very beginning, in this session, we will cross together the main features Power BI has to offer, starting with the powerful self-service ETL using M language when needed, modeling our tables and finally using powerful features to create a great data visualization, allowing you to better understand all the power and flexibility of this tool and how it will fit into your solution
Power BI Portugal 2023 S1 Sessions User group
Data Saturday Slovenia 2022
SQLSaturday MN 2022
Power BI Portugal 2022 Sessions User group
Data Toboggan - World Azure Synapse Day
Power Saturday 2021
Global Azure Lüdinghausen 2021
Data Platform MVP