SQLSaturday #400 - Torino 2015
Event Date: 05/23/2015 00:00:00
Event Location:
- TOOLBOX COWORKING
- Via Agostino da Montefeltro 2
- Torino, 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: Entity Framework 7, Back To The Future!
Abstract: Entity Framework #232; la tecnologia open-source di accesso ai dati consigliata e coordinata da Microsoft. Entity Framework 7 (EF7) a differenza della versione precedente, non si limita all’accesso a data store relazionali quali sql server, ma allarga i propri orizzonti verso store non-relazionali come Azure Table Storage e Redis. EF7 non solo abbatte la barriera Sql/NoSql, ma grazie alla completa riscrittura del codice, #232; molto pi#249; leggero, capace di soddisfare l’attuale richiesta cross-platform. L’obiettivo finale di EF7 #232; di essere universale: Windows Phone, Windows Store, ASP.NET 5, Mac, Linux e Xamarin (iOS, Android). In questa sessione vi proporr#242; una serie di demo che vi daranno un assaggio delle potenzialit#224; di EF7, in particolare vedremo: EF7 per Phone/Store/WinForms, miglioramenti generazione SQL, testing con InMemory, shadow state e Azure Table Storage, in un’unica sessione in stile back to the future, per chi si sente di dovere ritornare al futuro :)
Speaker(s):
- Michael Denny
Track and Room: BI\OPT - Blue
Title: AzureML - Creating and Using Machine Learning Solutions (IT)
Abstract: Si #232; tornato a parlare molto di Machine Learning negli ultimi anni. Grazie anche al fatto che #232; possibile oggi processare enormi moli di dati in tempi (relativamente) veloci questa parte dell’informatica sta vivendo una seconda giovinezza. In questa sessione vedremo cos’#232; il machine learning, quali sono le diverse casistiche tecniche e funzionali in cui pu#242; essere usato ed inizieremo a “giocare” con i dati per vedere fin dove possiamo spingerci, usando strumenti On-Premise e quindi spostandoci poi sull’offerta Azure Machine Learning dove, una volta fatta propria la teoria, si possono realizzare soluzioni estremamente complesso in modo molto visuale e sfruttare la scalabilit#224; di Azure per avere performance ottimali. Il tutto senza dimenticare che gli algoritmi cos#236; ottenuti possono essere facilmente integrati nelle nostre applicazioni semplicemente invocando un web service.
Speaker(s):
- Davide Mauri
Track and Room: BI\OPT - Blue
Title: Tabular vs. Multidimensional in SQL Server Analysis Services
Abstract: Since 2012, SQL Server Analysis Services has two engines: Tabular and Multidimensional. Somebody believes Multidimensional is granny stuff and aim to learn only Tabular. Somebody trust only the good-old well-debugged code of Multidimensional, and ignores Tabular. We try to use a more informed approach: by looking at the difference in features, hardware requirements, scalability, required knowledge and business needs, we will discuss which engine to use for which kind of project. The goal is to teach when to use what, and to avoid the common mistakes of choosing the wrong technology, which might be a very expensive error.
Speaker(s):
- Alberto Ferrari
Track and Room: BI\OPT - Blue
Title: SQL Server AlwaysOn
Abstract: Business continuity is becoming more and more a central topic for many companies. AlwaysOn Failover Cluster Instances and Availability Groups are two functionality for high availability and disaster recovery available in SQL Server. With the help of live demos, in this session we will cover in details this technologies that extends on the familiar concepts of database mirroring and failover clustering. We will also introduce some other engine enhancements that will help raising the overall service availability and we will cover enhancements introduced with SQL Server 2014.
Speaker(s):
- Gianluca Hotz
Track and Room: DBA\DEV - Red
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: DBA\DEV - Red
Title: SSDT Database Projects Deep Dives (IT)
Abstract: Nonostante i vecchi progetti database su Visual Studio for Database Professionals (“Data Dude”) Product si siano evoluti a progetti database su SQL Server Data Tools (SSDT), molti continuano a preferire l’utilizzo del Management Studio (SSMS). Questa sessione vuole mettere in evidenza quali sono i vantaggi che i Data Tools introducono nella vita quotidiana dello sviluppatore di database, mostrando anche come affrontare le casistiche pi#249; complesse.
Speaker(s):
- Luca Zavarella
Track and Room: DBA\DEV - Red
Title: Power BI Architecture
Abstract: Power BI is a cloud service that lets you share, collaborate and access your Excel reports anywhere on any device. In this session, you will learn how to create data models, display visualizations, and synchronize cloud data with on premises data sources. In order to use these new features, you will continue to leverage existing skillsets, such as Tabular, Power Pivot, DAX, and you will be able to connect to database and semantic models you already built, such as existing databases in Analysis Services Multidimensional and Tabular. The goal is to create dashboards leveraging data and models that you have both on cloud and on premises.
Speaker(s):
- Marco Russo
Track and Room: BI\OPT - Blue
Title: Analisi prestazionale (Performance Tuning) in Microsoft SQL Serve
Abstract: Microsoft SQL Server 2005 introdusse per la prima volta nella piattaforma questi oggetti che consentono di esporre metadati che riguardano connessioni, sessioni, transazioni, istruzioni, processi. E’ un mondo in costante evoluzione (86 oggetti in SQL 2005, 136 in SQL 2008…200 in SQL 2014) che apre prospettive di tuning sempre pi#249; evolute. Questa sessione illustra come utilizzare alcune (poche) fra le Dynamic Management Views (DMVs) e Dynamic Management Functions (DMFs) per estrarre metriche essenziali alla misurazione delle prestazioni complessive della nostra istanza.
Speaker(s):
- Gilberto Zampatti
Track and Room: DBA\DEV - Red
Title: Geocoding with SQL Server, Bing and Google Maps API
Abstract: Geocoding is the process of converting addresses into geographic coordinates (latitude and longitude). Geographic coordinates can then be converted into SQL Server spatial data type and stored in a database. In this session we will learn:
- how to retrieve coordinates from an address, using Google Maps API and Bing API;
- how to get a free license from API services;
- how to automate the process and convert coordinates into a geography data type using SQL Server Integration Services;
- how to store the data into a database.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: BI\OPT - Blue
Title: SSRS Reports HCI - How to build the perfect dashboard
Abstract: Reporting Services #232; uno strumento dalle grandi potenzialit#224;, flessibile, dinamico, e se sfruttato al meglio #232; in grado di creare delle vere e proprie opere d’arte partendo da dei semplici dati. La dashboard sono oggigiorno uno strumento fondamentale per il management perch#233; forniscono una chiara lettura dei principali KPI aziendali.
La sessione illustrer#224; come costruire delle dashboard utilizzando Reporting Services e dando particolare importanza a tutti quei principi alla base della HCI (Human Computer Interaction) in modo da costruire dei report intuitivi, accessibili ma prima di tutto usabili!
Speaker(s):
- Nicola Pressi
Track and Room: BI\OPT - Blue
Title: Build a SQL Server Machine - the right way
Abstract: Ok, dobbiamo installare un nuovo SQL Server in azienda. Magari anche virtuale. Abbiamo lanciato e completato il setup. E ora ? Quali sono i parametri di configurazione di default che dobbiamo assolutamente rivedere prima di mettere in produzione il nostro nuovo SQL Server ? Quali sono i principali accorgimenti che ogni DBA dovrebbe conoscere per utilizzare al massimo il proprio SQL Server ? In questa sessione vedremo quali sono questi accorgimenti, i principali parametri di configurazione da modificare, i principali tools per la manutenzione ed il tuning dei databases.
Speaker(s):
- Danilo Dominici
Track and Room: DBA\DEV - Red
Title: Execution Plans in SQL Server and SQL Azure (IT)
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, quali le modalit#224; di accesso, ecc… In questa sessione impareremo a leggere i piani di esecuzione per trarre informazioni che ci permettano di scrivere query pi#249; efficienti; vedremo infine come consultare i piani di esecuzione delle query eseguite in un’istanza SQL Azure.
Speaker(s):
- Sergio Govoni
Track and Room: DBA\DEV - Red
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Alberto Ferrari
Twitter: - @FerrariAlberto
Contact: http://www.sqlbi.com
Alberto Ferrari started working with SQL Server in 2000 and immediately focused his interest on Business Intelligence. He and Marco Russo created sqlbi.com, where they publish extensive content about Business Intelligence. Alberto published several books about Analysis Services, Power BI, and Power Pivot. He is a Microsoft MVP and he earned the SSAS Maestro title, the highest level of certification on Microsoft Analysis Services technology.
Today, Alberto’s main activities are in the delivery of DAX and data modeling workshops for Power BI and Analysis Services all around the world. Alberto offers consulting services on large and complex data warehouses to provide assessments and validation of project analysis or to perform specific problem-solving activities.
Alberto is a well-known speaker at many international conferences, like PASS Summit, SQLBits, and Microsoft Ignite. He loves to be on stage both at large events and at smaller user groups meetings, exchanging ideas with other SQL and BI fans. When traveling for work, he likes to engage with local user groups to provide evening sessions about his favorite topics. Thus, you can easily meet Alberto by looking up local Power BI user groups during scheduled courses. Outside of SQLBI, most of Alberto’s personal time is spent practicing video games, in the vain hope of eventually beating his son.
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.
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…
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
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.
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.
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.
Luca Zavarella
Twitter: - @lucazav
LinkedIn: Luca Zavarella
Contact: http://www.ugiss.org/lucazav
Luca #232; un Business Intelligence Architect amp; Project Leader e Database Architect. Ha conseguito le certificazioni Microsoft SQL Server 2008 MCTS e MCITP in Business Intelligence. E#39; inoltre un Business Analyst con particolare attitudine all#39;automazione e ottimizzazione dei flussi di dati. Nel tempo libero #232; un pianista classico.
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!
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.
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.
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).
Sponsors
The following is a list of sponsors that helped fund the event: