SQLSaturday #257 - Verona 2013
Event Date: 11/09/2013 00:00:00
Event Location:
- Strada le Grazie, 15
- Verona, , 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: Monitoring MDX Queries in Analysis Services
Abstract: If you are able to answer to questions like “How many people use your OLAP solution?”, “How many MDX queries are performed daily on your Analysis Services instances?”, “What is the average response time of an MDX query on your servers?” THIS SESSION IS NOT FOR YOU!!! Otherwise, in this session we will see how is it possible to implement a monitoring tool using resources already available on our servers such as PowerShell, SQL Server Profiler, Reporting Services, and simple XMLA commands. Finally, we will see how further enrich the presented solution providing also the ability to identify the most problematic MDX queries, run performance measures on them and obtain a summary report that identifies any bottlenecks specifying whether they reside in the Storage or Formula Engine of Analysis Services All this in a fully automatic way! The solution presented is currently being used successfully by SolidQ at some customers in Italy.
Speaker(s):
- Francesco De Chirico
Track and Room: Business Intelligence - N/A
Title: Hardware Planning Sizing for SQL Server
Abstract: L’acquisto di un server dedicato a SQL Server è ancora un’operazione necessaria. Il cloud è un’ottima scelta ma se dovete creare un datawarehouse di dimensioni non banali o se avete la necessità di avere performance e controllo ottimali del vostro database server di produzione, la scelta del server on-premise è ancora quella vincente.Il problema è quindi: come non buttare via soldi in hardware inutile? In questa sessione vedremo come tutti i componenti concorrono nel formare un hardware bilanciato (questa è la parola chiave!) e senza colli di bottiglia, massimizzando l’investimento fatto. Parlaremo di SAN, CPU, HBA, Fiber Channel, Memoria e tutto quello che pensavate di conoscere bene…
Speaker(s):
- Davide Mauri
Track and Room: Administration - N/A
Title: xVelocity Columnstore Indexes in SQL Server 2012 and SQL 2014
Abstract: With the release of SQL Server 2012, Microsoft introduced a new type of nonclustered index called xVelocity columnstore index in the SQL Server database engine. It is based on VertiPaq in-memory data compression technology. The xVelocity memory optimized columnstore indexes are one of the most significant performance and scalability enhancements in SQL Server 2012, and more in SQL 2014. The xVelocity columnstore indexes speed up the processing time for common data warehousing queries – particularly in situations where very large quantities of data have to be aggregated and accessed quickly.
Speaker(s):
- Gilberto Zampatti
Track and Room: Development - N/A
Title: Power BI in Action (IT)
Abstract: You will see how to create a Data Model in Power Pivot leveraging on Power Query to extract and manipulate data from your data sources. The model will be used to analyze data in Power View and the result will be published on Power BI site.The goal of the session is understanding how to leverage the feature of the on-premise tools in order to enable better reports also when the report is published in Power BI sites.
Speaker(s):
- Marco Russo
Track and Room: Business Intelligence - N/A
Title: The nightmare of locking, blocking and isolation levels!
Abstract: I am sure you all know that troubleshooting problems related to locking and blocking (hey, sometimes there are deadlocks too) can be a real nightmare! In this session, you will be able to see and understand why and how locking actually works, what problems it causes and how can we use isolation levels and various other techniques to resolve them!
Speaker(s):
- Boris Hristov
Track and Room: Administration - N/A
Title: .NET Development for the SQL Server Developer
Abstract: Every SQL Server DBA or Developer needs to create some kind of applications: a dashboard for data, a management console, a data-entry tool. Like SQL Server, .NET have evolved over years. Linq and ORM, ASP.NET MVC, Javascript/jQuery, async programming, Azure and the Cloud. I’ll present a fast entry to .net and some scenarios and sample applications that a typical SQL Server DBA or Developer can use in his daily work.
Speaker(s):
- Marco Parenzan
Track and Room: Development - N/A
Title: SQL Server Security in an Insecure World
Abstract: One of the first responsibilities of a SQL Server DBA is to safeguard the data and protect it from unauthorized access. Over and over we hear about hacker attacks and data leaks: if you don’t want to be the next victim, you have to take action and activate all the available protection measures. In this session you’ll learn how to secure your SQL Server infrastructure and how to take advantage of the numerous security features available in the product.
Speaker(s):
- Gianluca Sartori
Track and Room: Administration - N/A
Title: SQL Server workloads and Windows Azure platform: better together
Abstract: Join myself and Xin Jin for our session if you want to understand all the possibilities offered by Windows Azure to run SQL Server workloads. We will cover SQL Database and Windows Azure specific features added in SQL Server 2014.With Xin Jin, Program Manager at Microsoft Corporation, in SQL Server team.
Speaker(s):
- Francesco Diaz
Track and Room: Administration - N/A
Title: Useful everyday tips and tricks for Reporting Services
Abstract: Reporting Services è uno strumento molto potente e permette di creare report anche complessi in breve tempo. L’esperienza di sviluppo, però, presenta a volte alcuni “spigoli” che possono creare qualche problema e allungare i tempi di realizzazione nel tentativo di trovare una soluzione girovagando tra MSDN e i forum più disparati. Questa sessione vuole fornire una serie di trucchi e consigli, dettati dall’esperienza diretta sul campo -e da molti caffè-, che si sono rivelati utili a limare tali spigoli.
Speaker(s):
- Francesco Milano
Track and Room: Development - N/A
Title: Living with SQL Server Full-text Search
Abstract: If you’re already using SQL Server Full-text Search (FTS) in your applications, or are just starting to consider it for a future implementation, there are a couple of things you should know about it, that some day just might save your… Well, at least make your life a little less stressful. Join me in learning how to plan, deploy, and maintain, your full-text application.
Speaker(s):
- Matija Lah
Track and Room: Business Intelligence - N/A
Title: Node.js on SqlServer
Abstract: We are used to connect to a Sql Server database from our .NET applications with ADO.NET, but today new possibilities are available. Node.js is a new web framework suited for high scalable web applications. Microsoft has released on github the driver to build node.js applications that use SqlServer as a storage. During the session we will see what is node.js and how it can be used with SqlServer.
Speaker(s):
- Emanuele DelBono
Track and Room: Development - N/A
Title: Gestione degli errori nel codice T-SQL
Abstract: Tra i vari miglioramenti dell?engine c’è quello relativo alla gestione degli errori direttamente da T-SQL. Il nuovo costrutto throw, totalmente aderente alla Xact_abort, consente una migliore gestione degli errori che potrebbero verificarsi nell?engine di SQL server, siano essi sollevati dall?utente o da operazioni non lecite. L’importante è scrivere codice T-SQL in grado di gestire le anomalie e fare in modo che le nostre applicazioni lo richiamino E che interpretino correttamente i risultati.
Speaker(s):
- Luca Ferrari
Track and Room: Development - N/A
Title: Put 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.
Speaker(s):
- Alessandro Alpi
Track and Room: Administration - N/A
Title: Agile SSIS with Biml
Abstract: Are you tired to waste your time in a “monkey work” spent in SSIS packages? Are you tired to fight against packages’ corrupted metadata and side effects due to abrupt changes in metadata? It’s time to get in touch with Biml, a new player in the Microsoft BI realm. We’ll see how Biml can help us in a BI project, automating the ETL packages’ development. In particular, we’ll see it in action in the Staging phase of the project.
Speaker(s):
- Luca Zavarella
Track and Room: Business Intelligence - N/A
Title: Temporal Data in SQL Server
Abstract: Although temporal data is part of many business applications, most RDBMS’, including SQL Server, do not support it out of the box. However, SQL Server provides full infrastructure to build your own temporal data support. After introduction of temporal problems, we are going to develop interval CLR data type that supports validity time. Then we are going to discuss what kind of constraints pertain to temporal data, and how we can implement those constraints. We are going to use T-SQL to develop two very useful temporal operators: PACK and UNPACK. In addition, we are going to introduce the proposed sixth normal form that deals with temporal data, and show how you can implement it correctly.
Speaker(s):
- Dejan Sarka
Track and Room: Development - N/A
Title: Exploring In-memory OLTP Engine (Hekaton) in SQL Server 2014 CTP1
Abstract: The continuing drop in the price of memory has made fast in-memory OLTP increasingly viable. SQL Server 2014 allows you to migrate the most-used tables in an existing database to memory-optimised ‘Hekaton’ technology, but how you balance between disk tables and in-memory tables for optimum performance requires judgement and experiment. What is this technology, and how can you exploit it? This session will try to explains.
Speaker(s):
- Gilberto Zampatti
Track and Room: Administration - N/A
Title: DAX Introduction
Abstract: Data Analysis Expressions is the language for the definition of the expressions in PowerPivot. Offers a number of specific features of PowerPivot as many functions for the management of relationships between tables. This session will be introduced PowerPivot, its database columnar and operation of calculated columns and measures listed in DAX. The discussion will cover the DAX syntax, data types, and the set of the most useful functions of language. The aim is to illustrate what can be done using DAX and PowerPivot.
Speaker(s):
- Marco Pozzan
Track and Room: Business Intelligence - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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!
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…
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.
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 Pozzan
Twitter: - @marcopozzan
LinkedIn: Marco Pozzan
Contact: http://www.marcopozzan.it
Consultant and trainer in business intelligence, analytics and data mining on Methode . Teacher for ITS courses of data warehouse at the University of Pordenone.
Gilberto Zampatti
Time ago (a lot of time ago…) an excellent IT pro brought me with him and became my Mentor in the IT wonderland…it was a world full of mainframes… I met the Relational theory when there were no commercial RDBMS, and I was spellbound by that “magic”. When Microsoft appeared in the IT market, I felt finally which trek I had to follow. I’m still walking on such road, and in my rucksack I’ve ben putting some other stuff (like SharePoint, for example). My sole regret: I’ve left the College to consecrate all my time to my job; curiously, since then, I’ve never stop learning…
Francesco Diaz
Contact: http://blogs.technet.com/b/francesco_diaz
Francesco Diaz works in Microsoft Italy as Partner Technology Strategist on the Application Platform area, where supports Microsoft Partners and customers on SQL Server and Windows Azure propositions. In his previous role in Microsoft he worked as Partner Technical Consultant in the Microsoft Customer Services and Support delivering reactive and proactive services (Seminars, Hands on labs, Workshops, Webcasts) on SQL Server and Microsoft Dev Tools.
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.
Boris Hristov
Twitter: - https://twitter.com/BorisHristov
LinkedIn: Boris Hristov
Contact: http://borishristov.com/blog/
Boris is a SQL Server Consultant, but also an Author for Pluralsight and a SQL Server MVP. He is frequently speaking at conferences all accross Europe and is heavily involved in training students and organizations in what he calls quot;The Art of SQL Serverquot;. Boris is frequently blogging and is the host of SQLHangouts.
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.
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.
Gianluca Sartori
Twitter: - http://twitter.com/#!/spaghettidba
LinkedIn: Gianluca Sartori
Contact: http://spaghettidba.com
Gianluca Sartori is a Data Platform MVP, independent consultant and performance tuning specialist. He has been working in the software industry since 1999 and has been working with SQL Server ever since. He also works as a SQL Server trainer and in his spare time he writes technical articles and participates the SQL Server forums. Gianluca enjoys presenting SQL Server topics at conferences in Europe and in Italy in particular. He is currently working as lead DBA at a famous Formula 1 team.
Marco 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.
Francesco Milano
Twitter: - @fmilano
LinkedIn: Francesco Milano
I’ve been working with Microsoft technologies since 2000, and I’m specialized in .NET Framework and SQL Server platform. I focus primarily on back-end development, integration solutions, relational model design and implementation. Starting from 2011 I’m also member of UGISS (Italian SQL Server User Group) and speaker at main italian SQL Server conferences and workshops.
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.
Emanuele DelBono
Contact: http://ema.codiceplastico.com
I’m a software engineer that is trying to become a polyglot programmer learning new languages and tools to develop better applications. I work as a consultant in Trilance a software house based in Verona specialized in developing big applications for the energy market, I build web applications primarily with ASP.NET MVC, javascript and Ruby on Rails.
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.
Sponsors
The following is a list of sponsors that helped fund the event: