Author: Dennes

2022 Agenda

  • Most of these events are full-day conferences with many free technical sessions
  • Only confirmed sessions are included here. Many more may appear once they are confirmed
ConferencesDateSession DescriptionRSVP


Chicago Sub SQL User Group		19/10 12:45AM CEST
(18/10 18:46PM gmt -5)		Going To Azure SQL: Admin Differences no one told you before

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.		Link


Hybrid Virtual Group		26/10 18PM CESTSQL Server 2022: Intelligent Query Processing new Features

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.		Link


In Person		26/11SQL Server 2022: Intelligent Query Processing new Features

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.		Link
03/12Malta Community: Query Optimization in SQL Server 2022: From Zero to Hero

This is a full day conferece to introduce the new features for Query Optimization in SQL Server 2022.

The new features are based on existing features, so we will start talking about the existing features and proceed to explain the new features.

Innitial session planning:
 9:00 Query Store
10:00 Adaptive Query Processing
11:00 Intelligent Query Processing
13:00 Query Store Hints
14:00 DOP Feedback
15:00 CE Feedback
16:00 Parameter Sensitive Plan Optimizazion		Link

2021 Agenda

  • Most of these events are full-day conferences with many free technical sessions
  • Only confirmed sessions are included here. Many more may appear once they are confirmed
ConferencesDateSession DescriptionRSVP
24/05 14hs (Brasilia)Arquitetura de Dados: Da Produção ao Virtual Data Lake

Nesta apresentação você ira descobrir detalhes sobre arquitetura de dados: Data
Warehouse, Data lake, BI, Data Ingestion, Self-Service, Modelagem em Producao e
Warehouse e muito mais		Link
24/05 16hs (Brasilia)Vida na Europa

Uma visão geral sobre viver e trabalhar na Europa especificamente ou no
exterior de uma forma geral		Link
25/05 14hs (Brasilia)Plataforma de Dados na Nuvem

Entre PaaS e IaaS, temos muitas opções de SQL Server Cloud: Azure SQL Db, SQL
Server Managed Instance e Virtual Machines. Como devemos escolher entre eles? Como
devemos gerenciá-los? Vamos descobrir as melhores abordagens para usar o SQL Server
na nuvem		Link
26/05 14hs (Brasilia)Data Lake House na nuvem

Quando o Data Warehouse e Data Lake se juntam, vamos descobrir os benefícios que
obtemos e como podemos utilizar essa arquitetura na nuvem		Link
27/05 14hs (Brasilia)Power BI: Conceitos Básicos

Começando desde o início, nesta sessão, cruzaremos os principais recursos que o Power BI tem a oferecer, começando com o poderoso ETL de autoatendimento usando a linguagem M quando necessário, modelando nossas tabelas e, finalmente, usando recursos poderosos para criar grandes dados visualização, permitindo que você entenda melhor todo o poder e flexibilidade desta ferramenta e como ela se encaixará em sua solução		Link
28/05 14hs (Brasilia)Power BI: O self-service e a arquitetura de dados

Este recurso nos permite criar uma solução ETL mais complexa e reutilizável, criando pequenos fluxos de dados e permitindo que eles sejam reutilizados em uma hierarquia de fluxo de dados, que podem ser reutilizados em muitos conjuntos de dados diferentes,
criando uma arquitetura mais robusta e reutilizável.
Nesta sessão, você entenderá melhor como os fluxos de dados são um recurso
importante para fazer o Power BI ir muito além do autoatendimento		Link
04/06 17hsAdvanced ETL with Power Query

The M language provides to Power Query a very powerful way to develop ETL, way beyond the basic features you know.

We can create functions, re-use functions, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query		Link
Power Saturday05/06 14:30Power BI : Using streaming for real-time data

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
11/06 15:15Going to Azure SQL: Admin differences no one told you before

The M language provides to Power Query a very powerful way to develop ETL, way beyond the basic features you know.

We can create functions, re-use functions, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query		Link


DataTobogan		12/06 10amSecrets of Dedicated SQL Pool

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.		Link
12/06
20:15PM		Advanced ETL with Power Query

The M language provides to Power Query a very powerful way to develop ETL, way beyond the basic features you know.

We can create functions, re-use functions, create loops, everything to turn our data transformations easier. During this session you will see many advanced techniques using M and Power Query		Link