SQLSaturday #713 - Brisbane 2018
Event Date: 06/02/2018 00:00:00
Event Location:
- River City Labs
- Lvl 3 TCB Building, 315 Brunswick street Fortitude Valley
- Brisbane, Queensland, Australia
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).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Martin Cairney
Track and Room: Cloud Application Development Deployment - Wardy IT Solutions
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
- I will dive deep into real-time analytics with Power BI.
- How to build streaming tiles in Power BI Dashboards.
- Demo using Power BI REST APIs.
- Demo using Azure Event Hub and Azure Stream Analytics.
Speaker(s):
- Manohar Punna
Track and Room: Advanced Analysis Techniques - Pure Storage
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 .
Speaker(s):
- Ginger Grant
Track and Room: Advanced Analysis Techniques - North Stradbroke
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.
Speaker(s):
- Benjamin Nevarez
Track and Room: Application Database Development - Wardy IT Solutions
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.
Speaker(s):
- Gogula Aryalingam
Track and Room: BI Platform Architecture, Development Administration - Microsoft
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.
Speaker(s):
- Martin Catherall
Track and Room: Strategy and Architecture - Microsoft
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.
Speaker(s):
- Hamish Watson
Track and Room: Application Database Development - Microsoft
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
Speaker(s):
- Amit R S Bansal
Track and Room: Enterprise Database Administration Deployment - South Stradbroke
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.
Speaker(s):
- Michael van Halderen
Track and Room: Enterprise Database Administration Deployment - Microsoft
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
Speaker(s):
- Gilbert Quevauvilliers
Track and Room: BI Information Delivery - Pure Storage
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.
Speaker(s):
- Phillip Seamark
Track and Room: BI Platform Architecture, Development Administration - Microsoft
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.
Speaker(s):
- Amit R S Bansal
Track and Room: Enterprise Database Administration Deployment - Wardy IT Solutions
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.
Speaker(s):
- Henry Rooney
Track and Room: Strategy and Architecture - Wardy IT Solutions
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!
Speaker(s):
- Patrick Flynn
Track and Room: Enterprise Database Administration Deployment - Microsoft
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.
Speaker(s):
- Greg Low
Track and Room: Application Database Development - Wardy IT Solutions
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.
Speaker(s):
- Craig Bryden
Track and Room: BI Information Delivery - Pure Storage
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.
Speaker(s):
- Ginger Grant
Track and Room: Advanced Analysis Techniques - Pure Storage
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
- Overview of Lambda Architecture
- How Azure Services implement Lambda Architecture
- Advantages of leveraging Azure for Lambda Architecture
- Business Scenarios to consider Lambda Architecture
- End to End Demo
Speaker(s):
- Anupama Natarajan
Track and Room: Cloud Application Development Deployment - Pure Storage
Speakers
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.
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.
Gilbert Quevauvilliers
Twitter: - https://twitter.com/gilbertque
LinkedIn: Gilbert Quevauvilliers
Contact: https://www.fourmoo.com/blog
Power BI Data Analytics Consultant with over 12 years experience.
From small to enterprise implementations on Azure (Azure Analysis Services, Function Apps, Runbooks, Automation Accounts, SQL Serverless DB) and On-Premise Microsoft Platform (SQL Server, Integration Services, Analysis Services Multidimensional and Tabular, Reporting Services)
Recently I have focused on Power BI, with its rapidly changing features and incredible uptake it has allowed me to consult in a variety of different and challenging solutions.
I was awarded the Microsoft MVP award for Power BI since 2017.
I have spoken at the Microsoft Business Applications Summit (Seattle Atlanta), Power BI World Tour,SQLSaturdays other events.
Amit R S Bansal
Twitter: - A_Bansal
LinkedIn: Amit R S Bansal
Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.
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
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Greg Low
Twitter: - greglow
LinkedIn: Greg Low
Contact: http://blog.greglow.com
Greg Low is well-known in the SQL Server community as a mentor, trainer, author, and community leader. He is a certified master for SQL Server, was an instructor in that program, and holds a PhD in Computer Science. Microsoft often calls on Greg to develop data-related content, and to train their staff. He regularly speaks at tier-one conferences internationally. Greg is best known for his SQL Down Under podcast, SDU Tools, and his eBooks and whitepapers. He heads up a boutique consultancy called SQL Down Under in Melbourne Australia. Greg has been awarded as an MVP since 2001.
Amit R S Bansal
Twitter: - A_Bansal
LinkedIn: Amit R S Bansal
Amit R. S. Bansal is a SQL Server Specialist at SQLMaestros. He leads the SQL Server practice with a focused team providing consulting, training, and content development services to more than 160+ SQL customers globally. He frequently speaks at international conferences on SQL Server performance tuning, which is his core expertise. Amit is also honored with Microsoft Regional Director status, MVP award, and Microsoft Certified Master of SQL Server credential. Amit has been working with SQL Server since 1999 and has been part of countless mission-critical SQL deployments. Performance Tuning in SQL Server is his core area of expertise. To learn more about Amit, visit http://sqlmaestros.com/amit-bansal.
Henry Rooney
LinkedIn: Henry Rooney
Having worked with SQL Server for more years that I can remember I am still enthusiastic about the product encouraging business to take advantage of the second greatest asset they have, their data!!! I have presented at numerous user groups and SQLSaturdays and enjoy sharing my thoughts and receiving feedback on what my thoughts are.
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.
Benjamin Nevarez
Twitter: - @BenjaminNevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server independent consultant based in Los Angeles, California, who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning amp; Optimization” and “Inside the SQL Server Query Optimizer” and co-author of “SQL Server 2012 Internals.quot; Benjamin has also been a speaker at many SQL Server conferences, including PASS Summit, SQL Server Connections, and SQLBits. His blog can be found at http://www.benjaminnevarez.com.
Gogula Aryalingam
Twitter: - http://www.twitter.com/gogula
LinkedIn: Gogula Aryalingam
Contact: http://datamaul.wordpress.com
Gogula is a data analytics professional from Sri Lanka, with 14+ years on the Microsoft data platform. He has worked with many aspects of data analytics and BI solutions from architecting, designing, developing and consulting across various industries and verticals. He is Regional Mentor for PASS South Asia, Data Platform MVP, MCSE, former MCT, and MSc in IT. Gogula’s passion revolves data analytics and BI; hence enjoys writing, teaching and speaking about the things he works with. He was also involved as an SME for Microsoft certification development. He currently juggles his full time job as Lead Architect while speaking at local and foreign events, along with regular stints at the Sri Lankan Data Community which he co-founded.
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
Anupama Natarajan
Twitter: - @shantha05
LinkedIn: Anupama Natarajan
Contact: http://www.anupamanatarajan.com
Anu Natarajan is a Data and AI Consultant with 15+ years of experience working in design and development of Data Warehouse, Business Intelligence, AI enabled applications, and SaaS integrated solutions. Anu is a Microsoft MVP Data Platform, Microsoft Certified Trainer and passionate in sharing knowledge. She loves solving complex business problems with innovative solutions using technologies. Anu also speaks at conferences including PASS Summit, SQLSaturdays, Data Platform Summit, Difinity, and she organizes local user group meetups.
Michael van Halderen
Twitter: - @Mickvanhalderen
Contact: http://www.serioussqlserver.com
Michael van Halderen is an independent SQL Server professional who has been working in the IT industry for over 15 years. He has worked exclusively with SQL server for more than 10 years in both DBA and DB Developer roles in Australia and the UK. Michael has contributed to SQL Server course development in Redmond, is an MCSE: Data Platform; and is certified to implement Azure Infrastructure solutions.
Martin Cairney
Twitter: - martin_cairney
LinkedIn: Martin Cairney
Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQLSaturday events and User Groups round the world
Phillip Seamark
Twitter: - PhilSeamark
LinkedIn: Phillip Seamark
An accomplished database and business intelligence (BI) professional with an in-depth knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling.
Expert knowledge in all facets of BI/DW including planning architecture, project management, dimensional modelling, performance tuning, ETL design, development and optimization, report and dashboard design as well as installation and administration. Author of multiple books on DAX.
Over 27 years of commercial experience in delivering business applications across a broad range of technologies.
Sponsors
The following is a list of sponsors that helped fund the event: