Start Time (24h) | Speaker | Track | Title |
---|---|---|---|
09:45:00 | Luca Zavarella | Advanced Analysis Techniques | Market Basket Analysis in SQL Server Machine Learning Services |
09:45:00 | Andrea Martorana Tusa | Visualization | Custom maps in Power BI |
09:45:00 | Janusz Rokicki | Cloud Application Development Deployment | 8 Steps to Securing Azure Sql PaaS |
09:45:00 | Gianluca Hotz | Strategy and Architecture | SQL Server 2019 CTP 2.2 (IT) |
09:45:00 | Francesco Milano | BI Platform Architecture, Development Administration | From Zero to Cube in forty minutes (within a web browser) |
11:15:00 | Dennes Torres | Analytics and Visualization | PowerBI: From Zero to Hero |
11:15:00 | andrea benedetti | Cloud Data Platform | Azure Data Integration:Choosing between SSIS, Azure Data Factory, Azure Databricks |
11:15:00 | Dejan Sarka | Advanced Analysis Techniques | Data Overview and Manipulation – T-SQL, R, Python |
11:15:00 | Danilo Dominici | Enterprise Database Administration Deployment | Powershell, DBATools e i "ferri del mestiere" del DBA |
11:15:00 | Marco Parenzan | DevOps/ Developer | Graph Databases in the Microsoft ecosystem |
12:20:00 | James Anderson | Application Database Development | SQL Server and Continuous Integration |
12:20:00 | Marco Obinu | Enterprise Database Administration Deployment | From on-prem SQL instance to SQL Azure Database Managed Instances in 60 minutes! |
12:20:00 | Gilberto Zampatti | Enterprise Database Administration Deployment | I metadati di SQL Server |
12:20:00 | Francesco De Chirico | BI Platform Architecture, Development Administration | Il mio grosso grasso modello di Power BI |
12:20:00 | Alessio Biasiutti | Other | Event Processing with Spark |
14:30:00 | Tomaž Kaštrun | Advanced Analysis Techniques | Applied data analytics with Azure Databricks |
14:30:00 | Marco Dal Pino | Application Database Development | Data management for disconnected or almost disconnected devices |
14:30:00 | Lorenzo Vercellati | Analytics and Visualization | Il Decalogo del progetto Power BI |
14:30:00 | Sergio Govoni | Enterprise Database Administration Deployment | SQL Server Query Optimizer end-to-end |
14:30:00 | Gianluca Sartori | Enterprise Database Administration Deployment | Benchmarking in the Cloud |
15:35:00 | Andrea Martorana Tusa | Analytics and Visualization | Failure prediction for manufacturing industry with SQL Server R |
15:35:00 | Gianluca Hotz | Enterprise Database Administration Deployment | SQL Server Modernization (IT) |
15:35:00 | Marco Minerva | Application Database Development | Accesso ai dati in applicazioni client/server con .NET Core 3.0 |
15:35:00 | Marco Pozzan | Advanced Analysis Techniques | What is in reality a DAX filter context |
15:35:00 | Elisa Piccin | Common Data Model, nice to meet you | |
16:40:00 | Kamil Nowinski | BI Platform Architecture, Development Administration | Azure Data Factory v2 with Data Flows capabilities |
16:40:00 | Rudi Bruchez | Enterprise Database Administration Deployment | What I have seen so far in my performance tuning audits |
16:40:00 | Tomaž Kaštrun | Analytics and Visualization | Near Real-time data visualizations |
16:40:00 | Emanuele Zanchettin | Cloud Application Development Deployment | Multitenancy – from zero to it works! |
16:40:00 | Marco Minerva | Other | Cosmos DB - La nuova frontiera del BigData e NoSql |
Event Date: 23-02-2019 - Session time: 09:45:00 - Track: Advanced Analysis Techniques
In questa sessione vedremo come i nuovi Machine Learning Services ci permettono di ricavare gli insight di questa analisi direttamente in SQL Server 2017, utilizzando il linguaggio di programmazione R.
Event Date: 23-02-2019 - Session time: 09:45:00 - Track: Visualization
Do you know what is a shapefile? Do you know how to create your own choropleth and import it into Power BI? What else? R support into Power BI opened the doors to the huge number of packages for spatial data analysis and statistical calculations included in the environment. Do you want to draw multi-layered interactive maps, or perform spatial analytics? With R in Power BI, now you can. Discover some custom visuals to overcome simple cartography: MapBox, IconMap, FlowMap. Last but not least, learn how to use Synoptic Panel, an awesome component that connects areas in a custom image with attributes in the data model and draws the data on a map. There are endless possibilities; the only limit is your imagination!
Event Date: 23-02-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment
Event Date: 23-02-2019 - Session time: 09:45:00 - Track: Strategy and Architecture
Event Date: 23-02-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 23-02-2019 - Session time: 11:15:00 - Track: Analytics and Visualization
Event Date: 23-02-2019 - Session time: 11:15:00 - Track: Cloud Data Platform
Event Date: 23-02-2019 - Session time: 11:15:00 - Track: Advanced Analysis Techniques
Event Date: 23-02-2019 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-02-2019 - Session time: 11:15:00 - Track: DevOps/ Developer
And then there are services like Microsoft Graph and Azure Digital Twins that give us vertical implementations of graph. So let's make a walkaround of graphs in the MIcrosoft ecosystem.
Event Date: 23-02-2019 - Session time: 12:20:00 - Track: Application Database Development
Do you dread large merge conflicts when integrating code?
Continuous Integration is a method of working where we merge and fully test our code multiple times a day. This is only possible with a high level of automation.
I'll be discussing the tools I use to achieve this automation when developing SQL Server databases.
Finding automating the deployment of database changes hard? SQL Change Automation is a tool that allows you to test deployments during development.
How do you know your database change won’t affect something you haven’t thought of? tSQLt and Pester unit tests can put your mind at rest.
Having trouble keeping your test environments in sync with production? Docker enables us to fix this with infrastructure as code
You will see how a CI approach to database development can increase team efficiency and reduce the time to go from an idea
Event Date: 23-02-2019 - Session time: 12:20:00 - Track: Enterprise Database Administration Deployment
Vediamo che cosa sono, e come possiamo agilmente spostarci sopra i nostri dati con pochi in maniera "DevOps-oriented".
Event Date: 23-02-2019 - Session time: 12:20:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-02-2019 - Session time: 12:20:00 - Track: BI Platform Architecture, Development Administration
In realtà questa è una buona prassi che dovrebbe sempre essere prevista nel ciclo di sviluppo dei nostri modelli indipendentemente dalla loro dimensione e complessità. In questa sessione, dopo una breve introduzione teorica sul funzionamento di VertiPaq e dei suoi algoritmi di compressione, ci concentreremo su alcune best practices da seguire per ottimizzare i nostri modelli e sugli strumenti a nostra disposizione per verificare l’effettivo livello di ottimizzazione degli stessi. Inoltre, vedremo come sia possibile raccogliere, tramite DMV, tutte le informazioni utili delle strutture dati dei nostri modelli utilizzando Power BI desktop, fino a realizzare una versione “Power BI” del famoso tool Vertipaq Analizer.
Event Date: 23-02-2019 - Session time: 12:20:00 - Track: Other
Durante la sessione vedremo un'overview delle funzionalità e un esempio di di come sia possibile eseguire l'ingestion dei dati con Event Hub (Kafka enabled) eseguire un'analisi con Spark e salvare i risultati su Cosmos DB.
Event Date: 23-02-2019 - Session time: 14:30:00 - Track: Advanced Analysis Techniques
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.
Event Date: 23-02-2019 - Session time: 14:30:00 - Track: Application Database Development
Event Date: 23-02-2019 - Session time: 14:30:00 - Track: Analytics and Visualization
Event Date: 23-02-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-02-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment
Join me in this session and learn how to capture a production workload, replay it to your cloud database and compare the performance. I will introduce you to the methodology and the tools to bring your database to the cloud without breaking a sweat.
Event Date: 23-02-2019 - Session time: 15:35:00 - Track: Analytics and Visualization
Machine Learning techniques can help us to accomplish this task. Starting from past failure data, we can build up a predictive model to forecast the likelihood for a product to fail or giving an estimate on its duration. And now it is possible to develop an end-to-end solution in SQL Server, because of the introduction of advanced analytics tools like R since release 2016. In this session, we start from the real case of a manufacturing company to create some predictive models: a) Regression model ; b) binary and multivariate models. Binary or multi-class classification problem. Some reports are also created to deliver the outcome to the stakeholders.
Event Date: 23-02-2019 - Session time: 15:35:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-02-2019 - Session time: 15:35:00 - Track: Application Database Development
Event Date: 23-02-2019 - Session time: 15:35:00 - Track: Advanced Analysis Techniques
Event Date: 23-02-2019 - Session time: 15:35:00 - Track:
Without being able to share and understand the same data easily, each application or data integration project requires a custom implementation, which can be expensive and potentially risky from a business users point of view. Here is where the Common Data Model (CDM) comes in: we will understand CDM underlying concepts and try some hands-on integration with Microsoft Power Platform and Azure data services.
Event Date: 23-02-2019 - Session time: 16:40:00 - Track: BI Platform Architecture, Development Administration
But, has that been only UI introduction? Why and how Databricks does work under the hood? Do you want to know this new (still in private preview) feature of ADF and reveal the power of modern big data processes without knowledge of such languages like Python or Scala? We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
Event Date: 23-02-2019 - Session time: 16:40:00 - Track: Enterprise Database Administration Deployment
Event Date: 23-02-2019 - Session time: 16:40:00 - Track: Analytics and Visualization
Session will cover several capabilities to use open source products to deliver real-time data visualization and data predictions on top of your SQL Server database.
Event Date: 23-02-2019 - Session time: 16:40:00 - Track: Cloud Application Development Deployment
Event Date: 23-02-2019 - Session time: 16:40:00 - Track: Other