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