sqlsathistory

Nr: 895

Back to Main list

SQLSaturday #895 - Parma 2019

Start Time (24h) Speaker Track Title
09:45:00 Isabelle Van Campenhoudt Data Science Power BI server and Office Online server, modernize your on-premises BI approach.
09:45:00 Marcelo Fernandes Database Admin Architecting SQL Server environments for Mission Critical and High Performance
09:45:00 Andrea Martorana Tusa Development The language of graph databases and SQL Server
09:45:00 Emanuele Meazzo Analytics and Visualization How to use PowerBI as a free monitoring tool (including 5 free reports for SQL Server)
09:45:00 Gianluca Hotz Database Admin SQL Server Modernization (IT)
11:00:00 Alexander Klein Cloud 101 BI and AI
11:00:00 Sergio Govoni Database Admin Query Processing improvements in the latest versions of SQL Server – IT
11:00:00 Francesco Milano Development A gentle introduction to Apache Spark for SQL Server people
11:00:00 Gianluca Sartori DevOps Monitoring SQL Server without breaking the bank
12:10:00 Sebastiano Galazzo Data Science Machine Learning - Best Practices and Vulnerabilities
12:10:00 Massimo Bonanni Cloud SQL-Serverless
12:10:00 Danilo Dominici DevOps Inside SQL Server containers
12:10:00 Gabriele Franco Database Admin TempDB optimizations from SQL Server 2005 to 2019
14:50:00 Tomaž Kaštrun Database Admin Analyzing System with Extended events, Query Store and R and Python
14:50:00 Marco Dal Pino Cloud Design and Architect always disconnected IoT System
14:50:00 Alessandro Mortola Database Admin Query tuning with Hypothetical Indexes - IT
14:50:00 Luca Zavarella Data Science Walk-through of Azure Machine Learning Service new features
16:00:00 Marco Obinu DevOps SQL Server e PowerShell: from zero to hero!
16:00:00 Mark Broadbent Database Admin SQL Server Availability Groups for dummies
16:00:00 franco perduca Analytics and Visualization Pratical Data Virtualization
16:00:00 Luca Ferrari Cloud Azure SQL Database: Dove siamo arrivati
17:00:00 Marco Minerva Development Accesso ai dati in applicazioni client/server con .NET Core 3.0
17:00:00 Riccardo Perico Database Admin EmPower your BI Architecture
17:00:00 Gilberto Zampatti Database Admin Database recovery: Concetti e novità in SQL Server 2019
17:00:00 Lorenzo Vercellati Analytics and Visualization No more Powerpoint: Datastorytelling Presentation with PowerBi

SessionID: 94220

Power BI server and Office Online server, modernize your on-premises BI approach.

Back to calendar

Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Data Science

Speaker: Isabelle Van Campenhoudt

Title: Power BI server and Office Online server, modernize your on-premises BI approach.

Abstract:

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 ?

SessionID: 95229

Architecting SQL Server environments for Mission Critical and High Performance

Back to calendar

Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Database Admin

Speaker: Marcelo Fernandes

Title: Architecting SQL Server environments for Mission Critical and High Performance

Abstract:

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.

SessionID: 95623

The language of graph databases and SQL Server

Back to calendar

Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Development

Speaker: Andrea Martorana Tusa

Title: The language of graph databases and SQL Server

Abstract:

SQL Server 2017 introduced the extension for graph databases. As there are millions of SQL Server users worldwide, this feature broadens enormously the audience of potential users.

But, what to expect exactly from a graph database? How to query it? Is SQL Server fully featured compared to other products? In this session we answer these questions. We start illustrating the concepts behind the model; how relationships are handled and what are the common patterns and issues for a graph. What are the data connections a graph can easily represent. Then we compare the semantic model with SQL Server to discover how to apply it to real world. We analyze some case study: pattern matching, path finding, aggregation, ranking … For each of them we show how to use standard T-SQL and how to rewrite the query using graph objects. What is the benefit of reformulate our queries in terms of clearness and performances, what is already available in order to consider SQL Server a valuable player.

SessionID: 98175

How to use PowerBI as a free monitoring tool (including 5 free reports for SQL Server)

Back to calendar

Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Emanuele Meazzo

Title: How to use PowerBI as a free monitoring tool (including 5 free reports for SQL Server)

Abstract:

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:

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

SessionID: 98390

SQL Server Modernization (IT)

Back to calendar

Event Date: 23-11-2019 - Session time: 09:45:00 - Track: Database Admin

Speaker: Gianluca Hotz

Title: SQL Server Modernization (IT)

Abstract:

Il supporto esteso per SQL Sever 2008 è terminato da pochi mesi, molte aziende si stanno ancora organizzando per modernizzare i loro ambienti. Ma cosa vuol dire modernizzare? Aggiornamento, cambio di piattaforma, consolidamento, spostamento da IaaS a PaaS... quali e quanti sono gli scenari evolutivi? Quali sono i fattori bloccanti? Quali sono i fattori di rischio più comuni? Come è strutturato un progetto di migrazione/modernizzazione? Quali sono gli strumenti a supporto? A queste e altre domande cercheremo di dare risposta con questa sessione che si pone l'obiettivo sia di fornire una panoramica sull'argomento anche portando esempi concreti dal campo.

SessionID: 94155

101 BI and AI

Back to calendar

Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Cloud

Speaker: Alexander Klein

Title: 101 BI and AI

Abstract:

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.

SessionID: 96744

Query Processing improvements in the latest versions of SQL Server – IT

Back to calendar

Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Database Admin

Speaker: Sergio Govoni

Title: Query Processing improvements in the latest versions of SQL Server – IT

Abstract:

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.

SessionID: 98263

A gentle introduction to Apache Spark for SQL Server people

Back to calendar

Event Date: 23-11-2019 - Session time: 11:00:00 - Track: Development

Speaker: Francesco Milano

Title: A gentle introduction to Apache Spark for SQL Server people

Abstract:

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.

SessionID: 98386

Monitoring SQL Server without breaking the bank

Back to calendar

Event Date: 23-11-2019 - Session time: 11:00:00 - Track: DevOps

Speaker: Gianluca Sartori

Title: Monitoring SQL Server without breaking the bank

Abstract:

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.

SessionID: 94204

Machine Learning - Best Practices and Vulnerabilities

Back to calendar

Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Data Science

Speaker: Sebastiano Galazzo

Title: Machine Learning - Best Practices and Vulnerabilities

Abstract:

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.

SessionID: 95169

SQL-Serverless

Back to calendar

Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Cloud

Speaker: Massimo Bonanni

Title: SQL-Serverless

Abstract:

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 in che modo sfruttare l'estensibilità delle Azure Functions per implementare Trigger, Binding o supportare i nostri servizi per l'accesso a SQL Server.

SessionID: 96804

Inside SQL Server containers

Back to calendar

Event Date: 23-11-2019 - Session time: 12:10:00 - Track: DevOps

Speaker: Danilo Dominici

Title: Inside SQL Server containers

Abstract:

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.

SessionID: 96845

TempDB optimizations from SQL Server 2005 to 2019

Back to calendar

Event Date: 23-11-2019 - Session time: 12:10:00 - Track: Database Admin

Speaker: Gabriele Franco

Title: TempDB optimizations from SQL Server 2005 to 2019

Abstract:

La contesa dei metadati in tempdb è sempre stato uno dei colli di bottiglia per quanto riguarda la scalabilità delle istanze SQL.

Negli anni sono state fatte parecchie ottimizzazioni dell’architettura del tempdb. In questa sessione verranno illustrate tutte le configurazioni, ottimizzazioni e best practices riguardanti il tempdb da SQL Server 2005 ad oggi.

SessionID: 95687

Analyzing System with Extended events, Query Store and R and Python

Back to calendar

Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Database Admin

Speaker: Tomaž Kaštrun

Title: Analyzing System with Extended events, Query Store and R and Python

Abstract:

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.

SessionID: 96389

Design and Architect always disconnected IoT System

Back to calendar

Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Cloud

Speaker: Marco Dal Pino

Title: Design and Architect always disconnected IoT System

Abstract:

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.

SessionID: 96720

Query tuning with Hypothetical Indexes - IT

Back to calendar

Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Database Admin

Speaker: Alessandro Mortola

Title: Query tuning with Hypothetical Indexes - IT

Abstract:

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.

SessionID: 99732

Walk-through of Azure Machine Learning Service new features

Back to calendar

Event Date: 23-11-2019 - Session time: 14:50:00 - Track: Data Science

Speaker: Luca Zavarella

Title: Walk-through of Azure Machine Learning Service new features

Abstract:

La sessione consiste prevalentemente in una dimostrazione pratica che vi guiderà nel mondo del nuovo Azure Machine Learning Service, focalizzandosi sulle nuove funzionalità quali il Designer (ML senza codice), l'auto ML e l'interpretabilità di un modello.

SessionID: 95118

SQL Server e PowerShell: from zero to hero!

Back to calendar

Event Date: 23-11-2019 - Session time: 16:00:00 - Track: DevOps

Speaker: Marco Obinu

Title: SQL Server e PowerShell: from zero to hero!

Abstract:

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.

SessionID: 95419

SQL Server Availability Groups for dummies

Back to calendar

Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Database Admin

Speaker: Mark Broadbent

Title: SQL Server Availability Groups for dummies

Abstract:

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!

SessionID: 96910

Pratical Data Virtualization

Back to calendar

Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: franco perduca

Title: Pratical Data Virtualization

Abstract:

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

SessionID: 98070

Azure SQL Database: Dove siamo arrivati

Back to calendar

Event Date: 23-11-2019 - Session time: 16:00:00 - Track: Cloud

Speaker: Luca Ferrari

Title: Azure SQL Database: Dove siamo arrivati

Abstract:

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.

SessionID: 94147

Accesso ai dati in applicazioni client/server con .NET Core 3.0

Back to calendar

Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Development

Speaker: Marco Minerva

Title: Accesso ai dati in applicazioni client/server con .NET Core 3.0

Abstract:

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.

SessionID: 96643

EmPower your BI Architecture

Back to calendar

Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Database Admin

Speaker: Riccardo Perico

Title: EmPower your BI Architecture

Abstract:

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.

SessionID: 98195

Database recovery: Concetti e novità in SQL Server 2019

Back to calendar

Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Database Admin

Speaker: Gilberto Zampatti

Title: Database recovery: Concetti e novità in SQL Server 2019

Abstract:

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

SessionID: 98207

No more Powerpoint: Datastorytelling Presentation with PowerBi

Back to calendar

Event Date: 23-11-2019 - Session time: 17:00:00 - Track: Analytics and Visualization

Speaker: Lorenzo Vercellati

Title: No more Powerpoint: Datastorytelling Presentation with PowerBi

Abstract:

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.