Event Location:
Viale G.P. Usberti c/o Campus Università degli Studi di Parma
Parco Area delle Scienze, 181/a
Parma, , Italy
Abstract:
Spesso, troppo spesso, si leggono informazioni non precise in merito a come utilizzare SQL Server. A volte veri e propri suggerimenti errati che portano a costruire soluzioni pensando di fare le cose nel modo migliore. Molti sono i miti che ruotano intorno al motore relazionale di casa Microsoft. In questa sessione affronteremo diversi miti e pregiudizi su SQL Server per spiegare cosa realmente accade "dietro le quinte" e come poter sfruttare al meglio le funzionalità che abbiamo a disposizione. Una sessione molto utile sia per testare le reali conoscenze di SQL Server, sia per migliorare la propria competenza. Scopriremo come miti e pregiudizi comuni possono in realtà peggiorare le prestazioni, avere configurazioni errate, ridurre la disponibilità dei dati.
Speaker(s): andrea benedetti,
Abstract:
Entity Framework è la tecnologia (open-source) di accesso ai dati consigliata e coordinata da Microsoft, in dettaglio è un ORM (object-relational mapper) nato dall'esigenza di volere accedere a dati relazionali sfruttando la pura programmazione ad oggetti, eliminando quasi completamente la necessità di dovere scrivere codice specifico per l'accesso ai dati (T-SQL). In particolare in questa sessione vedremo come sfruttare Entity Framework ricavandone il massimo dell'elasticità, partendo dal codice (Code-First) e non da un designer (Model-First), inoltre vedremo come sia possibile accedere anche ad un database esistente, sempre in code-first. Indipendentemente che siate nuovi, o abbiate già sguazzato in altre tecnologie ORM, vi mostrerò quanto velocemente sia possibile iniziare a lavorare con EF6 e aumentare la vostra produttività durante la creazione di applicazione .NET data-centriche.
Speaker(s): Michael Denny,
Abstract:
In a Corporate BI environment, it is common having data available in controlled data sources such as Data Warehouse, relational Data Marts, and Analysis Services cubes. Consuming this data with self-service BI is very useful, but how do you manage and validate the access to corporate data sources? How do you share and validate new queries created by end users? How can users extract data at the right granularity level? Power Query bridges the gap between corporate and self-service BI. It empowers end-users so that they can extract and manipulate data from several data sources, inside and outside of the company. In this session, learn the Power Query best practices that enable the extraction of data from existing database and cubes, guided by an expert who understands both worlds (Corporate BI and Power Pivot data models).
Speaker(s): Marco Russo,
Abstract:
Ogni query, prima di essere eseguita, viene trasformata dal Query Optimizer in un piano di esecuzione. Il piano di esecuzione descrive in quale ordine vengono accedute le tabelle, quali sono gli indici utilizzati e con quale modalità di accesso; quali operatori fisici implementano le operazioni richieste, sintetizzando traccia la strada più efficiente per accedere ai dati. In questa sessione, dopo aver descritto che cosa accade, dietro le quinte, quando una query viene eseguita, vedremo come consultare il relativo piano di esecuzione per trarre informazioni che ci permettano di scrivere query più efficienti; vedremo infine come consultare i piani di esecuzione delle query eseguite in un’istanza SQL Azure.
Speaker(s): Sergio Govoni,
Abstract:
Migliorare le prestazioni del codice T-SQL eseguito su SQL Server è uno dei temi più ricorrenti. SQL Server offre una fonte ricchissima di informazioni per capire molti problemi prestazionali: la memoria cache dei piani di esecuzione. La sessione mostra le tecniche di esplorazione della memoria cache di SQL Server, per arrivare ad identificare le query peggiori tramite l’analisi automatica di script SQL e xQuery dei piani di esecuzione presenti in formato XML. Viene mostrato come identificare in maniera automatica i piani di esecuzione più costosi, le possibili ottimizzazioni e gli operatori meno performanti. Più in generale, come identificare le parti di codice più onerose per arrivare a dare indicazioni puntuali di progettazione e manutenzione allo sviluppatore ed al DBA. Mostra inoltre le novità introdotte da SQL 2014 per facilitare l’approccio a questa tematica.
Speaker(s): Saverio Lorenzini,
Abstract:
In an enterprise, merging master data, like customer data, from multiple sources is a common problem. Typically, you do not have a single, i.e. the same key identifying a customer in different sources. You have to match data based on similarity of strings, like names and addresses. In this session, we are going to check how different algorithms for comparing strings included in SQL Server work. We are going to use four different algorithms that come with Master Data Services (Levenshtein, Jaccard, Jaro-Winkler and Ratcliff-Obershelp), and Fuzzy Lookup transformation from Integration Services. Finally, we are going to introduce how SQL Server Data Quality Services help us here.
Speaker(s): Dejan Sarka,
Abstract:
How Massive Parallel Process Works? Sql Server 2012 Parallel Datawarehouse is an Enterprise solution for massive parallel data processing for huge database. Redundancy, Scalable, Extreme performances, Hadoop Polybase native support....
Speaker(s): Luca Ferrari,
Abstract:
The Columnstore indexes technology has been introduced in SL Server 2012 and strongly enhanced in SQL 2014. This session illustrate their architecture and will show pros (many) and cons (not so many). Starting from large DWH in SQL Server 2012, a number of OLTP application can now take advantage from this feature to achieve impressive performance improvements.
Speaker(s): Gilberto Zampatti,
Abstract:
We are used to see our code under source control. What about our databases? This topic is too often underestimated. Keeping database under our control (source controlled) brings many advantages in terms of organization and quality. The distributed work become rock solid and Continuous integration is simpler to implement. In addition, we can take many advantages from testing, automated deployment and all the stuff that brings the agile methodology available to the team. We will compare also third party tools in order to understand the differences between different vendors.
Speaker(s): Alessandro Alpi,
Abstract:
Text mining is becoming more and more popular. Everybody would like to understand data from blogs, Web sites, and social media. Microsoft SQL Server in versions 2012 and 2014 enhances full-text search support that was substantially available in previous editions. Semantic Search, a new component in Full-Text Search, can help you understanding the meaning of documents. The Term Extraction and Term Lookup components from SQL Server Integration Services also help with text analysis. However, the question arises: is all this enough? This presentation unveils the good and the bad side of text mining with SQL Server tools.
Speaker(s): Dejan Sarka,
Abstract:
In questa sessione vedremo come Azure permette di interagire con I Big Data, per creare quello che viene definite un "Modern BI Ecosystem": utilizzando HDInsight, PowerBI, e SQL Server nel cloud, vedremo come poter creare una soluzione complete, sfruttuando tutte le potenzialità che il cloud ci mette a disposizione.
Speaker(s): Davide Mauri,
Abstract:
PowerPivot and BISM Tabular share a columnar-based database engine called xVelocity. Understand some basic principles about how VertiPaq works, how data is compressed, and how you can design a data model for better optimization.
Speaker(s): Marco Pozzan,
Abstract:
Descrizione delle best practices per la virtualizzazione di SQL Server. Consolidamento dei server al fine del risparmio di licenze. Alta disponibilità in ambiente virtuale
Speaker(s): Andrea Caldarone,
Abstract:
Unit testing is a good practice to follow also in a database development environment. It allows to realize and finalize the Continuous Integration process on our database and It makes all the development more reliable and consistent just before deployment. We can use some interesting frameworks when testing, and we will speak about installing and executing them.
Speaker(s): Alessandro Alpi,
Abstract:
The SQL Server Data Collector has earned a bad name since its inception in SQL Server 2008. It has always been hard to customize, troubleshoot and extend. However, things are changing now with a new open source tool that lets you manage and customize your data collection with a graphical user interface and allows collecting data from Extended Events. Why not give Data Collector another try? It’s free, it ships with the product and in this session you will learn how to extend it to create a complete monitoring solution.
Speaker(s): Gianluca Sartori,
Abstract:
How does it works ? Why is so fast ? How can I use it ?
Speaker(s): Luca Ferrari,
Abstract:
Ok: you have SQL Azure, Machine Learning, and some specific DW-specific VMs. But...what is Azure? Let's do an overview about Azure, its offer, what you can do for your solution. Discover what is a Cloud Service, what is storage and georeplication, choose the right size of a VM. Try Virtual network and manage it with Powershell. https://github.com/marcoparenzan/sqlsat355
Speaker(s): Marco Parenzan,
Abstract:
BIML è un linguaggio XML-Based che permette di modellare completamente una soluzione di BI. E' particolarmente interessante per la creazione in automatico di processi ETL, per il quale può essere usato gratuitamente tramite il BIDS Helper, tool free che dovrebbe essere noto a tutti coloro che sviluppano soluzioni di BI con la piattaforma Microsoft.In questa sessione vedremo cos'è, come si usa e come può aiutare a ridurre sensibilmente i tempi di sviluppo di una soluzione ETL ed allo stesso tempo aumentarne la qualità.
Speaker(s): Davide Mauri,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: http://www.linkedin.com/in/sqlbi
Contact: https://www.sqlbi.com/blog/marco
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.
LinkedIn: https://it.linkedin.com/in/suxstellino
Contact: http://suxstellino.wordpress.com/
Alessandro lavora nell#39;IT dal 2000. La passione per l#39;informatica nasce ad 11 anni partendo dal C64 ed oggi #232; CTO di Engage IT Services srl dove si occupa della gestione del team di sviluppo e del contatto tecnico con i clienti. Nel team si occupa anche dell#39;amministrazione e del ciclo di vita dei database. E’ MVP SQL Server dal 2008, #232; anche Microsoft Certified Professional, ed oltre ad essere speaker a diversi eventi Microsoft, segue due blog e risponde sui forum di StackOverflow e MSDN
LinkedIn: http://www.linkedin.com/in/davidemauri
Contact: https://medium.com/@mauridb
Data Platform MVP for almost 12 years, I love Data and Database in all their forms. Developer for passion (C# and Python), I've been working in the IT field since 1997. My focus has been databases and performance tuning since the start, focusing both on transactional and analytical workloads. I worked for more than 10 years on Business Intelligence and Data Warehousing, then moved to IoT and Big Data for a while. Now back to database space, injecting passion and innovation into Azure SQL as Microsoft Program Manager for Azure SQL Hyperscale, helping developers to re-discover SQL, which is now almost everywhere, and take advantage of all its amazing power!
Contact: http://tipsandtrickssqlserver.blogspot.com
Luca Ferrari lavora in Microsoft Italia come PFE Engineer. Lavora con Sql server dalla versione 2000 ed ha seguito con attenzione tutte le evoluzioni del prodotto. Si occupa principalmente di: MPP SMP Design Troubleshooting Performance Tuning SSIS e SSRS, Azure SQL Database, Azure DataWarehouse.
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
I currently work as solution. I’m project leader in Microsoft and non Microsoft based solution involving technologies such as databases, active directory, virtualization and themes as disaster recovery, business continuity and cloud services. I’ve designed solution for some of the biggest firms in Italy both in the public and in the private sector. I’ve a wide knowledge of technologies involved in the IT world from the network, where I’ve a deep knowledge of
Contact: http://blogs.solidq.com/dsarka/Home.aspx
Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on development of database and business intelligence applications. Besides projects, he spends about half of his time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, Radacad, SolidQ, and Pluralsight.
LinkedIn: http://www.linkedin.com/in/davidemauri
Contact: https://medium.com/@mauridb
Data Platform MVP for almost 12 years, I love Data and Database in all their forms. Developer for passion (C# and Python), I've been working in the IT field since 1997. My focus has been databases and performance tuning since the start, focusing both on transactional and analytical workloads. I worked for more than 10 years on Business Intelligence and Data Warehousing, then moved to IoT and Big Data for a while. Now back to database space, injecting passion and innovation into Azure SQL as Microsoft Program Manager for Azure SQL Hyperscale, helping developers to re-discover SQL, which is now almost everywhere, and take advantage of all its amazing power!
Contact: http://tipsandtrickssqlserver.blogspot.com
Luca Ferrari lavora in Microsoft Italia come PFE Engineer. Lavora con Sql server dalla versione 2000 ed ha seguito con attenzione tutte le evoluzioni del prodotto. Si occupa principalmente di: MPP SMP Design Troubleshooting Performance Tuning SSIS e SSRS, Azure SQL Database, Azure DataWarehouse.
LinkedIn: https://it.linkedin.com/in/saveriolorenzini
Saverio Lorenzini is a Principal Engineer at the Premier Field Engineering division in Microsoft Italy. He has a master degree in Computer Science Engineering from University of Pisa, and joined Microsoft in 1998, where he started working on SQL Server from version 7.0. With more than 20 years of experience on SQL Server, he works on customer projects, focusing on performance tuning and optimization, solution development. He recently designed and developed SQL Monitoring Dashboard, a monitoring and performance analysis Web solution for SQL Server farms, sold by Microsoft Italy to Premier customers. He is a speaker at Microsoft events (TechReady), SQLPASS Summit and at PASS SQLSaturday community conferences, where he is an active member.
Contact: http://dennymichael.net
.NET developer and software architect, specialized in the development of highly scalable applications. Recognized as Microsoft Visual C# MVP in 2014. I like to contribute in open-source projects, and in the same way I like to help people on them development crusade, teaching what I've learned from my own experiences.
LinkedIn: https://www.linkedin.com/in/abenedetti
Contact: http://blogs.technet.com/b/andrea_benedetti_blog/
Andrea Benedetti è Architect SQL Server BI nella divisione Servizi di Microsoft Italia dove ha la responsabilità dei progetti enterprise su tutta la data platform. SQL Server MVP dal 2004 a fine 2011, lavora con SQL Server fin dalla versione 6.5, è intervenuto come relatore in numerosi workshop, conferenze, seminari e roadshow. Appassionato di alpinismo (in solitaria) cura un blog in italiano. Scrive su Twitter come @anbenedetti.
LinkedIn: https://it.linkedin.com/in/marcoparenzan
Contact: https://www.linkedin.com/in/marcoparenzan/
Marco Parenzan is an independent Cloud and IoT Architect and .NET Developer. He has been awarded as a MVP on Microsoft Azure since 2014. He is a speaker in major community events in Italy about Azure and .NET development. He is a community lead for 1nn0va, an official Microsoft community in Pordenone, Italy. He has written a book on Azure in 2016. He loves developing retrogames and reading comix. Marco Parenzan è professionista per le architetture Cloud e IoT e lo sviluppo in .NET. Ha ricevuto il titolo di MVP su Microsoft Azure dal 2014. È uno speaker in Italia su Azure e lo sviluppo di .NET. E' un community lead per 1nn0va, una community ufficiale Microsoft a Pordenone, in Italia. Ha scritto un libro su Azure nel 2016.
LinkedIn: https://it.linkedin.com/in/suxstellino
Contact: http://suxstellino.wordpress.com/
Alessandro lavora nell#39;IT dal 2000. La passione per l#39;informatica nasce ad 11 anni partendo dal C64 ed oggi #232; CTO di Engage IT Services srl dove si occupa della gestione del team di sviluppo e del contatto tecnico con i clienti. Nel team si occupa anche dell#39;amministrazione e del ciclo di vita dei database. E’ MVP SQL Server dal 2008, #232; anche Microsoft Certified Professional, ed oltre ad essere speaker a diversi eventi Microsoft, segue due blog e risponde sui forum di StackOverflow e MSDN
LinkedIn: http://it.linkedin.com/pub/gianluca-sartori/23/50b/a12
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
LinkedIn: https://it.linkedin.com/in/marcopozzan
Contact: http://www.marcopozzan.it
Consultant and trainer in business intelligence, analytics and data mining on Methode . Teacher for ITS courses of data warehouse at the University of Pordenone.
Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…
LinkedIn: http://www.linkedin.com/in/sgovoni
Contact: https://mvp.microsoft.com/it-it/PublicProfile/4029181?fullName=Sergio%20Govoni
Since 1999 Sergio Govoni has been a software developer; in 2000 he got a degree in Computer Science at "Università degli Studi" in Ferrara (Italy). He has worked for over 18 years in Centro Software, a software house that produces the best ERP for manufacturing companies that are export oriented. Now, he manages the development product team and he is constantly involved on several team projects, where he focues his attention on the architecture and the mission-critical technical details. Since 2016 he is the vice president of the UGISS (www.ugiss.org). For the provided help to technical communities and for sharing his own experience, since 2010 he has received the Microsoft Data Platform MVP award.
The following is a list of sponsors that helped fund the event.