sqlsathistory

Nr: 456

Back to Main list

SQLSaturday #456 - Auckland 2015

Start Time (24h) Speaker Track Title
10:00:00 Leila Etaati SQL Saturday Main Track Being Smarter with Azure Machine Learning
11:00:00 Warwick Rudd SQL Saturday Main Track Mission Critical SQL Server and You
13:00:00 Aben Samuel SQL Saturday Main Track Deep dive into Running SQL Platform on Azure IAAS
13:00:00 Martin Catherall SQL Saturday Main Track SQL Developer Tips and Tricks
14:00:00 Dave Dustin SQL Saturday Main Track Myths and misconceptions
15:30:00 Reza Rad SQL Saturday Main Track Power BI; Amazing Things You Can Do

SessionID: 39807

Being Smarter with Azure Machine Learning

Back to calendar

Event Date: 03-10-2015 - Session time: 10:00:00 - Track: SQL Saturday Main Track

Speaker: Leila Etaati

Title: Being Smarter with Azure Machine Learning

Abstract:

Machine Learning is a subfield of computer science which is so pervasive today that you probably use it dozens of times a day without knowing it. Azure Machine Learning is a valuable tool that can be employed by data scientists with different skill levels. Azure ML also supports R and Python custom code, which can be dropped directly into your workspace. In this session, I will show a demo of using Azure ML with R. Audience will learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, choose the right algorithm, and then finally to the integration of predictive insights.

SessionID: 38049

Mission Critical SQL Server and You

Back to calendar

Event Date: 03-10-2015 - Session time: 11:00:00 - Track: SQL Saturday Main Track

Speaker: Warwick Rudd

Title: Mission Critical SQL Server and You

Abstract:

Mission Critical systems require High Availability, High Performance High Security of the data, which is the most important part of your company. Could you survive if your environment did not have these?

In this session I will look at the options available to you to meet your High Availability, High Performance High Security requirements using some of the new and enhanced features being released in SQL Server 2016 to build better mission critical environments.

SessionID: 37918

Deep dive into Running SQL Platform on Azure IAAS

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: SQL Saturday Main Track

Speaker: Aben Samuel

Title: Deep dive into Running SQL Platform on Azure IAAS

Abstract:

In this deep dive session, we dig in on SQL Server VM troubleshooting, best practices and configurations across multiple scenarios.In this demo packed session learn about Performance Tuning, end to end High Availability and Disaster Recovery and look at some of the Hybrid Scenarios and Features.

SessionID: 40295

SQL Developer Tips and Tricks

Back to calendar

Event Date: 03-10-2015 - Session time: 13:00:00 - Track: SQL Saturday Main Track

Speaker: Martin Catherall

Title: SQL Developer Tips and Tricks

Abstract:

Martin has seen life from a few different sides of the database environment. Often the world of TSQL and DBA are seen from vastly different viewpoints – but it doesn’t have to be this way. Join Martin to find out some ways that these two groups can enhance each other’s life and work as efficiently as possible. We’ll examine a range of tip during this presentation that most SQL professionals should get value from.

SessionID: 40163

Myths and misconceptions

Back to calendar

Event Date: 03-10-2015 - Session time: 14:00:00 - Track: SQL Saturday Main Track

Speaker: Dave Dustin

Title: Myths and misconceptions

Abstract:

There are a great many theories, anti-patterns and just plain wrong ideas that people (mostly Devs, but including DBAs) believe about SQL Server. Yes, it’s enterprise ready. No, it doesn’t magically tune/tweak itself (it needs some lovin’ from time to time (just nowhere near as much as Oracle)). We’re going to look into debunking some of these falsehoods.

SessionID: 39797

Power BI; Amazing Things You Can Do

Back to calendar

Event Date: 03-10-2015 - Session time: 15:30:00 - Track: SQL Saturday Main Track

Speaker: Reza Rad

Title: Power BI; Amazing Things You Can Do

Abstract:

Power Query, Power View, and Power Pivot has been in the BI market for a while. Microsoft combined these three products into a single product and service with a new designer called Power BI Desktop (Power BI Designer). Power BI gathered features of these three products all in one, so building dashboards and effective visualization items with this tool is much easier nowadays. In this session you will learn all new and great features of Power BI. You will learn how to work with different data source, and apply Power Query transformation on them. You will learn tricks and tips of modelling with Power BI Desktop, and then how to visualize effectively with this tool. You will also learn how to build dashboards on Power BI website. At the end of this session you will be able to use Power BI for your everyday data analysis as well as organizational data mash up and visualization. So expect lots of demos in this session.