SQLSaturday #664 - Katowice 2017

Event Date: 09/16/2017 00:00:00

Event Location:

  • Wyższa Szkoła Bankowa (WSB University)
  • ul. Sportowa 29
  • Chorzow, Silesian Voivodeship, Poland

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: 2,4,8 16 - Upgrade your journey with SQL Server

Abstract: 2,4,8 16 - these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade? Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading SQL Server (2000 to 2012), SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

A popular session that I have been presenting since the year 2008, in MS Tech-Ed, SQLSaturday SQLbits UK. We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why how such a solution.

Speaker(s):

  • Satya Jayanty

Track and Room: Enterprise Database Administration Deployment - Aula A


Title: SQL Server Performance Tuning Nowadays

Abstract: Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it’s time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning.

In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. And despite I’m a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.

Speaker(s):

  • Denis Reznik

Track and Room: Enterprise Database Administration Deployment - Aula A


Title: Tuning large queries

Abstract: Tuning large queries is going to show techniques and tools that allow to find optimizing solution when query plan is large. Multiple joins, function calls, many views and inline functions is what I call complex plan. In this short session I will try to tune large queries with multiple techniques.

Speaker(s):

  • Grzegorz Łyp

Track and Room: Enterprise Database Administration Deployment - Sala 6


Title: A Masters view on Locking and blocking

Abstract: How do the wait stats show you that you have a locking issue? This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.

Speaker(s):

  • Mikael Wedham

Track and Room: Enterprise Database Administration Deployment - Aula A


Title: SSIS – Transform Your Data in Parallel

Abstract: There are few DWH environments out there which struggle with their data loading window and whole night is not enough for them to push all fresh data to those hungry star schemas. Since SQL Server 2016 we may speed up things by enabling new way of dealing with data processing – SSIS Scale Out. This full-of-demos session will show you how to set up workers, establish communication, split your workload among them in attempt to shorten execution times and where to find additional log files. This session will show you if parallel processing is the future of ETL in Microsoft world of data.

Speaker(s):

  • Hubert Kobierzewski

Track and Room: BI Platform Architecture, Development Administration - Aula B


Title: Reporting Services Power BI Server

Abstract: Microsoft finally released Power BI Server - on-premise platform for Power BI solutions. During the session I’m going to explain licensing model and show how to use it. Finally, I’ll compare Power BI cloud service and on-premise capabilities.

Speaker(s):

  • Tomasz Libera

Track and Room: Analytics and Visualization - Aula B


Title: Build your first bot – no code required!

Abstract: Learn how to build a bot that will answer questions asked by users. Learn how to customise it and embed it on your website. Learn how to do all of this without having to write a single line of code.

I’ll be using Microsoft’s qnamaker.io site to build an FAQ bot and the putting it live with an Azure Bot Service and the Skype Web Control. The end result is a little snippet you can add to any web page, making implementation a breeze.

You can follow along as I build the bot live, or just soak it all in. Either way, you’ll see how easy it is to build a bot and you’ll know the next steps to follow to start building more complex bots.

Speaker(s):

  • Stephanie Locke

Track and Room: Information Delivery - Aula A


Title: R’em All. Use R in Power BI to Deal with Data

Abstract: R becomes a commodity in Microsoft Data Platform, including Power BI as one of this platform’s elements. By learning R data analysts and BI developers can significantly expand capabilities of Power BI, and perform much more sophisticated analysis. R can be used for getting data, for data transformations, for analysis with additional power of statistics and predictive algorithms, and finally for nontrivial visualizations. The purpose of this session is to showcase some step by step examples of how R code can be an integrated part of Power BI reports, as well as provide several scenarios in which R brings more power into Power BI.

Speaker(s):

  • Pawel Potasinski

Track and Room: Analytics and Visualization - Aula B


Speakers

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

Satya Jayanty

Twitter: - sqlmaster

LinkedIn: Satya Jayanty

Contact: http://www.sqlserver-qa.net

My experience surrounded with high focus on the data platform with a track record of defining strategy, designing and delivering digital transformation migrations with major enhancements to current working methods. Worked in a capacity of Head of Data Engineering, Enterprise Data Architect and Solutions

Key career accomplishment recognition as an industry expert technical excellence from the Microsoft as Data Platform Most Valuable Professional (MVP) recognition since the year 2006 (13 years as MVP and counting), which recognizes exceptional technical community leaders worldwide who actively deliver, present share their extraordinary contributions, high quality, and real-world expertise. Twitter pod (http://twitter.com/sqlmast

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

Mikael Wedham

Twitter: - @wedham

Contact: http://www.wedham.com

Mikael Wedham is the first SQL Server MCM in Sweden and the only one who also is a Microsoft Certified Trainer. He has been paid to do things in SQL Server since 1993. His long experience makes him an appreciated speaker at events and conferences all over Europe. To be prepared for deep dives, he is also certified as an Open Water Scuba Instructor.

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.

Stephanie Locke

Twitter: - @stefflocke

LinkedIn: Stephanie Locke

Contact: https://itsalocke.com

Steph Locke leads a life of data, coffee, books and board games. During the day, Steph runs her own consultancy helping people start doing data science. Steph enjoys being her own gal as it means she gets to spend plenty of time building communities to provide platforms for people to help each other be better with data.

Grzegorz Łyp

Twitter: - @GrzegorzLyp

LinkedIn: Grzegorz Łyp

Contact: http://www.lyp.pl/blog

SQL Server Database Engine tuning enthusiast. Product Manager and Team Leader at Asseco Business Solutions. Developing SQL Database Engine enterprise scale solutions for 10 years.

Sergiy Lunyakin

Twitter: - slunyakin

LinkedIn: Sergiy Lunyakin

Contact: https://slunyakin.wordpress.com

Sergiy Lunyakin (MCSA, MCSE, MCTS) is a Big Data Architect at SoftServe, Inc. He has extensive experience in designing and developing Big Data Analytics, Data Warehouse, and BI solutions, using both on-premises and cloud products. In 2016, Sergiy became Microsoft Data Platform MVP and has since maintained his MVP status. Sharing knowledge is another one of his passions. He regularly speaks at international conferences such as SQLSaturday, SQLDay, SQLNexus, and SQLBits. He also runs the Lviv SQL Server User Group in Ukraine and organizes SQLSaturday Lviv.

David Postlethwaite

Twitter: - @postledm

LinkedIn: David Postlethwaite

Contact: http://www.gethynellis.com/

David Postlethwaite has been a DBA for Liverpool Victoria in Bournemouth, England since 2008 He supports both Oracle and SQL Server from 2000 to 2017, DBMS, SSIS, SSAS and Reporting Services. In 2015 David built and deployed the company’s first cloud solution using Microsoft Azure SQL Database and web services

Before becoming a DBA David was a .NET developer and way back in history a Windows and Netware administrator.

He is an occasional blogger on www.gethynellis.com

David is a regular speaker for SQLSaturday. Most of his presentations can be found on his YouTube channel www.youtube.com/c/DavidPostlethwaiteSQL

Pawel Potasinski

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

LinkedIn: Pawel Potasinski

Contact: http://blog.sqlgeek.pl

CTO at Elitmind. Focused on determining the company’s technological directions and transforming Clients into successful data driven organizations. Former Microsoft employee (Data Insights Product Manager for Poland). In 2007 Pawel started Polish SQL Server User Group (PLSSUG), currently known as Data Community Poland, an official PASS Chapter in Poland. Pawel has been a speaker at many conferences in Poland and worldwide (e.g. SQLDay, SQLSaturday, European PASS Conference). He has been awarded with Microsoft Most Valuable Professional (MVP) sixtimes in his career. Father of three. Avid runner.

Hubert Kobierzewski

LinkedIn: Hubert Kobierzewski

Hubert works at Codec-dss as BI Practice Lead. He helps customers to gather their data and convert it into valuable information using Microsoft Data Platform technologies. Hubert is also a board member of Data Community Poland and a leader of Warsaw Power BI User Group.

Agnieszka Cieplak

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

LinkedIn: Agnieszka Cieplak

Database administrator, Data Community Poland - Lublin chapter leader.

Andrzej Kukula

Twitter: - @andrzejkukula

LinkedIn: Andrzej Kukula

Consultant and trainer in SQLExpert.pl with more than 20 years of IT experience. Architect of HA/DR solutions, BI solutions, Data Platform solutions, cloud solutions. Solves SQL Server related problems, including performance tuning. Passionate about SQL Server and programming. Speaker at various conferences including SQLSaturday, SQLDay, SQLNexus, AzureDay, Global Azure Bootcamp and local user groups.

Marek Maśko

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

LinkedIn: Marek Maśko

Contact: http://blog.sqlterritory.com/

Marek works as a Principal Database Analyst at Sabre Polska where he is developing a database solution for flight planning system. He supports teams of developers, testers, delivery, and technical support staff in this large international project. Fan of query optimization and exploration of knowledge about SQL Server Internals. He professionally works on databases and in particular with SQL Server since 2010. Earlier, a Java and C# coder. An active member of the Krakow chapter of the Polish Data Community. Marek is MCSE: Data Platform and MCSE: Data Management and Analytics.

Denis Reznik

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

LinkedIn: Denis Reznik

Contact: http://reznik.uneta.com.ua

Denis Reznik is a Data Architect at Intapp, Inc. He has more than ten years experience in software development, database design, and performance tuning for cloud and on-premises solutions. In 2010 Denis became Microsoft Data Platform MVP and maintains MVP status today. Apart from his professional career, Denis actively participates in the development of the Ukrainian Data Community.

Tomasz Libera

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

LinkedIn: Tomasz Libera

MVP Data Platform, MCT, leader of Krakow Data Community Poland user group. Organizer of SQLDay and SQLSaturday conferences. SQL Server Developer and academic trainer. Speaker at group meetings and conferences.

LEONEL ABREU

Twitter: - leonel_abreu

LinkedIn: LEONEL ABREU

An IT Pro who likes to play chess and baseball.

System Engineer degree since 2007, formerly Data Warehousing teacher at university levels from 2008 to 2009. Microsoft Student Partner during the years 2006 - 2007, Second Place in Microsoft Andean Imagine Cup (2006), MCTS, MCITP and MCP with over a decade of experience with SQL Server, working in BI, DBA, Database Development, .net Development, SharePoint and other several areas.

Since 2014 based in Barcelona, Spain. Learning enthusiast and always with passion for new technologies and new challenges.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page