SQLSaturday #509 - Brisbane 2016

Event Date: 05/28/2016 00:00:00

Event Location:

  • Microsoft Brisbane
  • Level 28, 400 George Street Brisbane
  • Brisbane, Queensland, Australia

PDF of Schedule

This event has completed. All data shown below is from the historical XML public data available.

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).


This is a list of sessions from the event, based on the schedule in the XML files.

Title: Temporal Databases in Microsoft SQL server 2016

Abstract: Introducing Temporal Databases in SQL Server 2016

More and more organizations are storing archives of data to help them make important business decisions. Traditionally, organizations had to rely on expensive, and tedious methods to go back in time and make sense of growth, negative growth, profit, loss, etc.

Microsoft SQL Server 2016 introduces a new feature called Temporal Databases which essentially solves all the problems mentioned above.

This presentation aims to go deep into Temporal Databases (requirements, use cases, technical know-hows) and present some demo’s in order to gain specific understanding on this new feature which is being called “Time Travel”.


  • Amit Arora

Track and Room: Enterprise Database Administration Deployment - Board Room

Title: Moving from Profiler to Extended Events.

Abstract: Profiler has been with us for a long time and it’s pretty much the goto tool for a lot of performance related issues but there’s been a new tool around for a few years now - actually since SQL SERVER 2008 - but there doesn’t seem to have been a big uptake of it. Well, after this session hopefully that will all change for you. Profiler is now deprecated and all new work is going into extended events. This means that new monitoring events are constantly being added. These give deeper insights into performance problems withing SQL SERVER and also aid the developer / DBA in understanding the inner working of the SQL SERVER database engine. An understanding of profiler would be advantageous but is definitely not required to get some good insights from this session.


  • Martin Catherall

Track and Room: Enterprise Database Administration Deployment - North Stradbroke

Title: 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. Researching the many suggested methods of tuning TempDB is a long, arduous and at times confusing process.

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

We will start with determining the best configuration of TempDB database files to use, the impact disk configuration has, which trace flags are important and what changes SQL Server 2016 will bring us. We will look at what is stored in TempDB and how both developers and DBA can optimize how TempDB is configured and used.

We will then use these best practices to optimize our instance and performance tune our queries to make the system faster.


  • Hamish Watson

Track and Room: Enterprise Database Administration Deployment - Board Room

Title: Boost your SQL Server performance with Delayed Durability and BPE

Abstract: SQL Server 2014 has come with many performance boosting features. In-Memory OLTP being one of the favourites, there are two more less talked about heroes - Delayed Durability and Buffer Pool Extensions. With the increase of usage of SSDs in production environment it has become essential to use them to the full potential. In this session Manohar will explore Delayed Durability and how it is achieved. He will also cover a case study with delayed durability and SSDs. SSDs can be fully utilized by enabling Buffer Pool Extensions. He will cover the usage and caveats of both these features which boosts the transaction throughput.


  • Manohar Punna

Track and Room: Enterprise Database Administration Deployment - North Stradbroke

Title: Azure Machine Learning: From Design to Integration

Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.

In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.

This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.


  • Peter Myers

Track and Room: BI Platform Architecture, Development Administration - South Stradbroke

Title: SQL Server 2016 - Real Time Operational Analytics - “Real” Game changer

Abstract: Performing analytics on operational data has all along being a huge challenge for applications, due to its impact on regular operations and day to day transactions. SQL Server 2016 has extended its analytic capablities by its enahancements on “In memory tables” and Columnstore indexes.”In memory tables” combined with columnstore indexes is a boon for performing analytics on operational data with no impact to regular workload, with no delayed data, no complex ETL tasks and without a need to maintain seperate data warehouse.

The presentation would cover how “In Memory” Columnstore indexes help to perform real time operational analytics and would involve interesting demos show casing the gains using SQL Server 2016 “In Memory” and Column Store Index enhancements. Presentation would also demonstrate and compare the performances of “In Memory” columnstore indexes and disk based columnstore indexes.


  • Nagaraj Venkatesan

Track and Room: Application Database Development - Board Room

Title: Automated Data Validation 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.


  • Dan de Sousa

Track and Room: BI Platform Architecture, Development Administration - Board Room

Title: Automated and Repeatable Test Cases for SQL Server Development.

Abstract: Automated and repeatable test cases are required for agile software development. In this session we will look at some of the tools and techniques for automated testing with SQL Server. Demonstrations during the session will create tests using the Visual Studio toolset and discuss how they can be used for Test Driven Development (TDD), unit testing, integration testing and acceptance testing. The presentation will cover testing SQL Server Databases, SQL Server Analysis Services and SQL Server Integration Services. Following the session attendees will be able to incorporate these tools and practices into their projects.


  • Stefan Riedel

Track and Room: Application Database Development - South Stradbroke

Title: Hitting the SQL Server “Go Faster” Button

Abstract: Tuning individual queries is incredibly resource intensive. Everyone wants a “Go Faster” button that will improve performance across the entire SQL instance. While there is no sp_gofaster command to run, there are a bunch of magic knobs and switches that can quite often achieve the desired results. In this session we’ll look at some of the things you can do to get the best performance out of your SQL Server workload. You’ll leave with a shopping list of things to check and options to try in your environments to get the performance you are after.


  • Rob Douglas

Track and Room: Enterprise Database Administration Deployment - North Stradbroke

Title: Power BI - Getting It Right - A Full Walkthrough

Abstract: In this session you will get a full walkthrough of Power BI: What is it? How is it done? What’s in it for me?

By the end of this session you will have a full understanding of the Power BI offering and the tools used to discover data, design dashboards and visualizations , visualize them on all devices , how to optimize your data model for Power BI, and natural language query. You’ll learn about sharing and collaborating, and working with multiple datasources to build live interactive dashboards and reports.


  • Dandy Weyn

Track and Room: BI Information Delivery - South Stradbroke

Title: Database Corruption - Advanced Recovery Techniques

Abstract: Being able to monitor, diagnose and recover from Database Corruption is a critical skill for any SQL Server DBA. In this session we will walk through the techniques required to detect and repair various forms of Corruption Using a number of example corrupted database we will explore how to determine and fix corruption while avoiding some of the common mistakes. Warning: Hex Editors and DBCC Page dumps will be involved!


  • Patrick Flynn

Track and Room: Enterprise Database Administration Deployment - Board Room

Title: An Introduction to R and R Services

Abstract: R is the most popular programming language for advanced analytics today. With Microsoft’s purchase of Revolution R, we are seeing native integration of R capabilities in the SQL Server 2016 database engine (R Services). We are also seeing R support in most of the Azure cloud products. In this session I will provide an introduction to the R language as well as discuss how you go about using this inside SQL Server and other Microsoft provided tools.


  • Craig Bryden

Track and Room: Analytics and Visualization - South Stradbroke

Title: Query Store Overview and Architecture

Abstract: Fixing performance problems and detecting query regressions has never been easy in SQL Server as the database engine fundamentally does not capture the relevant information. With the release of SQL Server 2016, Microsoft has introduced a feature called Query Store that will help you capture vital query metrics that will help performance troubleshooting and regression detection. In this session we will examine Query Store, examine it’s architecture, configuration and how it can be used to solve real-world performance problems.


  • Victor Isakov

Track and Room: Enterprise Database Administration Deployment - North Stradbroke

Title: Building HA/DR Solutions with SQL Server and Azure SQL Database

Abstract: In the world of Data Platform a variety of solutions are available going from on premises, hybrid to cloud solutions. Database Administrators play a crucial role in application design and architecture, providing mission critical and highly available solutions. In this session you will learn everything a DBA needs to know about Azure. You’ll learn about SQL Server running in Windows Azure virtual machines, Azure Storage and network configurations, SQL Database and how to manage and support workloads running in a traditional, hybrid and cloud based environment. Become the DBA of the future!


  • Dandy Weyn

Track and Room: Enterprise Database Administration Deployment - North Stradbroke

Title: Cortana Intelligence Suite; Where the Magic Happens

Abstract: Come to this session to learn what Cortana Intelligence is and why it is used for. Cortana Intelligence is a combination of tools and services that enables you to transform your data into intelligence action. Cortana uses powerful services such as Cortana digital assistance for hearing the voice commands, Power BI for visualization, Machine Learning for prediction, Stream Analytics for real-time interaction with data with IoT devices, and many other great features. Prepare to be amazed with what Cortana can do in demos of this session.


  • Reza Rad

Track and Room: Analytics and Visualization - South Stradbroke


This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Hamish Watson

Twitter: - theHybridDBA

LinkedIn: Hamish Watson

Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/

Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies.

He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies.

He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion.

Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.

Stefan Riedel

LinkedIn: Stefan Riedel

Stefan Riedel has been working with databases for more than 15 years, the last 10 of which have been focused on Microsoft SQL Server. Stefan has led and contributed to the implementation of many data warehouse and business intelligence solutions built using the Microsoft BI stack. To support these projects Stefan has designed and implemented automated testing and deployment tooling to support agile BI development methodologies. Stefan has presented at previous SQLSaturday events in Melbourne, Brisbane and Singapore.

Rob Douglas

Twitter: - Rob_DouglasNZ

LinkedIn: Rob Douglas

Contact: http://www.gumption.co.nz

Robs SQL history started as a remote DBA, branched into consultancy and now includes providing SQL Solutions to a variety of businesses, government departments and banks throughout Australia and New Zealand using a variety of native SQL solutions to meet their performance, higher availability and Disaster Recovery needs.

Manohar Punna

Twitter: - ManuSQLGeek

LinkedIn: Manohar Punna

Contact: http://www.sqlservergeeks.com/author/manoharpunna/

Manohar Punna is an Data Platform Geek and Vice President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various conferences like PASS Summit, SQLBits, DPS. He has authored over 150 blogs and has written a One DMV a Day series which is a longest one day series on any topic on SQL Server till date. Manohar is a product of this community and strongly believes in giving back to the community. So, ask him anything you would like to know and he is happy to learn it with you.

Dandy Weyn

Twitter: - ILIKESQL

LinkedIn: Dandy Weyn

Contact: http://WWW.ILIKESQL.COM

With over 20 years of experience in the database world, Dandy Weyn is very experienced on database platforms and business intelligence. As content developer for hands-on-labs, owner of technical events, and multiple years as international consultant and trainer Dandy offers the unique combination of deep technical and solid presentation skills. He is an MCM for SQL Server, Microsoft Certified Trainer and Global Technical Lead for Data Platform in the Enterprise Partner Group (EPG) at Microsoft.

Amit Arora

LinkedIn: Amit Arora

Amit Arora is an SQL Server Consultant with WARDY IT Solutions. Amit has over 10 years of experience working with SQL Server including working as a Technical Advisor and DBA for Microsoft. Amit has recently been working on SQL Server solutions with Microsoft Azure and HDInsight as well as other big data technologies.

Craig Bryden

Twitter: - @cbryden

LinkedIn: Craig Bryden

Craig has been working with SQL Server for over 20 years and currently holds several SQL Server based certifications. He has also previously held an MCT certification. Craig’s contribution to the SQL Server community was recognised in 2018 with a Microsoft MVP award. He was involved with Microsoft Learning to set some of the current SQL server Exams. Craig is the Chief Data Strategist at BiTQ. Craig is an organiser of the QLD Power BI User Group

Patrick Flynn

Twitter: - sqllensman

Contact: http://sqllensman.com/blog/

Patrick Flynn is a Senior Database Administrator with 10 years experience in large 24 x 7 enterprise environments. He is a certified master for SQL Server and a regular attendee of the PASS Summit.

Has presented at SQLSaturday events in Sydney, Melbourne, Brisbane and Auckland, Edmonton and Calgary, Oslo and Cambridge

Dandy Weyn

Twitter: - ILIKESQL

LinkedIn: Dandy Weyn

Contact: http://WWW.ILIKESQL.COM

With over 20 years of experience in the database world, Dandy Weyn is very experienced on database platforms and business intelligence. As content developer for hands-on-labs, owner of technical events, and multiple years as international consultant and trainer Dandy offers the unique combination of deep technical and solid presentation skills. He is an MCM for SQL Server, Microsoft Certified Trainer and Global Technical Lead for Data Platform in the Enterprise Partner Group (EPG) at Microsoft.

Peter Myers

LinkedIn: Peter Myers

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.

He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.

Nagaraj Venkatesan

Twitter: - https://twitter.com/arrnagaraj

LinkedIn: Nagaraj Venkatesan

Contact: http://strictlysql.blogspot.com

Nagaraj Venkatesan is a Data Platform MVP from Singapore and the leader of Singapore SQL PASS Chapter. As a SQL Server enthusiast, Nagaraj is a regular speaker in Asia Pacific region at Data Platform events like SQLSaturdays, SQL Server Geeks Summit, User group meetups etc. Nagaraj shares his technical expertise at strictlysql.blogspot.com. Nagaraj also runs a YouTube channel called “DataChannel”, which contains technical interviews with top Microsoft Data Platform experts in the world.

Victor Isakov

Twitter: - @victorisakov

LinkedIn: Victor Isakov

Contact: http://www.victorisakov.com

Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored “Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)”. He is one of only three non-Microsoft, Microsoft Certified Architects in the world.

Dan de Sousa

Twitter: - @dcasousa

LinkedIn: Dan de Sousa

Contact: https://sqlblog2017.wordpress.com/

Dan de Sousa is a Senior Data Consultant for DSI in Mississauga, Canada. He has been working with SQL Server for the last 10 years and has been involved in the development of datawarehouses as well as creating reports and dashboards. Dan is currently working on a data security compliance project for Europe which involves making sure any personal information is secured/encrypted before leaving its country of origin.

Martin Catherall

Twitter: - MartyCatherall

LinkedIn: Martin Catherall

Contact: http://martincatherall.com

Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.


The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page