We are pleased to announce our three precons - on Friday 25th May 2018:
1. Machine Learning with SQL Server
Thinking about getting involved with Machine Learning(ML) and are unsure what it can do? This session provides answers to the question: Where can ML provide a solution? As it is important to understand the limitations of ML, the course also reviews when other analytic processes would work better. Learn the steps to ensure that your data is suited for ML analysis and what you can do to fix it. Once attendees understand the workflow, the course will cover the processes used in algorithm selection. We will implement ML solutions in both R and Python to show the strengths and limitations of each in SQL Server 2017.
In this session attendees will learn:
- The machine learning workflow
- The techniques and algorithms used in creating solutions
- The implementation techniques in R and Python and deploy solutions in SQL Server.
Since the release of SQL Server 2017, Microsoft now supports both R and Python. In this course we will cover the strengths and weaknesses of each language so that you can make an informed choice which is the right tool for the job. During this class I will also provide the answer to a question commonly asked by people starting to learn data science, if you only are going to learn one language, R or Python, which one should you choose?
There are some steps to follow to help simplify which algorithm to use, which can speed up the design process. Once you have created your machine learning solution, you will learn how to implement it in SQL Server, monitor the ongoing performance of SQL Server and configure the server to optimally configure the Machine Learning Services of SQL Server 2017, without adversely impacting the overall performance of SQL Server.
2. Practical SQL Server Performance Tuning
This practical Performance Troubleshooting Pre-Con is designed for the working SQL Server professional who has the some experience with SQL Server and only needs practical examples of troubleshooting SQL Server performance that can be applied in production right away.
In this full-day training, participants will see relevant, crisp, real-world examples of common performance areas.
An 8-hour, 100% demo-oriented delivery on SQL Server Performance Troubleshooting.
Basic to Intermediate level, covering important aspects.
Module 1: CPU Troubleshooting (Scheduling)
Module 2: IO Troubleshooting
Module 3: Memory Troubleshooting
Module 4: Tempdb Troubleshooting
Module 5: Dealing with Deadlocks
Module 6: Troubleshooting Indexes.
3. Designing and Implementing a Database Management Strategy for Azure PaaS Databases
Although Microsoft sells its Azure PaaS Database offerings on the basis of minimal administrative effort, how do you know for sure how things are running smoothly and if you are getting the optimum value for money from your investment.
Your first port of call is identifying which option you should be moving to. As well as Azure SQL DB, there is now Elastic Pools, Managed Instances and even PaaS options for MySQL, PostgreSQL and MariaDB.
Each of these has differences to the boxed product and you’ll learn the most important of these. There are some tools available to help with the decision of which offering and performance tier you will need. Depending upon which offering you choose, there are some exciting new utilities built in that can help with aspects of tuning and security.
Once your database is up and running in Azure, is that the end of the traditional DBA activities? You will see how that supposition can lead to big trouble and inflate your costs. The utilities we’ve examined don’t cover all the management tasks but looking beyond the PaaS Database resources, we find that Azure does also provide a number of additional services that can allow us to gain insights and use these to proactively monitor and manage your databases.
You will leave this session with a better story for your manager to convince him to move your workload to Azure and lower your total SQL Server costs.