SQLSaturday #689 - Prague 2017
Event Date: 10/21/2017 00:00:00
Event Location:
- DOX
- Poupětova 1
- Prague, Hlavní Mesto Praha, Czechia
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: Scripting Tabular models
Abstract: Introducing the new scripting language for tabular models. Before SQL Server 2016 tabular models was wrapped into a multidimensional constructs. TOM is the new native library for tabular - this makes it easy to maintain, modify and deploy your model.
During this session I will go through and explain some examples and best practices on generating a SSAS tabular model by using the new TOM. I will spend some time showing and explaining a real world example on pushinga measure creation and changes to the key business stakeholders and to ensure quick time to market.
The last thing i will show is how you speed up your development free up up to 50% of the time you spend building tabular models with the simple and advanced features of Tabular Editor 2.0
Speaker(s):
- Bent Pedersen
Track and Room: Business Intelligence Analytics - Backstage
Title: Enabling Citizen Data Science with Microsoft
Abstract: In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics. Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure. These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists. Should we be worried about creating fools-with-tools or should we embrace the democratization of data science as the golden age of data? In this demo heavy session we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker(s):
- Jan Mulkens
Track and Room: Business Intelligence Analytics - Auditorium
Title: Data Science with SQL Server 2016 and R
Abstract: One of the most notable additions to the Microsoft BI stack is the addition of Microsoft R Server inside SQL Server 2016. The inbuilt ScaleR packages deliver scalability and multithreading capabilities that open-source R can’t easily provide, opening up a world of possibilities for data scientists interested in machine learning and predictive analytics. But what does this look like on a Microsoft platform?
Oliver Frost, a Data Science Engineer at Direct Line Group, demonstrates what tools are available to you as a data scientist inside SQL Server 2016. Discover how R adds value where traditional relational databases struggle, how to use ScaleR functions to build predictive models and efficient machine learning pipelines.
Speaker(s):
- Oliver Frost
Track and Room: Business Intelligence Analytics - Backstage
Title: From SQL to R – Leverage Your T-SQL Knowledge to Learn R
Abstract: You are already familiar with T-SQL and are eager to learn R but do not know where to start? Start from what you already know: T-SQL. Both languages have many things in common on some levels, but are very different on others. You will learn how to begin your first steps in the new language and how to perform the most common tasks, typical for R: statistics, machine learning data visualization. This session will kick you off to the new language by using analogies from T-SQL. You will learn how to write your first R-scripts, make usage of packages and will leave this session with a basic understanding of typical use-cases of R and how to integrate that into your existing environment with SQL Server.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Analytics and Visualization - Café
Title: Scale-Out your SSIS Package Executions
Abstract: With a rising number of parallel SQL Server Integration Services (SSIS) package executions the resource requirements on the SSIS server can be a limiting factor. In older SQL Server versions, scale-out architectures needed to be implemented by hand and required a lot of manual implementation effort. Beginning with SQL Server 2017, SSIS provides a built-in scale-out functionality for package executions. After the definition of scalability-types, the SSIS scale-out architecture and the involved system-parts are introduced. The attendees will learn the basics, get checklists and best practices when building up their own SSIS scale-out cluster. In addition to the configuration using SSMS other configuration options (command line, T-SQL,..) are presented. Behind the scenes information like logging, the programmability interfaces and configuration options will be shared.
Speaker(s):
- Wolfgang Strasser
Track and Room: Business Intelligence Analytics - Auditorium
Title: A Game of Hierarchies: Introduction to Graph Processing with SQL
Abstract: Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
- Product Categories
- Sales Territories
- Bill of Material
- Calendar and Time Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker(s):
- Markus Ehrenmueller-Jensen
Track and Room: Application Database Development - Café
Title: Database corruption
Abstract: In this session, you will learn how to detect and avoid common problems related to database corruption. There will be a description of the data structures in SQL Server and how it can affect the availability of SQL Server during corruption. On the session, there will be not only theoretical knowledge but many real life examples with demos.
Speaker(s):
- Michal Sadowski
Track and Room: Database Administration Deployment - Backstage
Title: Hello SQL! I’m Python! What can I do for you?
Abstract: At last… After SQL Server 2016 brought us the R language integration the newest 2017 version brings Python in its toolbox. Python is well known as tool for machine learning, advanced analytics and doing a lot of amazing and crazy things. Like its R companion it also has a powerful libraries support for scaling and big data handling. So let’s see what the famous scripting snake can do for us. During the session you will learn how to set up the integration, run simple scripts, use Python for transforming the data, use the Matplotlib library to visualise data in reports, create and run machine learning models with predictions.
Speaker(s):
- Grzegorz Stolecki
Track and Room: Application Database Development - Backstage
Title: Stop everything! Top T-SQL tricks to a Developer
Abstract: Writing a better code is always a difficult challenge. In this session we are going to investigate some common issues and learn new tips that will help you to be a better developer and then help the DBA keep his databases safer.
Speaker(s):
- Marcos Freccia
Track and Room: Application Database Development - Auditorium
Title: Shopping basket analysis with Analysis Services and Power BI
Abstract: What are the products commonly bought together? How can company increase sales by offering bundles of products? Current trend is to leverage Machine learning and Artificial Intelligence to drive sales. But will machine understand business better, that business person who is involved in his area for 20 years? Maybe. During presentation, you will see how to develop data model using SQL Server Analysis Services and Power BI for manual “Attached Sales” exploration and analysis. You will see how to prepare SQL Server layer, SSAS model and Power BI report.
Speaker(s):
- Jiří Neoral
Track and Room: Business Intelligence Analytics - Auditorium
Title: JSON in SQL Server
Abstract: SQL Server enables more flexibile approach to work with non-relational data with new JSON support. I’ll show you what you can do with pure SQL functionality and where you need CLR functions to take full advantage of JSON.
Speaker(s):
- Jakub Müller
Track and Room: Application Database Development - Café
Title: Query Processor Enhancements in SQL Server 2017
Abstract: SQL Server 2017 brings a lot of new useful features, there are a number of query processor enhancements among them, that improve queries performance. In this session, we are going to talk about improvements in three main areas:
- Adaptive Query Processing: Adaptive Memory Grant Feedback, Interleaved Execution and Adaptive Joins;
- Query Store: Automatic Plan Regression Correction and Wait Statistics;
- Query Optimizer: new Plan Operators, Batch Mode enhancements, Cardinality Estimation changes and improved Showplan diagnostics.
Speaker(s):
- Dmitry Pilugin
Track and Room: Database Administration Deployment - Backstage
Title: Real world DevOps - challenges, tools and solutions
Abstract: So you want to use AlwaysEncrypted, but your app is not using driver level parameters? Or you want to parameterize ad-hoc queries, without rewriting your application? Or you just want to pretty print your t-sql code? SQLDOM is here to help. Not very popular but extremely useful utility/library that can help anyone to intercept and rewrite queries during runtime so they meet feature requirements or just fix performance.
Speaker(s):
- Ivan Donev
Track and Room: Application Database Development - Auditorium
Title: Data Warehouse Testing and Why You Should Care!
Abstract: How do you test your data warehouse? Do you even test? Let’s face the truth that data processing solutions are very rarely tested … So let’s start with fundamentals of (not only data warehouse) testing, why you should have sleepless nights (today) and how to avoid them (in the future). Two Joyful Craftsmen: Jaroslav Reken Tomas Tucek will bring a piece of theory, but mainly practical examples, from real life … mainly to get you out of your comfort zone!
Speaker(s):
- Tomas Tucek
Track and Room: Business Intelligence Analytics - Café
Title: APPLY operator in action
Abstract: APPLY operator is a T-SQL table operator that allows to boost query perfomance and to solve complex calculation problems in an very efficient way. But it isn’t easy to understandt how does it work and how it can be applied to our queries. In this session, we will examine the various types of APPLY operator (CROSS APPLY, OUTER APPLY) to understand it’s behaviour and the power it holds. We will go through many real world cases to show how we can use the APPLY operator, when writing queries, instead of JOINs and we will show how performances can be improved by using this operator the right way.
Speaker(s):
- Andrea Martorana Tusa
Track and Room: Application Database Development - Café
Title: SQL Server Myths and Misconceptions
Abstract: SQL Server is full of misunderstood features and misnomers that could affect how it is operating and respectively our applications. If you do not want to be surprised in a bad way by some intended, but not widely known SQL functionalities, join me in this session where we will, in an entertaining way, examine some of the most common behaviors that you probably have not expected.
Speaker(s):
- Miroslav Dimitrov
Track and Room: Application Database Development - Backstage
Title: Azure Machine Learning in Action
Abstract: This session will help you make your first successful experiment with Azure Machine Learning, where we will explore the workflow of creating an experiment, from the initial idea to the final solution. This session will include a lot of demonstrations to show you, how you can start using this amazing technology for your applications.
Speaker(s):
- Marek Chmel
Track and Room: Business Intelligence Analytics - Café
Title: Introduction to U-SQL and Data Lake
Abstract: U-SQL is the new kid on the SQL language block. In this session we’ll look at the what, where, why and how of the language. Is it a query language? Is it a data transformation language? Will it replace T-SQL? Should you learn it? Where is it? What is Data Lake? We’ll discuss all this and more.
Speaker(s):
- Alex Whittles
Track and Room: Business Intelligence Analytics - Café
Title: Travelling in time with SQL Server 2016
Abstract: SQL Server 2016 comes up with a very exciting feature called Temporal tables. You can make queries to historical data lot easier by using this feature. The mechanism is very simple however you all should know it in depth to make sure you can use it efficiently. And this is exactly what I am going to do during this session – show you how to create temporal tables, how to use and manage them
Speaker(s):
- Damian Widera
Track and Room: Application Database Development - Auditorium
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Michal Sadowski
Twitter: - SadowskiMichal
LinkedIn: Michal Sadowski
Contact: https://sqlplayer.net/michal-sadowski
Senior Database Platform Engineer, leader of Krakow chapter of Data Community Krakow (former Polish SQL Server User Group) - PASS Chapter. With more than 10 years of experience in Microsoft technology, helps in advisory for performance optimization on database and application levels. Active speaker on SQL Server related events like SQLSaturday, SQLDay, MCT Global Summit etc. Holds many Microsoft certificates including MCSE: Data Platform, MCSA: SQL Server 2012/2014/2016, MCSA: Windows Server 2008/2012/2016 and MCT.
Jiří Neoral
Twitter: - https://twitter.com/JiriNeoral
LinkedIn: Jiří Neoral
Contact: http://www.neoral.cz
Jiri is BI Data Architect in Dixons Carphone and Microsoft MVP Data Platform. Before joining Dixons worked as Freelance Bi consultant and MCT (since 2008). Jiri has strong passion for Business Intelligence and loves to share his knowledge. Is active blogger about BI although decided to write in Czech and focus mainly on Czech and Slovak audience. He is also active speaker on conferences and community events (mainly based in Czech Republic). Jiri is Czech PUG leader and SQL PASS Member.
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).
Dmitry Pilugin
Twitter: - https://twitter.com/SomewereSomehow
LinkedIn: Dmitry Pilugin
Contact: http://www.queryprocessor.com/
Dmitry Pilugin, is a SQL Server DB developer from Russia, Moscow. He works with SQL Server for more than ten years. Currently he works as a database developer lead, responsible for the development of production databases in the media research company.
Dmitry holds a blog about SQL Server query processing: QueryProcessor.com, where he writes about a query optimization and execution, and also likes to share his knowledge about it speaking at various community events and tech conferences. Data Platform Microsoft MVP since 2014.
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.
Jan Mulkens
Twitter: - https://twitter.com/JanMulkens
LinkedIn: Jan Mulkens
Contact: http://www.janmulkens.be
Jan Mulkens is a Microsoft MVP in AI, a Solution Expert at Ordina Belgium, and a Microsoft Data Platform BI Consultant. In his spare time, he is a speaker at conferences and user groups in Europe and he organizes two user groups and a conference in Belgium. Power BI Days conference (www.powerbidays.com), Belgium Microsoft Advanced Analytics User Group (bit.ly/msaaug), and Flemish Power BI User Group (meetup.powerbibelgium.com).
Alex Whittles
Twitter: - @PurpleFrogSys
LinkedIn: Alex Whittles
Contact: http://www.PurpleFrogSystems.com/blog
Alex is a Data Platform MVP, and is the owner and lead consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the UK. He specializes in Data Warehouse modelling, ETL, Cubes, MDX amp; DAX. He#39;s a chartered engineer amp; has an MSc in Business Intelligence.
He runs the Birmingham (UK) SQL Pass chapter amp; Azure user groups, and is on the SQLBits and SQL Relay committees in the UK.
Alex is a regular speaker at global events including SQLBits, PASS Summit, SQL Relay, SQLSaturdays as well as numerous SQL Pass chapters around Europe
Oliver Frost
Twitter: - @ConsolidataLtd
LinkedIn: Oliver Frost
I am currently working as a Data Engineer, improving the company data platform and providing the necessary resources for our data consultants. I am extremely fortunate to dabble with a number of tools including those from the Microsoft BI stack and NoSQL tech like Neo4j, R and Python. My strengths lie in integrating multiple technologies for a specific business problem.
I aim to present material that BI consultants and developers can all take away something new to apply to their own work processes. I try to apply knowledge and skills from my previous life as a neuroscientist and as a blindfolded Rubik’s Cube world record holder. I am of the belief that, one day, neuroscience and big data will come together in a big way.
Wolfgang Strasser
Twitter: - wstrasser
LinkedIn: Wolfgang Strasser
Contact: http://workingondata.wordpress.com/
Wolfgang Strasser creates solutions based on the Microsoft Data Platform tools in his day-to-day job as Business Intelligence consultant. Either using SQL Server Database Engine, SSIS, reporting with SSAS and SSRS, implementing Power BI solutions or cloud tools for data analysis - the data-tools-landscape is broadening every day! Based on his professional careers as a software developer he likes to work on structured development processes. Wolfgang shares his knowledge with the community at many national and international events. For his community work, Wolfgang has been awarded with the Microsoft MVP Award for Data Platform in October 2015
Jakub Müller
Twitter: - @tckscz
…
Marek Chmel
LinkedIn: Marek Chmel
Contact: http://www.prosql.cz
I have started working in IT as a consultant and trainer for Microsoft server systems and from the beginning I did focus mainly on SQL Server. Few years back I have joined atamp;t, where I workin a team responsible for 24/7 operations for large SQL server environments. Our primary focus is architecture, delpoyment, performance tuning and disaster recovery for SQL Server ranging various sizes, versions and editions. If there#39;s any free time left, you can catch me speaking at a conference or teaching a Microsoft or security class in a training center.
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.
Marcos Freccia
Twitter: - @sqlfreccia
LinkedIn: Marcos Freccia
Contact: http://marcosfreccia.wordpress.com
Currently working as a Microsoft SQL Server DBA at Zalando SE, Marcos has over 9 years of SQL Server experience, working from small to enterprise environments with High Availability, Disaster Recovery, Database Optimization, etc.. Holding several Microsoft certifications such as: MCITP DBA DEV, MCSE Data Plataform and his last certification on Microsoft Azure Design and Implement Cloud Data Platform Solutions. In 2013 Marcos was awarded as a Microsoft MVP by his contributions in the Brazilian SQL Server community. Marcos is a frequent speaker in the SQL Server Community and he was the organizer of the first SQLSaturday in South Brazil.
Ivan Donev
Twitter: - https://twitter.com/ikdonev
LinkedIn: Ivan Donev
I am a Data platform MVP with more than 10 years of real-life experience with SQL Server and its stack of services. Besides the support and project work, I am also a trainer, conference speaker and user group organizer (and volunteer).
Miroslav Dimitrov
Twitter: - @miro_dd
LinkedIn: Miroslav Dimitrov
Contact: http://www.sqlshack.com/author/miroslav-dimitrov/
Miroslav Dimitrov is a Senior Big Data and Analytics Engineer at DXC Technology, regular speaker at various events and Microsoft Certified Trainer. He is MCSE: Data Platform for SQL Server and MCITP on SQL 2008. In the last years he had worked on great variety of customers’ environments and involved in complex transitions and transformation projects as well as developing private and public cloud solutions. Miroslav is also leading database courses at Sofia University.
Grzegorz Stolecki
Twitter: - gstolecki
LinkedIn: Grzegorz Stolecki
Business Intelligence expert with 20+ years of experience. Grzegorz worked as architect, developer and trainer. Currently he focuses on developing specialized analytical and reporting solutions using machine learning models for large and mid-size enterprises. He also works on financial planning, consolidation and budgeting applications. Grzegorz is one of the leaders of Polish Data Community (former Polish SQL Server User Group PLSSUG). You can meet him very often at community meetings, conferences and other events. He is an active speaker and ATE member. Microsoft MVP in Data Platform Area since 2010.
Damian Widera
Twitter: - @DamianWidera
LinkedIn: Damian Widera
Contact: https://codingfamily.net
SQL Server MVP amp; MCT Software engineer with 18+ years of professional experience in all aspects of software development. Damian participated in a number of projects in international environments and possesses practical knowledge of procedures and tools which are necessary for successful implementation of such projects. Now he focuses on building solutions based on Microsoft SQL Server environment (including complex database driven systems, database tuning and optimization).
Bent Pedersen
Twitter: - https://twitter.com/SQLBent
LinkedIn: Bent Pedersen
Contact: http://www.biblog.eu
Bent is a Data Platform MVP and working as Senior Business Analytics Architect at Kapacity A/S, where he have been working with enterprise customers on solutions with SSAS Tabular, SQL Server and in general Azure Data Platform services for the last years. During the past years, he concentrated on working with architecturing, devOps, Automation, testing and simplifying development processes for the Azure Data Platform.
Tomas Tucek
Twitter: - https://twitter.com/ttfromjc
LinkedIn: Tomas Tucek
Contact: http://joyfulcraftsmen.com/blog
More than 10 years in IT spent on custom solution(s) development, mainly for enterprises. Last several years spent in Business Intelligence product/project leading. Passionate in software craftsmenship.
Sponsors
The following is a list of sponsors that helped fund the event: