SQLSaturday #462 - Parma 2015
Event Date: 11/28/2015 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: SQL Server 2016: Maturazione dell’In-Memory OLTP
Abstract: In-Memory OLTP #232; una tecnologia che ha subito in questa nuova versione significativi miglioramenti, tesi soprattutto a garantire la scalabilit#224; su databases di maggiori dimensioni e un throughput pi#249; elevato, al fine di supportare carichi di lavoro sempre pi#249; elevati. Sono stati inoltre eliminati vincoli e limitazioni relative a tabelle e stored procedures per rendere pi#249; agevole la migrazione 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(s):
- Gilberto Zampatti
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Title: Many to Many in SSAS Multidimensional: How To Implement It
Abstract: Do you have many to many relationship between your dimensions? For example, a person having many accounts at the same bank and accounts being held by more than one person? Or do you have one to many, a patient having mutliple diagnosis? How do you analyze this data? Many to many in SSAS can help you.
In this session, you will learn step by step on how to implement many to many in SSAS. In addition, you will learn the benefits of using many to many, by looking at the real life example of the implementation with healthcare data.
After this session, you will have better understanding of many to many in SSAS, plus you will be able to solve some of common business problems that arise daily.
Speaker(s):
- Elvis Talic
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: Azure Machine Learning: From Design to Integration
Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.
This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.
Speaker(s):
- Peter Myers
Track and Room: Cloud Dev - Room 6 Cloud Dev
Title: Choosing the right Mobile BI tool: SSRS vs Power BI vs Datazen
Abstract: Two almost contemporary events have recently marked the Microsoft’s BI offer: the release of Power BI under GA license and the acquisition of Datazen. Join these new products with the long-lasting Reporting Services (SSRS), 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? 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 it can be done Mobile BI with Reporting Services, even tough it isn’t a immediate feature, as is for 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(s):
- Andrea Martorana Tusa
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: Choosing the right Mobile BI tool (seconda parte)
Abstract: Two almost contemporary events have recently marked the Microsoft’s BI offer: the release of Power BI under GA license and the acquisition of Datazen. Join these new products with the long-lasting Reporting Services (SSRS), 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? 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 it can be done Mobile BI with Reporting Services, even tough it isn’t a immediate feature, as is for 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(s):
- Andrea Martorana Tusa
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: SSRS - Charts like you’ve never seen before
Abstract: Reporting Services offre la possibilit#224; di illustrare dati in maniera visuale attraverso pi#249; di 50 grafici, che coprono la maggior parte dei Business Requirements di uno sviluppatore. Tuttavia, la richiesta di report sempre pi#249; intuitivi e graficamente innovativi ha creato l’esigenza di reportistiche pi#249; strutturate con grafici sempre pi#249; particolari .
In questa sessione verranno presentate prima delle linee guida generali per creare dei grafici classici pi#249; accattivanti e in linea con le nuove dinamiche del mercato BI; in secondo luogo verranno realizzati dei veri e propri grafici non nativi ma rimanendo sempre all’interno di Reporting Services.
Speaker(s):
- Nicola Pressi
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: SQL Server 2016 Query Store: un nuovo modo di ottimizzare 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 di ogni singola esecuzione delle query, permettendone l’analisi a posteriori. Questo meccanismo permette di effettuare analisi sofisticate delle query e delle loro prestazioni. E’ 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 nelle ultime esecuzioni. E possibile inoltre seguire nel tempo l’evoluzione di un piano di esecuzione 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.
Speaker(s):
- Saverio Lorenzini
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Title: Datazen - On-premise mobile bi
Abstract: Introducing Microsofts Onpremise Mobile BI solution, Datazen, a leader in mobile business intelligence and data visualization on Windows, iOS and Android devices serving for the on-premise mobile BI. Furthermore i will go through the latest release and present new functionality.
I want to show you how simply and easy it is to gets started and display insights that you can use to improve your business. This session will contain a demo of the UI, creation of dashboards, KPIs and a walk-through of the current architecture and security of the software.
Speaker(s):
- Bent Pedersen
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: Power Query
Abstract: Microsoft Power Query for Excel is a new set of experiences to empower business analysts and end users to discover, acquire, and transform data of any shape and size.
Speaker(s):
- Marco Pozzan
Track and Room: Analytics Reporting - Room 7 - Analytics Reporting
Title: Stream Analytics on premise and on the Cloud with SQL
Abstract: 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 two solutions, one on premise with SQL Server (Stream Insight), one on the Cloud with Azure (Stream Analytics). Let’s see how they work.
Speaker(s):
- Marco Parenzan
Track and Room: Cloud Dev - Room 6 Cloud Dev
Title: SQL Server 2016 JSON support
Abstract: SQL Server 2016 porter#224; tantissime novit#224;, tra cui, per quanto riguarda la programmabilit#224;, il supporto al formato JSON. vedremo com’#232; possibile serializzare i risultati delle nostre query tramite la clausola FOR JSON, inclusa negli ultimi rilasci della piattaforma.
Speaker(s):
- Alessandro Alpi
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Title: Power BI for the Developer
Abstract: In this session you will learn how Microsoft Power BI can deliver data insights with Software as a Service (SaaS), and specifically what can be achieved by the developer. You will learn that the new generation of Power BI enables developers to configure real-time dashboard scenarios.
Demonstrations will illustrate how to configure real-time dashboards by pushing data directly to Power BI by using the Power BI REST API, and also by processing data and events by using Azure Stream Analytics.
This session will be of interest to architects, developers and IT implementers looking to understand and evaluate the Power BI capabilities.
Speaker(s):
- Peter Myers
Track and Room: Cloud Dev - Room 6 Cloud Dev
Title: Sql server 2016 What’s new ?
Abstract: SQL Server 2016 delivers breakthrough mission critical performance, deeper insights across any data on many devices and enables the power of hyperscale cloud to unlock new hybrid scenarios. A quick look to Queries Store, enhanced security, temporal database and many more….
Speaker(s):
- Luca Ferrari
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Title: Implementing and Maintaining an Azure SQL Database project
Abstract: This is an evergreen session, it follows Azure SQL Database evolution and each time is different: it looks at how to implement, maintain and evolve/update solutions developed on Azure SQL Database, through the use of the tools like SQL Sever Management Studio and Visual Studio. Through examples and case studies, will be presented the versatility, power and reliability of the database as a service in the cloud.
Speaker(s):
- Emanuele Zanchettin
Track and Room: Cloud Dev - Room 6 Cloud Dev
Title: Entity Framework e SQL Server - Better Together
Abstract: L’utilizzo di un Object-Relational Mapper nelle applicazioni non #232; sempre ben visto dai DBA, per il fatto che il codice SQL generato dal framework, insieme agli altri “automatismi”, non sempre incontrano i loro favori. In questa sessione parleremo di quali accorgimenti prendere per far s#236; che il nostro O/RM vada d’accordo con il nostro DBA, ma soprattutto con il nostro Database.
Speaker(s):
- Alberto Dallagiacoma
Track and Room: Cloud Dev - Room 6 Cloud Dev
Title: DocumentDB Jumpstart, NoSQL adventures in Azure
Abstract: What is NoSQL? What is DocumentDB? How could this technology change the way we manage data? We’ll discover together how DocumentDB works, how we could use this new exciting product and which are its pros and cons compared to relational databases as SQL server. This session covers how configure a new DocumentDB instance in Azure, how to save and query data and the basic guidelines about organizing complex data as JSON documents.
Speaker(s):
- Marco De Nittis
Track and Room: Cloud Dev - Room 6 Cloud Dev
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 815 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.
Speaker(s):
- Sergio Govoni
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Title: SQL Server 2016 Temporal tables: Viaggiare nel tempo con SQL Server
Abstract: Una delle nuove (tante) funzionalit#224; di SQL Server 2016 #232; il supporto integrato per tabelle di dati temporali. Con una tabella temporale pu#242; essere reperito il valore di ciascun record in qualsiasi momento nel tempo. Questo pu#242; essere utile per “viaggiare nel tempo”, per fare audit, recuperare il vecchio valore di un campo in seguito a una modifica accidentale.
Speaker(s):
- Pasquale Ceglie
Track and Room: SQL Server 2016 - Room 8 - SQL Server 2016
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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).
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.
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.
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.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Gilberto Zampatti
Once upon a time a well skilled and valuable IT pro took care of me and elected himself as my mentor. I bumped into RDBMS when they were just prototypes and… when SQL Server appeared on the market I knew my trek. I#39;m still walking on it, glad to tell the people what I#39;m learning throughout my journey .
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
Elvis Talic
LinkedIn: Elvis Talic
Senior business intelligence professional demonstrating a distinctive combination of technical breadth, business acumen, critical analysis and communication skills, along with extensive experience in the full life cycle of business intelligence developments. Enjoys building relationships with stakeholders, understanding business issues, gathering and analyzing requirements, modeling data flows and conformed dimensions, inventing and specifying creative solutions.
Marco De Nittis
Twitter: - @mdnmdn
LinkedIn: Marco De Nittis
Marco De Nittis is a freelance passionate about web, data oriented and distributed technologies, mainly focused on Microsoft platform in particular with .NET, SQL Server and Sharepoint. He works as consultant, architect and trainer.
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.
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
Alberto Dallagiacoma
Twitter: - albertodall
LinkedIn: Alberto Dallagiacoma
Contact: http://blogs.ugidotnet.org/alby
I started programming when I was 12. I began on C64, then Amiga, MASM 8086, Pascal and C/C++. I#39;ve been using the .NET Framework since his first release, and I#39;m interested about all his ecosystem (WPF, WCF, XAML, Windows Phone, TFS, Azure). I also work on SQL Server, Active Directory and Exchange Server. In my spare time I like playing electric guitar.
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.
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.
Nicola Pressi
Nicola Pressi lavora da 3 anni per Berner SPA come sviluppatore SQL e .NET, dove ha maturato una discreta conoscenza in tutto lo stack della suite Microsoft focalizzandosi sulla modernizzazione dell#39;infrastruttura informatica aziendale. Proponendo e realizzando report all#39;avanguardia e dashboard intuitive ha permesso al management di accedere facilmente ad informazioni vitali per il core business.
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).
Pasquale Ceglie
Twitter: - @pceglie
LinkedIn: Pasquale Ceglie
MCSE - Data Management and Analytics
Sponsors
The following is a list of sponsors that helped fund the event: