Difinity Conference 2017
NZ$293.25 – NZ$419.75
Difinity Conference 2017

Difinity Conference 2017

Event Information

Share this event

Date and Time

Location

Location

Stamford Plaza Auckland

22-26 Albert Street

Auckland, Auckland 1010

New Zealand

View Map

Friends Who Are Going
Event description

Description

What is Difinity?

Difinity is largest Microsoft Data Platform, Business Intelligence, and Analytics Conference in New Zealand. IT Decision Makers, Developers, Analysts, IT Professionals, Database Administrators, Architects, and Consultants will gather for three consecutive days of learning.

Details: http://difinity.co.nz

3 Days Conference

Difinity is a 3 days conference. The first day is full day workshop and the next 2 days we have 30 sessions.

Who will Speak

We have 14 Microsoft data platform MVPs , 3 MCMs and overall 20+ expert speakers from Microsoft Product Team, US, UK, Australia, New Zealand.

One-day Full Workshop on 7th Feb 2017

We have three workshops. All of our workshop speakers have been spoke in different Microsoft conferences workshops.

PLAN-FIRST QUERYING – WRITING QUERIES TO SUIT THE OPTIMIZER by Rob Farley ( MCM, MVP, MCT, International Microsoft Data platform Speaker ) from Australia

ARCHITECTING HIGHLY AVAILABLE SQL SERVER SOLUTIONS by Allan Hirt (MVP and International Microsoft Data platform Speaker) from USA

SSIS PERFORMANCE DESIGN PATTERNS by Matt Masson Senior Program Manager in Microsoft Power BI and He used to be Program Manager of SSIS team (SSIS born with his efforts) From USA

Advance Analytics with R, Azure Machine Learning, Power BI and Microsoft R server by Dr.Leila Etaati Microsoft MVP, PhD, Machine Learning Expert, Trainer and Data Scientist from New Zealand.

2-days full sessions on 8th and 9th Feb 2017

We have 30+ sessions on different subject of Microsoft Database Administration, Business Intelligence, and Data science presented by experts speakers in Microsoft data platform filed. check out the detail of these sessions from Here.

More details here: http://difinity.co.nz

Details of Sessions and Speakers

SSIS Performance Design Patterns

Track: Pre-Conference Full Day Workshop

Level: 400

Need a fast data integration solution, but don’t have the time or budget for heavy performance tuning? By selecting the right design, 90% of SSIS customers will achieve their ETL performance goals with little to no performance tuning. This session will teach you how to pick that design! Targeted at intermediate to advanced SSIS users, Matt Masson – a long time member of the SSIS team – will guide you through a series of proven SSIS design patterns, and teach you how to apply them to solve many common ETL problems. We’ll start off with an overview of the Data Flow internals, and review the SQLCAT team’s Top Ten Best Practices for achieving optimal performance. We’ll then dive into a series of design patterns, including Advanced Lookup Patterns, Parallel Processing, Avoiding Transactions, handling Late Arriving Facts, Cloud/On-Prem Hybrid Data Flows, and multiple ways to process Slowly Changing Dimensions. Finally, we’ll take a close look at the new features and functionality provided in SQL Server 2016.

If you’re looking for ways to maximize your SSIS ROI, then you won’t want to miss this!

This training session includes the following modules:

Module 1 – Data Flow Internals

Module 2 – Benchmarking and Performance Best Practices

Module 3 – Common Design Patterns

Module 4 – Lookup Design Patterns

Module 5 – Parallelization Design Patterns

Module 6 – Advanced Design Patterns

Module 7 – SSIS in SQL Server 2016

Module 8 – Combining Microsoft Technologies

Speaker

Matt Masson

Matt Masson is a Senior Program Manager in Microsoft Power BI Team. He used to be Program Manager of SSIS team, and SSIS born with his efforts. He speak and teaches many SSIS courses around the world. Matt has worked on multiple data integration products, including Azure Data Factory, Power Query, Power BI, SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS). He is currently part of Microsoft Power BI team working on Data Movement areas of Power BI. He has authored two books – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at www.mattmasson.com .


Architecting Highly Available SQL Server Solutions

Track: Pre-Conference Full Day Workshop

Level: 300

Every SQL Server implementation – whether you are running an older version or SQL Server 2016 – needs to be up when the business needs to access it. Performance matters, too, but if it’s not available to serve data or process transactions, performance does not matter. This full day will cover how to approach and understand what the the different availability options mean for your SQL Server deployments, whether they are features in SQL Server, Windows Server, at the hardware layer, in virtualization, or even the public cloud. Storage, networking, and many other aspects will be covered because a solution is more than picking a feature such as Always On Availability Groups, and an important aspect of this is learning how to talk to the non-SQL Server administrators. Come to this session and learn not only the best practices, tips, and tricks, but the practical, real world knowledge you need to keep your SQL Server instances and databases highly available.

Speaker

Allan Hirt

Microsoft MVP and SQL Server mission critical expert Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. Based in the Boston, MA area, he travels all over the world to work with and train clients and is currently working on the book Mission Critical SQL Server.


Plan-first Querying – Writing Queries to suit the Optimizer

Track: Pre-Conference Full Day Workshop

Level: 400

This day-long seminar takes a different approach to T-SQL, by teaching you to cater for what the Query Optimizer is doing.

The Query Optimizer turns your T-SQL query into a program known as a query plan, which runs to produce the data you’ve requested. GROUP BY does grouping, but the plan can choose a few different ways to do that. ON, WHERE and HAVING all filter, but the physical implementations can be identical or vastly different, depending on many other factors.

When you were taught to write T-SQL, you learned about how to create queries that are logically correct to produce the results you want. You were probably taught about using indexes, and other techniques for tuning, but not about Hash Aggregates, Spools, or Parallelism.

In this seminar, you will learn to write queries that produce the plans you want, and identify how particular query plan operators can help or hinder the performance of your queries, to give the kind of performance you should expect.

Speaker

Rob Farley

Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his ability to explain complex concepts simply are known throughout the SQL Server community. He blogs at http://sqlblog.com/blogs/rob_farley and at http://sqlperformance.com/author/robfarley , and is on Twitter at @rob_farley.


Advance Analytics with R, Azure Machine Learning, Power BI and Microsoft R server

Track: Pre-Conference Full Day Workshop

Level: 300

You keep hearing about the machine learning and R recently. R become a language for data analysis and machine learning that makes the need for learning it more clearly. Moreover, Microsoft introduces R server as a comprehensive platform for using machine learning and R functionality inside the data analysis tools such as SQL Server 2016 and Power BI.

At the end of this training you will learn

Module 1:

background of R, installing R studio, setting up R server in SQL Server, setting up R in power BI, and main concept of machine learning. You will learn the main data structure in R, Managing Data with R, Exploring and Understanding Data in R (exploring numeric variable, categorical variable and relationship between variables). Moreover, audience learn how to use some of the main packages in R.

Module 2:

You will learn different types of machine learning algorithms and how they work and how they can solve different type of real life problems. At the end of this module you will able to choose right algorithm for right problem. We may employ various algorithms and approaches:

  • Classification problems (e.g. using K-mean)
  • Predict numeric data (e.g. using linear regression, multiple regression, logistic regression and so forth)
  • Classification (decision tree, decision forest)
  • Neural network and support vector machines
  • Market basket analysis
  • Time series and forecasting
  • Anomaly detection
  • Recommendation (content-based filtering and collaborative filtering).

Module 3:

In third module, you will realise how to bring analytics and intelligence into you reports and developments. You will learn how to write and use these algorithms using Azure ML, R studio, Power BI, R visual Studio and SQL Server 2016 through the real life scenarios. Audience learn

  • The main functionality of Azure ML and how to set it up, how to import/export data via Azure SQL database, Stream Analytics, Excel, and on-premises will be shown. Moreover, an approach how to run web service and call it from different platform (Stream analytics, Power BI, R and so forth) will be presented. The different Azure ML components be will explained in detail. Also how to run R code inside the Azure ML and how to create a web service from R studio will be discussed.
  • Using R SQL Server 2016 for rung the R code inside the SQL Server scripts will be shown. Moreover, how to run different type of algorithm and how to store different result type will be explained. Moreover, how we can enhance the SSRS reports with R graphs will be presented.
  • How using R for data transformation and visualization in Power BI will be shown.
  • How to use text analysis via R code or available API in Cortana will be presented. Also, you will learn how to employ different text analysis algorithm to do sentiment analysis, keyword distraction and topic detection. Moreover, how to run the R code using Microsoft Visual studio and how it can be useful via some scenarios will be presented.

Module 4:

In the last module, audience will learn how to evaluate each of machine learning algorithm performance. Audience able to find the most accurate algorithm and how to choose the right parameters. The evaluation process both in R and Azure ML will be shown. Also, audience will learn with the process of feature selectin and cross validation.


Speaker

Leila Etaati

Dr Leila Etaati is Microsoft Data Platform MVP, and senior data scientist. She is an international speaker in different Microsoft conferences such Microsoft Ignite, SQL PASS summit, PASS BA, PASS 24H, SQL Saturday, SQL PASS Rally in USA, Europe, Australia, and New Zealand. She has more than 10 year’s experiences in Microsoft BI and analytics. She is a trainer in Microsoft BI and Machine learning topics.


Conference Sessions

Building a Centralized Database Maintenance and Monitoring Solution

Track: SQL Server Database Administration

Level: 200

Database Professional is always challenged with monitoring and maintenance across the environment. Be it 10 server or a 1000 servers, would it be easier to have a centralised solution?

In this session I will walk you through the simple steps of building a centralised database maintenance and monitoring solution. This solution will help a database professional to query all the monitored instances, collect performance metrics, run customized scripts and any maintenance task a database professional needs to perform across the database environment.

Talk about a easy DBA life, this is a definite simple solution you should build.

Speaker

Manohar Punna

Manohar Punna is a Senior SQL DBA by profession and a Data Platform Community Enthusiast by passion. He is a Microsoft Data Platform MVP and heads the Asia’s Largest Database Community, DataPlatformGeeks as President. He is the author of the longest one day blog series till date – One DMV a Day. In his day to day job he designs and builds new database systems, automate DBA activities, tune databases and queries and much more. He likes to get his hands dirty by exploring other tools like Powershell, .NET, WMI, etc to simplify DBA life. Manohar has also built tools like database service and health monitor, Job Activity Monitor, Using SanSnap to achieve HA and DR capabilities in SQL 2008 etc.

Building Data Models with Many to Many Relationships in Power Pivot/Tabular Data Models

Track: Business Intelligence

Level: 300

Power Pivot/Tabular data models are built on top of SQL Server Analysis Services Tabular which is optimised for lightning performance as a reporting tool. However one unfortunately side effect of delivering this performance is that SSAS Tabular does not directly support “Many to Many” relationships like a traditional relational database.

In this 300 level session, I introduce the many to many pattern problem and then demonstrate how to build a data model that supports the pattern using only “one to many” relationships. The session covers.

Why the 1 to many pattern doesn’t workHow to configure a many to many data model using a pattern that does workAn explanation of how and why the many to many pattern works through a deep analysis of evaluation contexts and context transition.

Speaker

Matt Allington

Matt Allington is a career expert in BI and has 30+ years experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Pivot and Power Query. He brings his business and IT experience to the table to get fast and effective results through training, consulting and general business data problem solving. Matt is the author of the book “Learn to DAX – A Practical Guide to Learning Power Pivot for Excel and Power BI”.

2016 – The Rise and Fall of DBM

Track: SQL Server Database Administration

Level: 300

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.
Goals:
Introduce you to what 2016 brings to the table allowing this shift from DBM.
Show you how to migrate from DBM to AG’s

Speaker

Warwick Rudd

Warwick Rudd is a SQL Server MVP, Microsoft Certified Master – SQL Server 2008, Founder and Principal Consultant at SQL Master Consulting. With over 15 years of experience beginning with the release of SQL Server 6.5, he has worked in both Australia and England from small start-ups to Multi-National Corporations. Warwick predominantly specialties in designing and implementing HA & DR Solutions. He is a frequent speaker at local SQL Server User Groups & SQL Saturday events, Ignite in Australia and New Zealand. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.

SQL Server Backup in the Era of the Clouds

Track: SQL Server Database Administration

Level: 200

Backup? Who cares! Now and Then? We store our data in the cloud. Somewhere in the Cloud. Which Cloud? Who cares! But we are still SQL Server Professionals, so… are we need backup? Should we use newest opportunities or old methods? Are we going step further or step back? On my session I will try to find answers for all of those (and more) questions. Demos, cases and examples from world of backup. And of course worst practices.

Speaker

Tobiasz Koprowski

CEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in West Bridgford (England). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, freelancer and consultant. Subject Matter Expert at CQURE. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. Member of the boards: PTI & ISSA (Poland’s Chapter). Since 1st July 2010 Data Platform MVP. Former President of the Polish SQL Server USer Group. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences.

SQL Security in the Cloud

Track: SQL Server Database Administration

Level: 200

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

Tobiasz Koprowski

CEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in West Bridgford (England). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM and SLA. Love licensing stuff. MCT, freelancer and consultant. Subject Matter Expert at CQURE. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. Member of the boards: PTI & ISSA (Poland’s Chapter). Since 1st July 2010 Data Platform MVP. Former President of the Polish SQL Server USer Group. Creator of SQLDAY Conference and Conference CEO 2009-2011. Co-Leader of PASS East Midlands Group. Speaker at group meetings and conferences.

SSIS 2016: new features; DevOps, SSISDB Catalog and hybrid Azure implementations

Track: Business Intelligence

Level: 300

New features in SSIS 2016 will be discussed, with specific focus on SSIS deployment approaches within a DevOps framework. The internals of the SSISDB Catalog will be examined. The use of SSIS in a hybrid Azure implementation leveraging the Azure feature pack for Integration Services will be demonstrated.

Speaker

Jean van Schalkwyk

Jéan van Schalkwyk is the director of Business Intelligence at Samaki Consulting Ltd. Jean has over 12 years’ experience and has expertise in BI and Master Data Management – strategy, architecture, analysis and design specialising in Microsoft’s BI suite of applications. Jean has worked across a breadth of industries including education, utilities, telecommunications, finance, facilities management, healthcare, retail, justice and insurance. Jean has a Postgraduate Diploma in Business and Administration from Massey University and a B.IT degree from the University of Pretoria in South Africa.

Taking DWH design to the next level with Data Vault

Track: Business Intelligence

Level: 200

The standard dimensional modelling practices have been around for over 2 decades now but with the volumes data, the ever increasing demand for information from the business and the pressures to deliver in a more agile fashion, these modelling techniques are causing us a few headaches. The change requests to exiting dimensions can have huge impacts upstream and it’s becoming more and more difficult to manage these changes. Often we wonder if there is a better way …. and there is. In this session I would like to show you how the Data Vault architecture can help you become more agile and meet the ever increasing demand for information within your business.

Speaker

Robert Blaas

Robert Blass has over 20 years of experience in the architecture, design and delivery of Business Intelligence solutions with a focus on the data structures required to effectively deliver business information. Over this time he has consulted with large multi nationals, local government and private companies in New Zealand and overseas.

From Inception to Production – bringing Continuous Delivery to the Database

Track: SQL Server Database Administration

Level: 100

Continuous Delivery is the next step after Continuous Integration in the deployment pipeline.

Continuous Delivery has enabled development and operational teams to deploy application code reliably and efficiently to their production systems.

Database migrations/changes are an area that may not be automated or utilize Continuous Delivery.

By utilizing the DevOPs principles of People, Culture, Process and Tools – great efficiency for database deployments can be realized.

In this session we will look at what hurdles may be perceived using Continuous Delivery to deploy database changes. We will also look at the rewards of Continuous Delivery and discuss the different methodologies that can make it to happen.

Through the use of a comprehensive live demo to a running production database the audience will learn the benefits and how to implement Continuous Delivery in their database systems.

Speaker

Hamish Watson

Hamish is a Systems Management Specialist with a passion for efficient application deployment using DevOps methodologies. He has 18 years IT experience in managing large scale databases on JADE & SQL technologies. He has been managing SQL Server since SQL 2000 and pragmatic architectural design is his main focus at Jade Software. Educating and helping others learn is a driver for Hamish and he is a PASS Chapter Leader, confident speaker and a guest lecturer at a local university.

A Few of my Favourite Plan Operators

Track: SQL Server Performance Tuning

Level: 300

Query plan operators are where the work is done when you run a query. Some operators are more significant than others. You might have learned about Seeks and Lookups and about different Join operators, but certain operators convey a lot more information than you might realize. This session looks at operators such as Merge Join (Concat), Top N Sort, Filter, Hash Match (Flow Distinct), and more. Explore the significance of some of their properties, and raise your game when it comes to performance tuning.

Speaker

Rob Farley

Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his ability to explain complex concepts simply are known throughout the SQL Server community. He blogs at http://sqlblog.com/blogs/rob_farley and at http://sqlperformance.com/author/robfarley , and is on Twitter at @rob_farley.

Table-Splitting Headaches

Track: SQL Server Development

Level: 300

No matter whether you want to split tables vertically or horizontally, you can easily get a headache. In this session, Rob Farley explores reasons you might want to split tables, some of the performance pain you can suffer from, and some of the ways you can help mitigate it. Whether you’re thinking about partitioned tables or partitioned views, using a single filegroup or many, even using SQL DW versus SQL DB or SQL Server, this session may raise a few eyebrows.

Speaker

Rob Farley

Rob Farley runs LobsterPot Solutions. He is an MCM, MVP, MCT, PDW Trainer, and proud Arsenal supporter. He spends a lot of his time either tuning queries or helping people with their BI systems, from small in-house data warehouses to large PDW implementations. His presentation style and his ability to explain complex concepts simply are known throughout the SQL Server community. He blogs at http://sqlblog.com/blogs/rob_farley and at http://sqlperformance.com/author/robfarley , and is on Twitter at @rob_farley.

Get Near Realtime ETL with Service Broker

Track: SQL Server Development

Level: 100

Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

Speaker

Allen white

Allen is the Business Development Manager for SQL Sentry. He’s been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last nine years.

Maintain SQL Server Performance Baseline with PowerShell

Track: SQL Server Database Administration

Level: 200

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

Allen white

Allen is the Business Development Manager for SQL Sentry. He’s been both a developer and an administrator so understands both perspectives towards database technology, and loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT and has been using SQL Server since 1992 and is certified MCITP in SQL Server and MCT. Allen has been awarded Microsoft’s MVP Award for the last nine years.

What’s New for Availability in SQL Server 2016 and Windows Server 2016

Track: SQL Server Database Administration

Level: 300

Double Session (150 Minutes)

SQL Server 2016 and Windows Server 2016 have major enhancements to existing features as well as brand new ones that will contribute to making SQL Server implementations more highly available. This session will cover not only what is in SQL Server 2016, such as all of the improvements to availability groups like seeding and basic AGs, but important Windows Server 2016 features like site awareness, storage replica, and more that all DBAs should be aware of. Many of these new features will also be demoed. Whether you want to get up to speed on the latest and greatest, or you just want see what you will need to be thinking about deploying over the next few years whether you are doing on premises (physical or virtual) or cloud-based deployments, this session is for you.

Speaker

Allan Hirt

Microsoft MVP and SQL Server mission critical expert Allan Hirt is a consultant, published author, speaker, and trainer who has been using Microsoft SQL Server in various guises since 1992 since interning at Sybase in college. Based in the Boston, MA area, he travels all over the world to work with and train clients and is currently working on the book Mission Critical SQL Server.

Power BI – The Voice of the Customer

Track: Business Intelligence

Level: 100

Microsoft Power BI enables organisations to easily transform data into rich visuals which empower every individual to focus on what matters. In this session you will hear the real-world transformation that a retail client went on deploying Power BI and the difference it made in driving a data driven culture. Peter Ward from WARDY IT Solutions will be joined by a senior IT executive who will provide insight into how Power BI can be deployed to over 20,000 staff and how a modern data warehouse can be delivered successfully.

Speaker

Peter Ward

Peter Ward is WARDY IT Solutions Chief Technical Architect. He is a member of the Australian Institute of Company Directors and the Australian Institute of Management. Peter’s credentials and achievements include being a highly regarded speaker at SQL Server events; a sought after SQL Server consultant and trainer providing solutions for some of the largest SQL Server sites in Australia. Peter has been recognised as a Microsoft Most Valuable Professional for his technical excellence and commitment to the SQL Server Community. Peter is an active member in the Australian SQL Server community and President of the Queensland SQL Server User Group. In the last year Peter was a speaker for Tech-Ed North America, New Zealand and Australia. He was also a Spotlight speaker for the SQL Pass Community Summit, the largest SQL Server event in the world.

In memory OLTP – what can it do for me?

Track: SQL Server Database Administration

Level: 300

SQL Server 2016 widens the use cases of in-memory OLTP.

For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations.

Now you’ll be able to say that table variables are truly in memory!

However, there is much more that In-Memory OLTP has to offer, especially considering the lack of both locking and latching.

Come along to this session and learn about some of features of In-Memory OLTP – or Hekaton – and how you may be able to leverage these high performance features in both new and existing apps.

This fast paced session will start with the basics and build you should leave this session with some useful 300+ level knowledge that you can start working with straight away.

Speaker

Martin Catherall

Martin is a Senior SQL Consultant with RockSolid SQL and has over 10 years’ experience as a TSQL developer and database administrator. He is a current recipient of the Microsoft Most Valuable Professional (MVP) award in SQL Server and is a regional mentor for the Professional Association of SQL Server (PASS) in the Asia Pacific area.

Query Store: A (R)evolution in Query Tuning

Track: SQL Server Performance Tuning

Level: 300

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 comprehensive monitoring solution that will help you detect and solve real-world performance problems across your entire SQL Server infrastructure.

Speaker

Victor Isakov

Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect that specializes in SQL Server performance tuning, optimization, high-availability and upgrade projects. Victor has authored a number of books and Microsoft courseware for SQL Server and regularly speaks at various conference internationally. He was one of the first IT professionals to achieve the Microsoft Certified Master certification and is the only Microsoft Certified Architect in Australia.

New Security Features in SQL Server 2016

Track: SQL Server Development

Level: 300

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

Victor Isakov

Victor Isakov (MCA, MCM, MCT, MVP) is a Database Architect that specializes in SQL Server performance tuning, optimization, high-availability and upgrade projects. Victor has authored a number of books and Microsoft courseware for SQL Server and regularly speaks at various conference internationally. He was one of the first IT professionals to achieve the Microsoft Certified Master certification and is the only Microsoft Certified Architect in Australia.

What’s New in Master Data Services for SQL Server 2016

Track: Business Intelligence

Level: 300

The Master Data Services (MDS) team has obviously been hard at work! There are a number of great new features to show off, including data modeling improvements in Excel, and new server administration capabilities. The team has been paying close attention to feedback, addressing a number of the top customer pain points, as well making a number of significant performance improvements. If you are a current MDS user, or would just like to find out more about it, you’ll be excited to see the new features and functionality delivered in SQL Server 2016!

Speaker

Matt Masson

Matt Masson is a Senior Program Manager in Microsoft Power BI Team. He used to be Program Manager of SSIS team, and SSIS born with his efforts. He speak and teaches many SSIS courses around the world. Matt has worked on multiple data integration products, including Azure Data Factory, Power Query, Power BI, SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS). He is currently part of Microsoft Power BI team working on Data Movement areas of Power BI. He has authored two books – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at www.mattmasson.com .

The Power of Power Query!

Track: Business Intelligence

Level: 300

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. This session provides an overview of the product, future integration plans, and a deep dive into the Power Query formula language. We’ll cover how to leverage some of the advanced features recently added to Power BI Desktop, such as function creation and query parameterization, and show you how to wrangle data like a pro.

Speaker

Matt Masson

Matt Masson is a Senior Program Manager in Microsoft Power BI Team. He used to be Program Manager of SSIS team, and SSIS born with his efforts. He speak and teaches many SSIS courses around the world. Matt has worked on multiple data integration products, including Azure Data Factory, Power Query, Power BI, SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS). He is currently part of Microsoft Power BI team working on Data Movement areas of Power BI. He has authored two books – SSIS Design Patterns (Apress) and SQL Server 2012 Integration Services (MS Press), and is a frequent presenter at Microsoft conferences. You can find his blog at www.mattmasson.com .

Database Administration for Azure SQL DB

Track: SQL Server Database Administration

Level: 300

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

Martin Cairney

Martin Cairney is a highly experienced Database Administrator and Developer with well over a decade’s worth of experience with SQL Server. He has knowledge across multiple industry sectors including London’s global financial institutions and both Australian State and Federal Government Departments. He has regularly worked with companys with hundreds of SQL Server instances and has experience in developing tools and scripts for managing such large environments. He is an experienced conference presenter, having presented a number of times at SQLBits in the UK and various SQL Server User Groups in Australia and the UK. He is a Microsoft Certified Trainer and holds a number of Microsoft certifications, including MCDBA and MCITP. He has recently moved to Melbourne to help establish LobsterPot’s presence there.

Imposter Syndrome: Are You Faking It & Will they Find Out?

Track: Professional Development

Level: 200

Have you ever thought to yourself All these people think I’m smarter than I really am” or “I really don’t know what I’m doing, they’re going to figure out I’m a fraud! If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

Speaker

Mindy Curnutt

Mindy Curnutt is a Trimble Distinguished Engineer, 3X Microsoft Data Platform MVP and the VP of Information Management at TMW Systems. She helps support almost 1500 companies in the logistics industry using a combination of Microsoft Solutions for their Database Platform. Mindy is very active within the SQL Server Community. She presented at her local North Texas SQL Server User Group (2002, 2003 & 2015), SQL PASS Summits (2005, 2006, 2012, 2013, 2015), as well as numerous SQL Saturdays (2013-2016). For two years, she was a Team Lead for the SQL PASS Summit Abstract Review Process (2013-2014). In 2015 and 2016 served (and is serving) as one of the 3 SQL PASS Summit Program Managers. You can find Mindy on Twitter as @sqlgirl.

Implementation of Binary Collaborative Filtering Using SQL

Track: Analytics

Level: 300

This paper presents an attempt of developing an item based collaborative filtering recommendation system in SQL language rather than using existing packages such as Open Source Apache Mahout or recommendation libraries available in Python or R.
In a typical scenario, this class of recommendation systems would construct an item-to- item matrix that reveals relationships between each pairs of items based on users’ action upon those items (purchasing items, watching movies). Than the system would infer the preferences of the target user using that matrix and find items similar to the preferred in order to recommend them to the target user. When items rating is not available, then it can be replaced with binary rating values, where 1 gets assigned to the item if the user explicitly showed preference to this item (purchased that item, watched that movie), and 0 – otherwise. This type of rating is used in this paper as well.
The idea behind the decision of using SQL language was to bring the engine as close to the data (that is often a data warehouse) as possible and prompted by the simplicity of the algorithm. Although the algorithm does not present any coding challenges, the amount of data in practical cases – definitely does present some challenges. By and large this is an experimental work and the author pleased to share his findings.

Speaker

Sergei Dumnov

Sergei is a senior data scientist at Qrious (Spark Ventures), an Auckland based big data analytics company, where he responsible for data wrangling, analysing it and building analytical applications using variety of tools (Hive, R, Greenplum, Power BI, Tableau). He received his PhD degree in Physics & Mathematics from Lavrent’ev Institute of Hydrodynamics in Novosibirsk (Akademgorodok), Russia, where Sergei conducted research activities in the areas of mathematical modelling of water flow and transport phenomena in water bodies.

Unleash the Power of Power BI – tips and tricks

Track: Business Intelligence

Level: 300

A variety of tips and tricks to help you enhance your Power BI reports.
Learn how to;
Create self-annotating Dashboards
Use Power BI to optimise Power BI
Send data via the API
Take advantage of bi-directional relationships
Use Measures more creatively
And more…..

Speaker

Philip Seamark

Experienced database and business intelligence professional with a deep knowledge of the Microsoft BI stack and extensive knowledge of data warehouse methodologies and enterprise data modelling. Expert knowledge in all facets of BI/DW including project management, dimensional modelling, performance tuning, ETL design and development, report and dashboard design and development as well as installation and administration. 25 years experience in delivering business applications across a broad range of technologies.

R; One Ring to Rule Them All

Track: Analytics

Level: 300

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 cleaning, visualization, and prediction will be presented. Subsequently, an introduction to use R server and R in SQL Server 2016 will be shown. Finally, a brief introduction on how to use Azure ML with R will be shown.

Speaker

Leila Etaati

Leila is a Data Platform MVP, PhD, mentor, speaker, and consultant. She spoke in some important SQL server conference such as SQL Rally and Microsoft ignite New Zealand. She has over 10 years’ experience working with SQL server. She was involved in many large-scale projects for big sized companies as SQL server and BI consultant. She worked in Industries including banking financial, power and utility, manufacturing .Leila is PhD of Information System department, University of Auckland, New Zealand. She is a lecturer of BI and Machine Learning courses.

Cortana Analytics : Transform Data into Intelligence

Track: Analytics

Level: 200

Cortana Analytics delivers an end-to-end platform with an integrated and comprehensive set of tools and services to help users to build intelligent applications. This session will show Cortana can be used for collecting data from different resources, storing data in a big data storage, getting insights from collected data, creating analytics services, and finally showing the results through web apps, mobile apps, or rich client apps.

Speaker

Leila Etaati

Leila is a Data Platform MVP, PhD, mentor, speaker, and consultant. She spoke in some important SQL server conference such as SQL Rally and Microsoft ignite New Zealand. She has over 10 years’ experience working with SQL server. She was involved in many large-scale projects for big sized companies as SQL server and BI consultant. She worked in Industries including banking financial, power and utility, manufacturing .Leila is PhD of Information System department, University of Auckland, New Zealand. She is a lecturer of BI and Machine Learning courses.

Effective Data Visualization with Power BI

Track: Business Intelligence

Level: 300

Data Visualization despite the fact that it seems to be the easy part of every BI tool, is the one of the most critical components. In Power BI like many other BI tools Data Visualization plays an important role. In this session you will learn concepts of data visualizations with many demos. You will learn when is best to use each visual, and what are pros and cons of using visuals. You will learn how you can leverage custom visuals and pros and cons of using it. This demo heavy session will show you how to build effective data visualizations with Power BI.

Speaker

Reza Rad

Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in SQL Server for five continues years (from 2011 till now) for his dedication in Microsoft BI. His articles on different aspects of technologies, especially on MS BI, can be found on his blog: http://www.radacad.com/blog (previously was http://www.rad.pasfu.com) . He wrote some books on MS SQL BI and also is writing some others, He is also an active member on online technical forums such as MSDN and Experts-Exchange, and is a moderator of MSDN SQL Server forums, and is a MCP, MCSE and MCITP of BI. He is the leader of New Zealand Business Intelligence users group. He is a International Speaker in SQL Saturday and SQL users groups and Conferences like TechEd and PASS Summit. And He is a Microsoft Certified Trainer.

Registration for Difinity is open now;

http://difinity.co.nz


FAQs

Where can I contact the organizer with any questions?

Contact us with this email; training@radacad.com or contact@difinity.co.nz

Is my registration/ticket transferrable?

Yes, before starting the conference only.

Can I update my registration information?

Yes, before starting the conference only.

What is the refund policy?

Cancellation Details are listed below. Cancellation fees are calculated per ticket (pre-con and 2-days conference individually);

Cancellation: (Per Ticket)

Cancellation up to 5 weeks before the event: fully refund minus administration fee ($50) and credit-card processing fees (if applicable).

Cancellation from 5 weeks to 2 weeks before the event: 50% cancellation charge, 50% refund

Cancellation from 2 weeks before the event: 100% cancellation charge, 0% refunded.

No Show:

No fee will be refunded for no show.

The name on the registration/ticket doesn't match the attendee. Is that okay?

You need to change/transfer ticket to someone else before starting the conference. At the day of conference the registration/ticket's name SHOULD MATCH the attendee's name.

Share with friends

Date and Time

Location

Stamford Plaza Auckland

22-26 Albert Street

Auckland, Auckland 1010

New Zealand

View Map

Save This Event

Event Saved