sqlsathistory

Nr: 771

Back to Main list

SQLSaturday #771 - Sydney 2018

Start Time (24h) Speaker Track Title
09:00:00 Hamish Watson Application Database Development Test Driven Development in SQL Server – how to deploy code safer
09:00:00 David Alzamendi BI Platform Architecture, Development Administration Business Intelligence Solutions in Azure
09:00:00 Jim McLeod BI Platform Architecture, Development Administration Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud
09:00:00 Grant Paisley BI Information Delivery Data modelling fundamentals for Power BI and SSAS Tabular
10:10:00 Warwick Rudd Application Database Development SQLOpsStudio Vs SSMS - There can be only one
10:10:00 Reza Rad BI Platform Architecture, Development Administration M and Power Query Beyond Limits
10:10:00 Rolf Tesmer Analytics and Visualization Building Streaming Data Pipelines Using Azure Cloud Services
10:10:00 Matt Allington BI Information Delivery DAX as a Query Language
11:30:00 Gilbert Quevauvilliers BI Information Delivery Power BI Writeback with Power Apps
11:30:00 Martin Cairney Application Database Development The Why and How of Partitioned Tables
11:30:00 Leila Etaati Advanced Analysis Techniques End To End Data Science Solution: Azure ML Workbench
11:30:00 Martin Catherall Strategy and Architecture What is DevOps? - and why should I care?
13:30:00 Andreas Wolter Enterprise Database Administration Deployment Troubleshooting Always On Availability Groups Performance
13:30:00 Patrick Flynn Enterprise Database Administration Deployment DBATools! The reason to finally start learning and using Powershell
13:30:00 Manohar Punna Advanced Analysis Techniques Data Science for DBA - Get Started Now
13:30:00 Daniil Maslyuk Analytics and Visualization DAX best practices
14:50:00 Gogula Aryalingam BI Platform Architecture, Development Administration Azure Data Lake Analytics: Leveraging the Modern Data Warehouse
14:50:00 Iman Eftekhari Strategy and Architecture Power BI Adoption Framework
14:50:00 Victor Isakov Application Database Development Mastering Temporary Objects
14:50:00 Greg Low Application Database Development Tips and Tricks for Using SQL Server Management Studio Effectively

SessionID: 78493

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

Back to calendar

Event Date: 07-07-2018 - Session time: 09:00: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: 78799

Business Intelligence Solutions in Azure

Back to calendar

Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Alzamendi

Title: Business Intelligence Solutions in Azure

Abstract:

When the number of services is more than 600 in Azure, many questions arise surrounding the different services that can be included in a Business Intelligence Architecture. This session will cover traditional as well as modern Business Intelligence solutions taking advantage of technologies such as Azure HDInsight, Azure Data Lakes or Azure Event Hubs.

I will go over the characteristics of the main services that can be implemented in a Business Intelligence solution in the cloud. The demo will include 5 of these services.

SessionID: 82529

Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud

Back to calendar

Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jim McLeod

Title: Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud

Abstract:

Azure SQL Data Warehouse is a cloud-based massively parallel database platform, based on the concepts that the Analytics Platform System/Parallel Data Warehouse uses for on-premises extreme performance. While it appears at first glance to be a familiar SQL Server environment, Azure SQL Data Warehouse has a few gotchas and design implications that can bite you (and your data warehouse's performance!) if you're not aware of them. This session will teach you the basic concepts of Azure SQL Data Warehouse, and provide tips and guidance on how to get the most of it.

SessionID: 84133

Data modelling fundamentals for Power BI and SSAS Tabular

Back to calendar

Event Date: 07-07-2018 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Grant Paisley

Title: Data modelling fundamentals for Power BI and SSAS Tabular

Abstract:

Nothing beats having a correctly structured data model - DAX calculations are a breeze. Having the wrong data model can result in slow performance, convoluted expressions or potentially even block you from achieving your desired output all together. This session includes demos of different modelling patterns and shows you how to implement them to solve real world business problems. These techniques apply to Power BI and Analysis Server Tabular

SessionID: 78184

SQLOpsStudio Vs SSMS - There can be only one

Back to calendar

Event Date: 07-07-2018 - Session time: 10:10:00 - Track: Application Database Development

Speaker: Warwick Rudd

Title: SQLOpsStudio Vs SSMS - There can be only one

Abstract:

SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS?

In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.

SessionID: 78542

M and Power Query Beyond Limits

Back to calendar

Event Date: 07-07-2018 - Session time: 10:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reza Rad

Title: M and Power Query Beyond Limits

Abstract:

Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. This session is full of live demos. Prepare to be amazed with what Power Query can do with heaps of demos in this session.

SessionID: 78744

Building Streaming Data Pipelines Using Azure Cloud Services

Back to calendar

Event Date: 07-07-2018 - Session time: 10:10:00 - Track: Analytics and Visualization

Speaker: Rolf Tesmer

Title: Building Streaming Data Pipelines Using Azure Cloud Services

Abstract:

The scope of the Data Platform is changing with the number of data sources available to businesses today growing and becoming more complex. Data today comes in many shapes, sizes and rates and in many cases no longer can business wait till data is landed before analysing it for business decisions. This session introduces the concept of the Lambda Architecture and the alignment to Microsoft Azure Cloud Services for managing high velocity streaming data. The session will talk to each of the key Azure services that form part of a streaming data pipeline, how they work and demonstrate how a streaming solution can be easily and quickly deployed. The session will walkthrough several examples of real streaming solutions and provide the relevant knowledge and information on how you can easily build your own streaming data architectures!

SessionID: 80775

DAX as a Query Language

Back to calendar

Event Date: 07-07-2018 - Session time: 10:10:00 - Track: BI Information Delivery

Speaker: Matt Allington

Title: DAX as a Query Language

Abstract:

Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools. But did you know that these tools also have their own query language? In traditional databases such as SQL server, it is possible to extract data into a new table. The same is possible using DAX as a query language with a tabular data model.

In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model. Once connected, DAX studio can be used to write queries over the tabular data model to start to interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report). The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.

SessionID: 78128

Power BI Writeback with Power Apps

Back to calendar

Event Date: 07-07-2018 - Session time: 11:30:00 - Track: BI Information Delivery

Speaker: Gilbert Quevauvilliers

Title: Power BI Writeback with Power Apps

Abstract:

Have your users ever asked if it is possible to update a record in a report, and see the results almost immediately?

In this session I will demonstrate how to integrate write back using Power Apps, within a Power BI report.

The session will be almost entirely demo based, in which I will demonstrate how to integrate the Power App with the Power BI report. And then show by updating a record, that the data is almost instantly updated within the Power BI report.

SessionID: 78661

The Why and How of Partitioned Tables

Back to calendar

Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Martin Cairney

Title: The Why and How of Partitioned Tables

Abstract:

Previously restricted to Enterprise Edition, partitioning was one of the features pushed down to all Editions in SQL 2016 SP1. With greater availability comes greater responsibility to make sure it is implemented appropriately.

This session will demonstrate some of the common pitfalls with implementing partitioning: • how excessive data movement can kill performance • how poor maintenance can negate the performance gains We’ll then look at how to plan and implement partitioning appropriately and some of the corresponding benefits that can be realised from a well implemented and managed partition scheme: • how to automatically maintain a partition scheme • how to implement a sliding window for data loading and archiving • how to plan and implement partitioning to limit data movement Finally, we will consider the additional options open to us with partitioned tables from both the maintenance perspective, and the coding and tuning perspective.

SessionID: 78722

End To End Data Science Solution: Azure ML Workbench

Back to calendar

Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Advanced Analysis Techniques

Speaker: Leila Etaati

Title: End To End Data Science Solution: Azure ML Workbench

Abstract:

Azure Machine Learning is integrated, end-to-end data science and advanced analytics solution. It enables data scientists to prepare data, develop experiments, and deploy models at cloud scale. In this session, the audience will learn how to install the Azure ML workbench and how to set it up. Moreover, an introduction on how to write Python code inside it and what packages can be used will be presented. Next the process of importing data from different resources will be explained. The audience will learn how to deploy and how to check the run log inside Azure ML workbench. Two main components of Azure ML workbench: Azure Machine Learning Experimentation and Management Services will be explained. This session contains demos for each practice and all steps will be shown.

SessionID: 80903

What is DevOps? - and why should I care?

Back to calendar

Event Date: 07-07-2018 - Session time: 11:30:00 - Track: Strategy and Architecture

Speaker: Martin Catherall

Title: What is DevOps? - and why should I care?

Abstract:

If you like an interactive and lively sessions them this is the place for you.

We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional. We’ll take a peak at what it means for the technology professional as well as what it means for the business professional - and we'll see Visual Studio Team Services (VSTS) and the cloud in action. We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up. We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption. We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these. Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates kn

SessionID: 80336

Troubleshooting Always On Availability Groups Performance

Back to calendar

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

Speaker: Andreas Wolter

Title: Troubleshooting Always On Availability Groups Performance

Abstract:

This session is dedicated to a thoroughly examination of Always On Availability Groups in action. Various demos show how to analyze functionality and performance in the different stages in the life of an Availability Group: Initialization, Synchronization, and even Failover. We will follow the streams of data from insert on the primary to redo on the secondary and thereby gain a deep understanding of the architecture of availability groups with its special queues. We will also see the potential of the performance overhead on the workload and lag of a synchronous replica. Get ready for a pure demo-session using DMVs, Extended Events, Perfmon and Wait Stats methodology.

SessionID: 82266

DBATools! The reason to finally start learning and using Powershell

Back to calendar

Event Date: 07-07-2018 - Session time: 13:30: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: 82312

Data Science for DBA - Get Started Now

Back to calendar

Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Manohar Punna

Title: Data Science for DBA - Get Started Now

Abstract:

If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will introduce you to the field of Data Science. You will start with R in SQL Server. Then you step into the world of R using R Studio and realise the power of Data Science using Azure Machine Learning.

You will learn the basics of R programming language, Machine Learning, real-world analytics and visualisations that businesses need today. In this session you will get a head start about each component and the possibilities that can be achieved with them.

SessionID: 82314

DAX best practices

Back to calendar

Event Date: 07-07-2018 - Session time: 13:30:00 - Track: Analytics and Visualization

Speaker: Daniil Maslyuk

Title: DAX best practices

Abstract:

In this session, I am going to discuss a few DAX best practices, illustrated by examples derived from real projects. Attendants are going to see why they should follow the prescribed DAX best practices. There are going to be PowerPoint slides and live screen demos.

SessionID: 78734

Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

Back to calendar

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

Speaker: Gogula Aryalingam

Title: Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

Abstract:

What you feared has come upon you: You’ve been happily building business intelligence solutions the traditional way for years; Finally, the big data curse has caught up with you. Your organization wants to exploit their big data along with their day-to-day transactional data. You are now tasked with storing all this in one place and working your analytics magic on it. You start wondering how and where you would store this data, what kind of hardware you would need and and how you would learn everything from storing to processing to analysis in a short time – after all big data is a different type of beast from transactional data.

Fear not, all you need to do is look to the heavens; with Azure Data Lake and Azure Data Lake Analytics, you could get started quite fast. After an introduction to Azure Data Lake, we will dive into how you could perform simple yet power analytics using methods that are familiar with Azure Data Lake Analytics.

SessionID: 80007

Power BI Adoption Framework

Back to calendar

Event Date: 07-07-2018 - Session time: 14:50:00 - Track: Strategy and Architecture

Speaker: Iman Eftekhari

Title: Power BI Adoption Framework

Abstract:

Power BI has become the new Excel for many business users and its ease of use has made it viral within businesses of all shapes and sizes.

Many Business Users started using Power BI with minimum / no IT collaboration that started causing concerns especially within larger organisations regarding security, governance, change management, etc. With the risk of facing another spreadsheet hell in a different form, organisations have become increasingly aware of the need to put a governance and control process in place.

In this presentation Iman will use his extensive experience in implementing and rolling out Power BI for many organisations to share some tips from his adoption framework for mid to large size organisations.

SessionID: 82374

Mastering Temporary Objects

Back to calendar

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

Speaker: Victor Isakov

Title: Mastering Temporary Objects

Abstract:

More and more Transact-SQL code is using temporary tables and table variables constructs. These constructs leverage the tempdb system database, which in turn becomes a severe performance bottleneck. This will be particularly "felt" when moving on-premise database solutions into the cloud. In this session we will cover the best practices in how you should be implementing these temporary constructs in your database solutions. We will discuss the differences between temporary tables and table variables, their impact on query performance and tempdb before looking a different implementations and best practices. We will examine a variety of techniques to improve temporary object performance, from hardware to the database engine configuration. Finally we will cover a number of key, proven techniques that can improve substantially performance. With lots of examples and case studies we will show how you can improve query performance by 20x or more.

SessionID: 83058

Tips and Tricks for Using SQL Server Management Studio Effectively

Back to calendar

Event Date: 07-07-2018 - Session time: 14:50: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.