Nr: 495
SQLSaturday #495 - Pordenone 2016
SessionID: 42375
SQL Server 2016: Nuove funzionalit#224; in SQL Server Integration Services
Event Date: 27-02-2016 - Session time: 09:40:00 - Track: Analytics and Reporting
Speaker: Gilberto Zampatti
Title: SQL Server 2016: Nuove funzionalit#224; in SQL Server Integration Services
Abstract:
SQL Server Integration Services (SSIS) introduce nnuove capacit#224;, come ad esempio la ppossibilit#224; 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#249; 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#224; di SSIS e valutare nuovi benefici ed opportunit#224;.
SessionID: 42596
SQL Server 2012-2016 Columnar Storage
Event Date: 27-02-2016 - Session time: 09:40:00 - Track: SQL Server 2016
Speaker: Dejan Sarka
Title: SQL Server 2012-2016 Columnar Storage
Abstract:
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.
SessionID: 44543
Azure SQL Database (IT)
Event Date: 27-02-2016 - Session time: 09:40:00 - Track: Cloud Developers
Speaker: Gianluca Hotz
Title: Azure SQL Database (IT)
Abstract:
SQL Server in una Virtual Machine #232; la classica soluzione IaaS nel Cloud, si tratta di un’ottima soluzione che ha il pregio della familiarit#224; 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#224; legate ai temi di scalabilit#224;, alta disponibilit#224; e disaster recovery. Azure SQL Database #232; 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#224; tipicamente introdotte in anticipo rispetto alle versioni On-Premise. Questa sessione #232; diretta sia agli sviluppatori che agli amministratori di database interessati ad approfondirne le funzionalit#224;, gli scenari implementativi e le differenze con offerte simili quali Amazon RDS.
SessionID: 42139
SQL Server 2016 JSON support
Event Date: 27-02-2016 - Session time: 10:50:00 - Track: SQL Server 2016
Speaker: Alessandro Alpi
Title: SQL Server 2016 JSON support
Abstract:
SessionID: 42151
Tired of connecting on-prem cloud data? Take a DB stretch
Event Date: 27-02-2016 - Session time: 10:50:00 - Track: Cloud Developers
Speaker: Dr. Subramani Paramasivam
Title: Tired of connecting on-prem cloud data? Take a DB stretch
Abstract:
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.
SessionID: 42599
Event Date: 27-02-2016 - Session time: 11:45:00 - Track: Cloud Developers
Speaker: Dejan Sarka
Abstract:
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.
SessionID: 43080
Using SQL Server 2016 and R Integration
Event Date: 27-02-2016 - Session time: 11:45:00 - Track: Analytics and Reporting
Speaker: Tomaž Kaštrun
Title: Using SQL Server 2016 and R Integration
Abstract:
With SQL Server 2016 (CTP 3 release) R Language for statistical programming is now supported with native T-SQL. With this extension we can now integrate powerful R Language with transactional data directly using SSMS.
In this session we will go through:
- Installation needed (R and RRO by Revolution Analytics (now Microsoft)
- Exploring the usage of RRO Engine (multi-threated usage and parallel multi-core usage of CPU,...)
- Using T-SQL for Data analysis with importing and exporting data to SQL Tables
- Demos with using Predictions on datasets and exploring usability of Reporting services (SSRS) and Power BI (integration with R now possible).
Session is useful for BI analysts as well as for DEV and DBA as we can easily make server monitoring and use of predictions for server monitoring (predicting when disk will be full and any other extended events).
SessionID: 44544
SQL Server 2016 Temporal Database Support (IT)
Event Date: 27-02-2016 - Session time: 11:45:00 - Track: SQL Server 2016
Speaker: Gianluca Hotz
Title: SQL Server 2016 Temporal Database Support (IT)
Abstract:
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.
SessionID: 43079
Microsoft Azure Machine Learning Algorithms
Event Date: 27-02-2016 - Session time: 13:40:00 - Track: Analytics and Reporting
Speaker: Tomaž Kaštrun
Title: Microsoft Azure Machine Learning Algorithms
Abstract:
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.
SessionID: 44407
SQL Server 2016 Query Store: un nuovo modo di monitorare le query
Event Date: 27-02-2016 - Session time: 13:40:00 - Track: SQL Server 2016
Speaker: Saverio Lorenzini
Title: SQL Server 2016 Query Store: un nuovo modo di monitorare le query
Abstract:
Query Store #232; la nuova funzionalit#224; 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: #232; 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#224; e ne illustra l’utilizzo in un’ottica di ottimizzazione e troubleshooting.
SessionID: 44989
Azure Stream Analytics
Event Date: 27-02-2016 - Session time: 13:40:00 - Track: Cloud Developers
Speaker: Marco Parenzan
Title: Azure Stream Analytics
Abstract:
SessionID: 42853
New life for Reporting Services: what'up in 2016
Event Date: 27-02-2016 - Session time: 14:35:00 - Track: Analytics and Reporting
Speaker: Andrea Martorana Tusa
Title: New life for Reporting Services: what'up in 2016
Abstract:
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.
SessionID: 44411
The most prominent wait types of your SQL Server 2016 (IT)
Event Date: 27-02-2016 - Session time: 14:35:00 - Track: SQL Server 2016
Speaker: Sergio Govoni
Title: The most prominent wait types of your SQL Server 2016 (IT)
Abstract:
Una query, durante la sua esecuzione, pu#242; 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#242; attendere. In questa sessione, sulla base delle statistiche pubblicate dalla DMV sys.dm_os_wait_stats, verranno descritti e analizzati i wait type pi#249; frequenti in un carico di lavoro OLTP.
SessionID: 42138
Realizzare una vera Continuous Integration con SQL Server
Event Date: 27-02-2016 - Session time: 15:45:00 - Track: Cloud Developers
Speaker: Alessandro Alpi
Title: Realizzare una vera Continuous Integration con SQL Server
Abstract:
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
SessionID: 42373
SQL Server 2016: Maturazione dell'In-Memory OLTP
Event Date: 27-02-2016 - Session time: 15:45:00 - Track: SQL Server 2016
Speaker: Gilberto Zampatti
Title: SQL Server 2016: Maturazione dell'In-Memory OLTP
Abstract:
SessionID: 44992
PowerBi
Event Date: 27-02-2016 - Session time: 15:45:00 - Track: Analytics and Reporting
Speaker: Marco Pozzan
Title: PowerBi
Abstract:
PowerBi
SessionID: 42720
Event Date: 27-02-2016 - Session time: 16:40:00 - Track: Analytics and Reporting
Speaker: Andrea Martorana Tusa
Abstract:
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.
SessionID: 42860
New Security Features in SQL Server 2016
Event Date: 27-02-2016 - Session time: 16:40:00 - Track: SQL Server 2016
Speaker: Gianluca Sartori
Title: New Security Features in SQL Server 2016
Abstract:
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.
SessionID: 44287
Elastic Database, going to the infinity *
Event Date: 27-02-2016 - Session time: 16:40:00 - Track: Cloud Developers
Speaker: Emanuele Zanchettin
Title: Elastic Database, going to the infinity *
Abstract:
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