SQLSaturday 712

South Island NZ, New Zealand

PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. This event will be held on May 26 2018 at Ara Institute of Canterbury, 130 Madras Street, Christchurch, Canterbury, 8011, New Zealand

Register Now

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.


Register here:


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.

Topics Include:

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.



Register here:


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.


Register here:


Event Location

Event news

No Event News entered. Please come back later and check again


Profile Image

Contact The Organizer

Send Message

XML Icon

XML Feed

Access event's XML feed

View Feed

Connect With Us

What is a PASS SQLSaturday?

PASS SQLSaturdays are local events organized by PASS community members around the world. PASS is a not-for-profit association for data professionals who leverage the Microsoft Data Platform, offering interactive learning built by community and guided by trusted data experts.

Back to Top cage-aids