Event Location:
Unitec Institute of Technology
139 Carrington Rd, Mount Albert
Auckland, Auckland, New Zealand
Abstract:
You may have heard the word "DevOps" and wondered whether it is just another buzzword and/or what it can do for you. In this session I will demystify the concepts of DevOps and we will look at two aspects of DevOps - Continuous Integration Continuous Delivery. Continuous Integration is the practice in which software developers frequently integrate their work with that of other members of the development team.It also involves automating tests around the integrated work Continuous Delivery is the next step after Continuous Integration in the deployment pipeline and is the process of automating the deployment of software to test, staging, and production environments. Database migrations/changes are an area that may not be typically automated or utilise Continuous Delivery. Through the use of a comprehensive live demo to a running database hosted in Azure the audience will learn the benefits and how to implement Continuous Delivery in their database systems deployment pipeline.
Speaker(s): Hamish Watson,
Abstract:
Some database / data warehouse developers are still using handcrafted scripts to deploy database changes between environments as well developing directly on a database and then scripting changes from that. This was one of the traditional way to do things, but as developers we should not be doing that anymore. Microsoft has provided us an excellent database development tool in SQL Server Database Projects. In this session, I will demonstrate how to use SQL Server Database Projects, discuss the benefits of using SQL Server Database Projects for authoring databases, and demonstrate the benefits of integrating your database development with Microsoft Visual Studio Team Services.
Speaker(s): Craig Bryden,
Abstract:
High Availability and Disaster Recovery (HA/DR) planning is not just about the technology. When thinking or talking about High Availability/Disaster Recovery, many people jump straight to a particular technology without understanding other factors impacting the solution, and then waste time working backwards to understand requirements. Recovery Objectives, SLA’s and budget are some of the commonly overlooked factors when planning and developing a HA/DR solution. In this session we will walk through the 6 building blocks I take into account when developing a HA/DR solution. You can then use this same methodology to implement High Availability and/or Disaster Recovery in your own environment, working forward to determine the right technology.
Speaker(s): Warwick Rudd,
Abstract:
So your really familiar with databases - but only from the perspective of an operation DBA. Your management have decided that they need some reports and they are going to use your systems - and that you are going to build them. You'll need to design these to work optimally with your current system - and although you've heard and read a fair bit about data warehousing, you have limited experience. Where should you start? what are your options? Come along to this session and find out some of the things that you might want to take notice of and some of the options that are open to you as well as ways to make those reports really shine - which will really impress your management team
Speaker(s): Martin Catherall,
Abstract:
R integration with Power BI provides more flexibility for users. People able to have more visualizations which not exist currently in Power BI such as: normal distribution chart, column width chart, different type of subplots in a map, five dimensions chart with facet and so forth. Moreover, writing R scripts inside power query and Power BI Visualization enable users to do machine learning using R cods. In this session, first I will show how to create some interesting charts using ggplot package inside Power BI. Then, I will show how to do Machine Learning inside Power query by following machine learning process: data gathering, data cleaning, feature selection, model creation, data sampling and finally prediction. I will show how to do predictive analysis using KNN algorithm. Moreover, a short explanation about KNN algorithms concepts will be provided.
Speaker(s): Leila Etaati,
Abstract:
We've mastered the basics of basic database design patterns, but what happens when you or a teammate wants to use THIS ONE WEIRD TRICK to improve on your database design? Have you just discovered a brilliant new trick that no one else has ever thought of? Or will your new design cost you more, take on more risk and cause all kinds of pain for both IT and your business users? We'll demo tricks that we've seen in our database design reviews and show you how they work and talk about the trade offs for using them. You' learn about: Building a database engine inside your database, Implementing Hierarchies, Dealing with data structures that don't do as well in RDBMSs, Generating code out of the database, Optimizing the developer versus the data or the app, Using design patterns that don't reflect modern architectures and tools, and a lot more.
Speaker(s): Karen Lopez,
Abstract:
Have you use Power BI for a real-time dashboard? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power QA to respond intelligently? Have you head of structured columns in Power Query? Have you used Calculated Tables in DAX? Have you used Power BI Embedded? Have you done many other amazing things with Power BI? In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.
Speaker(s): Reza Rad,
Abstract:
Service broker provides scalable asynchronous message processing that can prove extremely useful to both DBA’s and Developer’s. However, Service Broker is possibly one of the least used components of SQL Server despite debuting in the product in 2005. This session will aim to demystify Service Broker and introduce people to some of the major benefits that it offers. We’ll build a full application which will demonstrate just how easy it is to get up and running with this technology. This session is aimed at people with little to no Service Broker knowledge and aims to show how applications can be easily created with Service Broker. You should leave this session with enough knowledge to then take your Service Broker skills to the next level and be capable of handling more complex projects.
Speaker(s): Martin Catherall,
Abstract:
Graph database is type of database that uses graph attributes – edges (or relationships) and nodes (or vertices) and features, to store data. Relationship between nodes are through edges and features (also called properties) hold the values to represent the strength or direction of the edges. SQL Server 2017 offers graph database capabilities to model many-to-many relationships. The graph relationships are integrated into T-SQL and receive the benefits of using SQL Server as the foundational database management system. In this session we're going to be looking at the key differences between a standard relational database and a graph database, including what datasets are best suited for each type, and how to work between them.
Speaker(s): Dave Dustin,
Abstract:
SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds. For example, by taking advantage of services like Azure Blob Storage or Azure VMs we can increase the availability of our services or distribute data in smart ways that benefit our performance and decrease cost. In this demo-heavy session, you will learn the strongest use cases for hybrid scenarios between on-premises and the cloud, and open a new horizon of what you can do with your SQL Server infrastructure. SQL Server and Azure are built for each other. New hybrid scenarios between on-premise SQL Server and Azure mean they don't have to exclude each other but instead you can have the best of both worlds. Key Learning: Integrating SQL Server and Azure Scaling on-premises SQL Server using Azure Extending on-premises to the cloud Demos: The demo will demonstrate some of the
Speaker(s): Murilo Miranda,
Abstract:
SQL Server 2017 being released brings to the table some new features and improvements in quick succession from SQL Server 2016. In this session we will look at a subset of the new /or improved features that SQL Server 2017 brings to the table. From Analytics, Availability, Configuration and Performance there is something for everyone in this session to introduce you to the latest version of SQL Server.
Speaker(s): Warwick Rudd,
Abstract:
In this session I will display the new functionality of SQL Server 2016 called Stretch Database, with which you can optimize the storage and manipulation of historical data integrating an instance of SQL Server to SQL Azure.
Speaker(s): Vitor Fava,
Abstract:
Storage is getting cheaper and data is being generated at an exponential rate. As a database professional, it is only a matter of time until you will be supporting a database which is measured in Terabytes. Multi-Terabyte databases come with their own challenges, and this presentation aims to provide the audience with the knowledge required to proactively and effectively manage multi-terabyte databases in SQL Server.
Speaker(s): Michael van Halderen,
Abstract:
Come to this session to hear from all DBA and DEV speakers in the event. You will have the opportunity to ask them any questions and get high valued responses. Topics for the free discussion is around DBA and DEV topic.
Speaker(s): Karen Lopez,
Abstract:
When On-Premise Data Warehouses are not the only option, many questions arise surrounding Azure SQL Data Warehouse. This session will cover the fundamentals of using Azure SQL Data Warehouse. From a beginner's perspective, the benefits of using this product will be discussed, as well as pricing measurements and the differences from Azure SQL Database and Big Data. I will explain how to deploy this service in only a few minutes by using some of the latest features such as extracting data from Azure Data Lakes and Azure Blob Storage through PolyBase.
Speaker(s): David Alzamendi,
Abstract:
Flow and Powerapps along with Power BI caters power users to build and deliver BI solutions without writing any code. In this session, I will walk you through a) What is Microsoft Business Application Platform? b) What is Flow and how to use it for automation? c) What is Powerapps and how to create an app without writing code? d) How to create an business application using Flow, Powerapps and Power BI?
Speaker(s): Anupama Natarajan,
Abstract:
Do you love monitoring but still wish you could be doing something else instead? Join me for creating your own monitoring tool using Powershell and then impress your boss with pretty PowerBI reports. We will discuss remoting, daily monitoring, trend analysis and then customizable reports.
Speaker(s): Manjot Kaur,
Abstract:
SQL Server R Services is a new feature in SQL Server 2016. In this session I will show the set of resources required for running R in SQL Server 2016. I will also show how to transform large amounts of data into a format that is ideal for building a predictive model.
Speaker(s): Indira Bandari,
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,
Abstract:
Come to this session to hear from all BI and Analytics speakers in the event. You will have the opportunity to ask them any questions and get high valued responses. Topics for the free discussion is around BI and Analytics topic.
Speaker(s): Reza Rad,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/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.
LinkedIn: https://nz.linkedin.com/pub/leila-etaati/36/46/b03
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQL Saturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQL Saturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
LinkedIn: https://br.linkedin.com/in/vitorfava
Contact: https://www.vitorfava.com
I'm a DBA with extensive experience in the areas of Database and Information Technology, working on planning, implementation, and maintenance of large corporate database servers. I have several professional certifications and good experience in development activities and management of entrepreneurial environments using SQL SERVER. I'm a speaker at various technology events such as SQL Saturday, The Developers Conference, InteropMix and also in various discussion groups focused on database technology. I teach advanced training in SQL Server and Azure SQL Database and also acting as MCT in Microsoft official training. I'm the Chapter Leader of SQLManiacs PASS chapter.
LinkedIn: http://nz.linkedin.com/in/rezarad/
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.
LinkedIn: http://au.linkedin.com/pub/warwick-rudd/0/956/718
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
LinkedIn: https://nz.linkedin.com/pub/leila-etaati/36/46/b03
Contact: http://blog.radacad.com
Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQL Saturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQL Saturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.
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.
LinkedIn: http://pt.linkedin.com/in/murilomiranda/
Murilo Miranda is a blogger, speaker and SQL Server MVP from Portugal. Nowadays he#39;s a Cloud Operations Engineer at DataStax. Murilo’s passion for working with people coupled with his honesty have helped him establish effective, meaningful relationships with his clients. When he isn’t working, he can be found enjoying life with his family, watching football and playing Playstation.
LinkedIn: http://www.linkedin.com/in/karenlopez
Contact: http://datamodel.com
Karen Lopez is a Sr. Project Manager and Architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a Data Platform MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. Karen’s presentations are known for their lively and interactive approach to learning. Her motto: “Love Your Data!”
LinkedIn: https://www.linkedin.com/in/martincatherall
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.
LinkedIn: https://nz.linkedin.com/in/hamishwatson8
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.
LinkedIn: https://www.linkedin.com/in/martincatherall
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.
LinkedIn: https://www.linkedin.com/in/craigbryden/
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
LinkedIn: https://www.linkedin.com/in/indira-bandari/
Contact: http://mytechlearning.blogspot.co.nz/
Indira is a Microsoft Data Platform MVP in New Zealand. She has a Masters degree in Statistics and is passionate about data, analytics and Artificial Intelligence. She is a BI and SQL Lead, an international speaker, mentor and part time trainer with over 15 years of experience in designing and developing data warehouses and analytical solutions. Volunteering and sharing her knowledge is her passion. In her pass time, she runs free game development classes, database concepts and data visualization classes for 9-16 year old kids. She is a Co-organiser for Data, Insights and Power BI User Group , Auckland AI Meetup Group and SQL Saturday Auckland. She speaks at various conferences, Virtual Webinars, PASS events etc
LinkedIn: https://nz.linkedin.com/in/hamishwatson8
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.
LinkedIn: http://nz.linkedin.com/in/rezarad/
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.
LinkedIn: https://nz.linkedin.com/in/anupama-natarajan-516a107
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, SQL Saturdays, Data Platform Summit, Difinity, and she organizes local user group meetups.
LinkedIn: http://au.linkedin.com/pub/warwick-rudd/0/956/718
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
With more than 35 years industry experience, Dave has worked with organisations and data systems of all sizes. He is currently Principal Engineer at Xero.
I have been working with SQL server for over 10 years. I have been an internal DBA and a consultant. I am passionate about automation, cloud technologies, performance tuning and learning SQL internals. In my free time I love to read, playing with my toddler and trying my hands on new recipes.
LinkedIn: https://www.linkedin.com/in/dalzamendi
Contact: https://www.techtalkcorner.com
Delivering Business Intelligence and Data Analytics Solutions with On-Premises and Cloud technologies since 2011, David Alzamendi is a Microsoft Certified Solutions Expert and event speaker who solves problems with best practice procedures and the latest technology. David is passionate about the positive impact data can have on our lives, businesses, economy and the environment. He prides himself on using his creativity and optimism to solve what others thought impossible.
LinkedIn: http://au.linkedin.com/pub/warwick-rudd/0/956/718
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
The following is a list of sponsors that helped fund the event.