SQLSaturday #764 - Bratislava 2018
Event Date: 06/23/2018 00:00:00
Event Location:
- Microsoft Slovakia s.r.o.
- Apollo Business Center II, Block E, Prievozská 4D, Bratislava
- Bratislava, Bratislavský, Slovakia
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: The Road to The Autonomous Databases
Abstract: Autonomous means capable of existing independently. Think maintenance free, self-healing, auto-tuning databases able to detect and automatically mitigate security risks. Sounds like impossible dream, but here is the best part - Azure is gradually making that next level of automation possible. Cloud economy of scale combined with unique features of Azure PaaS resources transform and enhance the way we collect, store and process data. And that also affects our professional lives. Find out where we are on The Road to The Autonomous Databases, what are main building blocks, what kind of obstacles we still have to overcome and how to turn these challenges into opportunities.
Speaker(s):
- Janusz Rokicki
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: High availability for SQL Server using Azure as DR site
Abstract: In this session we will present the union of the local environment and the cloud and show the integration between these environments. The cloud is already a reality and we still have several environments that must remain in local environments due to legislation or company rules. In this session you will see that it is possible to maintain both environments.
Speaker(s):
- Marcelo Fernandes
Track and Room: Cloud Application Development Deployment - Borneo
Title: How to build solution for High Availability/Disaster Recovery
Abstract: How does your SQL Server environment meet the RPO and RTO service levels? In this session, we will cover all aspects of HA / DR. We will cover all technology options and compare the benefits between them. We will also talk about processes to maintain your RPO and RTO level.
Speaker(s):
- Marcelo Fernandes
Track and Room: Strategy and Architecture - Madagascar
Title: Running SQL Server on Linux
Abstract: New SQL Server will run on Linux, and in this session we’ll explore the options which are already available for us. We’ll see how to start and manage SQL server on Linux even with high availability.
Speaker(s):
- Marek Chmel
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: Performance Tuning with SQL Server 2017
Abstract: Each new SQL Server version brings some performance improvements. In this session, you will see new SQL Server 2017 features that can not only improve performance of your queries, but also performance and query troubleshooting process.
Speaker(s):
- Miloš Radivojević
Track and Room: Application Database Development - Borneo
Title: Bulk Load and Minimal Logging
Abstract: Session subject is bulk load and minimal logging. I will show you on various demos how bulk load and minimal logging behieves on heap and cluster tables, in-memory tables, clustered and non-clustered columnstore tables and on all combinations as well.
Speaker(s):
- Dean Savović
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: Score a (row) goal and beat a query optimizer
Abstract: Query optimizer is a magical piece of architecture inside SQL Server which instructs the engine how your query is going to be executed. It performs a great job …unless it doesn’t.
In this session we will have a deep look on cases where the query optimizer fails and explain why is it happening. Expect to see a real code written by real developers which will be tuned just in front of you to perform several times faster. If you want to (or possibly need to) take control of execution plan, this session is right for you!
Speaker(s):
- Pavel Malek
Track and Room: Application Database Development - Borneo
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: Advanced Analysis Techniques - Borneo
Title: Common Developer Mistakes with SQL Server
Abstract: In this session, you will be advised how to avoid common developer mistakes when working with SQL Server. You will see common mistakes made by developers during table design, writing queries and script deployment.
Speaker(s):
- Miloš Radivojević
Track and Room: Application Database Development - Borneo
Title: How to start working in the multiserver environment?
Abstract: For several years you have been working as a database administrator with few Microsoft SQL Server instances and you have moved to a new project where there is a need to consolidate hundreds of instances. How to tackle this problem? On the session, I will show how to discover, check configuration, apply all best practices and introduce best in class maintenance tasks. And all of that using free community-based tools!
Speaker(s):
- Michal Sadowski
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: Encryption in SQL Server
Abstract: An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.
Speaker(s):
- Michal Sadowski
Track and Room: Enterprise Database Administration Deployment - Madagascar
Title: Building an Analytics Platform in Azure
Abstract: Even though the Cloud is becoming more popular every day, most companies still want to host their Data Platform on-premises. However, the Cloud also offers huge potential in this area and technologies and tools - some of them only exist in the Cloud at all! This session focuses purely on Microsoft Azure and the services it provides to build a scalable, powerful and yet low-cost Analytics Platform in the Cloud. Based on a real-world scenario I will show how these components play together and how on-premises data and can be integrated into this pure Cloud system.
Speaker(s):
- Gerhard Brueckl
Track and Room: Cloud Application Development Deployment - Borneo
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.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
Dean Savović
Twitter: - https://twitter.com/dsavovic
LinkedIn: Dean Savović
Contact: http://www.savovic.com.hr
Dean is Senior DBA practicing SQL Server since version 7.0 and main areas of interest are performance tuning and troubleshooting SQL Server database. He speaks at Microsoft Windays Croatia, ATD Croatia, SSWUG, KulenDayz Croatia, SQLSaturday events, etc… Primary focus is on OLTP databases with occasional adventures with Business Intelligence. He finished Faculty of Electrical Engineering and Computing and MBA on Faculty of Economics in Zagreb. His premise was that it is very useful to combine technical knowledge with management process knowledge that help us in our everyday work. He works in SPAN which is specialized in data management field on Microsoft SQL Server.
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.
Miloš Radivojević
Twitter: - MilosSQL
LinkedIn: Miloš Radivojević
Contact: https://milossql.wordpress.com/
Miloš Radivojević is a database consultant located in Vienna, Austria. He is Data Platform MVP and specializes in SQL Server for application developers and performance and query tuning. Currently, he works as a principal database consultant in bwin GVC (the largest regulated online gaming company in the world). He is co-founder of the SQL Pass Austria and speaks regularly at local and international database conferences. He is also co-author of the books SQL Server 2016 Developer’s Guide, SQL Server 2017 Developer’s Guide and Mastering SQL Server 2017.
Marcelo Fernandes
Twitter: - marcelodba
LinkedIn: Marcelo Fernandes
Contact: http://marcelodba.wordpress.com
Marcelo Fernandes is SQL Server MVP and has 12+ years experience with databases, specialized in High Availability, critical missions and very large databases. He holds the MCP / MCDBA / MCSA / MCTS / MCITP and MCT certifications, he lives and works in Berlin for an American e-commerce company that sells home goods. He share their knowledge through webcasts, presentations and articles on Microsoft technologies and can be cantacted by email fernandes_dba@hotmail.com or twitter @ marcelodba
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.
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.
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.
Janusz Rokicki
Twitter: - DataSic
LinkedIn: Janusz Rokicki
Contact: https://www.datasic.com/
Microsoft Data Platform Expert and certified Azure Solutions Architect with over 12 years’ experience working in the City of London in the Financial Services Industry (retail and investment banking, multi-asset class trading systems). He has passion for secure, high-performance, maintainable data-driven applications that can be deployed with confidence on-premises and in-cloud. With educational background in intelligent sensor networks and machine learning he is always in search of automation and optimisation opportunities.
Has presented at SqlBits, PASS Summit, SqlDay and multiple SQLSaturday events (Tel-Aviv, Kiev, Paris, Tallinn, Bonn, Bratislava, Goteborg, Kharkiv, Bucharest, Sofia, Ljubljana) and user groups.
Pavel Malek
Twitter: - malekpav
Pavel has worked with SQL server for the past 10 years as a programmer, lead infrastructure DBA and team-leader in the largest Czech bank. During that time, he got an experience in planning, implementing and maintaining large-scale environment with hundreds of multi terabytes databases. His main points of interests include HA/DR solutions, T-SQL performance tuning and CI/CD.
Pavel also runs a local SQL Server group in Czech Republic and helps to organize a SQLSaturday in Prague.
Pavel runs a local SQL Server group in Czech Republic and helps to organize a SQLSaturday in Prague.
Sponsors
The following is a list of sponsors that helped fund the event: