SQLSaturday #280 - Vienna 2014

Event Date: 03/06/2014 00:00:00

Event Location:

Microsoft Österreich
Am Euro Platz 3
Vienna, Austria

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: The ‘Secret Sauce’ in your Big Data: R, HDInsight and PowerBI

Abstract: Big Data is not so much about storing massive amounts of data in a common database. It is also a force of change for the organisation, and it means that we have to consider the collective capabilities of the platform to serve the business: from data source to secret sauce to help the business to make data-driven decisions to drive the enterprise forward. How can you get your organisation’s secret sauce? Data scientists need a way of combining the scalability of Big Data with the ability to conduct extensive data analysis to obtain the ‘secret sauce’. In this session, we will look at R, the world’s favourite free data analysis tool, and HDInsight, which is Microsoft’s distribution of Hadoop. In this session, we will look at an end-to-end solution to discover our secret sauce from data ingredients. We will then visualise the results in Microsoft’s latest BI toolset, Power BI.

Speaker(s):

Jen Stirrup

Track and Room: C - Cloud - N/A

Title: ETL for the masses with Power Query and “M”

Abstract: Power Query allows users to incorporate public data and organizational data seamlessly in Excel. The purpose of this session is to take a deeper dive into the capabilities of Power Query and of the “M” language. The more I use Power Query and the M language that underpins it, the more I see how useful it is – quite apart from its abilities to import data from other data sources – as a third option to solve problems in Excel itself. Furthermore it provides a simple interface over the data transformation engine (powered by M), and it has become a tool of choice anytime I need to get data into Excel. In this demo-driven session I will show how you can use Power Query to do some initial data shaping, visualize, and then automate the data loading process through SSIS.

Speaker(s):

Regis Baccaro

Track and Room: C - Cloud - N/A

Title: FILETABLEs: What They Are and How to Use Them

Abstract: Have you ever had the need to access documents in your database as if they were files in the file system? SQL Server 2012 introduces a brand new method for managing large data objects (BLOBs) in a database. FILETABLEs provide access to data using Transact-SQL - just like any other table inside the database, while at the same time also provide access to the data using the operating system File I/O API - i.e. just like any other folder in the file system. In this session you will learn how to upgrade your document management solutions by migrating your large data to FILETABLEs. The session covers two most typical migration scenarios: migrating from a distributed data store, where files are stored outside the database, and from a homogeneous d

Speaker(s):

Matija Lah

Track and Room: D - Development - N/A

Title: MDS + DQS + SSIS = EIM or How to build master data management solution

Abstract: The process of entering data into corporate dictionary is not as simple as you can see at the first glance. Just imagine the process of collection information about the new retail store. It starts from discovering the possible place, then estimating the size, format and revenue, making a decision to buy or rent this place and so on. At the end you have to liquidate the goods remained unsold, reassign you workers to another store, demount all equipment, close accounts, etc. This process may involve 5, 10 and even 20 different workers who collect and enter different pieces of information about a retail store. At this session we will talk about the approaches of creating a master data management solution and take a look at the implementation with the services of Microsoft SQL Server 2012.

Speaker(s):

Andrey Zavadskiy

Track and Room: B - Business Intelligence Big Data - N/A

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Abstract: Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.

Speaker(s):

Scott Klein

Track and Room: C - Cloud - N/A

Title: Windowing Functions: THE Reason to Upgrade to 2012

Abstract: For the first time since SQL 7 there is a compelling reason for EVERY SQL Server user to upgrade to the next version and this time around the reason is Windowing Functions. And these are NOT limited to Enterprise Edition, like so many other really useful and important features! The range of data processing needs that can be very efficiently and cleanly solved with these tools is stunning. In this demo-packed session we will cover as many features as we can pack into an hour’s time, and you can take the demo code back home with you to review at your leisure!

Speaker(s):

Kevin Boles

Track and Room: D - Development - 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: D - Development - N/A

Title: Siena calling! Project Siena a RBID App?

Abstract: With Project Siena Microsoft has introduced a beta release of a new technology for business experts, business analysts, consultants, and other app imagineers. This session will review if Siena is useful for Business analysts. We will show how to combine simple app development (Rapid R Business Intelligence BI Development D) with different data sources from Excel Sheets (Power Query driven) , RSS Feeds, SharePoint Lists or Windows Azure Tables and how to deploy your little app in minutes. We will discuss the use cases of Siena from a BI perspective, what you can do already and what is missing.

Speaker(s):

Tillmann Eitelberg

Track and Room: B - Business Intelligence Big Data - N/A

Title: Product-Demo: MelissaData

Abstract: Product-Demo: MelissaData

Speaker(s):

Inna Selipanov

Track and Room: D - Development - N/A

Title: Optimizing BI with SQL2014 In-Memory tables

Abstract: Well - they named it SQL2014 In-Memory OLTP tables - BUT that does not mean we can’t optimize our BI solutions with this new feature.
This demo intensiv session is build around a number of hypothesis that are testet and show what we can - and cannot optimize with In-Memeory tables covering both the ETL and (R)OLAP angels of the BI process. The session will use the latest CTP release and is constantly updated to include the latest news on the topic.

Speaker(s):

Rasmus Reinholdt

Track and Room: B - Business Intelligence Big Data - N/A

Title: Scaling Analysis Services in the Cloud

Abstract: Over the last years Analysis Services has proven its scalability with big data volumes and also with many users. Those high-end solutions are usually very strongly tied to the hardware they are running on. When moving those solutions to the cloud we need to reconsider this whole setup as a single on-premise hardware still outperforms a cloud machine by far. In order to achieve the same overall performance we need to scale out our Analysis Services instances across multiple hosts in the cloud and that’s what this session is about.

Speaker(s):

Gerhard Brueckl

Track and Room: C - Cloud - N/A

Title: SQL anti patterns

Abstract: You can learn SQL in three days but it’ll take you 10 years to become good at it. In this session we will have a look at some basic design errors and get a notion of the things that absolutely doesn’t work. Antipatterns is a way of naming common design errors in order to make them easier to remember - even if you haven’t done them yet.

We will become acquainted with antipatterns on a physical level, a logical level and an sql-queries and application level, and spice it up with some seriously foolish errors made by me and my colleagues. The session is relevant for developers and DBAs.

Speaker(s):

Kennie Pontoppidan

Track and Room: D - Development - N/A

Title: Product-Demo: Idera

Abstract: Product-Demo: Idera

Speaker(s):

Rudolf Brandstötter

Track and Room: A - Administration - N/A

Title: Product-Demo: cubido

Abstract: Product-Demo: cubido

Speaker(s):

Wolfgang Ennikl

Track and Room: B - Business Intelligence Big Data - N/A

Title: Clustered Columnstore Deep Dive

Abstract: When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.

Speaker(s):

Niko Neugebauer

Track and Room: A - Administration - N/A

Title: Preparing a Tabular Data Model for Power View Reporting

Abstract: This presentation will describe how to prepare a tabular data model (PowerPivot or Tabular Project) to fully exploit the reporting capabilities of Power View. Theory and demonstrations will describe why and how to configure the Reporting Properties, and how to enable images to surface within Power View reports.

Speaker(s):

Peter Myers

Track and Room: B - Business Intelligence Big Data - N/A

Title: Indexing Deep Dive

Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.

Speaker(s):

Kevin Boles

Track and Room: A - Administration - N/A

Title: Windows Azure SQL Database - your cloud database and why you need it

Abstract: This session will take an exploratory look at Microsoft’s cloud-based relational database offering. We’ll lift the hood and look at its many benefits and features, and how it easily fills the need for a highly available and scalable database service in the cloud. We’ll discuss how the database formally known as SQL Azure helps ease provisioning and deployment, and how Microsoft takes care of the physical administration so that developers and DBA’s alike can focus on the aspects of their job they really care about.

Speaker(s):

Scott Klein

Track and Room: C - Cloud - N/A

Title: SQL Server Data Tools - The IDE for database developers

Abstract: Since March 2012, SQL Server Data Tools (SSDT) are available for database developers as a project-based development environment within Visual Studio.

Although SSDT is installed automatically with Visual Studio 2012, this method of database development and the functions provided are completely new to many developers.

This session aims to change that and to provide an overview of the advantages and potentials of SSDT. You will see how you can develop, debug, refactor, deploy and maintain SQL Server and Azure databases from a single IDE.

Speaker(s):

Constantin Klein

Track and Room: D - Development - 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: A - Administration - N/A

Title: SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds

Abstract: The session is centered around what was codenamed “Hekaton”, the SQL 2014 inMemory OLTP Engine. It Shows an overview of the most critical Feature Areas (from a Migration Point of view), Shows the limitations of those Features and Workarounds where they exist. There will also be a Focus on explaining the reasons and thoughts behind some limitations.

Speaker(s):

Wolfgang Rick Kutschera

Track and Room: A - Administration - N/A

Title: Replay your workload as it’s your actual one!

Abstract: Have you ever wanted to replay your application workload be that because you upgraded to a new hardware, added new indexes or something else? Now there’s a feature for that! It’s called Distributed Replay and in this session you will learn how this new feature in SQL Server 2012 can help you resolve that problem!

Speaker(s):

Boris Hristov

Track and Room: A - Administration - N/A

Title: WiT-Panel

Abstract: Women in Technology

Speaker(s):

Jen Stirrup

Track and Room: C - Cloud - N/A

Title: Opening Keynote

Abstract: Opening and Keynote

Speaker(s):

Markus Ehrenmueller-Jensen

Track and Room: D - Development - 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.

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.

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Jen Stirrup, Microsoft Regional Director and MVP is a well-known Business Intelligence and Data Visualization expert, author, data strategist, and Master of Business Administration (MBA) student in London. Jen leads a boutique analytics consultancy, delivering strategic advice to companies large and small.

Jen has presented in Africa, India, Europe and North America. Jen has presented at Ignite, Techorama, TechEd, PASS Summit, SQLBits, and SQLSaturday events in Europe and the US. She also delivers the MAPA Azure Architects course worldwide with Microsoft team members. Jen was also featured on the Best of PASS Summit 2015 DVD as one of the top 10 speakers. Jen also was awarded PASS prestigious PASSion Award in 2012

Andrey Zavadskiy

Twitter: - @AndreyZavadskiy

LinkedIn: Andrey Zavadskiy

Contact: https://andreyzavadskiy.com

Andrey has been leading the development of corporate information system for realty estate business based on MS SQL Server, ASP.NET and Sharepoint. He works with SQL Server since version 7.0. Currently holds MCSE certification for SQL Server, MCSD for Web development and active Microsoft trainer status. He loves to design enterprise-scale application architecture, take part in database development and optimization.

Tillmann Eitelberg

Twitter: - @_Tillmann

LinkedIn: Tillmann Eitelberg

Contact: http://www.ssis-components.net

Tillmann Eitelberg is CEO and co-founder of oh22information services GmbH, which specializes in data integration and data management. Tillmann is an active blogger at www.ssis-components.net, writing regularly about data quality topics and his passion: spatial data. In addition, he has published several SSIS components on Codeplex and GitHub. Tillmann is a Data Platform MVP, a board member of PASS Germany e.V., a PASS CL for the Cologne/Bonn region, and a PASS RM.

Regis Baccaro

Twitter: - @regbac

LinkedIn: Regis Baccaro

Contact: http://theblobfarm.wordpress.com

Regis has more than 15 years of experience with SQL Server, SharePoint and .Net as an architect and developer. R#233;gis is a SQL Server MVP since 2014 and a frequent speaker at SQL conferences, a PASS Regional Mentor and the founder of SQLSaturday Denmark community event. He is also a certified industry trainer on the APS/PDW platform. In his freetime he is an avid runner, cook and farmer.

Gerhard Brueckl

Twitter: - gbrueckl

LinkedIn: Gerhard Brueckl

Contact: http://blog.gbrueckl.at

Gerhard has been working with Microsoft BI tools since 2006 mainly focusing on Microsoft SQL Server and its components. As a consultant and architect he designed various enterprise BI solutions primary in the German-speaking areas. His personal interest has always been on analytical databases and their capabilities. In 2012 he achieved the SSAS Maestro certification. He is also very active in the community, has its own blog and speaks at conferences all over the world on a regular basis.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.

Niko Neugebauer

Twitter: - NikoNeugebauer

LinkedIn: Niko Neugebauer

Contact: http://www.nikoport.com

Niko Neugebauer is a Data Platform Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about the Microsoft Data Platform and community. Founder of the Portuguese SQL Server User Group and the main organizer of the first SQLSaturday event outside of North America (#78 Portugal), Niko speaks regularly at events such as PASS Summit, SQLRally, SQLBits, and SQLSaturday events around the world. Niko loves sharing information and knowledge and has authored over 130 blog posts on Columnstore Indexes, and regularly contributes to the open-sourced CISL library focused on Columnstore Indexes.

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.

Inna Selipanov

MelissaData GmbH

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.

Rasmus Reinholdt

Twitter: - @RasmusReinholdt

LinkedIn: Rasmus Reinholdt

Contact: http://rasmusreinholdt.wordpress.com

Rasmus is the Data Warehouse architect at UNOPS, the implementation arm of the UN, based in Copenhagen, Denmark. He has worked with Microsoft BI since 2005 both as a developer and architect, building large solutions on every release from sql2005 and onwards. Rasmus is certified is MSCE SQLServer (Data platform amp; BI), a long time speaker at various SQLSaturdays, PASS SQLRally Nordic and SQLBits. He also co-organizes SQLSaturday Copenhagen and blogs at http://rasmusreinholdt.wordpress.com.

Markus Ehrenmueller-Jensen

Twitter: - MEhrenmueller

LinkedIn: Markus Ehrenmueller-Jensen

Contact: http://www.savorydata.com

Markus Ehrenmueller-Jensen, as the founder of Savory Data, has a long history of providing customer solutions in the areas of data engineering, data science, and Business Intelligence. He is a certified software engineer, a graduated business educator, and professor of Databases Project Management at HTL Leonding, and is certified as an MCSE MCT. He is a published author and writes articles for well-known journals. He co-founded PASS Austria and organizes SQLSaturdays in Austria. Markus is a founding member of Power BI Usergroup Austria. Since 2017 Markus was awarded as an Microsoft Data Platform MVP.

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.

Wolfgang Rick Kutschera

Contact: http://dangerousdba.blogspot.co.at/

DBA at BwinSQL Server MVP

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Rudolf Brandstötter

Dynalox Software GmbH

Jen Stirrup

Twitter: - @jenstirrup

LinkedIn: Jen Stirrup

Contact: http://www.jenstirrup.com

Kennie Pontoppidan

Twitter: - @KennieNP

LinkedIn: Kennie Pontoppidan

Contact: http://www.pontop.dk/

Kennie Nybo Pontoppidan is a senior program manager in Microsoft working in the Dynamics NAV server backend team. He has worked in the dangerous field between developers, dbas, customers and project managers for many years and done his part of mistakes as a developer before that in his 15+ years in the it industry. He enjoys working with databases and really, really enjoys his daily dose of sql. Kennie has no humor.

Constantin Klein

Twitter: - KostjaKlein

Contact: http://kostjaklein.wordpress.com

Constantin is working at Syntax Systems GmbH Co. KG. He mainly deals with the design and development of solutions based on Microsoft products and technologies. Since 2010 he was each year designated Most Valuable Professional (MVP) for the Microsoft Data Platform. In addition he is member of the board of Just Community e.V. (http://www.justcommunity.de) and PASS Deutschland e.V. (http://www.sqlpass.de). He also leads the .NET User Group Frankfurt/Germany (http://dnug-frankfurt.de). Find his blog at: http://kostjaklein.wordpress.com

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Boris Hristov

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

LinkedIn: Boris Hristov

Contact: http://borishristov.com/blog/

Wolfgang Ennikl

cubido business solutions GmbH

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

SQLSaturday #280 - Vienna 2014

Sessions

Title: The ‘Secret Sauce’ in your Big Data: R, HDInsight and PowerBI

Title: ETL for the masses with Power Query and “M”

Title: FILETABLEs: What They Are and How to Use Them

Title: MDS + DQS + SSIS = EIM or How to build master data management solution

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Title: Windowing Functions: THE Reason to Upgrade to 2012

Title: Temporal Data in SQL Server

Title: Siena calling! Project Siena a RBID App?

Title: Product-Demo: MelissaData

Title: Optimizing BI with SQL2014 In-Memory tables

Title: Scaling Analysis Services in the Cloud

Title: SQL anti patterns

Title: Product-Demo: Idera

Title: Product-Demo: cubido

Title: Clustered Columnstore Deep Dive

Title: Preparing a Tabular Data Model for Power View Reporting

Title: Indexing Deep Dive

Title: Windows Azure SQL Database - your cloud database and why you need it

Title: SQL Server Data Tools - The IDE for database developers

Title: The nightmare of locking, blocking and isolation levels!

Title: SQL2014 InMemory OLTP - Features, Limitations, Reasons and Workarounds

Title: Replay your workload as it’s your actual one!

Title: WiT-Panel

Title: Opening Keynote

Speakers

Sponsors