sqlsathistory

Nr: 468

Back to Main list

SQLSaturday #468 - Sydney 2016

Start Time (24h)	Speaker	Track	Title
08:30:00	Grant Paisley	Other	[#15
09:45:00	Martin Cairney	Enterprise Database Administration Deployment	[#22
09:45:00	Hamish Watson	Application Database Development	[#21
09:45:00	Peter Myers	BI Platform Architecture, Development Administration	[#06
09:45:00	Marco Russo	BI Platform Architecture, Development Administration	[#23
11:15:00	Dan de Sousa	BI Platform Architecture, Development Administration	[#05
11:15:00	Warwick Rudd	Enterprise Database Administration Deployment	[#13
11:15:00	Iman Eftekhari	Advanced Analysis Techniques	[#01
11:15:00	James Beresford	Other	[#08
11:15:00	Glyn LLewellyn	Analytics and Visualization	[#03
12:45:00	Iman Eftekhari	Analytics and Visualization	[#24
13:30:00	Manohar Punna	Enterprise Database Administration Deployment	[#09
13:30:00	Rob Douglas	Strategy and Architecture	[#04
13:30:00	Reza Rad	BI Platform Architecture, Development Administration	[#20
13:30:00	Grant Paisley	Advanced Analysis Techniques	[#07
13:30:00	Allen White	Enterprise Database Administration Deployment	[#16
15:00:00	Melody Zacharias	Application Database Development	[#11
15:00:00	Craig Bryden	BI Platform Architecture, Development Administration	[#14
15:00:00	Victor Isakov	Enterprise Database Administration Deployment	[#02
15:00:00	Martin Catherall	Enterprise Database Administration Deployment	[#18
15:00:00	Matt Allington	Analytics and Visualization	[#10

SessionID: 46163

#15 | KEYNOTE | SQL 2016 Data Platform | Mark Souza | Microsoft USA

Back to calendar

Event Date: 27-02-2016 - Session time: 08:30:00 - Track: Other

Speaker: Grant Paisley

Title: #15 | KEYNOTE | SQL 2016 Data Platform | Mark Souza | Microsoft USA

Abstract:

Mark will be flying over from the states to give the latest updates from the engineering team with respect to the Microsoft data platform. With the upcoming release of SQL Server 2016 around the corner you will get a drill in on the product including the latest on performance and customer experiences. Mark will also give you an update on the other important pieces of the platform including Azure SQL DB, Azure SQL DW, Data Lake, Hybrid capabilities, etc.

SessionID: 39466

#22 | The DBA with his Head in the Clouds

Back to calendar

Event Date: 27-02-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Martin Cairney

Title: #22 | The DBA with his Head in the Clouds

Abstract:

With Azure data centres located round the globe, will your company be looking more at cloud options? The Azure VM approach doesn't change your day to day role much, but Azure SQL Database certainly does.

In this session we will compare the core features of Azure SQL Database against SQL Server in an Azure VM, including the limitations and how to create, access and configure it. We'll then compare scaling-up and scaling-out and the change in perspective that a DBA needs to manage a mixed environment. Finally, we'll look at some of the DBA activities that are still needed on Azure SQL Database and how these can be achieved easily.

SessionID: 42653

#21 | TempDB: the forgotten pillar of Performance Tuning

Back to calendar

Event Date: 27-02-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Hamish Watson

Title: #21 | TempDB: the forgotten pillar of Performance Tuning

Abstract:

Tempdb is an integral part of SQL Server, and is often overlooked when trying to get the most out of your system.

In this session we will go over what tempdb is used for, why it is a special type of database and how to use it to tune the performance of your overall system.

We will start with determining the best configuration, number of database files to use and the common performance issues that tempdb can indicate. We will then use these best practices to optimise our instance and performance tune our queries to make your system faster.

SessionID: 42906

#06 | Big Data Fundamentals with Azure HDInsight

Back to calendar

Event Date: 27-02-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Peter Myers

Title: #06 | Big Data Fundamentals with Azure HDInsight

Abstract:

Big Data is a phrase used to describe large, possibly complex datasets. With today's data explosion of devices and sensors, technology is responding with new ways to practically and economically store and process the resulting Big Data.

This session describes the fundamentals of Big Data and Hadoop, leading to the introduction of Microsoft’s cloud-based Big Data service: Azure HDInsight. The session includes numerous demonstrations to show how files can be archived in the Azure Blob Store and then efficiently processed with a cluster of servers. The demonstrations will introduce Hive, a query language designed to ensure that Big Data remains approachable to database developers, and the integration of Big Data into a conventional Business Intelligence (BI) solution.

This session will be of interest to those new to the concept of Big Data and interested to understand the challenges that it is designed to solve.

SessionID: 44393

#23 | Toolkit for DAX Optimization

Back to calendar

Event Date: 27-02-2016 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marco Russo

Title: #23 | Toolkit for DAX Optimization

Abstract:

How do you optimize a DAX expression? This session will introduce you to the useful tools to measure performance, gathering data to find the bottlenecks and helping you in writing new optimized versions of DAX. Starting from SQL Profiler, you will learn which events are relevant for DAX, and how to collect them in different environments (Analysis Services, Power Pivot, Power BI). We will show DAX Studio, which simplify and speed-up the data collection process, and makes it easy to find bottlenecks in storage engine and formula engine. VertiPaq Analyzer and other small tools will be also used to collect other useful information. The goal of the session is to provide you a methodology to analyze performance of your DAX measures, to find the bottleneck and to identify the main reason of a performance issue.

SessionID: 41556

#05 | Automated Test Driven Development with SQL Server using nUnit

Back to calendar

Event Date: 27-02-2016 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Dan de Sousa

Title: #05 | Automated Test Driven Development with SQL Server using nUnit

Abstract:

Testing software is hard work. Testing BI solutions is even harder;there's lots of moving parts, the tools are thin and it takes a lot of time and effort. Software development uses unit testing and while this can be applied to the different parts of a BI solution, most people are more interested in the numbers the solution produces and proving that they are right. So can you validate the numbers in your BI solution? And can you do it quickly and easily? In this session we will cover an approach for automating the validation of your BI solution covering multiple scenarios with a hand full of demos. We will be using nUnit as a framework and some free codeplex tools, so we can run a suite of tests every time we load data into our BI platform. This is not continuous integration, and it is not unit testing in the true sense either. It is, instead, "continuous validation", and it can provide you with an awful lot of assurance for not very much extra effort.

SessionID: 41920

#13 | How Available is SQL Server 2016

Back to calendar

Event Date: 27-02-2016 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Warwick Rudd

Title: #13 | How Available is SQL Server 2016

Abstract:

Having your SQL Server databases not available for business to be making money is not a good way to stay employed. Do you understand what features and options can assist you with keeping SQL Server Databases Available?

In this session we will look at the options available to you currently to meet your Availability requirements using features being released in SQL Server 2016 to better provide high availability

SessionID: 42918

#01 | 5 reasons I am excited about IoT and Cortana Analytics

Back to calendar

Event Date: 27-02-2016 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Iman Eftekhari

Title: #01 | 5 reasons I am excited about IoT and Cortana Analytics

Abstract:

Internet of Things (IoT) is now even more practicable with the power of the cloud analytics. Now with Cortana Analytics which have included components across a broad set of Azure Services, Power BI and APIs, you can connect your sensors and devices to the cloud to do more intelligent stuff and “Connect the Dots”. In this session you will get an overview of the capabilities in Cortana Analytics, and Iman will show you an outlook of the future.

SessionID: 42944

#08 | Creating High Performance Tabular Models

Back to calendar

Event Date: 27-02-2016 - Session time: 11:15:00 - Track: Other

Speaker: James Beresford

Title: #08 | Creating High Performance Tabular Models

Abstract:

In this session James will use his experience building large cubes for large organisations and show how you can optimise all aspects of the process - preparing data for load, processing tips and how to get the thing to perform as users expect.

SessionID: 44539

#03 | An introduction to data analysis with R

Back to calendar

Event Date: 27-02-2016 - Session time: 11:15:00 - Track: Analytics and Visualization

Speaker: Glyn LLewellyn

Title: #03 | An introduction to data analysis with R

Abstract:

The R language is one of the key programming languages used in Azure Machine Learning. During this session we will introduce the basic programming constructs of the language and get you started on the road to detailed data analysis. We describe the language, data structures and libraries used in R development and show how your completed code can be deployed to a Azure Machine Language environment and executed through the web API. At the completion of this session, you may not be an R hotshot, but you will hopefully have accelerated your journey toward becoming one.

SessionID: 47188

#24 | Power BI Red Carpet Showcases – come and see real-life dashboards

Back to calendar

Event Date: 27-02-2016 - Session time: 12:45:00 - Track: Analytics and Visualization

Speaker: Iman Eftekhari

Title: #24 | Power BI Red Carpet Showcases – come and see real-life dashboards

Abstract:

Presenter: Kale Temple, Iman Eftekhari, Jixin (Gin) Jia

Abstract: in this half-an-hour session we will show you real-life dashboards for 4 scenarios, no Adventure Works!

BIO: Agile BI is a Sydney based consulting firm that specialises in Microsoft Data Analytics. As a Microsoft Gold partner, we have built up a reputation as one of Australia’s most respected service providers in the Microsoft Business Intelligence arena especially Power BI.

SessionID: 39468

#09 | DBA life made easier with SQL Server 2016 - Query Store and

Back to calendar

Event Date: 27-02-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Manohar Punna

Title: #09 | DBA life made easier with SQL Server 2016 - Query Store and

Abstract:

DBA always faces challenges in troubleshooting live performance issues. In SQL Server 2016, the two new features introduced to help a DBA to be more productive. The Query Store is a feature that will help in visualizing what is happening with your executing queries, which otherwise is hard to collect with DMVs. The UI rich interface makes it easier to troubleshoot live scenarios as well has collect data for troubleshooting. Have you ever felt a need to see the execution plan when executing a query while troubleshooting? Live Query Statistics helps you view the live execution plan rather than waiting till end of the execution of query to see the actual execution plan. This session is recommended for advanced users as you will need basic understanding of troubleshooting using execution plans.

SessionID: 42570

#04 | Are You High? Can You Recover?

Back to calendar

Event Date: 27-02-2016 - Session time: 13:30:00 - Track: Strategy and Architecture

Speaker: Rob Douglas

Title: #04 | Are You High? Can You Recover?

Abstract:

A look at the options for providing High Availability and Disaster Recovery using the native features available in SQL Server. This session will cover the basis of how the technologies work, what is(and isn't) protected and a list of the advantages and disadvantages of each technology.

We'll also look at the why of High Availability, Disaster recovery and how to get the business to commit to a design to provide Business Continuity when disaster strikes.

SessionID: 42817

#20 | SSIS vs. Azure Data Factory

Back to calendar

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

Speaker: Reza Rad

Title: #20 | SSIS vs. Azure Data Factory

Abstract:

SQL Server Integration Services (SSIS) is a mature on-premise ETL and data-transformation tool. Azure Data Factory is a cloud ETL and data-consolidation tool that was recently released as part of Microsoft Azure services. In this session, learn themain differences between these two tools and learn how to determine which works best in specific scenarios. We compare Azure Data Factory and SSIS on many factors; demos will help illustrate the differences.

SessionID: 42895

#07 | Build an Activity-Based Costing System with Power BI

Back to calendar

Event Date: 27-02-2016 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Grant Paisley

Title: #07 | Build an Activity-Based Costing System with Power BI

Abstract:

Get a sneak preview of my USA 2016 PASS Analytics Conference session - creating an Activity-Based Costing System with Power BI. Having the final report model in Power BI gives you the ultimate control over reporting, including adding other information possibly not even held with Information Technology.

We will use a real-world health care model to show how we replaced an expensive, difficult to understand and maintain SAS system, with a simple, elegant, and auditable solution based on the Microsoft stack. The rules are table-driven with allocated costs handling built in.

SessionID: 44400

#16 | Maintain SQL Server Performance Baseline w/PowerShell

Back to calendar

Event Date: 27-02-2016 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: #16 | Maintain SQL Server Performance Baseline w/PowerShell

Abstract:

Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

SessionID: 42601

#11 | Distributed Replay: Testing With Your Data, Your Way!

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Melody Zacharias

Title: #11 | Distributed Replay: Testing With Your Data, Your Way!

Abstract:

Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization? Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing and replay. This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.

SessionID: 42654

#14 | Introduction to Biml BimlScript

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Craig Bryden

Title: #14 | Introduction to Biml BimlScript

Abstract:

Within every Data Warehouse project there is always ETL development that is very repetitive in nature, for example, you need to import 20 different flat file exports from the ERP system, you need to load 15 dimensions into the data warehouse and so on.

With Microsoft SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In a typical BI project, the ETL implementation can easily take up 60% of the project time, so it is beneficial if the development time of similar SSIS packages can be cut down. Business Intelligence Markup Language (Biml) is an XML dialect for defining Business Intelligence assets across the Microsoft SQL Server platform In this session Craig will introduce you to Biml BimlScript, providing those new to Biml with a foundational understanding of what BIML is and what the benefits of using Biml are.

SessionID: 42665

#02 | Administering and Optimizing Availability Groups Correctly

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Victor Isakov

Title: #02 | Administering and Optimizing Availability Groups Correctly

Abstract:

Although Availability Groups are relatively easy to implement, there are many complexities when it comes to administering and optimizing them--especially if you are familiar with Failover Clustering. In some cases, your existing database solutions perform slower. In this session, we examine the various potential problems you can have when implementing Availability Groups and the potential solutions to these problems. This session covers areas such as performance, administration, and security management. You learn how to manage complex jobs, backup strategies, and logins within an Availability Group environment. You also learn how Availability Groups might dramatically affect your application performance, how to recognise such performance problems, and how to resolve them. With a number of real-world examples, this practical session enables you to maximize the benefits of Availability Groups.

SessionID: 43026

#18 | SQL Developer Tips and Tricks

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Martin Catherall

Title: #18 | 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: 46795

#10 | Disconnected Tables in PowerPivot/Tabular models to Solve B

Back to calendar

Event Date: 27-02-2016 - Session time: 15:00:00 - Track: Analytics and Visualization

Speaker: Matt Allington

Title: #10 | Disconnected Tables in PowerPivot/Tabular models to Solve B

Abstract:

In this session you will see how to solve a number of business scenarios using DAX and Power Pivot, including:

#183; Taking real time user input to change the calculations in a pivot table/report - changing the results of your DAX calculations using slicers #183; Changing the visualisation experience of charts and tables using user input from slicers #183; Grouping customers into age groups for reporting and analysis using 2 different Banding techniques #183; Displaying the "latest survey result" in a Pivot Table for any date selected.

This site is open source. Improve this page.