SQLSaturday #464 - Melbourne 2016
Event Date: 02/20/2016 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: Introduction to Biml BimlScript
Abstract: Within every Data Warehouse project there is always ETL development that is very repetitive in nature, for example, you need to import 20 different flat file exports from the ERP system, you need to load 15 dimensions into the data warehouse and so on. With Microsoft SSIS out-of-the-box, you are forced to create multiple individual packages which is very time consuming due to the lack of easy code reuse. In a typical BI project, the ETL implementation can easily take up 60% of the project time, so it is beneficial if the development time of similar SSIS packages can be cut down. Business Intelligence Markup Language (Biml) is an XML dialect for defining Business Intelligence assets across the Microsoft SQL Server platform In this session Craig will introduce you to Biml BimlScript, providing those new to Biml with a foundational understanding of what BIML is and what the benefits of using Biml are.
Speaker(s):
- Craig Bryden
Track and Room: BI Platform Architecture, Development Administration - HB.36
Title: Practical Partitioning
Abstract:
What can you do when you have an ever growing database, shrinking maintenance windows and increased demands from application queries? Enter “Table Partitioning”!
In this session we’ll initially talk to the basics of how partitioning works, and why it may be beneficial to your database. We’ll then demonstrate real practical methods to show how partitioning techniques can be applied to tables and the positive and negative impacts partitioning will have to your database queries and design. We’ll then wrap up with a demonstration on leveraging partitioning for database maintenance operations such as optimisations and the implementation of partial database backups.
This session will have a strong focus on real, practical, and hands-on partitioning methods and key concepts that DBA’s can apply from Day 1.
Speaker(s):
- Rolf Tesmer
Track and Room: Enterprise Database Administration Deployment - HB.36
Title: Protecting your data in the Cloud
Abstract: Are you concerned about moving to cloud, because of the safety of your data ? Organizations choose to go with the platform services of Azure using SQL Databases or they go with the Infrastructure services of Azure using virtual machines, in both cases security of your data is vital. This demo driven session will give you all the information you need to know about the security implementations available in SQL Databases in Azure and SQL Server. The session will cover the following topics with demos. Introduction to cloud adaptation of the organizations, - how enterprises adopt to the cloud and how startups are moving to the cloud. SQL relational store options in Azure. Security features of SQL Databases Cloud demanded security features of SQL Servers Using Azure Key Vault to secure data in SQL Server
Speaker(s):
- Vijayakumar Thurupathan
Track and Room: Cloud Application Development Deployment - HB.39
Title: Automated Test Driven Development with SQL Server using nUnit
Abstract: Testing software is hard work. Testing BI solutions is even harder;there’s lots of moving parts, the tools are thin and it takes a lot of time and effort. Software development uses unit testing and while this can be applied to the different parts of a BI solution, most people are more interested in the numbers the solution produces and proving that they are right.
So can you validate the numbers in your BI solution? And can you do it quickly and easily?
In this session we will cover an approach for automating the validation of your BI solution covering multiple scenarios with a hand full of demos. We will be using nUnit as a framework and some free codeplex tools, so we can run a suite of tests every time we load data into our BI platform. This is not continuous integration, and it is not unit testing in the true sense either. It is, instead, “continuous validation”, and it can provide you with an awful lot of assurance for not very much extra effort.
Speaker(s):
- Dan de Sousa
Track and Room: BI Platform Architecture, Development Administration - H2:41
Title: A Lap Around Columnstore.
Abstract:
Columnstore indexing was first introduced in SQL Server 2012.
The technology was designed to give significant performance gains for datawarehouse queries.
This initial version required some creative thinking to get all of the promised performance gains. This meant that adoption rates were not that high.
However, SQL Server 2014 added significant functionality, which SQL Server 2016 builds upon. Come along and get a lap around this feature and find out how its adoption could help your organisation.
Attendees should leave this session will enough knowledge about the storage, architecture and query enhancements to implement a successful columnstore feature and administer it.
Speaker(s):
- Martin Catherall
Track and Room: BI Platform Architecture, Development Administration - HB.40
Title: Azure Machine Learning: From Design to Integration
Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. In this session, learn how a Microsoft Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with machine learning algorithms, and then finally to the integration and integration of predictive insights.
This session has been specifically designed to describe machine learning fundamentals, and to help enable and inspire existing developers taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease in which it can be accomplished.
Speaker(s):
- Peter Myers
Track and Room: Advanced Analysis Techniques - HB.32
Title: SQL Server 2016: A Monster of a Release
Abstract: Without a doubt SQL Server 2016 will be a monster of a release. It will easily eclipse all other versions of SQL Server that have been released in scope of features, technology and breadth of vision. No wonder Gartner has positioned Microsoft as a Leader in the Magic Quadrant for Operational Database Management Systems. More importantly, Microsoft is placed furthest in vision and highest for ability to execute within the Leaders Quadrant. In this session we will examine SQL Server 2016 and have a look at what’s new in the Database Engine, Analysis Services, Reporting Services and Integration Services. We will highlight the “big ticket” items and discuss the business cases for using the technology and features. We will also discuss Microsoft’s vision for the Data Platform and how SQL Server will evolve in the future.
Speaker(s):
- Victor Isakov
Track and Room: Strategy and Architecture - HB.36
Title: Introduction to Querying Cubes - Swallow the Red Pill
Abstract: In this talk we will look at how you can get started with writing your own queries against cubes. We will start from a basis of SQL queries and compare and contrast equivalent DAX and MDX queries.
Being able to write your own queries is an important skill to know for the following reasons: • It makes it a lot easier to identify issues with your data, • It can provide a much faster way to test and develop measures, • It’s an extremely effective way of doing performance tuning • It can extended your reporting capability by providing a means of extracting data that is difficult or impossible to do with GUI tools.
As in the Matrix movie I’m inviting you to take the red pill and come with me on a journey. At the end of our session you should have an understanding of the basic concepts of querying cubes and how to get started writing your own queries.
Speaker(s):
- Darren Gosbell
Track and Room: BI Information Delivery - RockSolid Room (H1.26)
Title: Toolkit for DAX Optimization
Abstract: How do you optimize a DAX expression? This session will introduce you to the useful tools to measure performance, gathering data to find the bottlenecks and helping you in writing new optimized versions of DAX. Starting from SQL Profiler, you will learn which events are relevant for DAX, and how to collect them in different environments (Analysis Services, Power Pivot, Power BI). We will show DAX Studio, which simplify and speed-up the data collection process, and makes it easy to find bottlenecks in storage engine and formula engine. VertiPaq Analyzer and other small tools will be also used to collect other useful information. The goal of the session is to provide you a methodology to analyze performance of your DAX measures, to find the bottleneck and to identify the main reason of a performance issue.
Speaker(s):
- Marco Russo
Track and Room: BI Platform Architecture, Development Administration - Wardy Room (H1.25)
Title: Indexing for Optimal Performance
Abstract:
An Index can be the difference between your query returning in microseconds, seconds, minutes or hours! That makes them an incredibly powerful and often misunderstood part of the data driven application performance. In this session we’ll review if you have the right indexes, or the wrong ones. We’ll look at the internals of how indexes become fragmented and explain why this can have such a severe impact on the performance of your application and what you can do to combat that.
You’ll leave this session with a much better understanding of how your indexes work, and the knowledge and confidence to streamline your current Index optimization procedures to take your applications to new heights of performance.
Speaker(s):
- Rob Douglas
Track and Room: Application Database Development - RockSolid Room (H1.26)
Title: Lightning talk - Live Query Statistics
Abstract: Live Query Statistics is a new feature(ish) introduced in SQL Server 2016. In this lightning talk I will demonstrate the Live Query Statistics extracted from my DBA life made easier with 2016, Query Store and LQS. LQS will help in troubleshooting long running queries to pin point the pain points in the query execution even before the query completes the execution.
Speaker(s):
- Manohar Punna
Track and Room: Enterprise Database Administration Deployment - H2:41
Title: How Available is SQL Server 2016
Abstract: Having your SQL Server databases not available for business to be making money is not a good way to stay employed. Do you understand what features and options can assist you with keeping SQL Server Databases Available?
In this session we will look at the options available to you currently to meet your Availability requirements using features being released in SQL Server 2016 to better provide high availability
Speaker(s):
- Warwick Rudd
Track and Room: Enterprise Database Administration Deployment - HB.39
Title: Being Smarter with Azure Machine Learning and R
Abstract: How to get a better insight about the current situation of organization by analysing the Data? How we can predict the next step? Machine Learning is a subfield of computer science, which is so pervasive today that you probably use it dozens of times a day without knowing it. Azure Machine Learning is a valuable tool that can be employed by data scientists with different skill levels. Azure ML also supports R custom code, which can be dropped directly into your workspace. In this session, I will show a demo of interaction of R language with Azure Machine Learning, uploading R package into Azure ML, preparation of the data in R, and How to publish a R code into Azure ML.
Speaker(s):
- Leila Etaati
Track and Room: Analytics and Visualization - HB.40
Title: Maintain SQL Server Performance Baseline w/PowerShell
Abstract: Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: Enterprise Database Administration Deployment - HB.32
Title: Top 10 Clustering Dos and Don’ts
Abstract: Clustering SQL Server still vexes many in one way or another. For some, it is even worse now that both AlwaysOn features - clustered instances (FCIs) and availability groups (AGs) - require an underlying Windows Server failover cluster. Storage, networking, Active Directory quorum, and more are topics that come up quite often. Learn from one of the world’s experts on clustering SQL Server some the most important items - both good and bad - that you need to do to be successful whether you are creating an FCI, AG, or combining both together in one solution.
Speaker(s):
- Allan Hirt
Track and Room: Enterprise Database Administration Deployment - Wardy Room (H1.25)
Title: Getting started with Agile Business Intelligence
Abstract: Are you building Business Intelligence solutions but want to learn how to develop smarter, more business ready products? Are your customers frustrated with what appears to be slow progress? Do your projects always struggle with constant scope creep? Join me to discuss how to implement Agile principles into your project. We will discuss: • Gathering requirements, quickly designing a solution and start building • Tracking your progress, risks and issues without Microsoft Project • Handling scope creep • Continuously improving your efforts to get better and faster
Speaker(s):
- Kelly Broekstra
Track and Room: Professional Development - H2:41
Title: Power BI Rises; Wonderful Things You Can Do
Abstract: Power BI comes with bunch of new tools and features; Power BI Desktop is great editor for Power BI solution, it integrates Power Query for data transformation, Power Pivot for modeling, and Power View for data visualization. Power BI also has Android, Apple and Windows apps. Power BI website also provides some level of slicing and dicing the data, as well as dashboards features. In this session you will learn through many live demos how to get most of Power BI for real world scnearios. You will be amazed with features of Power BI and what you can do with this toolset.
Speaker(s):
- Reza Rad
Track and Room: BI Information Delivery - RockSolid Room (H1.26)
Title: Azure for the SQL Server DBA: What we need to know, and how to get started
Abstract: SQL Server has shipped with features that integrate Azure since 2008 R2. Fast forward to 2016 and we have seen plenty of development from Microsoft in the cloud arena. As our IT landscape evolves in support of cloud-based computing, this technology will slowly but surely become more integrated into the life of a DBA. In this session we explore what Azure means for your applications, how to identify good candidates for the cloud, and how to build your Azure knowledge FAST.
Speaker(s):
- Michael van Halderen
Track and Room: Enterprise Database Administration Deployment - HB.39
Title: Data Warehouse in Azure - Intro and Demo
Abstract: Session to provide an introduction to Microsoft Azure Services (SQL Data Warehouse, Data Lake / blobs etc) to simulate a live and breathing DW platform, living off Azure completely. Will as well touch a little on Data Vault as part of model generation.
Speaker(s):
- Vikas Rajput
Track and Room: BI Platform Architecture, Development Administration - HB.40
Title: Hybrid Solutions with SQL Server 2016
Abstract: By its nature, SQL Server installations on-prem can often require significant CapEx investment on a recurring basis. If you are considering the cloud then you want to ensure that you have received the maximum return from that investment before you switch to a fully OpEx model. Hybrid solutions can let you scale and migrate your SQL Server workloads into Azure while still getting the maximum return from your on-prem infrastructure.
Speaker(s):
- Martin Cairney
Track and Room: Cloud Application Development Deployment - Wardy Room (H1.25)
Title: An overview of SQL Openquery
Abstract: Openquery - Executes the specified pass-through query on the specified linked server.
In this session, we’ll look into the following
- When to use Openquery?
- How to use Openquery without effecting server performance?
- Guidelines when using Openquery
Speaker(s):
- Johnley John
Track and Room: Information Delivery - H2:41
Title: Keynote Session
Abstract: Microsoft Data Platform Update from General Manager – Mark Souza Redmond, WA USA
Mark will be flying over from the states to give the latest updates from the engineering team with respect to the Microsoft data platform. With the upcoming release of SQL Server 2016 around the corner you will get a drill in on the product including the latest on performance and customer experiences. Mark will also give you an update on the other important pieces of the platform including Azure SQL DB, Azure SQL DW, Data Lake, Hybrid capabilities, etc.
Speaker(s):
- Martin Cairney
Track and Room: Other - K3.09
Title: Interesting Facts on SQL Server Use
Abstract: RockSolid SQL monitors thousands of SQL Server databases around the globe. In this short and punchy session we present real-world facts on how SQL Server is commonly used, configured, managed and maintained. From versions deployed, to upgrade cycles, backup methods, cloud migration etc. Please join us for this session, we think you’re bound to learn something interesting.
Speaker(s):
- Martin Catherall
Track and Room: Other - RockSolid Room (H1.26)
Title: I didn’t know SSMS could do that
Abstract: Think you know your way around SQL Server Management Studio? This session will let you know if you really do. Lots of demos of ways to use SQL Server Management Studio that you might not have seen.
Speaker(s):
- Greg Low
Track and Room: Other - HB.39
Title: MPP - What you should know about Massively Parallel Processing
Abstract: SQL DW and PDW both use Massively Parallel Processing (MPP). But what is this and what should you know about it? This session quickly moves from introductory material through to design patterns and troubleshooting. You’ll learn how to make important decisions about scale-out, and leave with the skills you need to get into this growing space.
Speaker(s):
- Rob Farley
Track and Room: BI Platform Architecture, Development Administration - RockSolid Room (H1.26)
Title: Securing Data on your terms
Abstract: This session will take you through a number of different security options, from Always Encrypted, Row Level Security, and Dynamic Data masking. Both for SQL Azure and SQL Server 2016.
Speaker(s):
- Kristina Rumpff
Track and Room: Enterprise Database Administration Deployment - HB.40
Title: Killing FearOps with a culture of DevOPS
Abstract: FearOps is a fear of change, a fear of manual/automated deploys going anywhere near production systems. DevOPs is about breaking down the silos of mistrust between development and operations teams and aligning the two teams around delivering a product to market faster. It is about a cultural shift as much as a process and technological one. In this session we will look at some of the challenges implementing DevOps, the benefits of it, and how it can help you remove FearOps from your organisation.
Speaker(s):
- Hamish Watson
Track and Room: Enterprise Database Administration Deployment - H2:41
Title: Distributed Replay: Testing With Your Data, Your Way!
Abstract: Do you want to test hardware upgrades, index tuning or multi-client applications? Would you like to do this with data specific to your organization? Distributed Replay, introduced in SQL Server 2012, is a tool that will allow you to accomplish exactly that. In this session, we will cover why you should use it, how to set it up, and what types of data to collect for testing and replay. This session will demonstrate tangible methods and undocumented tidbits, that you can take back to your environment to create immediate, and measurable tests.
Speaker(s):
- Melody Zacharias
Track and Room: Application Database Development - HB.32
Title: Build an Activity-Based Costing System with Power BI
Abstract: Get a sneak preview of my USA 2016 PASS Analytics Conference session - creating an Activity-Based Costing System with Power BI. Having the final report model in Power BI gives you the ultimate control over reporting, including adding other information possibly not even held with Information Technology.
We will use a real-world health care model to show how we replaced an expensive, difficult to understand and maintain SAS system, with a simple, elegant, and auditable solution based on the Microsoft stack. The rules are table-driven with allocated costs handling built in.
Speaker(s):
- Grant Paisley
Track and Room: Advanced Analysis Techniques - Wardy Room (H1.25)
Title: Automated and Repeatable Test Cases for Agile SQL Server Development.
Abstract: Automated and repeatable test cases are required for agile development. In this session we will look at some of the tools and techniques for automated testing with SQL Server. During demonstrations we will create some simple tests using the Visual Studio toolset and discuss how they can be used for Test Driven Development (TDD), unit testing, integration testing and acceptance testing. The presentation will cover testing SQL Server Databases, SQL Server Analysis Services and SQL Server Integration Services.
Speaker(s):
- Stefan Riedel
Track and Room: Application Database Development - H2:41
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Vijayakumar Thurupathan
Twitter: - thurutweets
LinkedIn: Vijayakumar Thurupathan
Contact: http://www.thuru.net
Thuru is a versatile technical person who has diversified experience in many areas of Information Technology for 6 years. Cloud computing, security, software development, business intelligence and databases are his most preferred technology areas.
He is a frequent speaker in Sri Lanka .NET forum and Sri Lanka SQL Server Universe user groups. Thuru is the founder of Colombo Cloud Meet Up where he often talks about various cloud computing topics. Also he is a Microsoft MVP for Microsoft Azure.
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
Kelly Broekstra
Twitter: - kellybroekstra
LinkedIn: Kelly Broekstra
Kelly is an Information Management, Business Intelligence, and Project Management specialist with over fifteen years’ experience in data warehouse development and a passion for understanding a client’s need to create the most fit for purpose solution achievable. Kelly has considerable practice utilising and adapting best practice principles to extensive BI and data warehousing projects at large and small organisations. Her desire for simplifying the development process while providing the best solution for the client is perfectly suited to the fast-moving BI world.
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.
Rob Farley
Twitter: - rob_farley
LinkedIn: Rob Farley
Contact: http://blogs.lobsterpot.com.au
Rob Farley runs LobsterPot Solutions in Australia, where he’s a consultant in the Microsoft Data Platform and Analytics space. He’s been an MVP since 2006, probably because of his blogging, his presentations around the world, and his dedication to the Adelaide Data Analytics User Group which he has led since before the release of SQL Server 2005. He’s on Twitter at @rob_farley, but you can always email him using rob@lobsterpot.com.au
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.
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.
Peter Myers
LinkedIn: Peter Myers
Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.
He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.
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.
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.
Melody Zacharias
Twitter: - SQLMelody
LinkedIn: Melody Zacharias
Contact: http://sqlmelody.com
Melody is the Sr. Microsoft Solutions Manager at Pure and has been in love with data since 1991. She has been sharing her passion with the community in technical sessions and blogs since 2014. She has been a Microsoft MVP since 2016, including winning Rookie of the year for Canada that year. This last year, she was elected to the board of directors for PASS.org, the professional association for SQL Server and was awarded Regional Director by Microsoft. She has co-authored 3 books, including, SQL Server 2019 Administration inside out by Microsoft Press.
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.
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.
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.
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.
Grant Paisley
Twitter: - @angrykoala
Grant Paisley is a Data Platform MVP and founder of Angry Koala, a Microsoft Business Intelligence partner based in Sydney, Australia. Grant is president of the SQL Server Usergroup Sydney and created http://reportsurfer.com, a community built around reporting, where you can also run the reports. He was contributing author for quot;SQL Server 2008 Analysis Services with MDXquot; and quot;Microsoft SQL Server Reporting Services Recipesquot;.
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.
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.
Vikas Rajput
LinkedIn: Vikas Rajput
Vikas is passionate about anything data. He has worked in consulting and core software development roles, and delivered solutions ranging from few MB sized Master Data to multi-billion 100+TB scalable data systems using Microsoft and other Data Technologies. Other than data, Vikas enjoys trekking, long walks, mentoring, visualization and automation (in no particular order!).
Johnley John
LinkedIn: Johnley John
Expertise in SQL Server, SSRS, SSIS, .NET, VB.Net, Crystal Reports.
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
Stefan Riedel
LinkedIn: Stefan Riedel
Stefan Riedel has been working with databases for more than 15 years, the last 10 of which have been focused on Microsoft SQL Server. Stefan has led and contributed to the implementation of many data warehouse and business intelligence solutions built using the Microsoft BI stack. To support these projects Stefan has designed and implemented automated testing and deployment tooling to support agile BI development methodologies. Stefan has presented at previous SQLSaturday events in Melbourne, Brisbane and Singapore.
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.
Kristina Rumpff
Twitter: - krumpff
LinkedIn: Kristina Rumpff
Kristina has been a DBA for the past 15 years, with a number of companies including IBM, and Telstra. She made the move over to Microsoft, and now gets to play with technology and tell others about how it can help them!
Allan Hirt
Twitter: - SQLHA
LinkedIn: Allan Hirt
Contact: http://www.sqlha.com/blog
SQLHA, LLC founder, consultant, trainer, author, and business continuity, infrastructure, and virtualization expert Allan Hirt has been working with SQL Server since 1992 when it was still a Sybase product. He has also been clustering in Windows Server since the late 1990s when it was known as Wolfpack. Currently a dual Microsoft MVP (Data Platform; Cloud and Datacenter Management) as well as a VMware vExpert, Allan works with all sizes of customers, no matter if they are on premises or in the public cloud. He also delivers training and speaks at events over the world.
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.
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.
Marco Russo
Twitter: - marcorus
LinkedIn: Marco Russo
Contact: https://www.sqlbi.com/blog/marco
Marco is a Business Intelligence consultant and mentor. He wrote several books about Power BI, Analysis Service, and Power Pivot. He also regularly writes articles and white papers that are available on sqlbi.com. Marco is a Microsoft MVP and an SSAS Maestro, the highest level of certification on Microsoft Analysis Services. Today, Marco focuses his time with SQLBI customers, traveling extensively to train and consult on DAX and data modeling for Power BI and Analysis Services. Marco also teaches public classes worldwide. Marco is a regular speaker at international conferences like Microsoft Ignite, PASS Summit, and SQLBits. He also enjoys delivering evening sessions at local user groups during his trips.
Dan de Sousa
Twitter: - @dcasousa
LinkedIn: Dan de Sousa
Contact: https://sqlblog2017.wordpress.com/
Dan de Sousa is a Senior Data Consultant for DSI in Mississauga, Canada. He has been working with SQL Server for the last 10 years and has been involved in the development of datawarehouses as well as creating reports and dashboards. Dan is currently working on a data security compliance project for Europe which involves making sure any personal information is secured/encrypted before leaving its country of origin.
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: