SQLSaturday #355 - Parma, Italy 2014
Event Date: 11/22/2014 00:00:00
Event Location:
- Viale G.P. Usberti c/o Campus Università degli Studi di Parma
- Parco Area delle Scienze, 181/a
- Parma, Italy
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server: miti da sfatare
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
Track and Room: Track OPERATIONAL - N/A
Title: Entity Framework 6 for developers, Code-First!
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
Track and Room: Track DEV - N/A
Title: Power Query in Modern Corporate BI
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
Track and Room: Track BI - N/A
Title: Execution Plans in SQL Server e SQL Azure
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
Track and Room: Track OPERATIONAL - N/A
Title: Ottimizzare le query SQL: tecniche di analisi del codice eseguito in memoria cache.
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
Track and Room: Track OPERATIONAL - N/A
Title: Identity Mapping and De-Duplicating
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
Track and Room: Track DEV - N/A
Title: SQl Server 2012 Parallel Datawarehouse
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
Track and Room: Track BI - N/A
Title: Columnstore indexes, concepts and evolution
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
Track and Room: Track BI - N/A
Title: Database under source control
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
Track and Room: Track DEV - N/A
Title: Analyzing Text with SQL Server 2014
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
Track and Room: Track DEV - N/A
Title: Modern Hybrid BI Solutions: Azure, Big Data Power BI
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
Track and Room: Track BI - N/A
Title: Xvelocity in deep
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
Track and Room: Track BI - N/A
Title: Virtualize SQL Server
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
Track and Room: Track OPERATIONAL - N/A
Title: Database unit testing
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
Track and Room: Track DEV - N/A
Title: Extending the Data Collector to Monitor SQL Server effortlessly
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
Track and Room: Track OPERATIONAL - N/A
Title: Sql Server 2014 In-Memory Oltp Database
Abstract: How does it works ? Why is so fast ? How can I use it ?
Speaker(s):
- Luca Ferrari
Track and Room: Track DEV - N/A
Title: Azure Overview for SQL Server Developers
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
Track and Room: Track OPERATIONAL - N/A
Title: BI Markup Language - BI to the next level (IT)
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
Track and Room: Track BI - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Marco Russo
Twitter: - marcorus
LinkedIn: Marco Russo
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.
Alessandro Alpi
Twitter: - https://twitter.com/suxstellino
LinkedIn: Alessandro Alpi
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
Davide Mauri
Twitter: - mauridb
LinkedIn: Davide Mauri
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!
Luca Ferrari
LinkedIn: Luca Ferrari
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.
Dejan Sarka
Twitter: - DejanSarka
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.
Andrea Caldarone
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
Dejan Sarka
Twitter: - DejanSarka
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.
Davide Mauri
Twitter: - mauridb
LinkedIn: Davide Mauri
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!
Luca Ferrari
LinkedIn: Luca Ferrari
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.
Saverio Lorenzini
Twitter: - sqlSavelor
LinkedIn: Saverio Lorenzini
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.
Michael Denny
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.
andrea benedetti
Twitter: - @anbenedetti
LinkedIn: andrea benedetti
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.
Marco Parenzan
Twitter: - @marco_parenzan
LinkedIn: Marco Parenzan
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.
Alessandro Alpi
Twitter: - https://twitter.com/suxstellino
LinkedIn: Alessandro Alpi
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
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
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.
Marco Pozzan
Twitter: - @marcopozzan
LinkedIn: Marco Pozzan
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.
Gilberto Zampatti
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…
Sergio Govoni
Twitter: - @segovoni
LinkedIn: Sergio Govoni
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.
Sponsors
The following is a list of sponsors that helped fund the event: