Nr: 764
SQLSaturday #764 - Bratislava 2018
SessionID: 77386
Event Date: 23-06-2018 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Speaker: Gerhard Brueckl
Abstract:
SessionID: 78780
The Road to The Autonomous Databases
Event Date: 23-06-2018 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Janusz Rokicki
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.
SessionID: 80855
How to build solution for High Availability/Disaster Recovery
Event Date: 23-06-2018 - Session time: 10:30:00 - Track: Strategy and Architecture
Speaker: Marcelo Fernandes
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.
SessionID: 82084
Event Date: 23-06-2018 - Session time: 10:30:00 - Track: Application Database Development
Speaker: Miloš Radivojević
Abstract:
SessionID: 80835
Encryption in SQL Server
Event Date: 23-06-2018 - Session time: 11:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Michal Sadowski
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.
SessionID: 82085
Common Developer Mistakes with SQL Server
Event Date: 23-06-2018 - Session time: 11:45:00 - Track: Application Database Development
Speaker: Miloš Radivojević
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.
SessionID: 77216
Running SQL Server on Linux
Event Date: 23-06-2018 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
Speaker: Marek Chmel
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.
SessionID: 77688
Score a (row) goal and beat a query optimizer
Event Date: 23-06-2018 - Session time: 13:45:00 - Track: Application Database Development
Speaker: Pavel Malek
Title: Score a (row) goal and beat a query optimizer
Abstract:
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!
SessionID: 77236
Bulk Load and Minimal Logging
Event Date: 23-06-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Dean Savović
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.
SessionID: 80853
High availability for SQL Server using Azure as DR site
Event Date: 23-06-2018 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
Speaker: Marcelo Fernandes
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.
SessionID: 77217
Azure Machine Learning in Action
Event Date: 23-06-2018 - Session time: 16:15:00 - Track: Advanced Analysis Techniques
Speaker: Marek Chmel
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.
SessionID: 80834
How to start working in the multiserver environment?
Event Date: 23-06-2018 - Session time: 16:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Michal Sadowski
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!