Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 21
SQL Server in una Virtual Machine è la classica soluzione IaaS nel Cloud, si tratta di un’ottima soluzione che ha il pregio della familiarità e si presta bene a scenari di integrazione ibridi tra Cloud e On-Premise. Tuttavia, non riduce significativamente i costi di gestione ordinaria e le complessità legate ai temi di scalabilità, alta disponibilità e disaster recovery. Azure SQL Database è la soluzione PaaS/SaaS che offre un servizio di database relazionale con una copertura funzionale ormai praticamente identica a quella del Database Engine di un SQL Server tradizionale con una riduzione dei costi di implementazione e manutenzione e il beneficio di nuove funzionalità tipicamente introdotte in anticipo rispetto alle versioni On-Premise. Questa sessione è diretta sia agli sviluppatori che agli amministratori di database interessati ad approfondirne le funzionalità, gli scenari implementativi e le differenze con offerte simili quali Amazon RDS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Beginner

Session Code:

Date: February 27

Time: 9:40 AM - 10:40 AM

Room: Room S7

Modern business is fast and needs to take decisions immediatly. It cannot wait that a traditional BI task that snapshots data at some time. Social data, Internet of Things, Just in Time don't undestand "snapshot" and needs working on streaming, live data. Microsoft offers Stream Analytics service on the Cloud. Let's see how it works.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Intermedia

Session Code:

Date: February 27

Time: 1:40 PM - 2:40 PM

Room: Room S7

In 2015 Microsoft carried out the release of Power BI and the acquisition of Datazen. 
During 2016 many changes are expected mostly regarding Reporting Services as a tool for contents repository and delivery. 
This means that now developers have a wide range of tools available for reporting, dashboarding, data analysis, both for desktop and mobile devices. So the question is: which one to choose? 
What are the key factor for supporting the correct decision? What changes are expected in the next future?
This session we'll focus on mobile BI reporting; we will provide a clear and understandable overview of each product, highlighting strengths and weaknesses.
You'll be able to see how to develop and deliver mobile BI reports with Reporting Services, Power BI and Datazen. 
Based on some real examples we will set out a comparison matrix to find the best way to meet your needs with the right reporting tool. 
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Reporting

Level: Intermedia

Session Code:

Date: February 27

Time: 4:40 PM - 5:40 PM

Room: Room S6

Elastic Database features enables you to use the virtually unlimited database resources of Azure SQL Database to create solutions for transactional workloads, and especially Software as a Service (SaaS) applications. Honors and duties to use this feature: in this session we will try to understand how it works, when to use it and when it becomes necessary. * Depends on your wallet ;D
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Intermedia

Session Code:

Date: February 27

Time: 4:40 PM - 5:40 PM

Room: Room S7

Companies want to gather information from the data; therefore, they start BI projects. They design a data warehouse and then start developing extract – transform – load (ETL) applications. However, most of BI projects have to deal with problems with data quality (DQ). Data quality can be a huge obstacle for a successful BI project. Of course, line of business applications suffer from poor data quality as well.
Every company has part of the data which is used everywhere, in every transaction, like customers data, products data and similar. Such data is called master data. People who manage master data are often called data stewards. Processes and activities for maintaining master data are known as master data management (MDM). In this presentation, we are going to discuss ETL, DQ and MDM problems and introduce how Microsoft SQL Server 2016 tools can help you with solutions.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Intermedia

Session Code:

Date: February 27

Time: 11:45 AM - 12:45 PM

Room: Room S7

Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service.  Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms  and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms.
Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Reporting

Level: Intermedia

Session Code:

Date: February 27

Time: 1:40 PM - 2:40 PM

Room: Room S6

During 2015 PASS Summit, Microsoft announced a roadmap to harmonize and standardize its BI reporting solutions into one unique hybrid scenario.
Reporting Services will play a crucial role in this new architecture. Starting from 2016 release, Reporting Services will be the Microsoft's on-premises solution for BI report delivery, meaning that it will host on-premises standard report as well as mobile report as well as Power BI Desktop report. 
To achieve this goal Reporting Services has been completely revisited and redesigned.

Come to this session to have a preview of the new features developed for Reporting Service with the advent of SQL Server 2016.
Your BI reporting strategy for the future could be completely revisited as you learn how many amazing changes are expected in the next future.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Reporting

Level: Intermedia

Session Code:

Date: February 27

Time: 2:35 PM - 3:35 PM

Room: Room S6

In this session we will explore the new features introduced with SQL Server 2016 to enhance security. 
Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database.
Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents.
Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code.
We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 4:40 PM - 5:40 PM

Room: Room S1

PowerBi
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Reporting

Level: Beginner

Session Code:

Date: February 27

Time: 3:45 PM - 4:45 PM

Room: Room S6

Dopo aver messo i nostri database sotto Source Control e dopo aver scritto i nostri Unit Testing, andiamo a completare il processo di Continuous Integration automatizzando il processo di build. In questo modo avremo realizzato una vera ed automatizzata integrazione continua. In questa sessione andremo a mostrare come creare i trigger di automazione delle build dei nostri database (construzioni di database sandbox, separati dallo sviluppo) e come, di conseguenza, eseguire i test dopo una semplice operazione di checkin di un changeset. Affronteremo la problematica utilizzando TFS (o Visual Studio Online) e SQL Server + tSQLt
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Advanced

Session Code:

Date: February 27

Time: 3:45 PM - 4:45 PM

Room: Room S7

First introduced in version 2012, columnstore indices and batch processing development continued in SQL Server 2014 and 2016. This session explains the need for the columnar storage, the internals of the SQL Server columnstore indices, and compares the implementations in different versions of SQL Server.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 9:40 AM - 10:40 AM

Room: Room S1

SQL Server 2016 porterà tantissime novità, tra cui, per quanto riguarda la programmabilità, il supporto al formato JSON. vedremo com'è possibile serializzare i risultati delle nostre query tramite la clausola FOR JSON, inclusa negli ultimi rilasci della piattaforma.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 10:50 AM - 11:50 AM

Room: Room S1

Query Store è la nuova funzionalità di SQLServer 2016 che permette la storicizzazione nel tempo delle prestazioni delle query, oltre i riavvii della macchina.  Consente l'archiviazione delle prestazioni del piano di esecuzione e delle prestazioni delle query, permettendone l'analisi a posteriori.
Questo meccanismo permette di effettuare analisi sofisticate delle query e delle loro prestazioni: è possibile correlare il cambiamento delle performances a quello del piano di esecuzione o ad altri eventi, seguire nel tempo le prestazioni di determinate porzioni del codice, individuare regressioni oppure identificare le query che hanno degradato recentemente.
E possibile inoltre seguire nel tempo l’evoluzione di un piano di esecuzione di una specifica query in funzione di cambiamenti, quali cambio delle statistiche, modifiche dello schema o presenza di indici.
La sessione entra nel dettaglio della funzionalità e ne illustra l’utilizzo in un’ottica di ottimizzazione e troubleshooting.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 1:40 PM - 2:40 PM

Room: Room S1

I database temporali sono oggetto di studio da lungo tempo, quasi dieci anni fa UGISS ha dedicato due sessioni a questo tema sia dal punto di vista teorico, che da quello pratico, pur non avendo alcun tipo di supporto specifico in SQL Server. La nuova versione 2016 introduce il supporto a tabelle temporali che mantengono automaticamente, e in modo trasparente, la storia delle modifiche e permettono analisi puntuali nel tempo in maniera pratica con apposite estensioni del linguaggio. In questa sessione faremo una breve revisione dei database temporali e vedremo in dettaglio il supporto in SQL Server 2016 con l'ausilio di svariate dimostrazioni pratiche.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 11:45 AM - 12:45 PM

Room: Room S1

In-Memory OLTP è una tecnologia che ha subito in questa nuova versione significativi miglioramenti, tesi soprattutto a garantire la scalabilità su databases di maggiori dimensioni e un throughput più elevato, al fine di supportare carichi di lavoro sempre più elevati. Sono stati inoltre eliminati vincoli e limitazioni relative a tabelle e stored procedures per rendere più agevole la mugrazione alla nuova piattaforma e trarne i relativi vantaggi. In questa sessione esploreremo le nuove features e quelle migliorate (altering Memory-optimized Tables and Natively Compiled Stored Procedures, Scalar UDF, supporto alle subqueries nelle Natively Complied Stored Procedures ecc.).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 3:45 PM - 4:45 PM

Room: Room S1

SQL Server Integration Services (SSIS) introduce nnuove capacità, come ad esempio la ppossibilità di aggiunggere il catalogo SSISDB ad un AlwaysOn Availability Group; Incremental Package Deployment (Deploytment incrementale dei packages) consente di effettuare il deployment di uno o più packages in un progetto nuovo o preesistente senza dover effettuare il deployment dell'intero progetto; Effettuando l'upgrade dei progetti SSIS dalle versioni precedenti i connection manager a livello di progetto continueranno a funzionare e saranno conservati i layout e le annotazioni dei packages. In questa sessione potremo approfondire i vari aspetti di queste ed altre novità di SSIS e valutare nuovi benefici ed opportunità.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Reporting

Level: Intermedia

Session Code:

Date: February 27

Time: 9:40 AM - 10:40 AM

Room: Room S6

SQL Server Integration Services (SSIS) include several most important components required in data acquisition, transformation, and load operations. If the problem at hand demands a solution that cannot be solved using the built-in components alone, you can resort to the freely extensible Script Component, but when the circumstances also call for a more complex, and more robust solution, that will be deployed to more than one destination server, the more appropriate alternative is to design a Custom Component.In this session you will learn how this can be achieved, what advantages it provides, and how to perform even the most complex data transformations in a standardised and reliable environment.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Analytics and Reporting

Level: Advanced

Session Code:

Date: February 27

Time: 10:50 AM - 12:20 PM

Room: Room S6

Numerous techniques for concatenating string data can be found online, and even in some books. In this session you will learn two of them that are reliable, and fairly easy to understand, implement, and deploy. You will also learn how to control the order of the values being concatenated, a feature that is not natively provided by SQL Server.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Advanced

Session Code:

Date: February 27

Time: 2:35 PM - 3:35 PM

Room: Room S7

Una query, durante la sua esecuzione, può essere sospesa decine o addirittura centinaia di volte. Una query rimane in esecuzione fino a quando, ad esempio, non richiede di accedere ad una risorsa esterna o fino a quando il thread che la gestisce non eccede il quantum di utilizzo della CPU. In SQL Server 2016 ci sono 831 buoni motivi per cui una query può attendere. In questa sessione, sulla base delle statistiche pubblicate dalla DMV sys.dm_os_wait_stats, verranno descritti e analizzati i wait type più frequenti in un carico di lavoro OLTP.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
SQL Server 2016

Level: Intermedia

Session Code:

Date: February 27

Time: 2:35 PM - 4:05 PM

Room: Room S1

You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm & cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily and this session will enable you to understand enabling / disabling data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup & restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow & Deep backups. However, Deep backups are not currently supported with SQL Server 2016 CTP2.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud & Developers

Level: Beginner

Session Code:

Date: February 27

Time: 10:50 AM - 11:50 AM

Room: Room S7

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