SQLSaturday #566 - Parma 2016
Event Date: 11/26/2016 00:00:00
Event Location:
- Università degli Studi di Parma, Dipartimento di Ingegneria dell’Informazione
- Viale Usberti, 181
- Parma, Emilia-Romagna, 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: Troubleshooting delle prestazioni delle query con SQL Server 2016 Query Store
Abstract: Query Data Store è la nuova funzionalità di SQLServer 2016 che permette la storicizzazione nel tempo delle prestazioni delle query in termini di consumo delle risorse e dei relativi piani di esecuzione, oltre i riavvii della macchina. La sessione entra nel dettaglio di Query Store e mostra come questo meccanismo permetta di effettuare analisi sofisticate del comportamento delle query e delle loro prestazioni. Illustra come sia possibile correlare il cambiamento delle performances ed il consumo delle risorse a quello del piano di esecuzione oppure seguire nel tempo l’evoluzione di un piano di esecuzione in funzione di eventi quali cambio delle statistiche, modifiche dello schema o presenza di indici. Inoltre, analizzare le prestazioni di determinate porzioni del codice, individuare regressioni e identificare le query che hanno degradato nelle ultime esecuzioni tra tutte quelle eseguite. Più in generale, la sessione mostra come trarre il massimo vantaggio da questa funzionalità in un’
Speaker(s):
- Saverio Lorenzini
Track and Room: DBA - DBA
Title: Giving Permissions through Stored Procedures
Abstract: You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. But you may have noticed that this does not work when the SP uses dynamic SQL.
In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.
The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Speaker(s):
- Erland Sommarskog
Track and Room: DEV - DEV
Title: SQL Server Extended Events: monitoring tuning (IT)
Abstract: Extended Events è un sistema per la raccolta di eventi generati dai vari componenti di SQL Server a scopo diagnostico. Introdotto in SQL Server 2008 è stato inizialmente considerato da molti unicamente come futuro sostituto di SQL Trace con il pregio di avere un minore impatto sul sistema tracciato. In realtà Extended Events ha sempre offerto funzionalità uniche per la raccolta e la correlazione di alcuni eventi tramite un singolo strumento. In questa sessione vedremo come utilizzare al meglio questo sistema che con il tempo è diventato un componente sempre più importante dell’infrastruttura diagnostica anche per l’ottimizzazione delle prestazioni.
Speaker(s):
- Gianluca Hotz
Track and Room: DBA - DBA
Title: Upload data on Azure SQL Database with Azure Service Bus amp; Azure Logic Apps
Abstract: Sempre pi#249; spesso le infrastrutture applicative includono piattaforme dati in esecuzione sul cloud. Uno dei problemi con cui ci si scontra riguarda la modalit#224; di integrazione con queste nuove piattaforme. Questa sessione mostra alcune tecniche per trasferire dati da sistemi e applicazioni presenti nella propria farm verso il cloud. Vedremo come #232; possibile trasferire dati provenienti da database relazionali o flat file verso Azure SQL Database, utilizzando servizi come Azure Service Bus, Azure Stream Analytics e Azure Logic Apps.
Speaker(s):
- Salvatore Pellitteri
Track and Room: CLOUD/BI - Cloud/BI
Title: Continuous integration for BI
Abstract: Team Foundation Server (TFS) is a collaboration platform to manage the lifecycle of your BI Solution. In this session, we are going to focus on the interaction between SSDT, SSIS, TFS and automated testing.
I will demonstrative how to do develop, test and publish and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration of Databases and other BI elements between development and diffrent environments in a seamless manner upon successful build of the solution.
Testing will cover different aspects of SQL, SSAS and execution of SSIS packages for test-purposes to ensure simple setup of test-cases and both manual and automated execution.
Speaker(s):
- Bent Pedersen
Track and Room: CLOUD/BI - Cloud/BI
Title: Crate your own Data Pipeline with Spark on HDInsight
Abstract: HDInsight is a powerfull tool for the process of big amount of data such as web/application log, sensor data and many other scalable datasources. During this session we will handle:
- Create manually and programmatically an HDInsight Cluster
- Work on a python noteook for the creation of a prototype
- Create a simple Spark application that manage your logs
- Aggregate your data on SQL Azure
- Create a simple powerbi dashboard
At the end of the session you will be able to create data pipeline on the cloud.
Speaker(s):
- Roberto Grandi
Track and Room: DEV - DEV
Title: Common non-configured options on a Database Server
Abstract: Una soluzione database ha performance ottimali quando l’applicazione scala all’aumentare dei dati, e il database server #232; configurato (e dimensionato) correttamente. In questa sessione verranno esaminate alcune opzioni che se lasciate “by default” non permetteranno di ottenere le massime prestazioni dal vostro database server. Verranno trattate opzioni del sistema operativo, dell’istanza SQL Server fino ad arrivare alla configurazione del piano di manutenzione. Se pensate che il vostro database server sia configurato correttamente, non perdete questa sessione!
Speaker(s):
- Sergio Govoni
Track and Room: DBA - DBA
Title: T-SQL Error Handling - Perchè gestire gli errori è importante
Abstract: Perchè dovrei gestire gli errori nel codice T-SQL ? Cosa succede se in una transazione si verifica un errore ? La gestione degli errori è spesso sottovalutata nella scrittura del codice T-SQL e questo potrebbe porre i dati in serio pericolo. Tutto quello che c’è da sapere per scrivere codice T-SQL, e non solo, robusto ed affidabile.
Speaker(s):
- Luca Ferrari
Track and Room: DEV - DEV
Title: SQL Server 2016 Temporal Database Support - Focus on Retention and Performance
Abstract: Dopo alcuni mesi di utilizzo delle tabelle temporali potremmo trovarci con milioni di record nelle tabelle “storiche” che (forse) non ci serviranno poi così spesso oppure non ci serviranno mai. Dopo una adeguata introduzione rivolta a chi non avesse ancora approcciato questa nuova feature di SQL Server 2016 di procederà all’analisi delle tecniche per fare della adeguata manutenzione in scenari critici.
Speaker(s):
- Pasquale Ceglie
Track and Room: DEV - DEV
Title: SQL Server Infernals: Worst Practices in Action
Abstract: Let’s face it: Best Practices are too many to really know them all and choose which ones should be applied first. Does your telephone ring all the time? Do your users ask for that “quick report” that instead takes ages and keeps changing every time you think it’s done?
Have you ever thought that in dire times avoiding Worst Practices could be a good starting point and you can leave fine tuning for a better future? If the answer is “yes”, then this session is for you: we will discover together how not to torture a SQL Server instance and we will see how to avoid making choices that in the long run could turn out to be not as smart as they looked initially.
Speaker(s):
- Gianluca Sartori
Track and Room: DEV - DEV
Title: Cortana Intelligence Suite overview
Abstract: Che cos’è “Cortana Intelligence Suite”? Quali sono i servizi e le tecnologie che mette a disposizione? Perché e come ci può essere utile? Queste sono alcune delle domande a cui cercheremo di dare riposta in questa sessione che fornirà una overview dell’intera Suite di Microsoft. Si tratta di una sessione per “beginners” il cui obiettivo è quello di fornire una comprensione di base dell’architettura di Cortana Intelligence Suite e delle infinite potenzialità che essa ci mette a disposizione.
Speaker(s):
- Francesco De Chirico
Track and Room: CLOUD/BI - Cloud/BI
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
Speaker(s):
- Emanuele Zanchettin
Track and Room: DBA - DBA
Title: SQL Server tuning in pillole
Abstract: E’ capitato anche a voi di avere a che fare con l’ottimizzazione delle prestazioni di SQL Server ? Magari quella query che certi giorni va come una fucilata e altri lentissima ? In questa sessione, di taglio pratico, vedremo quali sono le metodologie di analisi e tuning delle query, attraverso piccoli esempi mirati (pillole, appunto), che forniscano, se non proprio una soluzione, almeno uno spunto di riflessione per migliorare l’uso di SQL Server ed ottimizzarne le performance.
Speaker(s):
- Danilo Dominici
Track and Room: DBA - DBA
Title: APPLY operator in action
Abstract: APPLY operator is a T-SQL table operator that allows to boost query perfomance and to solve complex calculation problems in an very efficient way. But it isn’t easy to understandt how does it work and how it can be applied to our queries. In this session, we will examine the various types of APPLY operator (CROSS APPLY, OUTER APPLY) to understand it’s behaviour and the power it holds. We will go through many real world cases to show how we can use the APPLY operator when writing queries instead of JOINs and we will show how performances can be improved by using this operator the right way.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: DEV - DEV
Title: Power BI: basic data modelling with DAX
Abstract: In this session will introduce you to the concept of basic data modeling with some practical examples that you will be able to reproduce on the hands-on-lab PC. This introduction covers basic calculations and an overview of all the scalar and table functions in DAX
Speaker(s):
- Marco Pozzan
Track and Room: CLOUD/BI - Cloud/BI
Title: State of Azure SQL Database
Abstract: Azure is an evolving Cloud as each service increase functionalities on a daily basis. Azure Sql Database, the SQL Server executed as Platform as a Service is one of the most important services and is not excluded from this evolution, also with new features that comes from SQL Server 2016. Let’s see how to use, manage, develop with SQL in the cloud.
Speaker(s):
- Marco Parenzan
Track and Room: CLOUD/BI - Cloud/BI
Title: Configurare Always On Availability Group in Azure
Abstract: Azure offre due differenti modelli di deployment per creare e gestire risorse: Resource Manager e “classic”. In entrambe le modalità è possibile e conveniente allestire un ambiente Always On Availability group. SQL Server 2016 trova in Azure un contesto di elevata efficienza e relativa semplicità. In questa sessione si introducono le novità relative ad Always On e si illustrano alcuni tra i possibili metodi per l’implementazione della farm di server adibiti alla replica Always On dei nostri database.
Speaker(s):
- Gilberto Zampatti
Track and Room: DBA - DBA
Title: Using R in the Azure ML platform
Abstract: Azure ML, Microsoft’s machine learning service in the cloud, enables you to easily build, deploy and share advanced analytics solutions. Azure ML provides many machine learning algorithms and data preparation tasks. In addition, Azure Machine Learning supports R. You can bring in your existing R codes in to Azure Machine Learning and run it in the same experiment with the built-in learners and publish this as web service. R code can be used to prepare and manipulate the data, to train machine learning models and to make predictions on new data. This session shows how to use R in order to maximize the benefits of Azure ML.
Speaker(s):
- Alessandro Rezzani
Track and Room: CLOUD/BI - Cloud/BI
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Alessandro Rezzani
Twitter: - @alerezzani
LinkedIn: Alessandro Rezzani
Contact: http://www.dataskills.it/blog
I#39;m a senior Business Intelligence consultant and I#39;m specialized in data mining and big data applications. Since 2004, I’ve designed and developed Business Intelligence and Data Mining solutions based mainly on the Microsoft platform. The main activities I’m involved in are:
- Data Mining amp; Machine Learning projects.
- Data warehouse, OLAP cubes, ETL design and implementation
- Training on BI amp; Data minign topics
- Lecturing at Univesit#224; Bocconi
- Writing Books
Francesco De Chirico
Twitter: - http://twitter.com/fdechirico
LinkedIn: Francesco De Chirico
Contact: http://francescodechirico.wordpress.com/
Francesco De Chirico is a consultant, trainer and speaker specialized in modeling and developing complex BI solutions with the Microsoft BI stack. He has been working with SSAS since 2001 and has a strong knowledge of the MDX, DAX and M. He focused on all the Microsoft Data Platform especially on Power BI. Co-leader of the PASS Global Italian Virtual Group and Milan Power BI User Group, regular speaker at events like PASS SQLSaturday, Microsoft Certified Trainer for many years, Francesco holds several Microsoft certifications including the prestigious SSAS Maestro for BI certification (2012) and the Microsoft Professional Program Data Science certification (2017). He is the project creator of the Analysis Services Query Analyzer tool.
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.
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.
Salvatore Pellitteri
Twitter: - @pellittsa
LinkedIn: Salvatore Pellitteri
Contact: https://pellitterisbiztalkblog.wordpress.com
Salvatore Pellitteri lives in Italy. He is Developer Team Manager in Microsys Srl. He works on integration application projects using Microsoft Integration stack and on data platform projects using SQL Server. Salvatore works with BizTalk Server and Azure Integration technologies since the first version and has worked in many big integration project with several Italian enterprise organizations using many technologies like SAP, Oracle, SQL Server, Salesforce, Microsoft Dynamics 365/CRM/AX/NAV, AS400, J.D. Edwards, EDI and HL7.
He is Microsoft P-Seller for Data Platform and Microsoft Most Valuable Professional (MVP) for Microsoft Application Integration / Azure for three years.
Andrea Martorana Tusa
Twitter: - bruco441
Andrea Martorana Tusa is a Business Intelligence Team Manager at Würth Phoenix, the IT and consulting company of the Würth-Group. He is awarded as MVP in the Data Platform category
Former BI Specialist at Widex, a Danish manufacturing company, and BI Developer in the IT department of an Italian banking group. 20+ years of experience working with data. He is focused on the entire BI stack: database development, data warehousing, data analysis, reporting, etc. Andrea is a usual speaker at many events: SQLSaturdays, conferences in Europe and PASS Summit, and for PASS Virtual Groups.
Andrea is an author for sqlshack.com, sqlservercentral.com, and UGISS (User Group Italiano SQL Server).
Gianluca Hotz
Twitter: - glhotz
LinkedIn: Gianluca Hotz
Contact: http://www.ghotz.com
Gianluca Hotz is an independent consultant, trainer, speaker and Mentor specialized in architecture, database design, high availability, capacity planning, performance tuning, system integration and migrations for Microsoft SQL Server. He has been working as a consultant in the IT field since 1993 and with SQL Server since 1996. He is among the original founders of ugiss.org, where he served as vice-president from 2001 to 2016 and he is now serving as president, for his contribution to the community he has been a SQL Server MVP since 1998.
Bent Pedersen
Twitter: - https://twitter.com/SQLBent
LinkedIn: Bent Pedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
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…
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.
Emanuele Zanchettin
Twitter: - @thinkIT
LinkedIn: Emanuele Zanchettin
Emanuele Zanchettin, after studying in Computer Engineering, began his career with DB2 in the banking sector in 1998. After a few years and a change of scope of application, he encountered Access and Oracle with which he subsequently worked for several years in data access tuning and database design for new application features. Since 2007 he has also launched into the SQLServer world 2K, 2005, 2008* and 201* and more importantly, since 2011, into Azure SQL Database (SQL Azure). In order to have a greater capacity for assessment and familiarity with the various technologies that the market offers, he has deepened his knowledge to include MySQL and DocumentDB. Today Emanuele is mainly involved in IT projects and database management.
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.
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.
Pasquale Ceglie
Twitter: - @pceglie
LinkedIn: Pasquale Ceglie
MCSE - Data Management and Analytics
Erland Sommarskog
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
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.
Roberto Grandi
Twitter: - @grandirob
LinkedIn: Roberto Grandi
I am an enthusiast about MS technlologies. I started working on SQL Server 2000 and now I am working on the latest version of Azure HDInsight. I love my work and I like to share what I have discovered and learned.
Danilo Dominici
Twitter: - @danilo_dominici
Danilo Dominici, lavora con SQL Server sin dalla versione 6.5. Si occupa principalmente di progettazione, implementazione ed ottimizzazione architetturale, monitoring e performance tuning. Alterna le attivit#224; di consulenza a quelle di formatore, speaker ed autore. Microsoft Certified Trainer dal 2000 e SQL Server MVP dal 2014, #232; anche co-leader del PASS Global Italian Virtual Chapter, lo user group quot;virtualequot; in lingua italiana dedicato a SQL Server.
Sponsors
The following is a list of sponsors that helped fund the event: