- AI and Machine Learning
Machine Learning is a branch of Artificial Intelligence that enables systems to learn from data, identify patterns and make decisions with minimal human intervention. Machine learning is becoming an increasingly popular topic, and businesses will often request AI/machine learning as a solution to a complex problem. However, machine learning is not a magic crystal ball, and is not appropriate in all situations. In this session, we will go through some of the fundamentals of machine learning models, discuss when these models are appropriate to use, and go through a demo of how to create a basic model in Azure Machine Learning Studio. Presenter: Courtney Haley About the presenter: First finding a passion for data analysis and machine learning while studying Engineering, Courtney completed an undergraduate thesis project on the optimisation of neural networks for forecasting household electricity usage. Courtney is currently part of MOQdigital’s Applications, Data and Analytics team, and works to deliver actionable data insights to clients using a range of Microsoft technologies.
- The Relevant DBA
In this session, Henry will address the disruption that is being experienced in the data management sphere and how a DBA can look at the options they have to apply their skills to this new world. About the Presenter Henry Rooney has worked with SQL Server for nearly 20 years. Over that time there have been significant developments in the service and keeping up with the way that the product has morphed is a fascinating challenge. Currently employed at Microsoft as a Technology Solutions Professional, he is involved with data on premises and in the cloud encompassing all services, from SQL to CosmosDB, SQLDW, Data Lake and Analytics.
- Exploring Azure Cosmos DB
Exploring Azure Cosmos DB Cosmos DB is Microsoft's No SQL database offering on Azure. It is a multi-model database service, designed for global distribution and rapid scaling. Originally introduced as Document DB, Cosmos DB is slowly, but surely, gaining popularity. It is suitable for enterprise OLTP and analytics applications that need to handle massive amounts of data at a global scale with near-real response times. This introductory session will help you get familiar with core concepts such as partitioning, throughput and global distribution. A good understanding of these concepts is vital to designing your Cosmos DB container to scale seamlessly and perform optimally. This will be followed by an overview of the various APIs and data models supported by Cosmos DB. Demo will cover container creation through Azure portal, a sample project, the database migration tool and Cosmos DB change feed. Try Cosmos DB for free - https://azure.microsoft.com/en-au/free/ About the Presenter: Arjun Sivadasan After starting his career as a .NET programmer in 2007, Arjun soon got addicted to working with data after inadvertently solving a performance problem in a team meeting. Having worn multiple hats over his career as a Database Developer, DBA and Data Team Lead, he currently leads the Data Analytics team at Minor Hotels ANZ. Arjun is excited about innovations happening in the data space, and is focused on solving business problems through data solutions aimed at fostering a culture of data-driven decision making.
- Azure Data Platform End2End
Many of us - data people - come from a traditional, on-premise, relational data background. And depending on the size and complexity of the organisations we have worked for; it means that some of us never had a chance to work on Big Data projects. We hear a lot about how cloud, data lakes, Spark, machine learning and AI are revolutionising the world of analytics while we keep working on our SQL queries to generate a management dashboard. Organisations looking to stay relevant in the market recognise the value of data and are now asking their Data Architects to modernise their data platform. They have the mammoth task to handle an ever-growing amount of data that comes in different shapes and very fast. In order to fulfil the request, they are looking to leverage the power and flexibility of Azure cloud data services, but the problem is...there are so many of them! "What do they do?", "How they talk to each other?", "Which one should I choose?", "What does an architecture look like?" are the most common questions I hear. In this session we will put together many of the Azure data services in a common architecture that will be able to handle most data scenarios in your organisation.” About the Presenter: Fabio Braga Passionate data architect with over 20 years of experience in Microsoft data solution architecture design, implementation, optimisation and support of mission critical environments, such as banks, government, water and energy companies, superannuation and finance industry. With knowledge and experience in data solutions, software development and infrastructure support, I am able to develop end-to-end solutions to achieve the client’s need both on premise and in the cloud. My previous roles as pre-sales consultant, delivery architect, Microsoft trainer and most recently as Cloud Solution Architect at Microsoft. I hold a Bachelor degree in Computer Science and several Microsoft certifications. As Microsoft Official Trainer, I have delivered over 2,500 hours of Microsoft Official Courses on SQL Server and .NET. Continuous learning has always been part of my career and, just as important to acquire knowledge, it is to share it. I have developed a solid IT career built upon discipline, pro-activity, leadership, organisation and creativity. New challenges have always motivated me to keep learning and sharing knowledge with all teams that I have worked with.
- Predictive Modeling using R and SQL Server Machine Learning Services
In 2017, Microsoft introduced SQL Server Machine Learning Services letting us run R or Python scripts in SQL Server, and providing easy access to Machine Learning within the database. Have you explored this SQL Server feature already? This session will help you get familiar with SQL Server Machine Learning Services. We will go over its components and features, and understand how it brings data scientists and developers closer. As an example, we will build a Predictive Model using R and SQL Server Machine Learning Services. About the Presenter Arjun Sivadasan After starting his career as a .NET programmer in 2007, Arjun soon got addicted to working with data after inadvertently solving a performance problem in a team meeting. Having worn multiple hats over his career as a Database Developer, DBA and Data Team Lead, he currently leads the Data Analytics team at Minor Hotels ANZ. Arjun is excited about innovations happening in the data space, and is focused on solving business problems through performant data solutions and fostering a culture of data-driven decision making.
- Provisioning Dev/Test environments efficiently whilst protecting your data
As data professionals, we need to aim towards the most efficient way of provisioning production data to non-production environments while remaining compliant with data protection regulations. We also need to make sure that this process is performed as quickly as possible and at the same time ensuring that it uses the least amount of storage. With the effective usage of virtualization and data masking capabilities, provisioning full copies of protected databases takes a few seconds and saves up to 99% disk space. SQL Provision helps create, protect and manage SQL Server database copies for compliant DevOps without increasing the risk of a data breaches. In this session we will learn how to: - Protect our data and Easily comply with regulations - Create cloned databases (fast and with minimum storage requirements) - Automate the provisioning process. SQL Provision supports database DevOps while keeping compliance central to the process. About the Presenter Anderson Rangel An experienced Data Platform professional with over 14 years’ experience managing complex SQL Server environments on behalf of ASX-listed, private and public organisations across Australia. Using a consultative approach, I specialise in helping organisations unlock the value in their business data, architecting tailored solutions using the Microsoft Data Platform. I am business oriented with an intrinsic technical mindset. I am passionate about collaborating with people to drive results using technology.
- Azure Data Warehouse, a game changer
Trying to get some tips to start using Azure Data Warehouse? Do you know how Azure Data Warehouse is different from Azure SQL Database? Trying to process Terabytes of data in only a few minutes? This session will answer and expand upon each one of these questions. Azure Data Warehouse was released 4 years ago and has been maturing across its lifetime. With the release of the second generation of this service, as well as the integration with other services such as Azure Blob Storage Version 2 (including Azure Data Lakes) or the use of Polybase, it has become one of the services that should be considered in any Data Warehouse scenario or when you are looking to process a large volume of data in a short period of time. About the Presenter 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.
- Partitioning: The ‘why’ is easy, it’s the ‘how’ that stumps us
Database partitioning has been available since SQL Server 2005, however, it’s rare to find a DBA who has configured their database to make use of this feature. In this session, Darren will take you through the how, when and why for implementing partitioning in your databases, and the common pitfalls to avoid. By the end of this session, you will know how to identify good candidates for partitioning and determining the correct partitioning key to implement the feature. About the Presenter Based in Brisbane, Darren Dawson is a Microsoft Certified Solutions Expert and Data Platform Solutions Architect at WARDY IT Solutions. Darren has been working with SQL Server since SQL Server 2000, spanning a wide range of industry verticals. Since starting his journey as a junior DBA at Flight Centre, Darren has gained significant experience working with companies of all sizes across Australia and internationally, to help them design, build and improve their Microsoft SQL Server data assets. He’s passionate about modernisation, particularly Azure cloud solution s, and everything from designing and building HADR solutions to Reporting Services. Outside of work, you’ll most likely find Darren in ‘The Den’ at Brisbane Roar soccer matches across Australia and Asia.
- Getting Asynchronous with SQL Server and Service Broker
Service Broker has been inside SQL Server since the 2005 release, however it seems to be a vastly under-utilised component – despite its usefulness. In this session we will look at how a simple Service Broker implementation can be put together and then scaled. We will also look at how this technology can aid with increased responsiveness of our applications and various other uses such as monitoring and data warehouse scenarios. About the Presenter Martin Catherall has over 15 years of experience working with data- driven applications built on SQL Server and the Microsoft Data Platform technology. Martin founded the Christchurch SQL Server User Group and ran several SQL Saturdays in that city before relocating to Melbourne in early 2016. He currently volunteers as a Regional Mentor for PASS and maintains strong involvement in the Australian and New Zealand Data Platform communities. Martin’s current interests are around database testing and DevOps for the database.