Build Schedule

Advanced Filters:
  • Track

    clear all







  • Speaker


  • Level


  • Session Type

Sessions Found: 25
How does the AI make my BI applications smarter?

How can the AI make my BI application smarter? Everybody is talking about AI but what can you do with it today? Currently there are tools like the Cognitive Services, Azure ML or Azure Bot Framework, which can help in the classic ETL process to prepare or enrich data. Examples are the analysis of large data streams from the IoT area, how can I improve my demand planning of a call center or the analysis of social media regarding trends.
If you already have your BI application in the cloud, Azure Data Factory, Logic App or Azure Stream Analytics would be the right components for an AI extension.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Beginner

Session Code: 62

Date: November 23

Time: 11:00 AM - 12:00 PM

Room: Aula 6

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, introdurrà 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:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code: E2

Date: November 23

Time: 11:00 AM - 12:00 PM

Room: Aula E

Il nuovo .NET Core 3.0 supporta Windows Forms e WPF, che sono stati rilasciati come open-source: possiamo quindi aspettarci un nuovo impulso allo sviluppo di queste piattaforme. Nel corso di questa sessione mostreremo quali sono gli strumenti che abbiamo a disposizione per realizzare architetture client/server basate su accesso ai dati con .NET Core 3.0.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Development

Level: Beginner

Session Code: E6

Date: November 23

Time: 5:00 PM - 6:00 PM

Room: Aula E

Analyzing System from the eyes of DBA using Extended events and Query Store for performance bottlenecks and improvements.  Adding  R and Python  Framework (with SQL Server 2016) and Power BI we can improve the insights of performance and predict next problems.

Simplifying the performance troubleshooting by analysing query plans, runtime statistics and query history captured (all by using the Query store) we will be combining the data from extended events. With both powerful system insights, we will add the statistical abilities of Microsoft R server and create advanced statistical analysis (clustering type of errors occurring, discriminating the events and reducing the complexity of gathered information). Further more, we will be adding also predictive models for specific events (disk IO, size of temp db) or queries.

Session will cover demos and use cases, especially which statistical approaches and cases can help you enhance the monitoring and predicting next possible event.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Intermedia

Session Code: 74

Date: November 23

Time: 2:50 PM - 3:50 PM

Room: Aula 7

Mission critical SQL Servers require right architecture to satisfy SLAs, high availability, and disaster recovery requirements for your critical IT operational data environment. The ability to scale up these environments, to provide the level of performance required by OLTP and provide adequate resources is a significant operational challenge.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Beginner

Session Code: 71

Date: November 23

Time: 9:45 AM - 10:45 AM

Room: Aula 7

Azure SQL Database è sul mercato da parecchio tempo, negli anni sono state aggiunte features che l'hanno reso estremamente efficace. Facciamo un recap e vediamo cosa ci mette a disposizione per i più classici scenari d'utilizzo.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code: E5

Date: November 23

Time: 4:00 PM - 5:00 PM

Room: Aula E

Il Recovery è fondamentale per ogni database, consentendo di ripristinare la consistenza e l'integrità dei dati a fronte di qualsiasi evento e/o circostanza.
Questa sessione ne illustra i concetti e l'evoluzione delle tecniche e degli strumenti disponibili nella piattaforma SQL Server, con un particolare accento sulle novitrà introdotte dalla versione 2019
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Beginner

Session Code: 86

Date: November 23

Time: 5:00 PM - 6:00 PM

Room: Aula 8

Most of IoT system run around data retrieval, sensors interface, machine control and metrics sent to cloud Back-end; unfortunately in many cases, continuous network connection can't be guaranteed due to the type of device, to its location or the nature of the device itself.
Let's see what are the main topic to consider during the design process of this kind of systems.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud

Level: Intermedia

Session Code: E4

Date: November 23

Time: 2:50 PM - 3:50 PM

Room: Aula E

Con PowerBI puoi portare la tua infrastruttura BI “to the next level”. L’architettura è una parte importante in un progetto di business intelligence, scopriamo insieme quali sono le domende da porsi, i possibili scenari, ed il ruolo di PowerBI sia per costruirne una ex-novo, sia per integrare il tool in una esistente.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Intermedia

Session Code: 76

Date: November 23

Time: 5:00 PM - 6:00 PM

Room: Aula 7

Power BI is a business analytics service that delivers insights to enable fast, informed decisions; we'll use it as an (improper) free monitoring tool.
Being at SQL Saturday, we'll focus on SQL Server Reports, but the methodology is system-agnostic and will enable you to create a monitoring report for anything.

In the first part of the session, you'll learn why we're using PowerBI for such task and what are the limitations, explaining the PowerBI basics, architecture and components.

In the second part, we'll analyze 5 examples of ready-to-go and license free monitoring reports tailored for SQL Server:

- FirstRespondersKit Monitoring Dashboard
- Xevents Dashboard to track query errors
- Job Information Dashboard
- Permission Information Dashboard
- Streaming DataSet

This will give you both some reports that you can start to use right now, and the inspiration to build your own.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code: 61

Date: November 23

Time: 9:45 AM - 10:45 AM

Room: Aula 6

I containers consentono una nuova modalità di distribuzione, gestione ed esecuzione di istanze SQL Server, in maniera molto più semplice ed efficiente rispetto ad esempio alle macchine virtuali. In questa sessione vedremo in dettaglio come funzionano i containers Docker, come SQL Server viene eseguito in essi e come vengono orchestrati da Kubernetes, on premise e su Azure.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Intermedia

Session Code: 83

Date: November 23

Time: 12:10 PM - 1:10 PM

Room: Aula 8

It seems like Artificial Intelligence and Machine Learning are a must nowdays.
For projects carrying a simple or well kown problem we can find a lot of ready-made solutions, but this extremne easy to use could be one of our best enemy when facing with specific custom problems.
With this session we will cover how to apply best practices in configurin ML but much more, do we reaaly need it always?
The second part will cover vulnerabilities of ML discovering how easy could be to fool a neural network by some techinques (Like pixel attack) and their implication in projects that requires no security issues.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code: 63

Date: November 23

Time: 12:10 PM - 1:10 PM

Room: Aula 6

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:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Intermedia

Session Code: 82

Date: November 23

Time: 11:00 AM - 12:00 PM

Room: Aula 8

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 trasformare un report in una vera e propria presentazione interattiva e dinamica senza uscire mai da PowerBI, utilizzando tutti gli strumenti messi a disposizione dal tool e dal servizio di PowerBI, su tutti i Bookmarks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code: 66

Date: November 23

Time: 5:00 PM - 6:00 PM

Room: Aula 6

Your company is not-yet- ready for the cloud ?
 How to refresh your BI solution by providing the beauty of Power BI reports on premises and the ability from the same place to consume your legacy reports or to share efficiently your data model through a unique place. Demo based session with a strong architecture introduction and a "from the field" real project feedback.This session will explore all the possibilities offered by Power Bi Report server:
What are the difference with the classical SQL Server Report Server ? 
What is the difference with Power BI Service ?
What kind of data sources are used ? How to manage the refresh ?
What infrastructure is needed to make it working ? How to manage the authentication from the data source to the report ?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Data Science

Level: Intermedia

Session Code: 6A

Date: November 23

Time: 9:45 AM - 10:45 AM

Room: Aula 6

Data virtualization gestisce le difficolta di integrazione tra diverse fonti dati e formati senza dare origine a repliche o spostamento dei dati stessi. 
Quali sono i concetti e come poterli affrontare con i miglioramenti aggiunti a Polybase presenti in Sql Server 2019 è lo scopo di questa sessione
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Intermedia

Session Code: 65

Date: November 23

Time: 4:00 PM - 5:00 PM

Room: Aula 6

How many times have you faced bad performances caused by incorrect rows-estimation or caused by multi-statement user-defined table valued functions? Have you ever seen a warning on Sort operator that spills data on tempdb caused by inadequate memory estimation? These are not the only problems we could have with queries optimization, but these are the three problems that SQL Server 2017 Adaptive Query Processing attempts to address. SQL Server 2019 introduces additional features and all of them are known with the name Intelligent Query Processing. This session will cover the Adaptive Query Processing first. Next we will cover briefly the features implemented in the latest CTP of SQL Server 2019.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Intermedia

Session Code: 72

Date: November 23

Time: 11:00 AM - 12:00 PM

Room: Aula 7

The query tuning activity very often implies the evaluation of the impact of one or more new indexes on the query plan.
The creation of a new index on a large table, as we will see, could require a long time to complete, could take locks for the entire process and occupy a lot of disk space.
In several situations hypothetical indexes can help, although, in order to create and use them, we have to rely on a couple of undocumented features.
In this session we are going to give all the known details of these features and apply them in examples and practical situations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Intermedia

Session Code: 84

Date: November 23

Time: 2:50 PM - 3:50 PM

Room: Aula 8

Availability Groups have become Microsoft’s default high availability and scalability go-to solution for SQL Server, but due to their relative complexity is often misunderstood, or worse, feared. 

In this session, we will explain how to plan for, deploy, and manage Availability Groups from the ground up in easy to understand examples and demos.

We will cover both Basic Availability Groups (BAGs) and full deployments, and also cover their use in Windows and Linux environments as well as look at the new SQL Server 2019 availability group support on containers in a Kubernetes cluster.

If you want to finally get to grips with SQL Server Always On Availability Groups, then this is the session for you!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Database Admin

Level: Beginner

Session Code: 75

Date: November 23

Time: 4:00 PM - 5:00 PM

Room: Aula 7

L'automazione dei task di amministrazione e monitoraggio è un'esigenza sempre più sentita da parte dei DBA: permette di essere più efficaci e di risparmiare tempo, che può essere dedicato ad attività più interessanti. PowerShell ed i moduli dedicati a SQL Server sono l'ideale per assolvere a questo compito; vediamo insieme come muovere i primi passi in questo mondo e come affrontare in maniera semplice qualche scenario più sfidante.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
DevOps

Level: Beginner

Session Code: 85

Date: November 23

Time: 4:00 PM - 5:00 PM

Room: Aula 8

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