SQLSaturday #495 - Pordenone 2016

Event Date: 02/27/2016 00:00:00

Event Location:

  • Consorzio Universitario di Pordenone
  • Via Prasecco, 3/a
  • Pordenone, Friuli, Italy

PDF of Schedule

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: Enterprise Information Management with SQL Server 2016

Abstract: Companies want to gather information from the data; therefore, they start BI projects. They design a data warehouse and then start developing extract – transform – load (ETL) applications. However, most of BI projects have to deal with problems with data quality (DQ). Data quality can be a huge obstacle for a successful BI project. Of course, line of business applications suffer from poor data quality as well. Every company has part of the data which is used everywhere, in every transaction, like customers data, products data and similar. Such data is called master data. People who manage master data are often called data stewards. Processes and activities for maintaining master data are known as master data management (MDM). In this presentation, we are going to discuss ETL, DQ and MDM problems and introduce how Microsoft SQL Server 2016 tools can help you with solutions.

Speaker(s):

  • Dejan Sarka

Track and Room: Cloud Developers - Room S7


Title: Realizzare una vera Continuous Integration con SQL Server

Abstract: Dopo aver messo i nostri database sotto Source Control e dopo aver scritto i nostri Unit Testing, andiamo a completare il processo di Continuous Integration automatizzando il processo di build. In questo modo avremo realizzato una vera ed automatizzata integrazione continua. In questa sessione andremo a mostrare come creare i trigger di automazione delle build dei nostri database (construzioni di database sandbox, separati dallo sviluppo) e come, di conseguenza, eseguire i test dopo una semplice operazione di checkin di un changeset. Affronteremo la problematica utilizzando TFS (o Visual Studio Online) e SQL Server + tSQLt

Speaker(s):

  • Alessandro Alpi

Track and Room: Cloud Developers - Room S7


Title: Using SQL Server 2016 and R Integration

Abstract: With SQL Server 2016 (CTP 3 release) R Language for statistical programming is now supported with native T-SQL. With this extension we can now integrate powerful R Language with transactional data directly using SSMS.

In this session we will go through: 1) Installation needed (R and RRO by Revolution Analytics (now Microsoft) 2) Exploring the usage of RRO Engine (multi-threated usage and parallel multi-core usage of CPU,…) 3) Using T-SQL for Data analysis with importing and exporting data to SQL Tables 4) Demos with using Predictions on datasets and exploring usability of Reporting services (SSRS) and Power BI (integration with R now possible).

Session is useful for BI analysts as well as for DEV and DBA as we can easily make server monitoring and use of predictions for server monitoring (predicting when disk will be full and any other extended events).

Speaker(s):

  • Tomaž Kaštrun

Track and Room: Analytics and Reporting - Room S6


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 mugrazione 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 S1


Title: Microsoft Azure Machine Learning Algorithms

Abstract: Focus of this session will be explanation of algorithms available for predictive analytics in Azure Machine Learning service. Algorithms will be grouped by learning style (Supervised, semi-supervised and unsupervised) and will take a look into 1) regression algorithms, 2) Regularization algorithms, 3) Decision trees algorithms, 4) Naive Bayes algorithms, 5) Dimension reduction algorithms, 6) Associated learning (not Kernel) Algorithms and 7) Clustering algorithms. With theory explained we will look into data samples and later examples in ML for these algorithms. Within this session we will explore, which algorithm is used and useful for what kind of empirical problem and which is suitable for particular data-set.

Speaker(s):

  • Tomaž Kaštrun

Track and Room: Analytics and Reporting - Room S6


Title: SQL Server 2016: Nuove funzionalit#224; in SQL Server Integration Services

Abstract: SQL Server Integration Services (SSIS) introduce nnuove capacit#224;, come ad esempio la ppossibilit#224; di aggiunggere il catalogo SSISDB ad un AlwaysOn Availability Group; Incremental Package Deployment (Deploytment incrementale dei packages) consente di effettuare il deployment di uno o pi#249; packages in un progetto nuovo o preesistente senza dover effettuare il deployment dell’intero progetto; Effettuando l’upgrade dei progetti SSIS dalle versioni precedenti i connection manager a livello di progetto continueranno a funzionare e saranno conservati i layout e le annotazioni dei packages. In questa sessione potremo approfondire i vari aspetti di queste ed altre novit#224; di SSIS e valutare nuovi benefici ed opportunit#224;.

Speaker(s):

  • Gilberto Zampatti

Track and Room: Analytics and Reporting - Room S6


Title: Choosing the right mobile BI tool: SSRS vs Power BI vs Datazen

Abstract: In 2015 Microsoft carried out the release of Power BI and the acquisition of Datazen. During 2016 many changes are expected mostly regarding Reporting Services as a tool for contents repository and delivery. This 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? What changes are expected in the next future? 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 to develop and deliver mobile BI reports with Reporting Services, 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 and Reporting - Room S6


Title: Azure SQL Database (IT)

Abstract: SQL Server in una Virtual Machine #232; la classica soluzione IaaS nel Cloud, si tratta di un’ottima soluzione che ha il pregio della familiarit#224; e si presta bene a scenari di integrazione ibridi tra Cloud e On-Premise. Tuttavia, non riduce significativamente i costi di gestione ordinaria e le complessit#224; legate ai temi di scalabilit#224;, alta disponibilit#224; e disaster recovery. Azure SQL Database #232; la soluzione PaaS/SaaS che offre un servizio di database relazionale con una copertura funzionale ormai praticamente identica a quella del Database Engine di un SQL Server tradizionale con una riduzione dei costi di implementazione e manutenzione e il beneficio di nuove funzionalit#224; tipicamente introdotte in anticipo rispetto alle versioni On-Premise. Questa sessione #232; diretta sia agli sviluppatori che agli amministratori di database interessati ad approfondirne le funzionalit#224;, gli scenari implementativi e le differenze con offerte simili quali Amazon RDS.

Speaker(s):

  • Gianluca Hotz

Track and Room: Cloud Developers - Room S7


Title: New Security Features in SQL Server 2016

Abstract: In this session we will explore the new features introduced with SQL Server 2016 to enhance security. Always Encrypted is a new technology that protects your data not only at rest, but also throughout the whole interaction between the application and the database. Dynamic Data Masking is another interesting feature that allows us to protect sensitive data by masking it to all users that don’t have enough privileges to see the actual contents. Row Level Security allows showing to end users only the data they’re entitled to access, without changing the applications’ code. We will demonstrate the use of these three features with example applications and we will explore the use cases where these technologies represent a big leap from previous custom implementations.

Speaker(s):

  • Gianluca Sartori

Track and Room: SQL Server 2016 - Room S1


Title: New life for Reporting Services: what’up in 2016

Abstract: During 2015 PASS Summit, Microsoft announced a roadmap to harmonize and standardize its BI reporting solutions into one unique hybrid scenario. Reporting Services will play a crucial role in this new architecture. Starting from 2016 release, Reporting Services will be the Microsoft’s on-premises solution for BI report delivery, meaning that it will host on-premises standard report as well as mobile report as well as Power BI Desktop report. To achieve this goal Reporting Services has been completely revisited and redesigned.

Come to this session to have a preview of the new features developed for Reporting Service with the advent of SQL Server 2016. Your BI reporting strategy for the future could be completely revisited as you learn how many amazing changes are expected in the next future.

Speaker(s):

  • Andrea Martorana Tusa

Track and Room: Analytics and Reporting - Room S6


Title: SQL Server 2016 Query Store: un nuovo modo di monitorare 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 delle prestazioni delle query, permettendone l’analisi a posteriori. Questo meccanismo permette di effettuare analisi sofisticate delle query e delle loro prestazioni: #232; 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 recentemente. E possibile inoltre seguire nel tempo l’evoluzione di un piano di esecuzione di una specifica query 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 S1


Title: SQL Server 2016 Temporal Database Support (IT)

Abstract: I database temporali sono oggetto di studio da lungo tempo, quasi dieci anni fa UGISS ha dedicato due sessioni a questo tema sia dal punto di vista teorico, che da quello pratico, pur non avendo alcun tipo di supporto specifico in SQL Server. La nuova versione 2016 introduce il supporto a tabelle temporali che mantengono automaticamente, e in modo trasparente, la storia delle modifiche e permettono analisi puntuali nel tempo in maniera pratica con apposite estensioni del linguaggio. In questa sessione faremo una breve revisione dei database temporali e vedremo in dettaglio il supporto in SQL Server 2016 con l’ausilio di svariate dimostrazioni pratiche.

Speaker(s):

  • Gianluca Hotz

Track and Room: SQL Server 2016 - Room S1


Title: String Concatenation Done Right

Abstract: Numerous techniques for concatenating string data can be found online, and even in some books. In this session you will learn two of them that are reliable, and fairly easy to understand, implement, and deploy. You will also learn how to control the order of the values being concatenated, a feature that is not natively provided by SQL Server.

Speaker(s):

  • Matija Lah

Track and Room: Cloud Developers - Room S7


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: Cloud Developers - Room S7


Title: PowerBi

Abstract: PowerBi

Speaker(s):

  • Marco Pozzan

Track and Room: Analytics and Reporting - Room S6


Title: SQL Server 2012-2016 Columnar Storage

Abstract: First introduced in version 2012, columnstore indices and batch processing development continued in SQL Server 2014 and 2016. This session explains the need for the columnar storage, the internals of the SQL Server columnstore indices, and compares the implementations in different versions of SQL Server.

Speaker(s):

  • Dejan Sarka

Track and Room: SQL Server 2016 - Room S1


Title: Tired of connecting on-prem cloud data? Take a DB stretch

Abstract: You can stretch your legs and relax and get a quick session on delivering your analytics against hot, warm cold data. Stretch Database is the new concept, which allows you to stretch from on-prem to cloud easily and this session will enable you to understand enabling / disabling data stretch, accessing data using stretch database, setup remote data archiving, basic concepts on enabling database/table and backup restore for the stretch enabled databases. Stretch DB also covers the concepts of Shallow Deep backups. However, Deep backups are not currently supported with SQL Server 2016 CTP2.

Speaker(s):

  • Dr. Subramani Paramasivam

Track and Room: Cloud Developers - Room S7


Title: SSIS Custom Data Flow Components

Abstract: SQL Server Integration Services (SSIS) include several most important components required in data acquisition, transformation, and load operations. If the problem at hand demands a solution that cannot be solved using the built-in components alone, you can resort to the freely extensible Script Component, but when the circumstances also call for a more complex, and more robust solution, that will be deployed to more than one destination server, the more appropriate alternative is to design a Custom Component.In this session you will learn how this can be achieved, what advantages it provides, and how to perform even the most complex data transformations in a standardised and reliable environment.

Speaker(s):

  • Matija Lah

Track and Room: Analytics and Reporting - Room S6


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 S1


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 831 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 S1


Title: Azure Stream Analytics

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 Stream Analytics service on the Cloud. Let’s see how it works.

Speaker(s):

  • Marco Parenzan

Track and Room: Cloud Developers - Room S7


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

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.

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.

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

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 .

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).

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.

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

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

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.

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 .

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.

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.

Dr. Subramani Paramasivam

Twitter: - https://twitter.com/dageop

LinkedIn: Dr. Subramani Paramasivam

Contact: http://www.yoursqlman.com/index.php/blogs

Dr.SubraMANI Paramasivam is a Microsoft MVP, PhD, Microsoft Certified Trainer and Head of Data AI at DAGEOP Ltd having 21 years of DB, BI, Analytics and AI experience. Mani has also spoken in various events like MS IGNITE, PASS Summit, MS Inspire, SQLBITS, Power Platform Summit, Global AI Bootcamp, Data BI Summit, SQLRelay, Power BI World Tour, Data Platform Summit, INSIDESQL UK, Global AI Nights, SQLServerGeeks Summit, MCT Global Summits, Data Day Events and various user group events. Mani also believes in Empowering Every Person in the planet and spreads the awareness on Global challenges via www.EmpoweringEveryPerson.com. He is also a co-owner of 1 Global AI Meetup and 3 Power BI PUG PASS local / user groups.

Tomaž Kaštrun

Twitter: - @tomaz_tsql

LinkedIn: Tomaž Kaštrun

Contact: http://www.tomaztsql.wordpress.com

Tomaž Kaštrun is BI developer and data analyst. His main focus are data mining, T-SQL development, programming and query optimization. He has been working with SQL server since version 2000. He is Microsoft Certified Professional, Microsoft MVP for data platform and Microsoft trainer.

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.

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.

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 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.

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).

Matija Lah

Twitter: - @MatijaLah

LinkedIn: Matija Lah

Contact: http://milambda.blogspot.com

Matija Lah has more than a decade of experience working with Microsoft SQL Server, mostly architecting data-centric solutions in the legal domain. His contributions to the SQL Server community have led to the Microsoft Most Valuable Professional award in 2007 (Data Platform), which he held until 2017. In 2008 Matija joined SolidQ as a Mentor, located in Central and Eastern Europe. He spends most of his time on projects involving advanced information management, and natural language processing.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page