SQLSaturday #534 - Krakow 2016
Event Date: 10/01/2016 00:00:00
Event Location:
- Qubus Hotel Kraków
- ul. Nadwiślańska 6, Kraków
- Krakow, Lesser Poland 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: (EN) Demystifying clustered indexes
Abstract: If you ask an expert about using a clustered index you will ALWAYS hear: Yes, you need a clustered index for your table. Last but not least Microsoft Azure Databases requires clustered indexes. But clustered indexes are not always a good choice for your database solution because of several different reasons. This session will start a debate about genius and madness of clustered indexes in your application.
This session will run several demos which will show in a very clear way why a clustered index isn’t the best choice in several workload scenarios. “There’s no lunch for free”! Not using clustered indexes will have ONE heavy drawback - this drawback will be demonstrated, too.
The session goal is to make decisions easier for you to use a clustered index or not!
Speaker(s):
- Uwe Ricken
Track and Room: Enterprise Database Administration Deployment - ROOM A
Title: (PL) Refresh a 1TB+ database in under 10 seconds
Abstract: The presentation covers recoverability options in SQL Server over time. It will take us through many different ways of recovering a large 1TB+ database. It will also walk us through many different options for creating development/test/uat environments. It will highlight the benefits and shortcomings of these options while delivering a business value of each. It will also evaluate a high level ROI of each of these options. Finally, the presentation will focus on an architecture based on SAN technologies with respect to SQL Server. I will demonstrate an architecture put in place resolving many business needs in a financial trading environment, working with large data sets and many different environments. This section will highlight the benefits of using SQL Server together with newer SAN solutions and show the potential for reliability, scalability, and the delivery of a high quality HA/DR solution. That is where things get interesting…
Speaker(s):
- Andrzej Pilacik
Track and Room: Enterprise Database Administration Deployment - ROOM C
Title: (EN) Natural Born Killers, Performance Issues to Avoid
Abstract: Learning SQL is easy, mastering it is hard. In this session you’ll learn simple but effective tricks to design your database objects better and write more optimized code. As an attendee you will gain a deeper understanding of common database development and administration mistakes, and how you can avoid them.
Ever thought that you were adhering to best practices but still seeing performance problems? You might well be. In this session I will be covering why the optimizer isn’t using all available processors, when the database engine fails to report all the resources a query has used and why the optimizer doesn’t always use the best plan.
You will leave this session with a list of things that you can check for in your environment to improve performance for your users.
Speaker(s):
- Lord Richard Douglas
Track and Room: Enterprise Database Administration Deployment - ROOM C
Title: (EN) Continuous Integration with SSDT and Team Foundation Server
Abstract: SQL Server Data Tools (SSDT) is Microsoft developer tools for working with SQL Server databases on premises and in the cloud. It supersedes Management Studio in development functionality. Team Foundation Server (TFS) is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. TFS gives you the tools you need to effectively manage software development projects throughout the IT lifecycle. In this session, we are going to focus on the interaction between SSDT and TFS. Developing locally and publishing the changes to an on-premises instance of SQL Server. We will look at how we can do continuous integration between development and other environments pushing the schema changes and upgrading the version numbers in a seamless manner upon successful build of the solution. Furthermore we’ll look at how to lift the integration to an even greater level by using Microsoft Release Management thus automating the deployment and testing of your software.
Speaker(s):
- Regis Baccaro
Track and Room: Enterprise Database Administration Deployment - ROOM B
Title: (EN) NSA Secrets - Hacking SQL Server
Abstract: How easy is it to hack a SQL Server? In this session we’ll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace. We’ll start by gaining access to a SQL Server (using some “creative” ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. Most importantly, we’ll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016. This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level). Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Speaker(s):
- André Melancia
Track and Room: Enterprise Database Administration Deployment - ROOM B
Title: (EN)Upgrade, upgrade more upgrade -know about SQL Server platform upgrade
Abstract: 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 - ROOM C
Title: (PL) How minimal logging can help me?
Abstract: You have probably heard something about switching between FULL and BULK LOGGED recovery models and that it#39;s useful for minimally logged operations. But what exactly are these operations? How can you benefit from them and what conditions have to be met? Are there any downsides?
If you want to speed up data loading you should get familiar with minimal logging. In this sessiion I will show you real life examples (and - well - some not real life) how useful can it be, what downsides it has and how it changed over the SQL Server versions.
Speaker(s):
- Bartosz Ratajczyk
Track and Room: Application Database Development - ROOM B
Title: (EN) When good pages go bad / The rise and fall of db corruption.
Abstract: We#39;ll walk through how to detect and repair corruption in a database. The DBCC command is the most important part and its output will be covered. The different methods to repair the pages gives different amounts of data loss, so we#39;ll go through some of your options such as page level restore, DBCC repair options and some other options. Finally you#39;ll learn to estimate how much data loss you can expect. We#39;ll even going to see how to look at the corrupt page with DBCC PAGE to try to see approximately what data we are going to loose.
Speaker(s):
- Mikael Wedham
Track and Room: Enterprise Database Administration Deployment - ROOM A
Title: (PL) SQL Server talks Hadoop
Abstract: Nowadays (or in near future), when building data warehousing solutions we have to reach data saved on Hadoop nodes. With SQL Server 2016 you can do that leaving Hive, Pig and other animals behind and focus on your current skills. This session, fully packed with demos, will be focused mainly on new SSIS components keeping conversation with our Hadoop servers. I promise, your BI developer life will be easier from now on.
Speaker(s):
- Hubert Kobierzewski
Track and Room: BI Information Delivery - ROOM C
Title: (PL) Think Mobile! Mobile Reporting with Microsoft Data Platform
Abstract: There are some business users wanting the information to be available at hand, wherever they are. A good example is a board member tracking profitability of his/her company on a favourite iPhone. Microsoft Data Platform allows BI developers to build reports and dashboards that can be delivered to the most popular mobile devices in the world (iPhone, iPad, Android devices, Windows devices). The purpose of this session will be to show up the capabilities (but also some caveats) of mobile reporting solutions built with SQL Server 2016 Reporting Services (ex-Datazen) and Power BI.
Speaker(s):
- Pawel Potasinski
Track and Room: BI Platform Architecture, Development Administration - ROOM A
Title: (PL) Optymalizacja zapytań opartych o linked servery
Abstract: Na sesji zostaną om#243;wione następujące kwestie związane bezpośrednio z wydajnością linked server#243;w:
- konfiguracja sieci
- konfiguracja linked server#243;w
- zasady kt#243;rymi kieruje się Query Optimizer przy zapytaniach opartych o linked servery
- zasady i przykłady pisania zapytań opartych o linked servery
Speaker(s):
- Michał Janiec
Track and Room: Enterprise Database Administration Deployment - ROOM B
Title: (PL) Rozwiązywanie problemów i optym. SQL Server przy użyciu Data Collect
Abstract: Data Collection nie jest nowym rozwiązaniem. Możliwość zbudowania hurtowni danych zbierających liczniki, parametry i charakterystykę obciążenia SQL Server jest dostępny od wielu lat. Nie wszyscy jednak wiedzą o jego istnieniu, używają, bądź kupują inne produkty firm trzecich, a może byłoby dobrze poznać to co jest w pudełku z SQL Server? W ramach sesji przedstawimy konfigurację, ale też pokażemy jak korzystać i co można znaleźć w raportach tego rozwiązania, by rozwiązywać bieżące problemy, czy dokonywać optymalizacji SQL Server.
Speaker(s):
- Agnieszka Cieplak
Track and Room: Enterprise Database Administration Deployment - ROOM C
Title: (EN) Automating the testing of your BI solutions with NBi
Abstract: If you want to accelerate the testing of your BI solutions, the best strategy is the automation of your tests with the help of a dedicated framework. During this session, we’ll take a look to the features of the open-source framework named “NBi” (www.nbi.io). This framework is providing support for automated tests on the fields of databases, cubes, reports and ETLs, without the need of .Net skills. The demos will show us the best approaches to quickly and effectively assert the quality of BI developments. We’ll go a step further, generating the tests by an interesting system of templates and test-cases sources.
Speaker(s):
- Cédric Charlier
Track and Room: BI Platform Architecture, Development Administration - ROOM A
Title: (EN) Microsoft R Server
Abstract: R is the world’s most widely-used programming language for data analysis. SQL Server is say to be the most popular (or at least the fastest growing) DB engine. Guess, how popular MRS (Microsoft R Server) is going to be… In this demo heavy session Marcin Szeliga will introduce you to the fundamentals of Microsoft R Server, it’s native file format XDF (eXternal Data Frame), data manipulation functions, and machine learning algorithms. Don’t miss the opportunity to see how MSR addresses open source R scalability and performance issues.
Speaker(s):
- Marcin Szeliga
Track and Room: Advanced Analysis Techniques - ROOM A
Title: (PL) Diving into hyperspace - how to make better OLAP calculation
Abstract: Fully additive measures and simple x minus y plus z formulas exist only in simple cubes. Business requirements are growing at very high rate. Complicated calculations with many conditions are needed - for months divide by 30, for quarters by 90, for years by…no… for years display nothing etc. And what about what-if analysis, simulations? The solution is only one. You must become an MDX Hero and dive deeply into multidimensional space of your cube. In my session I will present some real life analytical examples utilizing the SCOPE instruction - a truly hyperdrive for SSAS developer.
Speaker(s):
- Grzegorz Stolecki
Track and Room: BI Platform Architecture, Development Administration - ROOM A
Title: (EN) Hidden gems of SQL Server 2014
Abstract: SQL Server 2014 is full of new features and improvements. Some of them are “Killer” features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight.
In this session, we will learn a lot about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and other overshadowed features will be covered in this session.
As a small bonus, we will talk a bit how these features are improved in SQL Server 2016.
Speaker(s):
- Denis Reznik
Track and Room: Application Database Development - ROOM C
Title: (EN) Azure SQL Data Warehouse: Deep Dive
Abstract: This is advanced topic about Azure SQL Data Warehouse. Here I will cover main concepts like Data Movement, Workload concurrency, Resource Management, Statistics.
Speaker(s):
- Sergiy Lunyakin
Track and Room: BI Platform Architecture, Development Administration - ROOM A
Title: (PL) 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 - ROOM B
Title: (EN) Effective Index Partitioning, Compression Strategy
Abstract: We all know that ‘Indexing’ is KING when it comes to achieving high levels of performance in SQL Server. When Indexing also combines 2 of the Enterprise features: Partitioning Compression, we can often see substantial gains.
Learn how to identify those objects that benefit greatly from being Partitioned or Compressed, OR combining both of these features to even greater effect.
Using Demos to illustrate the performance gains with real-world examples, Take away advanced scripts for use in your own environments.
Speaker(s):
- Neil Hambly
Track and Room: Enterprise Database Administration Deployment - ROOM C
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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
Cédric Charlier
Twitter: - @Seddryck
LinkedIn: Cédric Charlier
Contact: http://seddryck.wordpress.com
Cédric is a talented architect and Data Platform MVP active in the domain of Business Intelligence and Data warehousing. He has more than 10 years of successful experiences with SQL Server in European industrial groups and services companies. Driven by quality and reliability, he is the main developer of an open-source solution for testing BI solutions (cubes, etl, reports) named NBi (www.nbi.io). Cedric also advocates for the introduction and general usage of agile practices in BI’s world.
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.
André Melancia
Twitter: - AndyPT
LinkedIn: André Melancia
Contact: http://Andy.PT
Owner / Principal Consultant at LunarCat.PT Microsoft Certified Trainer (MCT) focusing on SQL Server, Azure, IoT and Security.
19+ years’ fun developing information and multimedia systems, DBA, project and IT management.
Data Community Portugal, IT Pro Portugal and PowerShell Portugal communities organiser. IPv6 Portugal, DNSSec Portugal and Windows Development Portugal online communities moderator. Actively volunteering, organising, speaking or just participating at community meetings and events around the world.
Proud uncle and food devouring expert, with dangerous рuϧϧy cat as companion.
Go to http://Andy.PT and you’ll know the same as the NSA…
Kamil Nowinski
Twitter: - @NowinskiK
LinkedIn: Kamil Nowinski
Contact: https://sqlplayer.net
Blogger, speaker, #sqlfamily member. Microsoft Data Platform MVP. Data passionate, Data engineer and Architect. Over 13 years of programming and experience with SQL Server databases, he worked both as developer and administrator big databases designing systems from the scratch. Passionate about tuning database engines, code transparency and maximising performance database engine. Currently, he is expanding new horizons as a contractor in the UK market, making troubleshooting, prototyping BI and Big Data solutions, enhancing existing processes among Microsoft stuff environments, popularizing the DevOps approach and efficient solutions in the cloud. An originator of the “Ask SQL Family” podcast and founder of SQLPlayer blog.
Andrzej Pilacik
Twitter: - cypisek77
LinkedIn: Andrzej Pilacik
Database Manger / Solution Architect at BraceBridge Capital 15 years of experience in Database Platforms, SQL Server 7.0 - 2019, PostgreSQL, Redis, Oracle Microsoft Certified Professional - SQL Server Working with large data in Healthcare, Insurance, and Financial Sectors Architecting HA/DR solutions Developing frameworks around DEVOPS Working with DW, SSIS, SSRS
Michał Janiec
LinkedIn: Michał Janiec
Contact: http://SQLinspirations.com
Od kilku lat pracuję jako administrator SQL Server i programista T-SQL. Posiadam kilka certyfikat#243;w związanych z bazami danych m. in. MCITP DBA oraz DEV. Jestem nastawiony na proaktywne wykrywanie i zapobieganie problem#243;w z silnikiem bazy danych. Moje gł#243;wne zainteresowania zawodowe to poprawna konfiguracja serwera, optymalizacja zapytań, troubleshooting oraz monitoring. W wolnych chwilach biegam oraz czytam książki z zakresu psychologii.
Bartosz Ratajczyk
Twitter: - @b_ratajczyk
LinkedIn: Bartosz Ratajczyk
Contact: http://blog.bartekr.net/
Database developer and (sometimes) administrator working with SQL Server Data Platform. Currently focusing on ETL development, delivery automation using TFS, query tuning, SQL Server training. Data Community Poland (DC) member, local group and conference speaker.
Agnieszka Cieplak
Twitter: - https://twitter.com/AgCieplak
LinkedIn: Agnieszka Cieplak
Database administrator, Data Community Poland - Lublin chapter leader.
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.
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.
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.
Uwe Ricken
Twitter: - https://twitter.com/dbBerater
LinkedIn: Uwe Ricken
Contact: http://www.sqlmaster.de
Uwe Ricken is working with IT systems since the 90’s. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he achieved the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification. In the same year he earned his first award as a Data Platform MVP for his support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken is a speaker on many international conferences and events and preferred topics are “Database Internals”, “Indexing” and “Development”.
Lord Richard Douglas
Twitter: - SQLRich
LinkedIn: Lord Richard Douglas
Contact: http://SQL.RichardDouglas.co.uk
Lord Richard Douglas is a Principal Solutions Engineer at SentryOne, where he specialises in the SQL Server product range. He has worked with SQL Server since version 7.0 in various developer and DBA roles and holds a number of Microsoft certifications. Richard is a keen member of the SQL Server community, having run a PASS Chapter in the UK and having served on the organizing committee for SQLRelay. Richard is on Twitter as @SQLRich.
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.
Marcin Szeliga
LinkedIn: Marcin Szeliga
Data Philosopher. Since 2006 invariably awarded Microsoft Most Valuable Professional title in the Data Platform category. A speaker at numerous conferences across Europe, as well as at user groups meetings. The author of many books and articles devoted to Microsoft Data Platform. An independent consultant, database-centric application practitioner and architect totally focused on SQL Server and Azure. Huge fan of Data Science and Machine Learning.
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.
Neil Hambly
Twitter: - Neil_Hambly
LinkedIn: Neil Hambly
Contact: http://dataidol.com/NeilHambly
Neil Hambly is a SQL Server consultant, founder and consultant at Datamovements, a Gold Microsoft Data Analytics Consulting company. Neil has 20+ years in a variety of SQL Server roles and is an MCT. He is a regular presenter (200+ events) at user groups, and PASS events, including PASS Summit and SQLSaturday, and many UK events (SQLBits, SQLRelay). Neil is the leader of PASS London (UK), a Professional Development VC, a Melissa Data MVP, and a SQL Cruise Technical Lead, who loves Guinness, whisky, and dancing.
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).
Sponsors
The following is a list of sponsors that helped fund the event: