sqlsathistory

Nr: 713

Back to Main list

SQLSaturday #713 - Brisbane 2018

Start Time (24h)	Speaker	Track	Title
09:00:00	Ginger Grant	Advanced Analysis Techniques	Machine Learning with SQL Server
09:00:00	Amit R S Bansal	Enterprise Database Administration Deployment	Practical SQL Server Performance Tuning
09:40:00	Gilbert Quevauvilliers	BI Information Delivery	Intro into Power BI
09:40:00	Martin Catherall	Strategy and Architecture	Data Privacy and the Data Professional.
09:40:00	Greg Low	Application Database Development	Tips and Tricks for Using SQL Server Management Studio Effectively
11:00:00	Manohar Punna	Advanced Analysis Techniques	Real-Time Analytics with Power BI
11:00:00	Henry Rooney	Strategy and Architecture	SQL Server Managed Instance, the PaaS Instance Offering
11:00:00	Michael van Halderen	Enterprise Database Administration Deployment	Configuring AlwaysOn Availability Groups exclusively in Azure, using IaaS.
13:30:00	Phillip Seamark	BI Platform Architecture, Development Administration	Advanced DAX for the SQL Professional
13:30:00	Anupama Natarajan	Cloud Application Development Deployment	Modern Data Warehouse using Lambda Architecture and Azure
13:30:00	Amit R S Bansal	Enterprise Database Administration Deployment	Troubleshooting SQL Server Memory Issues
14:50:00	Martin Cairney	Cloud Application Development Deployment	Hybrid Distributed Architecture with Azure Data Sync 2.0
14:50:00	Gogula Aryalingam	BI Platform Architecture, Development Administration	BI is a Journey, Not a Destination
14:50:00	Hamish Watson	Application Database Development	Test Driven Development in SQL Server – how to deploy code safer
14:50:00	Ginger Grant	Advanced Analysis Techniques	Implementing Python in SQL Server 2017
16:00:00	Patrick Flynn	Enterprise Database Administration Deployment	DBATools! The reason to finally start learning and using Powershell
16:00:00	Benjamin Nevarez	Application Database Development	Dive into the Query Optimizer - Undocumented Insight
16:00:00	Craig Bryden	BI Information Delivery	SSRS and Power BI Report Server - What's New

SessionID: 70695

Machine Learning with SQL Server

Back to calendar

Event Date: 02-06-2018 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Machine Learning with SQL Server

Abstract:

Thinking about getting involved with Machine Learning(ML) and are unsure what it can do? This session provides answers the question: Where can ML can 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.

Session Goals • Understand the Machine Learning development process including data analytics and algorithm selection • Learn why to use either R or Python given the task being performed • Know how to implement a machine learning solution as part of database solution in SQL Server .

SessionID: 80112

Practical SQL Server Performance Tuning

Back to calendar

Event Date: 02-06-2018 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Amit R S Bansal

Title: Practical SQL Server Performance Tuning

Abstract:

Practical SQL Server Performance Tuning Pre-Con is designed for the working SQL professional who has the relevant experience with SQL Server and only needs practical examples of SQL performance query tuning that can be applied in production right away. In this full-day training, participants will see relevant, crisp, real-world examples of SQL Server tuning focusing on common Practical Performance Troubleshooting Pre-Con is designed for the working SQL Server professional who has the relevant 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), IO Troubleshooting, Memory Trou

SessionID: 72705

Intro into Power BI

Back to calendar

Event Date: 02-06-2018 - Session time: 09:40:00 - Track: BI Information Delivery

Speaker: Gilbert Quevauvilliers

Title: Intro into Power BI

Abstract:

In this session I will give an intro into all the various aspects for Power BI, starting with Power BI Desktop (Importing data create a measure), using the Power BI Service (Creating Dashboards, updating reports, creating App Workspaces, creating Apps, sharing of dashboards content)

It will an interactive demo based session, where the goal will be for the user to walk away with a better understanding of what Power BI is capable of

SessionID: 77105

Data Privacy and the Data Professional.

Back to calendar

Event Date: 02-06-2018 - Session time: 09:40:00 - Track: Strategy and Architecture

Speaker: Martin Catherall

Title: Data Privacy and the Data Professional.

Abstract:

It’s almost a daily occurrence to hear about some sort of data breach.

But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional. As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex. Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world. We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking - to help with this sort of thing – but is there a better answer? Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.

SessionID: 78921

Tips and Tricks for Using SQL Server Management Studio Effectively

Back to calendar

Event Date: 02-06-2018 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Greg Low

Title: Tips and Tricks for Using SQL Server Management Studio Effectively

Abstract:

Most SQL Server developers and DBAs work with SQL Server Management Studio (SSMS) all the time. But SSMS is a very capable tool and most users only know how to use a fraction of its features. Join Greg to see his favourite tips and tricks for working with SSMS.

SessionID: 70392

Real-Time Analytics with Power BI

Back to calendar

Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Advanced Analysis Techniques

Speaker: Manohar Punna

Title: Real-Time Analytics with Power BI

Abstract:

Power BI helps you build appealing visualizations of your data. With ever growing footprint of data it is equally important to get real-time insights into your data. It can be as simple as monitoring a single metric or viewing real-time sales performance across multiple locations. Power BI real-time streaming enables you to stream data and update dashboards in real-time. Any time sensitive data can be a source of streaming data set like IoT sensor devices, social media sources, service usage metrics etc.

In this session

1. I will dive deep into real-time analytics with Power BI.
2. How to build streaming tiles in Power BI Dashboards.
3. Demo using Power BI REST APIs.
4. Demo using Azure Event Hub and Azure Stream Analytics.

SessionID: 74647

SQL Server Managed Instance, the PaaS Instance Offering

Back to calendar

Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Strategy and Architecture

Speaker: Henry Rooney

Title: SQL Server Managed Instance, the PaaS Instance Offering

Abstract:

With the pending release of SQL Server Managed Instance, the capabilities of the product as a near 100% compatible with an on premises instance will be discussed. What will be addressed are the capabilities of the product, features that are supported, how to migrate with the azure database migration service and what used cases would make you select this product.

SessionID: 80186

Configuring AlwaysOn Availability Groups exclusively in Azure, using IaaS.

Back to calendar

Event Date: 02-06-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael van Halderen

Title: Configuring AlwaysOn Availability Groups exclusively in Azure, using IaaS.

Abstract:

Both Availability Groups and Azure are big talking points when it comes to SQL Server. Deploying Availability Groups to Azure, requires an understanding of the infrastructure-based components that support an SQL Server install. In this session, we go beyond the traditional database silo, as we walk through all the steps required to successfully configure AlwaysOn Availability groups, exclusively in Azure.

SessionID: 74271

Advanced DAX for the SQL Professional

Back to calendar

Event Date: 02-06-2018 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Seamark

Title: Advanced DAX for the SQL Professional

Abstract:

Are you a whizz at SQL and curious about learning more about DAX? This session will be aimed to share some helpful tips and tricks for creating beautiful DAX when building Power BI reports or Tabular Cubes. Most people who learn DAX come from an Excel background, but this session will be tailored to those used to set based approaches such as SQL.

SessionID: 80082

Modern Data Warehouse using Lambda Architecture and Azure

Back to calendar

Event Date: 02-06-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Anupama Natarajan

Title: Modern Data Warehouse using Lambda Architecture and Azure

Abstract:

Organisations capture huge volumes of data and they need actionable information to act on them proactively in real-time to stay competitive. This requires a different thinking from the conventional Data Warehouse Architecture to more Cloud based Data Processing Architecture where high volume batch and real-time processing can be achieved using optimal cost.

In this session you will learn about

1. Overview of Lambda Architecture
2. How Azure Services implement Lambda Architecture
3. Advantages of leveraging Azure for Lambda Architecture
4. Business Scenarios to consider Lambda Architecture
5. End to End Demo

SessionID: 80113

Troubleshooting SQL Server Memory Issues

Back to calendar

Event Date: 02-06-2018 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Amit R S Bansal

Title: Troubleshooting SQL Server Memory Issues

Abstract:

Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. This session will help you find your way out of the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. Finally, you will learn how to troubleshoot common memory issues.

SessionID: 70224

Hybrid Distributed Architecture with Azure Data Sync 2.0

Back to calendar

Event Date: 02-06-2018 - Session time: 14:50:00 - Track: Cloud Application Development Deployment

Speaker: Martin Cairney

Title: Hybrid Distributed Architecture with Azure Data Sync 2.0

Abstract:

For a number of years, Azure Data Sync was stuck in "preview" mode in the old classic deployment model and with no updates on functionality over that time many thought that it was destined for the scrap heap. However with the recent revival and port to the Azure Resource Manager model it has become a viable option for organisations looking to deploy applications that are partially SaaS but with on local on-premises component.

This session will show how one organisation has used Azure Data Sync to allow for centralised management of point-of-sales terminals across multiple retail groups. The session will discuss the SaaS based component built on Azure SQL Database to segregate different retail groups into dedicated databases. From this design the retail group's dedicated management database can then use Data Sync to gather sales and stock metrics from each terminal and push down price changes to selected groups of stores.

SessionID: 72435

BI is a Journey, Not a Destination

Back to calendar

Event Date: 02-06-2018 - Session time: 14:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Gogula Aryalingam

Title: BI is a Journey, Not a Destination

Abstract:

With analytics becoming a buzzword in the recent past, everyone seems to want it in their businesses. Known as business intelligence for a long time, it helps an organization’s various decision makers take better business decisions using the insights that is provided. However, the path to a successful business intelligence implementation was always hounded by failure – The main reason being that BI is conceived as a one-time-implemented packaged solution, whereas business intelligence is in reality a journey.

This session will focus on how you could develop a business intelligence solution by taking the organization on an evolving journey, using the various Microsoft tools and technologies at different stages.

SessionID: 78489

Test Driven Development in SQL Server – how to deploy code safer

Back to calendar

Event Date: 02-06-2018 - Session time: 14:50:00 - Track: Application Database Development

Speaker: Hamish Watson

Title: Test Driven Development in SQL Server – how to deploy code safer

Abstract:

Test Driven Development (TDD) is a design approach which has enabled application developers to write cleaner code.

It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer. TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code. In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery. A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.

SessionID: 78627

Implementing Python in SQL Server 2017

Back to calendar

Event Date: 02-06-2018 - Session time: 14:50:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Implementing Python in SQL Server 2017

Abstract:

Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2017 using the language which is number one on the list of most popular programming languages today, Python. This session will provide and introduction to Python, cover how to integrate the language into SQL Server, demonstrate how to use Python in stored procedures and review how you can determine the resources that Python is using within SQL Server.

SessionID: 71109

DBATools! The reason to finally start learning and using Powershell

Back to calendar

Event Date: 02-06-2018 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

Title: DBATools! The reason to finally start learning and using Powershell

Abstract:

Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008.

In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!

SessionID: 73663

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 02-06-2018 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 75788

SSRS and Power BI Report Server - What's New

Back to calendar

Event Date: 02-06-2018 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Craig Bryden

Title: SSRS and Power BI Report Server - What's New

Abstract:

In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release, there have been many further developments, including the release of Power BI Report Server and SSRS 2017. In this demo laden session, Craig will recap the changes that SSRS has undergone from SSRS 2016 onwards, as well as look at and discuss Power BI Report Server.This session will be valuable for anyone new to SSRS, or anyone who has not had an opportunity to work with the latest versions of SSRS.

This site is open source. Improve this page.