SQLSaturday #582 - Melbourne 2017
Event Date: 02/11/2017 00:00:00
Event Location:
- Monash University, Caulfield Campus
- 888 Dandenong Road
- Caulfield East , Victoria, 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: Query Store: A (R)evolution in Query Tuning
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 and how it can be used in a myriad of use cases. We will examine its architecture, configuration and shortcomings. This session will help you build a monitoring solution that will help you detect and solve real-world performance problems across your entire SQL Server infrastructure. It will also substantially help de-risk upgrade projects, so there’s no “excuse” not to upgrade to SQL Server 2016!
Speaker(s):
- Victor Isakov
Track and Room: Application Database Development - HB.36 (Rocksolid SQL)
Title: Azure Cognitive Services - The Rise of the Machines!
Abstract: With advances in computing power, advanced machine learning algorithms and globally consumable data sources the real world use cases for Cognitive Services within our everyday lives has begun to grow significantly. This fun and demo heavy session first introduces the full suite of Azure Cognitive Services API’s and discusses the approach to solution design, API deployment and consumption within the context of a set of real deployments and practical use cases. The session then deep dives into 2 of the more commonly deployed Azure Cognitive Services detailing methods available for SQL and .Net developers to code, interact, and scale the usage of the Cognitive API services to create interesting, fun and innovative solutions. At the end of this session you will have a much clearer understanding of how the suite of Azure Cognitive Services could be used within your business and the methods available by which you can start to plan, deploy and actively consume these innovative services.
Speaker(s):
- Rolf Tesmer
Track and Room: Azure Services and Platform - HB.40 (Insight/Ignia)
Title: R; One Ring to Rule Them All
Abstract: R is one of the most popular and powerful analytics languages. That helps data scientists to prepare data, predict data, and visualize it. Microsoft offers several deployment options to bring next-generation advanced analytics to your business. Microsoft R Server delivers R-based analytics to where your data lives. Processing analytics in-place eliminates data movement, reducing latencies and operational costs. In this session, first basic concepts of machine learning will be discussed. Then, a demo of how to use R for data wrangling, and visualization (show map) in R studio will present. Then I will show how R can be helpful for software developers to create a intelligence software using R in visual studio and Azure ML API in c# codes. Finally a couple of demos will be presented on how R can help BI developers and database administrators using R server ,R in SQL Server 2016, and power BI to create smart reports.
Speaker(s):
- Leila Etaati
Track and Room: Analytics and Visualization - H1.25 (Sandisk)
Title: Making DevOps work in the wild…
Abstract: You may have heard about DevOps and wondered whether it is just another buzzword and/or what it can do for you and your organisation. In this session I will demystify the concepts of DevOps and more importantly show it in action in a real life application deployment pipeline. By using a realistic live demonstration and great technologies such as the Azure platform, Team Foundation Server, SSDT and docker on Windows Server 2016 I will show how DevOps can help you automate deploys reliably and repeatedly to your production applications. You will be able to take what you learned in this session and implement it successfully in your organisation.
Speaker(s):
- Hamish Watson
Track and Room: Strategy and Architecture - H1.25 (Sandisk)
Title: Become A Troubleshooting Ninja with PowerBI and SQL Server Extended Events
Abstract: New to Extended Events? Want to become a ninja in troubleshooting common SQL issues using extended events? This is a demo filled session that will show you how to troubleshoot several common issues in SQL server database engine and identify hotspots as well failures using only extended events. The session will showcase how extended events make scenario based troubleshooting easier using Power BI dashboards and without having to collect disparate sets of diagnostic data, gather memory dumps and comprise on performance. There have been a plethora of Extended Events which have been added to SQL Server recently based on customer feedback which deprecates the need to run profiler in many commonly encountered situations in production environments. This session covers the new enhancements and capabilities available for Extended Events.
Speaker(s):
- Ajay Jagannathan
Track and Room: Enterprise Database Administration Deployment - H1.26 (Microsoft)
Title: How you can use disconnected tables in PowerPivot/Tabular models to solve real world problems
Abstract: When people first start out with Power Pivot/Tabular data models, the first thing they learn is how to create “one to many” relationships between tables. But did you know it is quite valid to load tables into your data model that are “disconnected”?
In this session I introduce 4 real world scenarios that demonstrate how you can use the power of DAX disconnected tables to solve business problems. The scenarios are:
- Allow users to perform what if analysis and change the calculation values in a pivot table by altering the input values for key variables using a slicer.
- Allow users to change the series that is displayed on a chart using input from a slicer.
- Grouping you customers into age groups so you can create cohorts for reporting and analysis using “banding”
- Displaying the “latest survey result” in a Pivot Table for any date selected. It is very easy to see the “results” for a period using Power Pivot/Tabular. But it is much harder to find the “latest “ from any period.
Speaker(s):
- Matt Allington
Track and Room: Analytics and Visualization - HB.39 (Wardy IT)
Title: Common TSQL Mistakes
Abstract: We are going to examine a variety of oopsies MANY developers fall prey too - some obvious, some pretty subtle and some down right sneaky! Lots of code examples with the bad AND good code presented. I GUARANTEE that you will find things here that will either prevent you from getting bad data, throwing unwanted errors or vastly improving your database application’s performance. I have given this talk over SEVENTY times now and it is always very highly rated!
Speaker(s):
- Kevin Boles
Track and Room: Application Database Development - HB.40 (Insight/Ignia)
Title: SQL Server 2016 SP1: Enhancements that will make your SQL Server roar!
Abstract: This session will showcase several improvements in SQL Server 2016 SP1 that address some of the most common customer pain points with HA and the Database Engine. as well as diagnostics. Understand these changes in performance and scale, and the new and improved diagnostics for faster troubleshooting and mitigation.
Speaker(s):
- Sunil Agarwal
Track and Room: Enterprise Database Administration Deployment - H1.26 (Microsoft)
Title: Oh, When did THAT change happen?
Abstract: “Oh, when did that change happen?” is a reasonably common question that SQL consultants hear. Closely followed by “who made that change?” and possibly “how do we revert the change?”. There’s a few mechanisms available in SQL Server to do this – but we have to have these active in order to capture information about the change. In this session, we’ll look at some of the options that we have available to us for auditing data (and meta data) changes. These include SQL Audit and the new Temporal tables and Query Store features among other. You should leave this session with a firm knowledge of which feature is right for your auditing scenario.
Speaker(s):
- Martin Catherall
Track and Room: Application Database Development - HB.40 (Insight/Ignia)
Title: Database Administration for Azure SQL DB
Abstract: Azure SQL DB promises low touch once you have deployed your database. However the reality is that to gain the maximum benefit and lowest cost, you still need to be proactive with monitoring and management of your database. This session will identify the main aspects of the Azure SQL DBA role, including how to ensure you have longer term backups (if you need them for compliance), how to manage your Tier level automatically, how to ensure you have the best performance to keep your DTUs to a minimum. You will leave this session with a better story for your manager to convince him to move your workload to Azure and lower your total SQL Server costs.
Speaker(s):
- Martin Cairney
Track and Room: Azure Services and Platform - HB.40 (Insight/Ignia)
Title: SQL Server on Linux - The How, the What and the Why?
Abstract: In this Demo Heavy Session we will explore the recently released SQL Server on Linux
Join me as we try to understand questions like? How do we install and run SQL Server on Linux? What is different, what is the same? What may be better? What might be worse? Why would it be useful? What new skills will you need?
The presentation will be based around experience gained in evaluating the Public CTP and will help introduce you into the brave new world of SQL Server on Linux
Speaker(s):
- Patrick Flynn
Track and Room: Enterprise Database Administration Deployment - HB.39 (Wardy IT)
Title: What on earth are all the Azure* and Power* services and why would I want them?
Abstract: Don’t know your Power Apps from your Power BI, Flow, etc.? In this session Greg will do his best to explain what on earth all the various services are, or at least the ones that he thinks are relevant to data people. Can’t promise the final list until nearer the day but the aim at present would be to spend a short while on each of: SQL DB, SQL Data Warehouse, Elastic Database Pools, DocumentDB, Search, Storage, Power BI, Power Apps, Flow, Event Hubs, Stream Analytics, Azure ML, Cortana Intelligence Suite, Azure AD
Speaker(s):
- Greg Low
Track and Room: Azure Services and Platform - H1.25 (Sandisk)
Title: 10 Amazing Things About Power BI You Don’t Know
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
Track and Room: BI Platform Architecture, Development Administration - H1.25 (Sandisk)
Title: Automate Data Warehouse build and deployment (db,SSIS SSAS) with Visual Studio 2015 and TFS
Abstract: See a demonstration of automated generation, build and deployment of a Data Warehouse (database, SSIS and SSAS) using Visual Studio 2015 and ‘Visual Studio Team Services’ Online.
It’s not enough to ‘do’ Agile you must ‘be’ Agile…
This means modifying, building and deploying your DW/BI solution, on a daily/weekly basis. Achieving this without automation is very difficult.
Topics include:
- Visual Studio 2015 and Visual Studio Team Services Online licencing for BI developers (things have changed).
- A primer on setting up a project in ‘Visual Studio Team Services’.
- Automated Data Warehouse development (code generation) in Visual Studio 2015.
- Using MSBUILD, Source Control and Build Release functionality of ‘Visual Studio Team Services’ to automate the build and deployment of a Data Warehouse, SSIS and SSAS Cubes to multiple environments.
Grab a free script at the end to get you started.
Speaker(s):
- Adam Gilmore
Track and Room: BI Platform Architecture, Development Administration - HB.36 (Rocksolid SQL)
Title: Excel tips and tricks for the data professional
Abstract: Data is fast becoming the new currency of the 21 century as compute power increases whilst the cost of the storage decreases. Analysing data has never been easier with tools like Azure Machine learning (and R) which can provide powerful insights. Many data professions can only provide these insights if the has been cleaned beforehand. Microsoft Excel is one of the tools of choice for BI professionals and Data Scientists. This session will show a number of killer Excel tips and tricks that every data geek should be using in their career. This session will enable you to go back to the office and wow your boss and clients with cool and amazing techniques! Well … only if they are also data geeks.
Speaker(s):
- Bernard Spence
Track and Room: BI Platform Architecture, Development Administration - HB.36 (Rocksolid SQL)
Title: How to Use Parameters Like a Pro and Boost Performance
Abstract: Parameters are a fundamental part of T-SQL programming, whether they are used in stored procedures, in dynamic statements or in ad-hoc queries. Although widely used, most people aren’t aware of the crucial influence they have on query performance. In fact, wrong use of parameters is one of the common reasons for poor application performance. In this session we will learn about plan caching and how the query optimizer handles parameters. We will talk about the pros and cons of parameter sniffing as well as about simple vs. forced parameterization. But most important – we will learn how to identify performance problems caused by poor parameter handling, and we will also learn many techniques for solving these problems and boosting your application performance.
Speaker(s):
- Guy Glantser
Track and Room: Application Database Development - HB.36 (Rocksolid SQL)
Title: Why your charts suck and how to fix them
Abstract: Building effective data visualizations is an increasingly important skill. As data professionals the amount of data and the speed at which it is arriving is constantly growing. At the same time our business users are increasingly time poor in a world filled with distractions and shiny things. With social media, instant messaging, conference calls and emails if the message that you are trying to convey is not clear, engaging and easy to understand it will not get the attention that it deserves.
Clicking next, next, next, finish on a chart wizard is not the way to build engaging data visualizations.
In this presentation we will look at what you need to consider to build clear and engaging data visualizations and what pitfalls you should avoid.
Speaker(s):
- Darren Gosbell
Track and Room: Analytics and Visualization - H1.26 (Microsoft)
Title: Scalable Application Design with Service Broker
Abstract: How your business applications interact directly with the corporate database can dramatically affect how successful you are. One of the biggest issues is performance with large databases. By designing the application to use asynchronous messaging for non-critical updates, you can focus performance concerns where the timeliness is critical. SQL Server Service Broker handles the asynchronous requests quickly and efficiently and minimizes conflicts with your critical updates. This session walks you through the steps to get Service Broker running and providing a consistent delivery of your business data.
Speaker(s):
- Allen White
Track and Room: Application Database Development - H1.25 (Sandisk)
Title: New Security Features in SQL Server 2016
Abstract: SQL Server 2016 promises to be one of the more interesting releases from a security perspective. This releases sees an unprecedented number of new security features. And already, the market is getting it “wrong” with a number of “myths” and “misconceptions” growing about how these features work. This session will examine these new security features, specifically Always Encrypted, Dynamic Data Masking and Row-Level Security. It will look at these new features potential benefits, implementation considerations and importantly their limitations. Make sure you attend this session if you want to implement security correctly in SQL Server 2016!
Speaker(s):
- Victor Isakov
Track and Room: Application Database Development - HB.39 (Wardy IT)
Title: R for Database Administrators
Abstract: “R”, the latest buzzword in data platform, has all along been viewed as programming language for data scientists. However, “R” can be a handy tool for database administrators too. The presentation will show case how “R” can be used innovatively by Database Administrators to handle some of their common problems like tracking query regressions, capacity planning and detecting performance abnormalities. The session will introduce few algorithms of “R” and showcase how it can be used in DBA’s world. The session would serve as a good starting point for DBA’s exploring the world of “R”
Speaker(s):
- Nagaraj Venkatesan
Track and Room: Enterprise Database Administration Deployment - HB.32 (SQLSaturday)
Title: Plan, Design and Implement a HADR Solution - a Journey
Abstract: Have you ever struggled to get a HA and DR solution for a single instance with more than 50 applications, 100 databases and 4 TB of data? Over the years, HA and DR has been a challenge with SQL Server. As the product evolved so did the options simplified for achieving a feasible HADR solution. In this session I will walk you through various projects I have worked on in past 8 years. I will start with the basic DR solution built using Log shipping, an alternate to AGs in SQL 2008 using Powershell/.NET and SAN Replication and the latest 4 node, two site cluster built with Availability Groups.
Speaker(s):
- Manohar Punna
Track and Room: Enterprise Database Administration Deployment - HB.32 (SQLSaturday)
Title: SQL Security in the Cloud
Abstract: Our data should be secure. And our environment too. What we can do for maximize security in a hybrid environment, where SQL Server exist in two forms: premise and cloud. How organize our job, how control our data if we use Windows Azure SQL Database - The Cloud Database. Physical security, policy based management, auditing, encryption, federation, access and authorization. All of those subjects will be covered on my session.
Speaker(s):
- Tobias Koprowski
Track and Room: Enterprise Database Administration Deployment - HB.40 (Insight/Ignia)
Title: Statistics and New Cardinality Estimator Model
Abstract: Statistics in SQL Server plays a major role creating execution plan which essentially decides server performance. If you get a good execution plan the server performance is good otherwise it will impact negatively on the server performance. SQL Server 2014 introduced new Cardinality Estimation (CE) model to improve the quality of the execution plans via quality estimates of row counts. The new CE model is a major redesign to the Query Optimizer since SQL Server 7.0. In this session, I’m going to talk about how statistics is used to generate the execution plan, how execution plan changes with new CE model with demos.
Speaker(s):
- Susantha Bathige
Track and Room: Enterprise Database Administration Deployment - HB.32 (SQLSaturday)
Title: Simplify management of multi-server, multi-region SQL Server deployments with Conductor4SQL
Abstract: Conductor4SQL helps organisations with a large SQL Server footprint to manage their environment remotely in a more effective and efficient manner with guaranteed resiliency. We will cover topics that are critical to every SQL Server DBA including: security, auditing, governance, task automation, system standardisation and real-time data synchronisation -all of which are great aspects to the Conductor4SQL product.
Speaker(s):
- Michael Carder
Track and Room: Enterprise Database Administration Deployment - HB.32 (SQLSaturday)
Title: DW SuperHero-Columnstore Index
Abstract: Columnstore indexes were introduced in SQL 2012. They have the superpower to boost SQL server performance by flipping row based indexing to column based indexing. In this session, we will cover basics of this technology, its usability, performance impact, implementation (through demo), access mechanism and what’s new in SQL 2016.
Speaker(s):
- Manjot Kaur
Track and Room: BI Platform Architecture, Development Administration - HB.39 (Wardy IT)
Title: The Power of Power Query!
Abstract: Microsoft Power Query started a revolution in self-service data transformation. First launched as an Excel add-in, this incredible product was soon integrated into Excel 2016, and became a core component of the wildly successful Power BI Desktop. Thi
Speaker(s):
- Matt Masson
Track and Room: Analytics and Visualization - H1.26 (Microsoft)
Title: Intro to Azure Data Lake and U-SQL
Abstract: With ever growing demand to store different types of data and provide intelligent analytics, it can be a challenging task for data professionals. Join this session to learn more about the on-demand scalable platform for big data analysis, Azure Data Lake, that allows you to use language that you are already familiar with. This session will show case an end-to-end demo using Azure Data Lake for image processing and text analysis.
Speaker(s):
- Julie Koesmarno
Track and Room: Analytics and Visualization - H1.26 (Microsoft)
Title: Adding Powershell to Your Skillset
Abstract:
Powershell is not new, but to those bred and raised on the GUI it can be incredibly intimidating. This session is a complete beginners guide to understanding Powershell, how it works and what you can do with it. You’ll learn what a cmdlet is, what it does and how you can make it work for you.
Most importantly - you’ll learn how Powershell can make your job administering a SQL server easier and allow you to do more, faster.
Speaker(s):
- Rob Douglas
Track and Room: Enterprise Database Administration Deployment - HB.32 (SQLSaturday)
Title: What’s new in Azure SQL DB and SQL engine
Abstract: I will share the new improvements in Azure SQL DB and SQL engine
Speaker(s):
- Lindsey Allen
Track and Room: Azure Services and Platform - H1.26 (Microsoft)
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.
Speaker(s):
- Craig Bryden
Track and Room: Analytics and Visualization - HB.32 (SQLSaturday)
Title: 2016 – The Rise and Fall of DBM
Abstract: With the release of SQL Server 2016, a true shift achieving and implementing High Availability and Disaster Recovery has come about. Database Mirroring has been the only option available to meet certain requirements. SQL Server 2016 now changes the game and in this session Warwick will introduce you to the replacement for DBM taking you through what there is, what it gives you and how you can move from DBM to AGs.
Speaker(s):
- Warwick Rudd
Track and Room: Enterprise Database Administration Deployment - HB.39 (Wardy IT)
Title: Proactively Identifying and Dealing with SQL Server Database Corruption
Abstract: Corruption occurs on every SQL Server database whether we like it or not. And the only way to minimize downtime and data loss when it occurs is to proactively identify and deal with database corruption.
In this session, we will learn how to identify and detect database corruption. We will look at incorporating these different approaches in proactively identifying corruption in our regular database maintenance routines. We will also look at how to deal with database corruption using restore or repair that is appropriate to your edition of SQL Server.
Speaker(s):
- Edwin M Sarmiento
Track and Room: Enterprise Database Administration Deployment - H1.25 (Sandisk)
Title: Real time reporting with Power BI
Abstract: Real-time dashboards and reporting is no longer an exclusive technology with Power BI currently offering several ways to achieve that. In this session we will look at and talk about several ways you can achieve that and include demo(s) on those technologies. We will cover technologies such as using Azure Stream Analytics, Power BI REST APIs and recently introduced Streaming Datasets feature in Power BI service.
Speaker(s):
- Ankit Patira
Track and Room: Azure Services and Platform - HB.36 (Rocksolid SQL)
Title: 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.
Speaker(s):
- James Beresford
Track and Room: BI Platform Architecture, Development Administration - HB.36 (Rocksolid SQL)
Title: SQL Server Integration Services
Abstract: SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications.
It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
Speaker(s):
- Johnley John
Track and Room: BI Platform Architecture, Development Administration - HB.39 (Wardy IT)
Title: Azure SQL Data Warehouse - Massive, Parallel, and in the Cloud
Abstract: Azure SQL Data Warehouse is a cloud-based massively parallel database platform, based on the concepts that the Analytics Platform System/Parallel Data Warehouse uses for on-premises extreme performance. While it appears at first glance to be a familiar SQL Server environment, Azure SQL Data Warehouse has a few gotchas and design implications that can bite you (and your data warehouse’s performance!) if you’re not aware of them. This session will teach you the basic concepts of Azure SQL Data Warehouse, and provide tips and guidance on how to get the most of it.
Speaker(s):
- Jim McLeod
Track and Room: BI Platform Architecture, Development Administration - HB.40 (Insight/Ignia)
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Michael Carder
LinkedIn: Michael Carder
Contact: http://www.michaelcarder.co.uk/
Michael Carder Ltd is a specialised consultancy providing highly-skilled staff and services in Finance and Business Information Systems within highly focused and complex business areas. Our teams have extensive experience providing the Management Information and Forecasting systems working with large UK Government clients like the Tribunals Service, Ministry of Justice and HM Courts Tribunals Service. We are now working closely with a new partner EnterpiseWorx, to help promote their incredible enterprise SQL server management tool Conductor4SQL . The presentation will focus on the highlights and benefits of this tool and how it can simplify the work for a multi-server, multi-region SQL server system.
Jim McLeod
Twitter: - @Jim_McLeod
LinkedIn: Jim McLeod
Contact: http://www.jimmcleod.net
Jim McLeod is a Canberra-based SQL Server consultant with Ignia. Coming from a software development background, Jim chose to specialise in SQL Server in 2005, with a particular focus on database performance. Since then, Jim has worked with most aspects of SQL Server on databases of all sizes across a large number of industries, with the focus in the past few years on data warehousing, Azure and Analytics.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
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.
Darren Gosbell
Twitter: - darrengosbell
LinkedIn: Darren Gosbell
Contact: http://darren.gosbell.com
Darren Gosbell has been working with the Microsoft Data Platform since 1999. He has practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Darren has been awarded as a Microsoft MVP SQL Server since 2006 in recognition of his contribution to the community specially in the areas of Analysis Services, MDX and DAX. Darren is a contributor to a number of open source projects including BIDS Helper, DAX Studio and ASStoredProcedures.
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
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.
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
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.
Bernard Spence
Twitter: - TweetItReal
I am a Senior Business Intelligence Consultant with 21 years experience with SQL Server. I work at Readify where I help clients improve the performance of their SQL Server instances, SSAS solutions, and SSIS packages
Johnley John
LinkedIn: Johnley John
Expertise in SQL Server, SSRS, SSIS, .NET, VB.Net, Crystal Reports.
Adam Gilmore
Twitter: - @dimodelo
LinkedIn: Adam Gilmore
Contact: http://www.dimodelo.com/blog
Adam Gilmore is a Data Warehousing and Business Intelligence Architect with 10+ years experience using Microsoft technologies to deliver BI and DW Solutions. Adam is the Founder of Dimodelo Solutions, an Agile Data Warehousing and Business Intelligence consultancy. Dimodelo Solutions is the developer of ‘Dimodelo Architect’ an Agile Data Warehouse development tool built on the Microsoft Visual Studio platform.
Adam has presented at a number of SQL Server events in Brisbane including the SQL Server User Group and SQL Server Saturday.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
Sunil Agarwal
A seasoned professional with 30+ years of industry experience in databases, Sunil has worked as a lead developer for relational database engine solutions, as a tool designer for backup and restore technologies and as a development manager for B2B commerce and e-learning solutions. He has been in his role as a Principal Program Manager for SQL Server for the last 12+ years. Sunil has authored many technical white papers and blogs, and has co-authored two books on SQL Server and has presented database technologies in numerous national and international conferences. He enjoys teaching and has taught introductory programming courses at the University of Rhode Island and the University of Colorado.
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.
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.
Susantha Bathige
Twitter: - @sbathige
LinkedIn: Susantha Bathige
Contact: http://www.sqlservertorque.net
Susantha Bathige (MSc, MCITP) is a Microsoft Certified Database Professional specialized in relational database product, MS SQL Server. Having more than 16 years of IT experience including more than 9 years in database development and administration in non-production and production environments. He has experience of other databases systems such Cassandra and MongoDB as well.
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.
Guy Glantser
Twitter: - guy_glantser
LinkedIn: Guy Glantser
Contact: https://www.madeiradata.com/blog
Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS Local Group, as well as the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant, or a speaker. His main area of expertise is SQL Server development and optimization. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQLSaturdays, and user groups around the world. He also co-hosts the SQL Server Radio podcast.
Matt Masson
Twitter: - @mattmasson
Contact: http://www.mattmasson.com/
Matt Masson is a Program Manager in the Information Management and Machine Learning (IMML) organization. Matt has worked on multiple data integration products, including Power Query, SSIS, DQS, MDS, and the Data Management Gateway for Power BI. He has authored two books on SSIS (Apress, and MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at http://www.mattmasson.com/.
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.
Julie Koesmarno
Twitter: - @mssqlgirl
LinkedIn: Julie Koesmarno
Contact: http://www.mssqlgirl.com
Julie Koesmarno, MCSE Data Platform, and MCSE Business Intelligence, MCT, is a Senior Program Manager at Microsoft, with a Bachelor’s degree in IT. She has over 10 years of experience working with SQL Server for large-scale and multi-million-dollar OLTP and ETL projects as a SQL Server developer and system analyst/designer. Her past projects include delivering a SQL Server 2012 data warehouse and BI solutions in the US and Australia. She now works with hybrid, cloud and on-prem SQL projects.
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.
James Beresford
Twitter: - @BI_Monkey
LinkedIn: James Beresford
Contact: http://www.bimonkey.com
James - aka the BI Monkey - has been delivering Microsoft BI Solutions for over a Decade. He#39;s an unashamed SSIS geek and is responsible for the heavily downloaded BI Monkey ETL Framework on Codeplex. Recently he#39;s been digging in to Data Quality Services in SQL2012 and also developing on the HDInsight Big Data platform.
In his spare time he cultivates two small BI Monkeys - so really has no spare time!
Matt Allington
Twitter: - @exceleratorbi
LinkedIn: Matt Allington
Contact: http://exceleratorbi.com.au/exceleratorblog/
Matt is a BI Professional with over 30 years’ experience in the Consumer Packaged Goods industry. He has held senior job commercial and IT roles, always leveraging data to drive success. Matt was the BI Director for Asia Pacific at The Coca-Cola Company before leaving to set up his own consulting business in 2014.
Matt is now the Principal Consultant at Excelerator BI and specialises in helping small, medium and large companies leverage Microsoft Excel, Power Pivot, Power BI and SharePoint to deliver rapid business value through Self Service Business Intelligence.
Leila Etaati
Twitter: - @leila_etaati
LinkedIn: Leila Etaati
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: SQLSaturday 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, SQLSaturday, 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.
Manjot Kaur
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.
Rolf Tesmer
Twitter: - @TesmerR
LinkedIn: Rolf Tesmer
Contact: https://mrfoxsql.wordpress.com/
Rolf has 20+ years IT experience and has been working with the SQL platform since v6.0 (that’s 1994!) and has done just about everything you can around SQL related data and data platforms / architectures ever since then. I have a personal interest in All Things Cloud and Data (Azure, Streaming Data / IoT, Data Warehousing, Machine Learning, Visualisation and SQL Spatial). I have had the opportunity to present at PASS, TechEd, PASS SQLSaturday, PASS Virtual Chapter, SQL User Groups, Big Data Seminars, Microsoft Technology Roadshows, Breakfast Seminars, ++ and enjoy sharing and learning new ideas.
Ankit Patira
Twitter: - /AnkitPatira
LinkedIn: Ankit Patira
Ankit currently works as a Data AI Solution Architect for Insight Enterprises in Melbourne. He is regular speaker at various Microsoft events and conferences. His primary area of focus is Cloud, BI, AI, Machine Learning, Data and Advanced Analytics.
Ajay Jagannathan
Twitter: - @ajaymsft
Contact: https://blogs.msdn.microsoft.com/sqlserverstorageengine/
Ajay Jagannathan is a Principal Program Manager Lead for Azure SQL Database and SQL Server Engine PM team, based in Redmond. He has an MS in Computer Science and over 20 years of industry experience. He is currently responsible for driving product strategy and roadmap for the database engine for SQL Server and Azure SQL Database to deliver breakthrough innovations and product experiences from inception to engaged customer usage that modernize database to handle the speed, variety and scale of today’s data. He partners closely with several customers to understand product usage and feedback to drive improvements in the product. He has deep experience in various features of the database engine spanning over ten versions (SQL 6.5- SQL 2017).
Tobias Koprowski
Twitter: - @KoprowskiT
LinkedIn: Tobias Koprowski
Contact: http://koprowskit.eu/geek/
Founder of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff.
Microsoft Certified Trainer, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and more. Since 1st July 2010 Data Platform MVP. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences. STEM Ambassador.
Traveler. Coffee Addicted.
Lindsey Allen
Twitter: - @herdcat
Contact: http://sqlcat.com
Lindsey Allen is GPM with SQL Server, SQL Azure engineering, worked at Microsoft for more than 21 years.
Warwick Rudd
Twitter: - @warwick_Rudd
LinkedIn: Warwick Rudd
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.
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.
Edwin M Sarmiento
Twitter: - EdwinMSarmiento
LinkedIn: Edwin M Sarmiento
Contact: http://www.EdwinMSarmiento.com
Edwin M Sarmiento is the Managing Director of 15C, a consulting and training company that specializes in designing, implementing and supporting SQL Server infrastructures. He is a 12-year former Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada (but he’s originally from the Philippines) specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack. His background in Unix has taken him to the world of DevOps and Docker to containerize SQL Server. He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.
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
Sponsors
The following is a list of sponsors that helped fund the event: