Build Schedule

Advanced Filters:
  • Track

    clear all

















  • Speaker


  • Level


  • Session Type

Sessions Found: 30
in questa sessione, Giuliano e Alessandro mostrano le tecnologie disponibili per trasportare velocemente dati di produzione in ambienti isolati da usare in: test di integrazione, emulazione di rilasci e controllo di anomalie. Dal cloning in Hyper-V ai container Docker, vedremo quanto è semplice fare provisioning di dati su Microsoft SQL Server per verificare la presenza di regressioni nell'integrare le modifiche prodotte dal Team di sviluppo
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Track 4

Lavorando con i dati, capita sempre più frequentmente di doversi confrontare con mondi che fino a poco tempo fa erano quasi estranei fra loro. 
SQL Server 2019, per esempio, introduce per la prima volta con i nuovi Big Data Cluster il supporto nativo ad Apache Spark, rendendo concreta la convivenza tra il carico di lavoro tipico di un engine relazionale e il calcolo distribuito.

Proveniendo da un ambiente SQL, l'approccio ad Apache Spark tramite il suo dialetto Spark SQL può sembrare molto naturale e poco ostico. La sensazione di "sentirsi a casa", però, non deve far dimenticare che l'engine sottostante ragiona in modo molto diverso da quello a cui siamo abituati.

In questa sessione proveremo ad avvicinarci ad Apache Spark partendo dalle sue basi, così da capire come ragiona e conoscerlo per affrontarlo al meglio.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 29

Time: 3:55 PM - 4:55 PM

Room: Track 3

Power BI makes advanced analytics handy for business users, allowing stakeholders to extract knowledge and insights from data, to solve business problems and make decisions.  
This session will introduce to the advanced analytics features of Power BI, showcasing some real word areas of application: forecasting, predictive analytics, machine learning algorithms, customer sentiment analysis.  
For every case it will also be covered the integration with all the complementary tools needed for building a working solution: Azure ML, Cognitive Services, R, Key influence visuals, ...
Discover how easy is using advanced analytics in Power BI to effectively address the business challenge and uncover new insights
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 29

Time: 2:45 PM - 3:45 PM

Room: Track 5

Azure Databricks is an  Apache Spark–based analytics service for big data and data analytics on top.
In this session we will create Databricks scenarios for useful business scenarios.

Data engineers and business analysts (data scientists) can now work on RDD structured files using workbooks for collaborative projects, using ANSI SQL, R, Python or Scala, easily covering both analytical and machine learning solutions on one hand, and also giving the capabilities to use it as a datawarehouse.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: February 29

Time: 3:55 PM - 4:55 PM

Room: Track 1

Developing application for Smart city, Sensors, Industrial IoT increasingly need more affordable and powerful way to store data and manage it. 
Now we can also use the same approach we have in our client server distributed application even in remote deployed devices frquently not connected to internet.
Expand device architecture coverage to include ARM-based devices on top of x64-based architecture. Use Kubernetes to orchestrate your device infrastructure for better efficiency and automation. Run SQL Database Edge connected or offline to support various edge environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 2:45 PM - 3:45 PM

Room: Track 3

Microsoft is building the biggest cloud database. Hyperscale is a new cloud-native solution purpose-built to address common cloud scalability limits with either compute, storage, memory or combinations of all three.
Come to this session and learn about how we do it with Azure SQL Database Hyperscale.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: February 29

Time: 9:20 AM - 10:20 AM

Room: Track 3

Data warehouse and BI market is evolving rapidly with the appearance of new cloud born technologies. We might assume, that moving an existing Microsoft based DWH to the cloud is an easy step, but when we dig a little bit deeper, we will see, there are many-many new technological choices and aspects on how to modernize an existing dwh/bi system in the cloud. Not to mention if we start everything from scratch in a new project designed specifically to the cloud to utilize cloud flexibility and innovation as much as possible. 
Which ETL tool should I use? Data factory v2 with SSIS and BIML, or Azure Databricks powered Dataflows? Or Power BI Dataflow? Which is the right decision to run OLAP workloads? Azure AS? Or simply Power BI? When do I need Azure SQL DWH?
In the last couple years I helped many customers to modernize their DWH landscape partially or fully in the cloud and during my presentation I will share my findings and recipes for the most common situation I met. You will have fun:)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: February 29

Time: 2:45 PM - 3:45 PM

Room: Track 1

Durante la sessione vedremo le tecniche di base per estrarre informazioni da testo scritto in linguaggio naturale, creare un semplice servizio e pubblicarlo come container attraverso Machine Learning Services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Beginner

Session Code:

Date: February 29

Time: 5:00 PM - 6:00 PM

Room: Track 1

Quali sono le caratteristiche fondamentali del Data Storytelling? Come utilizzare PowerBI non solo come strumento di analisi dati ma anche di data storytelling? Durante la sessione scopriremo come il cervello umano reagisce a ciò che vede e quali sono le più importanti best practices inerenti alla visualizzazione dati. Scopriremo inoltre le principali caratteristiche dei visual più usati e quando usarli o non usarli.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 29

Time: 12:25 PM - 1:25 PM

Room: Track 4

What does Partitioning really means? And how does it impact writing apps with Cosmos? What does embedding vs. reference means? and how RU impact my app? And indexes? And how do I use Change Feed?
So not the ordinary session, to cosmos, but something more useful.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: February 29

Time: 2:45 PM - 3:45 PM

Room: Track 4

Il serverless è la nuova frontiera dello sviluppo Cloud e le Azure Functions sono uno degli strumenti a disposizione per implementare questo nuovo paradigma. SQL Server è un componente importante nell'ecosistema Azure ma non esiste, al momento, un modo "chiavi in mano" per poterlo utilizzare all'interno delle Azure Functions.
In questa sessione vedremo come scalare correttamente una applicazione che ha la necessità di scrivere e leggere su SQL Azure e di come ridurre al minimo il codice applicativo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 5:00 PM - 6:00 PM

Room: Track 4

Uno dei punti di forza di Power BI risiede nelle performance del suo engine di Power Query e nella capacità di semplificare lo sviluppo dell'intera fase ETL attraverso l'uso della sola interfaccia grafica. Ma dietro le quinte ogni nostro "click" si traduce in codice "M" e conoscere tale linguaggio consente di ampliare ulteriormente le potenzialità di Power BI e quindi dei nostri modelli. In questa sessione introduttiva verranno descritti i principali costrutti e le regole base del linguaggio e si mostreranno alcuni esempi pratici di utilizzo all'interno dei modelli di Power BI.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Track 2

Power BI is a cloud-based service; it means that it comes along with a standard set of APIs that provides access to its internal resources such as reports, datasets, rows.   
Using APIs gives more flexibility and allows to build custom dashboard applications either for administering or query the service.  
And if you combine the power of APIs with Microsoft Flow, you can automate some background processes such as adding users, granting rights, update or refresh datasets, ... 
The session is demo only. A complete walk-through to the process, will show you how to register an app, create a custom connector and leverage Power BI API actions by triggering a Microsoft Flow object.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: February 29

Time: 5:00 PM - 6:00 PM

Room: Track 2

Il modello composito consente di avere tabelle enormi come origine DirectQuery e alcune tabelle più piccole in modalità di importazione. Quando parliamo di tabelle enormi le prestazioni sono sempre una sfida. In questa sessione, parleremo di come le aggregazioni possono essere utili per accelerare le prestazioni. Puoi vedere come gigabyte di dati possono essere analizzati e visualizzati in meno di un secondo. Scopri molti suggerimenti, trucchi e aspetti interni sulle aggregazioni in Power BI e sul loro utilizzo in un modello composito.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: February 29

Time: 3:55 PM - 4:55 PM

Room: Track 5

When you deal with data, you have to deal with many data sources and many data destinations too. Even Data science approach is changing, in terms of tools used for the various phases of work. Let's explore many use cases in which you have to use a time series database to explore data, retrieve insights and fill new databases. Azure Data eXplorer can be the ace up your sleeve with such situations. Let's have a deep dive into various Data science phases, and the correct approach tha must be done if you use ADX.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code:

Date: February 29

Time: 12:25 PM - 1:25 PM

Room: Track 1

Azure Synapse is Azure SQL Data Warehouse evolved—blending big data, data warehousing, and data integration into a single service for end-to-end analytics at cloud scale.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: February 29

Time: 9:20 AM - 10:20 AM

Room: Track 2

Monitoring SQL Server can become a very expensive business. Sure, the market offers countless paid solutions, but what if you have a large server estate and your budget is tight? 
In this session we will combine multiple open source tools (InfluxDB, Telegraf , Grafana, DbaTools and many more) to collect important performance metrics, analyze the data they collect, set up alert for the critical events, troubleshoot issues and plan for the future. Join me and you will see how monitoring is not a business for billionaires.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 3:55 PM - 4:55 PM

Room: Track 4

Abbiamo installato SQL Server su una macchina virtuale VMWare seguendo (vero ?) tutte le best practices. Ma ancora non abbiamo le performance desiderate. Come si analizzano e risolvono le problematiche di performance su una VM? Quali sono le metriche da prendere in considerazione? E quali strumenti utilizzare? In questa sessione demo-oriented cercheremo di capire proprio questo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 11:20 AM - 12:20 PM

Room: Track 5

Some new object and configuration option of our databases can enhance the 
efficiency of our monitoring and tuning. This session will show some new 
object (DMO) introduced in the new platform and a couple of new options 
that can change our approach to the monitoring, maintenance and tuning activity.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: February 29

Time: 9:20 AM - 10:20 AM

Room: Track 1

Power BI dataflows permette di centralizzare e standardizzare le fasi di data preparation nel cloud, sfruttando Power Query ed il linguaggio M. 
Quali sono gli scenari in cui utilizzarli? Quali sono le best practice da tenere a mente? 
Quali nuovi orizzonti offrono? 
Cerchiamo di rispondere a queste ed altre domande con esempi pratici.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: February 29

Time: 3:55 PM - 4:55 PM

Room: Track 2

Sessions Found: 30
Back to Top cage-aids
cage-aids
cage-aids
cage-aids