[vc_row][vc_column][themeum_title title=”Difinity 2018 Conference Sessions for 13th and 14th of Feb 2018″][vc_row_inner][vc_column_inner][vc_column_text]List of sessions will be complete shortly. Please Stay Tuned![/vc_column_text][vc_separator][/vc_column_inner][/vc_row_inner][/vc_column][/vc_row][vc_row el_id=”evaluationcontetxt”][vc_column width=”1/2″][vc_column_text]Evaluation Contexts in DAX[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Evaluation contexts is one of the hardest things to master in DAX. It is not uncommon to think you know how evaluation contexts works only to find that you are completely stumped by a formula that is not doing what you expect. In this session Matt Allington will clearly explain the concepts of row context, filter context and context transition using on screen examples that anyone can understand. A working knowledge of the fundamentals of Power Pivot will be assumed but will be briefly covered in the session as well. Anyone with a working knowledge of DAX can learn from this session.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Matt Allington

Matt Allington

Matt Allington is a career data professional that has spent more than 30 years leveraging data to drive success. In 2014 Matt left the corporate world to start his own company (Excelerator BI) and now works full time to help others to use Microsoft BI products (Power BI, Power Pivot for Excel, Power Query for Excel). Matt is Microsoft MVP based in Sydney Australia, however has a global reach through his blog at http://xbi.com.au/blog

[/vc_column][/vc_row][vc_row el_id=”DAXasaQueryLanguage”][vc_column width=”1/2″][vc_column_text]DAX as a Query Language[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In 2011, Microsoft released the Vertipaq (also called xVelocity) database technology on the world. Vertipaq is the database technology that is better known as Power Pivot, Power BI and SSAS Tabular Edition. Many people (business and IT) already use Power Pivot, Power BI and SSAS Tabular to produce reporting and analytics tools. But did you know that these tools also have their own query language?   In traditional databases such as SQL server, it is possible to extract data into a new table. The same is possible using DAX as a query language with a tabular data model. In this session, Matt will introduce the topic and show how you can use DAX Studio to connect to a data model to write queries that interrogate the data itself (as opposed to simply aggregating the values into a pivot table or a Power BI report). The learning can then be used to write more complex DAX measures or alternatively it can be used to extract tabular data directly into a table for further analysis.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Matt Allington

Matt Allington

Matt Allington is a career data professional that has spent more than 30 years leveraging data to drive success. In 2014 Matt left the corporate world to start his own company (Excelerator BI) and now works full time to help others to use Microsoft BI products (Power BI, Power Pivot for Excel, Power Query for Excel). Matt is Microsoft MVP based in Sydney Australia, however has a global reach through his blog at http://xbi.com.au/blog

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”ThingsYouShouldNeverDoinMicrosoftSQLServer”][vc_column width=”1/2″][vc_column_text]

Things You Should Never Do In Microsoft SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

In this fun session we’ll review a bunch of problem implementations that have been seen in the real world. Most importantly we will look at why these implementations went horribly wrong so that we can learn from them and never repeat these mistakes again.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Denny Cherry

Denny Cherry

Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2014 including the Microsoft Certified Master as well as being a Microsoft MVP for several years.  Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”TableIndexingforthe.NETDeveloper”][vc_column width=”1/2″][vc_column_text]

Table Indexing for the .NET Developer

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]

In this session we will be looking at the best and worse practices for indexing tables within your SQL Server 2000-2017 databases. We will also be looking into the new indexing features that are available in SQL Server 2012/2014/2016/2017 (and SQL Server 2005/2008) and how you the .NET developer can make the best use of them to get your code running its best.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Denny Cherry

Denny Cherry

Denny Cherry is the owner and principal consultant for Denny Cherry & Associates Consulting and has over a decade of experience working with platforms such as Microsoft SQL Server, Hyper-V, vSphere and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication and troubleshooting. Denny currently holds several of the Microsoft Certifications related to SQL Server for versions 2000 through 2014 including the Microsoft Certified Master as well as being a Microsoft MVP for several years.  Denny has written several books and dozens of technical articles on SQL Server management and how SQL Server integrates with various other technologies.

[/vc_column][/vc_row][vc_row el_id=”PowerBIGatewaysasasolution”][vc_column width=”1/2″][vc_column_text]

Power BI Gateways as a solution

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 There are number of blog posts, technical deep dive(s) and how-to articles on Power BI desktop and service but very few on Gateways for Power BI. Gateways form a major part of Power BI enterprise deployment and so in this introductory session we will go through ways of managing, configuring and administering Gateways for Power BI within an organisation. We will also discuss real-world scenarios for the application of Gateways and how you can benefit from Gateways being in different job functions.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Philip Seamark

Philip Seamark

An experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. 

[/vc_column][/vc_row][vc_row el_id=”Whatarechat botsandwhydoweneedtheminBusinessintelligence?”][vc_column width=”1/2″][vc_column_text]

 What are chat bots and why do we need them in Business Intelligence?

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this session you will get to learn

a) What are chat bots?

b) How to develop a chat bot using Microsoft Bot Framework?

c) How bots can be useful in Business Intelligence?

d) Enabling Data driven conversations using bots

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Anupama	Natarajan

Anupama Natarajan

I am a Software Professional with over 15 years experience in designing and developing Web, Data Warehouse, Business Intelligence and Mobile solutions. I am a Microsoft Certified Trainer (MCT) and really passionate in sharing knowledge. I love solving complex business problems for my clients with innovative solutions using Microsoft Technologies and use that experience in my trainings.

[/vc_column][/vc_row][vc_row el_id=”AnalysisServicesDataDNA”][vc_column width=”1/2″][vc_column_text]

 Analysis Services Data DNA

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]

Have you ever wanted an overview of your cubes and their dimensions, attributes and measures?

This session will show you how you can use Analysis Services DMVs to extract information about your cubes and collect it for later use. We will then see how you can report on top of it thus documenting your SSAS cubes. We will then hear about different scenarios where this data might be useful.

The attendees will learn how to extract, transform and load the data into a database using SSIS. They will learn how to reports that show the relevant information for different scenarios and how my company is making use of these information for different purposes. Some of the use cases for this data can be aligning dimensions across cubes or creating a bus matrix for documentation purposes.

At the end of the session the attendees leave with all the code needed to start on their own as well as the knowledge on how to extend and further the solution for their own purposes

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Ásgeir Gunnarsson

Ásgeir Gunnarsson

Ásgeir works as a Business Intelligence Developer for Össur. Ásgeir has been working with business intelligence for over 10 years, and with Power BI since its inception. Ásgeir has been awarded the Microsoft Most Valuable Professional twice for his technical experience implementing Microsoft BI, as well as his contributions to the community as speaker and a user group leader. Ásgeir presents on international conferences such SQL Saturdays and others multiple times each year. In 2017 Ásgeir has presented Power BI sessions on SQL Bits, SQL Nexus and Microsoft Data Insight Summit with few other conferences coming up in the autumn. Besides speaking on international events Ásgeir also speaks locally and internationally in user groups and teaches multi day courses on Power BI and Power Pivot at the University of Ic

[/vc_column][/vc_row][vc_row el_id=”impactofweather”][vc_column width=”1/2″][vc_column_text]

 Impact of weather on English Premier League matches – Power BI analysis

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Have you ever wondered if there are scored more goals when it rains or if Stoke wins more games on cold weekday evening at bet265 stadium? This session shows how you can use open data sources and web pages to gather data. How you can then manipulate and extend it and finally report on it.

We will look into how you can use open weather data and combine it with data from web pages to create the dataset you need. When we have our dataset we will manipulate and extend it using M and DAX so that we can get meaningful insights from it. We will then dive into the data to see if there is anything to report.

In this end to end Power BI Desktop demo we will use fun data that many can relate to as the English Premier League is one of the most popular football leagues in the world. The audience will take away many nuggets of information as they see how a real world example could look like. I will share with them all the obstacles and learning I got when creating this report

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Ásgeir Gunnarsson

Ásgeir Gunnarsson

Ásgeir works as a Business Intelligence Developer for Össur. Ásgeir has been working with business intelligence for over 10 years, and with Power BI since its inception. Ásgeir has been awarded the Microsoft Most Valuable Professional twice for his technical experience implementing Microsoft BI, as well as his contributions to the community as speaker and a user group leader. Ásgeir presents on international conferences such SQL Saturdays and others multiple times each year. In 2017 Ásgeir has presented Power BI sessions on SQL Bits, SQL Nexus and Microsoft Data Insight Summit with few other conferences coming up in the autumn. Besides speaking on international events Ásgeir also speaks locally and internationally in user groups and teaches multi day courses on Power BI and Power Pivot at the University of Ic

[/vc_column][/vc_row][vc_row el_id=”ssrsandpowerbi”][vc_column width=”1/2″][vc_column_text]

 SSRS and Power BI Report Server – What’s new

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

 In SQL 2016, SQL Server Reporting Services (SSRS) underwent massive changes with the addition of many new reporting features. Since that release, there have been many further developments, including the release of Power BI Report Server and SSRS 2017. In this demo laden session, Craig will recap the changes that SSRS has undergone from SSRS 2016 onwards, as well as look at and discuss Power BI Report Server.This session will be valuable for anyone new to SSRS, or anyone who has not had an opportunity to work with the latest versions of SSRS.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Craig Bryden

Craig Bryden

Craig has been working in Business Intelligence since the late 90’s and has gained experience in almost all industries. He has previously been seconded by Microsoft to assist in creating certification tests for the Microsoft Business Intelligence tools, and is a regular speaker at BI related user groups and conferences. Craig is the organiser for the QLD Power BI user group. Craig is the COO at BiTQ (www.bitq.com.au) where he and his team help customers to transform business data into intelligent data.

[/vc_column][/vc_row][vc_row el_id=”sqlserverinamultiplatform”][vc_column width=”1/2″][vc_column_text]

 SQL Server in a multi-platform world – Windows/Linux/Mac

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 SQL Server is moving to a multi-platform world; in this session, we look at- SQL Server running on Windows and Linux; what’s included, what’s different, what’s the same

– Co-existence / Migration options

– Management and development tools across Windows/Linux/Mac

[/vc_column_text][/vc_column][vc_column width=”1/2″]

David Lyth

David Lyth

David is a Premier Field Engineer (PFE) working for Microsoft NZ. He runs workshops covering SQL Server performance tuning and optimization, high availability configurations, maintenance and management, and Powershell. He also works onsite with customers to analyze and improve the health of their SQL environments, and provide advice on consolidation and modernization. As well as SQL Server, David supports APS (parallel data warehouse) appliances. Prior to joining Microsoft, David worked for an outsourcing company, supporting large SQL Server installations for a variety of NZ customers.

[/vc_column][/vc_row][vc_row el_id=”sqlserverquerystore”][vc_column width=”1/2″][vc_column_text]

 SQL Server 2016 Query Store

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

 The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. It provides the ability to natively capture baseline data within SQL Server. Using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query.During this session we will take a thorough look at the Query Store, its architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Dharmendra Keshari

Dharmendra Keshari

Dharmendra Keshari is a Microsoft Data Platform MVP. He has been organizing world renowned events like SQL Saturday (Singapore), also a co-organizer of KDSSG MSSQL Tech Unite events (in India), and also a core member of “Singapore SQL PASS Chapter”. He also frequently blogs on his website and also a regular contributor at sqlservercentral.com Currently working as Senior Database Administrator at Micron Technology, Singapore. He has worked in a variety of roles including SQL DBA, Windows/Hyper-V Administrator and also worked very closely with Storage team and vendor management which have given him extensive experience planning and implementing large-scale environment changes and upgrades. In his free time, Dharmendra loves to hang out with family & friends, joining Marathons and spend time reading on SQL Server new technology developments.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”troubleshootingissues”][vc_column width=”1/2″][vc_column_text]

 Troubleshooting Issues with Extended Events in real time

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 400 – Expert[/vc_column_text][vc_column_text]

 Extended events to aid in performance tuning and in day to day administration specially when you don’t have any benchmarking data for troubleshooting issues. In this session, we will see how the Extended Events streaming API can be used to process events in a near real-time. We will demonstrate how this feature enables new possibilities to capture real time problems without enabling any third party tools or inbuilt SQL Server features to capture issues like blocking,  deadlocks, high CPU and many more.Extended Events were introduced in SQL Server 2008 but by SQL Server 2016, it has enhanced significantly. After this session, hopefully you will start using extended event, if you haven’t started using till now.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Dharmendra Keshari

Dharmendra Keshari

Dharmendra Keshari is a Microsoft Data Platform MVP. He has been organizing world renowned events like SQL Saturday (Singapore), also a co-organizer of KDSSG MSSQL Tech Unite events (in India), and also a core member of “Singapore SQL PASS Chapter”. He also frequently blogs on his website and also a regular contributor at sqlservercentral.com Currently working as Senior Database Administrator at Micron Technology, Singapore. He has worked in a variety of roles including SQL DBA, Windows/Hyper-V Administrator and also worked very closely with Storage team and vendor management which have given him extensive experience planning and implementing large-scale environment changes and upgrades. In his free time, Dharmendra loves to hang out with family & friends, joining Marathons and spend time reading on SQL Server new technology developments.

[/vc_column][/vc_row][vc_row el_id=”designingasqlserveralwayson”][vc_column width=”1/2″][vc_column_text]

 Designing a SQL Server AlwaysOn Availability Groups Topology Without Losing Your Sanity

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

 So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements. You will learn: – Common design patterns and guidelines that you need to consider when building your architecture – Proper selection of quorum configuration – Network configuration for local and geographically dispersed replicas – Combining SQL Server Failover Clustering with AlwaysOn Availability Groups

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Edwin Sarmiento

Edwin Sarmiento

Edwin M Sarmiento is a Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack.  He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.   He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential.

[/vc_column][/vc_row][vc_row el_id=”whatsqlserverdbas”][vc_column width=”1/2″][vc_column_text]

 What SQL Server DBAs Need To Know About Distributed Availability Groups

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

 With the introduction of Distributed Availability Groups in SQL Server 2016, it is becoming even more confusing to decide on the appropriate high availability and disaster recovery architecture to implement. In this session, we will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario and how you can combine them with the other high availability and disaster recovery features to meet your database recovery objectives and service level agreements.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Edwin Sarmiento

Edwin Sarmiento

Edwin M Sarmiento is a Microsoft Data Platform MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack.  He is very passionate about technology but has interests in music, professional and organizational development, leadership and management matters when not working with databases.   He lives up to his primary mission statement – “To help people and organizations grow and develop their full potential.

[/vc_column][/vc_row][vc_row el_id=”powerbirls”][vc_column width=”1/2″][vc_column_text]

 Power BI Row Level Security Made Easy

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 In this session I plan to go over the basics of what is Row Level Security for people in the audience who have not used Row Level Security before.I then plan to show how easy it can be to implement Row Level Security in your Power BI Model by leveraging the built in functionality, as well as leveraging Active Directory.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Gilbert Quevauvilliers

Gilbert Quevauvilliers

Microsoft MVP - Power BI Consultant using Microsoft Power BI to provide solutions for business challenges by sitting with the users within the business to build Power BI models which enable the business to gain insights My goal is for the business to see their data on their terms by delivering Microsoft Power BI Solutions in weeks or less, thereby enabling them to move forward to leverage their data I have assisted with the implementation and completion of Power BI which includes Power BI Desktop development, assistance with Power BI Gateway, Power BI Service, Power BI Internal Training, Power BI Best Practice & Power BI User Group sessions. Power BI training provided to Businesses based on their requirements. Participate and present at the Brisbane Power BI User Group Leader, SQL Saturday Presenter, Brisbane Power BI User Group, Power BI Community and publish blog posts to the Power BI Community Blogs Past working experience in Business Intelligence (BI), working on large, complex end to end BI solutions for customers.

[/vc_column][/vc_row][vc_row el_id=”testdrivendev”][vc_column width=”1/2″][vc_column_text]Test Driven Development in SQL Server – it will make your database deployments better[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]Test Driven Development (TDD) is a practice that has for years enabled application developers to write code that is less-buggy.
It is extremely relevant for database development, as it ensures that the code produced using TDD will be of higher quality, which means interactions with data and code are safer.
In this session we will go through how to setup some simple unit tests using various industry tools such as the open-source framework – tSQLt, the SQL Cop testing utility and Redgate’s SQL Test tool which brings it all together.
The advantage of these tools is that we can run them within our familiar SQL Server Management Studio, whereas other testing frameworks rely on the Visual Studio IDE.
It will be shown in a comprehensive DEMO how to bring TDD to your database development and result in higher quality deployments to your databases when incorporated into Continuous Integration processes.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Hamish Watson

Hamish Watson

Hamish is a Systems Management Specialist with a passion for efficient database & application deployment using DevOps methodologies. He has 19 years IT experience in managing large scale databases on SQL Server technologies. He has been managing SQL Server since SQL Server 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, International speaker and a repeat guest lecturer at a local university.

[/vc_column][/vc_row][vc_row el_id=”dynamicchartsfor”][vc_column width=”1/2″][vc_column_text]

 Dynamic charts for browser and mobile with Excel

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 Let’s face it, Excel is still the number one tool for data analysis and visualisation, because it is on everyone’s desk. Charts are the core of dashboards and reports and often require user choices and inputs. In this eye-opening session, you’ll discover different techniques to make Excel charts dynamic, including worksheet layout, tables, named ranges, and formulas. The best thing? All techniques covered in the session work without code and run perfectly in Excel online and Excel for mobile.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Ingeborg Hawighorst

Ingeborg Hawighorst

Ingeborg has several decades of experience in all aspects of information technology. For the last few years, her main focus has been on collaboration, data analysis, and her favourite: data visualisation. She is active in the online communities with the alias “teylyn” and has received the Microsoft MVP award for Excel every year since 2012. In 2001 Ingeborg moved with her family from Germany to New Zealand. She is a Senior System Analyst at Spark Digital, where her current focus is on data analytics and Office 365 integration.

[/vc_column][/vc_row][vc_row el_id=”introductiontobiml”][vc_column width=”1/2″][vc_column_text]

 An introduction to the magical world of BIML!

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

 Ever feel like you are just doing busy work while creating new SSIS packages? Feel like you are doing the same thing over and over while changing the names to protect the innocent? Ever wonder if there is a better way? Well wonder no more. Come learn about the magical world of BIML and how it can help transform your environment by increasing your productivity while reducing the possibility of errors. Come with intrigue and leave with a fundamental understanding of BIML!

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Jonathan	Stewart

Jonathan Stewart

Jonathan Stewart is a Business Intelligence Consultant specializing in data visualization, data warehousing and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack.  Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments. Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and business intelligence at numerous SQL Saturday events, local user groups and conferences throughout the United States and around the world. He participates in webcasts, podcasts and online presentation events. He is also an active board member for his local Columbus, Ohio PASS chapter. Jonathan maintains a blog at https://sqllocks.net/. He is a frequent speaker at local, national and international events and is a board member of the Columbus SQL Server User Group. In his free time, Jonathan works with the Mid-Ohio Regional Planning commission to help improve central Ohio and enhance the quality of life of its residents.

[/vc_column][/vc_row][vc_row el_id=”performancetunningbi”][vc_column width=”1/2″][vc_column_text]

 Performance Tuning for the BI Professional

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI as well as some core engine stuff.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Jonathan	Stewart

Jonathan Stewart

Jonathan Stewart is a Business Intelligence Consultant specializing in data visualization, data warehousing and data management technologies. An advocate for educating others, he is a public speaker, teacher and blogger, continually teaching people about the Microsoft BI Stack.  Since 2000, he has been working in the database field with industry leaders in healthcare, manufacturing, financial, insurance and federal, state and local governments. Jonathan is very active in the community. He has presented on SQL Server, SSIS, Reporting Services, Power BI and business intelligence at numerous SQL Saturday events, local user groups and conferences throughout the United States and around the world. He participates in webcasts, podcasts and online presentation events. He is also an active board member for his local Columbus, Ohio PASS chapter. Jonathan maintains a blog at https://sqllocks.net/. He is a frequent speaker at local, national and international events and is a board member of the Columbus SQL Server User Group. In his free time, Jonathan works with the Mid-Ohio Regional Planning commission to help improve central Ohio and enhance the quality of life of its residents.

[/vc_column][/vc_row][vc_row el_id=”azuresqldw”][vc_column width=”1/2″][vc_column_text]

 Azure SQL Data Warehouse, Data Lake, Polybase, SSAS and Powerbi

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

This session will show you how to make the most of the Azure Data Platform, when it comes to massive amounts of data, how we can easily process and move this data using Data Lake, Polybase and SQL Data warehouse. Data is then moved to an Tabular SSAS instance and viewed in a PowerBI dashboard with lightning fast performance.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Kenneth Nielsen

Kenneth Nielsen

Kenneth M. Nielsen currently work at Microsoft as Data Insights Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.

[/vc_column][/vc_row][vc_row el_id=”datalake”][vc_column width=”1/2″][vc_column_text]

 Data Lake Analytics – R, Python and Cognitive Services

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 In this session we take a look and a deep dive into Aure Data Lake, a new feature on Azure that will enable amost anyone to work with BIG DATA. It combines C# and SQL to a language that is way more intuitive than what we are used to. Azure Data Lake Store, our new repository for data of various origins – we can collect, store and share data from this lake as we see fit. Azure Data Lake Analytics, a new way to scale and use your analytics on AZURE and BIG Data, it introduces U-SQL a new language combined of C# and T-SQL to make the task of analyzing BIG Data easier and more comprehendible. Azure Data Lake Tools for Visual Studio, provide an integrated development environment that spans the Azure Data Lake, dramatically simplifying authoring, debugging and optimization for processing and analytics at any scale. The newest addition to Data Lake Analytics is execution of R, Python and Cognitive Services, parts that this session will focus on.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Kenneth Nielsen

Kenneth Nielsen

Kenneth M. Nielsen currently work at Microsoft as Data Insights Architect, focusing on data services on Azure. Previously worked as managing consultant and teamlead for the company Rehfeld Partners in Denmark. He has worked at various consulting firms and worked on many small/large/very large bi installations in Denmark over the last 12 years. He really likes to advice the customers to take the right decisions, but also maintains a high technical knowledge, so he can act at both architect and developer.

[/vc_column][/vc_row][vc_row el_id=”azuredbmigration”][vc_column width=”1/2″][vc_column_text]

 Azure Database Migration – Choosing the Right Tier

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Microsoft has two different types of SQL Server services available in Azure. The SQL Server on an Azure VM is the IaaS (Infrastructure as a Service), which is easier to understand and migrate to.

Microsoft offers two types of PaaS (Platform as a Service) or DBaaS (Database as a Service) for SQL Server Database native to could – Single Database and Elastic Pool. Choosing the right tier for your database gets harder with the complexity in calculating the resource utilization for your Azure SQL Database.

In this session, I will walk you through the steps involved in analyzing the resource utilization and estimating the right tier to choose for your database in Azure.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Manohar	Punna

Manohar Punna

"Manohar Punna is an SQL Geek and President of DataPlatformGeeks by passion and a Data Platform Consultant by profession. He is a speaker at various SQL Server Day events and user groups, SQL Saturday Melbourne and Sydney, SQLBits, SSGAS and DPS conferences.  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. "

[/vc_column][/vc_row][vc_row el_id=”HybridArchitecturewithAzureDataSync”][vc_column width=”1/2″][vc_column_text]

 Hybrid Distributed Architecture with Azure Data Sync 2.0

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 For a number of years, Azure Data Sync was stuck in “preview” mode in the old classic deployment model and with no updates on functionality over that time many thought that it was destined for the scrap heap. However with the recent revival and port to the Azure Resource Manager model it has become a viable option for organisations looking to deploy applications that are partially SaaS but with a local on-premises component. This session will show to use Azure Data Sync for centralised management of remote systems such as point-of-sales terminals. The session will show how to use Data Sync to gather data from each terminal and push down centralised changes to selected remote systems.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Martin Cairney

Martin Cairney

Martin has over 15 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 SQL Saturday events and User Groups round the world

[/vc_column][/vc_row][vc_row el_id=”splitmerge”][vc_column width=”1/2″][vc_column_text]

 Split, Merge and Eliminate – An Introduction to Partitioning

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that I have seen. Partitioning provides many potential benefits such as easier index maintenance, data loads and archiving using partition switching and improved query performance through partition elimination.. In this session we’ll cover the basics of partitioning – from getting started with partition switching to partition elimination to make your queries go faster – with plenty of demos for you to take away.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Martin Cairney

Martin Cairney

Martin has over 15 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 SQL Saturday events and User Groups round the world

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”reallifessis”][vc_column width=”1/2″][vc_column_text]

 Real life SSIS for Port

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

 This is the real life example on how to extract, transform, and load around 3 million transactions monthly for a shipping port to calculate the incentives for 2000 terminal operators. This session will let you know what are the do and don’t when you use SSIS for your real life day to day tasks. This session will also shows the best practices on deriving the data workflow.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Ming Man Chan

Ming Man Chan

Ming Man is Microsoft MVP since year 2006. He is a software development manager for a multinational company. With 27 years of experience in the IT field, he has developed system using Clipper, COBOL, VB5, VB6, VB.NET, Java and C #. He has been using Visual Studio (.NET) since the Beta back in year 2000.  He and the team have developed many projects using .NET platform supporting different key functional areas in the organizations such as engineering, sales, and marketing. He is familiar with the architecture design of business application and is also an expert with database experience in MS SQL, Oracle and AS 400. He is familiar Application Life Cycle Management using the Agile and CMMI methodology.

[/vc_column][/vc_row][vc_row el_id=”dbmonitoring”][vc_column width=”1/2″][vc_column_text]

 Database Monitoring and Reporting in 2018

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

In this Session we will look at how Powershell, PowerBI, SSRS, Flow and PoweApps can be used to provided a modern reporting environment that embraces the cloud and mobile options available in 2018.

We will look at how the collection of Database Metrics and Performance Data can be automated via PowerShell and then made available across On_Prem and Mobile Applications by utilising PowerBI, SSRS, PowerApps and Flow.

Attendees will leave with the required tools and information to be able to create a monitoring, alerting and reporting solution that is ready for environments of any size and embraces the tolls available in 2018

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Patrick Flynn

Patrick Flynn

Patrick Flynn is a full time Production DBA and has worked with Microsoft Database and Development products since 1994. He specializes in providing Automation, Monitoring, Performance Tuning, High Availability and Disaster Recovery solutions for Enterprise environments. He has particular interests in Database Internals and Corruption Recovery Techniques as well as applying Powershell and PowerBI to assist in DBA tasks. He is a regular Presenter at SQLSaturday events in Australia and NZ.

[/vc_column][/vc_row][vc_row el_id=”mdx”][vc_column width=”1/2″][vc_column_text]

 Why MDX cubes aren’t dead yet

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 Lets have a look at the pros and cons of the two SSAS offerings and see why Multi-Dimensional cubes still have a place.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Philip Seamark

Philip Seamark

An experienced database and business intelligence (BI) professional with a deep knowledge of the Microsoft BI stack along with extensive knowledge of data warehouse (DW) methodologies and enterprise data modelling. 

[/vc_column][/vc_row][vc_row el_id=”performancein60″][vc_column width=”1/2″][vc_column_text]

 Performance in 60 Seconds – SQL Tricks Everybody MUST Know

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

 Data and Database is a very important aspect of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This session is for all the Developers who want their server to perform at blazing fast speed, but want to invest very little time to make it happen. We will go over various database tricks which require absolutely no time to master and require practically no SQL coding at all. After attending this session, Developers will only need 60 seconds to improve performance of their database server in their implementation. We will have a quiz during the session to keep the conversation alive. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Pinal	 Dave

Pinal Dave

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

[/vc_column][/vc_row][vc_row el_id=”sercretsofsql”][vc_column width=”1/2″][vc_column_text]

 Secrets of SQL Server – Database Worst Practices

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 “Oh! What did I do?” Chances are you have heard, or even uttered, this expression. This demo-oriented session will show many examples where database professionals were dumbfounded by their own mistakes, and could even bring back memories of your own early DBA days. The goal of this session is to expose the small details that can be dangerous to the production environment and SQL Server as a whole, as well as talk about worst practices and how to avoid them. In this session we will focus on some of the common errors and their resolution. Developers will walk out with scripts and knowledge that can be applied to their servers, immediately post the session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Pinal	 Dave

Pinal Dave

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4000 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years of hands on experience he holds a Masters of Science degree and a number of database certifications.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”datafactory”][vc_column width=”1/2″][vc_column_text]

 Data Orchestration with Azure Data Factory

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 One of the biggest impediments to a successful data analytics project is the complexity involved in getting the data required for analysis in a timely and efficient manner. Azure Data Factory is a very powerful orchestration tool that can enable organizations to connect to numerous data sources and automate the process of moving data between various sources at predefined schedule. in this session you will learn the basics of Azure Data Factory, when and how to use it for several common data movement activities. Through an end to end demonstration you will learn how to create data pipelines for data movement and monitor the orchestration.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Raj Krishnan

Raj Krishnan

Raj Krishnan is a Data Solution Architect at Microsoft and helps customers implement Analytics solution in Azure. He has been with Microsoft for 15 years and has worked as an Architect at Microsoft Technology Center, Technical Evangelist in Developer Experience (DX) group and in healthcare vertical. Prior to joining Microsoft he has worked for one of the big five consulting companies, manufacturing, healthcare and database marketing companies. He teaches analytics and data warehousing at Illinois institute of Technology as an Adjunct professor and speaks regularly at conferences.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”catalog”][vc_column width=”1/2″][vc_column_text]

Azure Data Catalog – Do you know what you know

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]We are surrounded with data. Data is scattered across organizations. IOT is driving collection of data in massive scale. Data is available in public domain and can be bought from many sources. The need to manage information assets with metadata will remain a major challenge for data driven organizations. Self-service business intelligence solutions must be complemented with self-service data preparation system so that users can find the data they need, have appropriate access to the data that is in compliance with company policy and regulations and add valuable meta-data to a central repository of all the data assets for easy discovery. Any information governance practice such as Data governance, data quality or master data management will benefit from such a metadata store as well. In this session, you will learn how you can register, enrich, discover, understand, and consume data sources using Azure Data Catalog using the fully managed service offering from Microsoft. The presentation will include an overview of Azure Data Catalog and demonstration of tools and techniques for data discovery and metadata management.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Raj Krishnan

Raj Krishnan

Raj Krishnan is a Data Solution Architect at Microsoft and helps customers implement Analytics solution in Azure. He has been with Microsoft for 15 years and has worked as an Architect at Microsoft Technology Center, Technical Evangelist in Developer Experience (DX) group and in healthcare vertical. Prior to joining Microsoft he has worked for one of the big five consulting companies, manufacturing, healthcare and database marketing companies. He teaches analytics and data warehousing at Illinois institute of Technology as an Adjunct professor and speaks regularly at conferences.

[/vc_column][/vc_row][vc_row el_id=”bigdata”][vc_column width=”1/2″][vc_column_text]

 Big Data Ingestion and Analytics with Microsoft Azure

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 Azure is built to handle big data workloads.  From ingesting millions of events per second, to visualizing those events in a dashboard in real time (hot path), to storing for long term query and retrieval (cold path), Azure has the solutions.  In this talk we will take a look at a big data pipeline which includes Azure Event Hubs to ingest telemetry, Azure Stream Analytics and Power BI for real time dashboards, Azure Data Lake plus Azure Data Lake Analytics for big data retention and querying, Azure Data Factory and SQL Azure Data Warehouse for ETL.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Regan Murphy

Regan Murphy

Regan is part of the worldwide Commercial Software Engineering (CSE) team at Microsoft, but based in Auckland, NZ.  The CSE team has a focus across all development areas, with Regan specialising in Data Platform and Machine Learning.  Like the rest of my team I love technology, gadgets, and the promise of new things to come - including #mixedreality.  I like beer, craft beer. I also enjoy wine. To offset the beer and wine, I run. Running is also a nice way to sightsee when travelling.

[/vc_column][/vc_row][vc_row el_id=”248″][vc_column width=”1/2″][vc_column_text]

 2,4,8 & 16 – Journey of upgrading your data platform with SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: Double Session – 150 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

2,4,8 & 16 – these aren’t just numbers to count or calculate. These are years that how SQL Server evolved as number of years!

Why Upgrade?

Data Platform Upgrade topic has been a popular session that I’ve presented in major conferences like Microsoft Tech-Ed (North America, Europe & India) and SQLbits since 2008.

In this session, we will overview in depth end-to-end upgrade process that covers the essential phases, steps and issues involved in upgrading  SQL Server (2000 to  2012),  SQL Server 2014 (with a good overview on 2016 too) by using best practices and available resources.

What to-do and what not-to-do?

Real-world database demos and database upgrade with 40% demos.

We will cover the complete upgrade cycle, including the preparation tasks, upgrade tasks, and post-upgrade tasks. Real-world examples from my Consulting experience expanding on why & how such a solution

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Satya Jayanty

Satya Jayanty

"Microsoft Data Platform MVP (12+ years and counting). Satya Jayanty is a Data Platform Consulting professional based in United Kingdom, with over 25+ years of IT experience working within cross-industry, cross-functional and cross-domain know-how. The Consulting journey experience surrounding data platform comprises solution of architecture management service at the layers of definition, implementation and on-going evolution of IT strategy. He is a self-starter and team player who drives CxO & clients’ accounts with a focus to solve real-world business problems with achievable solution practices. A constant learner and always keen to gain perception on newer technologies, proven methodologies with best patterns & practices."

[/vc_column][/vc_row][vc_row el_id=”datawarehouselightning”][vc_column width=”1/2″][vc_column_text]

 Datawarehouse Lightning Performance with Columnstore!

[/vc_column_text][vc_column_text]Track: SQL Server Performance Tuning
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

During this session we will be talking about Columnstore Indexes and how to use them. We will be showing you tips & tricks on how to get the performance you want out of Columnstore.

We will show you the concepts on how to efficiently load data to your Columnstore tables, how to get your Columnstore properly created, and some dangers with performance you might face when working with Columnstore Indexes as seen in the field!

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Stijn Wynants

Stijn Wynants

Stijn is an independent Data Platform Consultant & DataMinds (Belgian Data Platform User Group) core member. He is also one of the organisers of the local user group sessions & the yearly event called DataMinds Connect (SQL Server Days). He spends his days tuning SQL Servers & solving problems with the data platform. He is primarily a DBA consultant, but has also done various BI & ETL projects. He gets his kicks out of Columnstore indexes & tuning queries but shivers at the sight of an SSAS cube. When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine & local beers or enjoying time with his wife and his dog.

[/vc_column][/vc_row][vc_row el_id=”realtimeanalytics”][vc_column width=”1/2″][vc_column_text]

 Realtime Analytics: OLAP & OLTP in the mix!

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes.

We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are & how to maintain your columnstore indexes.

We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Stijn Wynants

Stijn Wynants

Stijn is an independent Data Platform Consultant & DataMinds (Belgian Data Platform User Group) core member. He is also one of the organisers of the local user group sessions & the yearly event called DataMinds Connect (SQL Server Days). He spends his days tuning SQL Servers & solving problems with the data platform. He is primarily a DBA consultant, but has also done various BI & ETL projects. He gets his kicks out of Columnstore indexes & tuning queries but shivers at the sight of an SSAS cube. When Stijn is not working with SQL Server, you can probably find him enjoying the local cuisine & local beers or enjoying time with his wife and his dog.

[/vc_column][/vc_row][vc_row el_id=”cosmosdb”][vc_column width=”1/2″][vc_column_text]

Azure Cosmos DB

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Satya Jayanty

Satya Jayanty

"Microsoft Data Platform MVP (12+ years and counting). Satya Jayanty is a Data Platform Consulting professional based in United Kingdom, with over 25+ years of IT experience working within cross-industry, cross-functional and cross-domain know-how. The Consulting journey experience surrounding data platform comprises solution of architecture management service at the layers of definition, implementation and on-going evolution of IT strategy. He is a self-starter and team player who drives CxO & clients’ accounts with a focus to solve real-world business problems with achievable solution practices. A constant learner and always keen to gain perception on newer technologies, proven methodologies with best patterns & practices."

[/vc_column][/vc_row][vc_row el_id=”secure”][vc_column width=”1/2″][vc_column_text]

  Secure your data at rest – on demand, now!

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Description
The new releases of Microsoft SQL Server: SQL Server 2016 & 2017 brings new functionality for Data Security Professionals. Now you can protect your data in your database anywhere (on-premise, in the cloud, even in the hybrid environment) even more simply than before. Transparent Data Encryption with better algorithms and better support for backup, Row-Level Security, Dynamic Data Masking and AlwaysEncrypted for your application are now simple features. We focus on hard theory and of course, on demos. We look a little closer for few specific files that exist in our environment. We work on all three different environments, but our goal is only one: protect your data.Objective
New Security Features, SQL Server 2016, Microsoft Azure SQL Database, Encryption, Data Security

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Tobiasz Koprowski

Tobiasz Koprowski

CEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. MCT, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. 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.STEM Ambassador.

[/vc_column][/vc_row][vc_row el_id=”ad2018″][vc_column width=”1/2″][vc_column_text]

 AD 2018. 2 AM. A New Disaster just began.

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

Description
2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we will NOT talk about the potential disaster (Business Continuity Management); we talk about: What happened NOW? What tasks should have been finished BEFORE! Is virtual or physical SQL Server matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I’ll show which part of our SQL Server Environment is critical and how to be prepared for the disaster. With some papers, I’ll show you how to be BEST prepared for Early Morning Disaster.Objective
SQL Server 2014, SQL Server 2016, Backup, Restore, SQL Azure, Microsoft Azure SQL Database, Best Practices

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Tobiasz Koprowski

Tobiasz Koprowski

CEO of Shadowland Consulting. In January 2015 decided to permanently leave Poland and discover new worlds. Actually settled in Hucknall (The Last home of The Byron Family). Community leader focused on SQL Server, SharePoint, security, collaboration and ITIL, DR, BCM, and SLA. Love licensing stuff. MCT, freelancer, and consultant. Subject Matter Expert at Microsoft. Member of Microsoft Terminology Community, Friends of RedGate PLUS, PASS, ISSA, ACM and several communities in the world. 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.STEM Ambassador.

[/vc_column][/vc_row][vc_row el_id=”performancetuningsqlsentry”][vc_column width=”1/2″][vc_column_text]

 Performance Tuning with SQLSentry for SQL Server

[/vc_column_text][vc_column_text]Track: SQL Server Database Administration
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 As a Database professional, we are responsible for ensuring our data is accessible for the business in an optimal manner. However sometimes performance problems arise with our database that causes the business applications to slow down. Are you equipped with the right tools to quickly identify what has changed and what is going on in your environment that has caused this slowdown? In this Session, Warwick will introduce you to how to quickly identify what you need to look at and how to resolve this with the help of SQLSentry for SQL Server by SentryOne.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Warwick Rudd

Warwick Rudd

Warwick Rudd is a Data Platform 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 specialises 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.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”powerquerym”][vc_column width=”1/2″][vc_column_text]

 Power Query and M Deep Dive

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Power Query is the transformation engine in Power BI. This is the engine that you do all data preparation before loading data into the model. This is the keystone of your Power BI solution. In this session, you will learn what things Power Query can do. M is the language behind the scene of Power Query, you will learn how M can be more beneficial than the Power Query Graphical interface. You will see demos of transformations that you can do with M Code. This session is full of live demos. Prepare to be amazed with what Power Query can do with heaps of demos in this session.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Matt	 Masson

Matt Masson

Matt Masson is a Principal Program Manager at Microsoft who focuses on data integration challenges. Matt has worked on multiple products in this space, including Power BI, Power Query, Azure Data Factory, SQL Server Integration Services (SSIS), Data Quality Services (DQS), and Master Data Services (MDS). Most recently, he has been focused on Power BI’s data connectivity experience and the Power Query SDK (https://aka.ms/DataConnectors). 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 https://www.mattmasson.com/.

[/vc_column][/vc_row][vc_row el_id=”graph”][vc_column width=”1/2″][vc_column_text]

 SQL Server Graph Database

[/vc_column_text][vc_column_text]Track: SQL Server Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]

 A new feature introduced in SQL Server 2017 and Azure SQL DB is the ability to describe a graph, store data in form of nodes and edges making up a graph. This allows real-world scenarios such as recommendation systems, fraud detection, and basket analysis to be implemented more efficiently with SQL technologies.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Dave Dustin

Dave Dustin

With more than 25 years experience on SQL Server, Dave has worked with a number of startups, SMEs and larger enterprises. He is a popular presenter and contributor at meetups and conferences around the world. Based in Wellington, New Zealand, he is currently the Data Lead at Xero.

[/vc_column][/vc_row][vc_row el_id=”pbisharingsecurity”][vc_column width=”1/2″][vc_column_text]Building Fast and Reliable Reporting with Power BI[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Fast reports are a delight to use. Slow reports languish into obscurity. How do we build reports that are fast and reliable? Join us for a deep dive into Power BI performance tuning and optimization. We’ll cover the basic patterns for Power BI usage, performance implications and best practices, including security, workspaces, apps and content packs, as well as RLS and more.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Sergei Gundorov

Sergei Gundorov

The presenter, Sergei Gundorov, currently works as a Program Manager on the Power BI team at Microsoft. He has Master’s Degree in Business Administration. Sergei published numerous articles over the course of the last 26 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on MSDN (Microsoft Developer Network). Sergei’s most recent contribution was to the Security Whitepaper for Power BI published in May of 2017. He presented his most valuable technological advancements to worldwide developer audiences at TechEd, TechReady, and Office/SharePoint Developer conferences. He participated and contributed to numerous webcasts that focused on various technologies that he is considered to be an expert on. He is an inventor and filed several patent applications. Sergei runs popular technical “XLGeek’s Space” blog where his work is praised very highly by the readers and his apps users.

Siva Harinath

Siva Harinath

Siva is a Principal Program Manager on the Microsoft Business Applications Platform Innovation (BAPI) team. Siva joined Microsoft Business Intelligence team in 2002 and has been part of the Analysis Services, Reporting Services, Power BI product teams. Siva has closely worked with enterprise customers in architecting solutions with Microsoft BI stack. Siva currently leads the team helping the MVPs, user groups, community, education/training content and marketing websites of Dynamics 365, Power BI, PowerApps, and Stream.

[/vc_column][/vc_row][vc_row el_id=”pbiembedded”][vc_column width=”1/2″][vc_column_text]

 Power BI Embedded; Developers Guide

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Power BI is not just a self-service tool for business analysts. Power BI has many features that helps developers to build their reporting solution. Power BI Embedded, real-time streaming with Power BI, along with all powerful analytical engine of Power BI, helps developers to take their reporting to the next level. Come to this session to learn about all features that Power BI provides for developers.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Sergei Gundorov

Sergei Gundorov

The presenter, Sergei Gundorov, currently works as a Program Manager on the Power BI team at Microsoft. He has Master’s Degree in Business Administration. Sergei published numerous articles over the course of the last 26 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on MSDN (Microsoft Developer Network). Sergei’s most recent contribution was to the Security Whitepaper for Power BI published in May of 2017. He presented his most valuable technological advancements to worldwide developer audiences at TechEd, TechReady, and Office/SharePoint Developer conferences. He participated and contributed to numerous webcasts that focused on various technologies that he is considered to be an expert on. He is an inventor and filed several patent applications. Sergei runs popular technical “XLGeek’s Space” blog where his work is praised very highly by the readers and his apps users.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”azureml”][vc_column width=”1/2″][vc_column_text]

Azure Machine Learning algorithm accuracy enhancement, tips, and tricks

[/vc_column_text][vc_column_text]Track: Data Science
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

Azure ML is the Microsoft cloud based Machine Learning tool. It provides a variety of algorithms for performing descriptive, predictive, and prescriptive analysis. Moreover, it supports a variety of data science techniques for data wrangling, feature selection, cross validation, and so forth for enhancing the algorithm accuracy. In this session, I will talk about how to do feature selection in Azure ML to find proper attributes. Also, I will demo how to do data sampling and cross validation using existing components in Azure ML which will help to enhance machine learning accuracy. Moreover, I will show some of the main components that we can use for data cleaning like normalization, clip values and so forth.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Leila	Etaati

Leila Etaati

Leila is a Artificial Intelligence Microsoft MVP, PhD, Trainer, and BI consultant. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; Microsoft USA Ignite, Microsoft data Insight Summit, Microsoft NZ ignite, SQL PASS Summits, PASS Rally, SQL Nexus, SQL Saturdays and so on. She has more than 10 years’ experience in Data Mining and Analytics. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

[/vc_column][/vc_row][vc_row el_id=”pbiviz”][vc_column width=”1/2″][vc_column_text]

 Power BI Visualization Best Practices

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a BI application. Good visualization will benefit the decision making process, while bad visualization can lead to wrong decisions. In this session, you will learn how to create the right chart or visual, with examples ranging from line charts, bar/column charts, and some other useful chart styles in Power BI. You will also learn some tips and tricks to control interactivity of visuals in Power BI. Session is full of demos, and through that you will learn tips and tricks for choosing best colors and best visuals for your solution.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Reza Rad

Reza Rad

Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight Summit, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star; http://radacad.com/online-book-power-bi-from-rookie-to-rockstar

[/vc_column][/vc_row][vc_row el_id=”casestudy”][vc_column width=”1/2″][vc_column_text]Genesis Energy Implementation: Technical reference and Design patterns for enterprise BI and reporting supporting data science teams[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]

In this session we walk through the recently announce the technical reference implementation for BI and reporting solution to augment your data science and analytics platform on Azure.

 

This reference implementation enables you to fast track your infrastructure deployment, so that you can focus on the main goal of building a BI and reporting application that addresses your ever changing business needs.

 

We will cover the following :

  • pre-built with components like Blob, SQL Data Warehouse, SQL Database, and Analysis Services in highly scalable configurations that have been proven in the field to meet enterprise requirements.
  • configuration of software for virtual network configuration, job orchestration for data ingestion and flow, system management, monitoring, and other operational essentials for a production system.

Also we will Chris Lowe from Genesis Energy’s implementation of this architecture and share their experience with design and deployment.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Myles Matheson

Myles Matheson

Myles is a Solution Specialist for Microsoft New Zealand. He has worked in the field of business intelligence and data warehousing for the last 15 years both in New Zealand and the United Kingdom.

Chris Lowe

Chris Lowe

Chris Lowe is GM Architecture, Data and Analytics at Genesis Energy and plays a key role in building the capabilities to become a truly data driven organisation. He has worked with Microsoft data platforms for 18 years and is currently establishing the new data capabilities at Genesis to meet the needs of enterprise business intelligence, data science exploration and also expanding their artificial intelligence capability. Prior to joining Genesis, he worked in Telecommunications, Packaging, Forestry, Mining and Appliance Manufacturing in a variety of Operations Research and Information Technology roles.

[/vc_column][/vc_row][vc_row el_id=”rpowerbi”][vc_column width=”1/2″][vc_column_text]

Endless Possibilities: R and Power BI

[/vc_column_text][vc_column_text]Track:  Data Science
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]R integration with Power BI provides more flexibility for users. People are able to have more visualizations which not exist currently in Power BI such as: normal distribution chart, column width chart, different type of subplots in a map, five dimensions’ chart with facet chart and so forth. Moreover, writing R scripts inside power query and Power BI Visualization enable users to do machine learning using R cods. The other possibilities that recently added, people able to create custom R visual with plotly package to make their visualization much more interactive, accessible and more flexible. In this session, first I will show how to create some interesting charts using ggplot2 package inside Power BI. Then, I will show how to do Machine Learning inside Power query by following machine learning process: data gathering, data cleansing, feature selection, model creation, data sampling and finally prediction. Also, I will show the main process to create a custom R visual (pbiviz) file through the installing Power BI tools. Finally, a brief demo in current available R visual produces by Microsoft team will be presented.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Leila	Etaati

Leila Etaati

Leila is a Artificial Intelligence Microsoft MVP, PhD, Trainer, and BI consultant. She is world well-known speaker in Machine Learning and Analytics topics, and spoke in world’s best international conferences in Data Platform topics, such as; Microsoft USA Ignite, Microsoft data Insight Summit, Microsoft NZ ignite, SQL PASS Summits, PASS Rally, SQL Nexus, SQL Saturdays and so on. She has more than 10 years’ experience in Data Mining and Analytics. She writes blog posts in RADACAD and also publishes YouTube videos in our channel. She also is an invited lecturer in universities such as University of Auckland, and Unitec, and some other universities. She worked in many industries including banking financial, power and utility, manufacturing, tourism, and so on.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”customconnector”][vc_column width=”1/2″][vc_column_text]

 Custom Connectors in Power Query

[/vc_column_text][vc_column_text]Track:Business Intelligence
Length: 75 minutes
Level: 400 – Expert[/vc_column_text][vc_column_text]Custom connectors is a new features in Power Query and Power BI. You can now create connections to all new sources yourself. This session is all about creating custom connectors and things you need to know about it.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Sergei Gundorov

Sergei Gundorov

The presenter, Sergei Gundorov, currently works as a Program Manager on the Power BI team at Microsoft. He has Master’s Degree in Business Administration. Sergei published numerous articles over the course of the last 26 years through multiple channels on various subjects that range from accounting and economics to in depth technical articles on MSDN (Microsoft Developer Network). Sergei’s most recent contribution was to the Security Whitepaper for Power BI published in May of 2017. He presented his most valuable technological advancements to worldwide developer audiences at TechEd, TechReady, and Office/SharePoint Developer conferences. He participated and contributed to numerous webcasts that focused on various technologies that he is considered to be an expert on. He is an inventor and filed several patent applications. Sergei runs popular technical “XLGeek’s Space” blog where his work is praised very highly by the readers and his apps users.

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”pbiarchitecture”][vc_column width=”1/2″][vc_column_text]

 Power BI Solution Architecture; DirectQuery, LiveQuery, or Import Data

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Choosing the right method is an important step for your Power BI Solution Architecture, which you need to decide about it usually in early phases before starting implementation. In this session, I’m going to explain in details what every method is, and the answer to all questions below;

  • What is Import Data/Schedule Refresh?
  • What is DirectQuery?
  • What is Live Connection?
  • What is Difference between Live Connection and DirectQuery?
  • Pros and Cons of Each Method
  • Which method is performing best and fastest?
  • Which method is more flexible?
  • Which method is more scalable?
  • What are Architecture Scenarios to use Each Method?
  • What is the Gateway Role?

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Reza Rad

Reza Rad

Reza Rad is author, speaker, trainer and consultant. He is the world well-known name in the Microsoft BI field. Reza Rad is invited speaker in world’s best and biggest SQL Server and BI conferences such as PASS Summits, PASS Rallys, SQLBits, TechEds, Ignites, Microsoft Data Insight Summit, and so on. He is author of books on this topic, and he has more than 15 years’ experience in the Microsoft BI technologies. 10 years of his experience focused on training and consulting to the largest BI teams in the world. He is also Microsoft Certified Trainer for years. He is Microsoft SQL Server MVP (Most Valuable Professional) focused on BI and Data Analysis, He has been awarded MVP from Microsoft because of his dedication and expertise in Microsoft BI technologies. He is author of Power BI online book; from Rookie to Rock Star; http://radacad.com/online-book-power-bi-from-rookie-to-rockstar

[/vc_column][/vc_row][vc_row el_id=”integration”][vc_column width=”1/2″][vc_column_text]

 Data Integration – preparing for the data challenges of tomorrow

[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]With the ever increasing demand of data and information from the business, data professionals are increasingly feeling the pressure to deliver. This often results in us not being able to see the forest through the trees and we struggle making all those data streams come together in well tuned governed process. Many of us see understand the separate technology pieces that make up Data Integration architecure but we often loose the overview and how to make it all work together.

In this session I would like to share some pearls of wisdom on how to make the various tools work for your Data Integration projects. Show the common pittfalls and failures of big Data Integration projects and how to avoid them. Data Profiling, Performance tuning, Baseline measurements, master data management, data quality assesment, integration services are all cogs in the large machine called data integration. I hope to show you how you can oil that machine to make it work seamlesly for your organization.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Robert Blaas

Robert Blaas

"I have 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 I have consulted with large multi nationals, local government and private companies in New Zealand and overseas. I have designed and developed enterprise data warehouses and large corporate data stores ensuring high quality data and information to business users. I enjoy working with people across a business to understand their requirements and translates these into sound technical structures. Having worked within multi-cultural environments, I am able to easily facilitate, mentor and coach business teams in meeting their information requirements."

[/vc_column][/vc_row][vc_row el_id=”letsstartcognitive”][vc_column width=”1/2″][vc_column_text]

 Let’s start using Cognitive Services in our business apps!

[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 100 – Basic[/vc_column_text][vc_column_text]

Our business application started to be more and more intelligent. And we can use a lot of data that we never had a chance to use in our application. To do that we can easily use API provided by Microsoft Cognitive Services. There are 30-ish API’s that are really clever and can provide object recognition, face detection and identification, emotion recognition, computer vision, video services, speech and speaker recognition, language understanding, text analytics, sentiment analysis, knowledge exploration, search services, and more.
If you want to add to your application more intelligent futures, come to this session to more understand what Cognitive Services are and get some ideas how you can use in your business today.

[/vc_column_text][/vc_column][vc_column width=”1/2″]

Gosia Borzecka

Gosia Borzecka

Gosia Borzecka works as a full stack .NET developer. While searching for her path, she has been working as a network administrator and IT systems supervisor according to Prince2 and ITIL methodologies. Currently, she loves programming and looking for news related to it, to which she devotes most of her time. While she started work with Office 365 and SharePoint she found an opportunity to add more fun to existing business apps using the newest technology provided by Microsoft. After work, she teaching kids programming and co-organizing workshop meetup: NottsDevWorkshop.co.uk

[/vc_column][/vc_row][vc_row el_id=”powerbissas”][vc_column width=”1/2″][vc_column_text]Super Charge Power BI and What is new with Analysis Services[/vc_column_text][vc_column_text]Track: Azure Data Analysis
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Microsoft Azure Analysis Services enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session introduces Azure Analysis Services as a fully-managed platform as a service (PaaS) in Azure. We will discuss where Analysis Services fits into Microsoft’s BI platform and strategy, reference architectures and cloud efficiencies. Modeling and analytics features covered by the last two compatibility levels will be reviewed and demonstrated, including Power Query connectivity, object-level security, and Detail Rows for non-technical users to drill through to transactional records.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Siva Harinath

Siva Harinath

Siva is a Principal Program Manager on the Microsoft Business Applications Platform Innovation (BAPI) team. Siva joined Microsoft Business Intelligence team in 2002 and has been part of the Analysis Services, Reporting Services, Power BI product teams. Siva has closely worked with enterprise customers in architecting solutions with Microsoft BI stack. Siva currently leads the team helping the MVPs, user groups, community, education/training content and marketing websites of Dynamics 365, Power BI, PowerApps, and Stream.

[/vc_column][/vc_row][vc_row el_id=”premium”][vc_column width=”1/2″][vc_column_text]Introducing Power BI Premium[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Extend your Power BI solution to everyone on your team with Power BI Premium! Learn how our latest offering can bring you dedicated capacity for your organization.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Siva Harinath

Siva Harinath

Siva is a Principal Program Manager on the Microsoft Business Applications Platform Innovation (BAPI) team. Siva joined Microsoft Business Intelligence team in 2002 and has been part of the Analysis Services, Reporting Services, Power BI product teams. Siva has closely worked with enterprise customers in architecting solutions with Microsoft BI stack. Siva currently leads the team helping the MVPs, user groups, community, education/training content and marketing websites of Dynamics 365, Power BI, PowerApps, and Stream.

[/vc_column][/vc_row][vc_row el_id=”thelastmile”][vc_column width=”1/2″][vc_column_text]The last mile – Operationalization of Maching Learning[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]So you’ve built your AI/Machine Learning model. What next? How do you extract value out of your model and integrate them into you business? In this session, we show you different options available in the Microsoft stack; from both on-prem and cloud or a fully hybrid one.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Julian Lee

Julian Lee

Julian is not your traditional Microsoft employee. He does not know SQL, .NET or Windows. He started his career in Cancer Research and specialized in Genomics. Half of his time was spent in tools such as R, Bioconductor, Perl and a Sun Machine to do High Performance Computing work. 5 years ago, a Palo Alto based company (Revolution Analytics) started its operations in Asia and he joined them as their early ‘revolutionaries’ preaching R and Data Science. In 2015, Microsoft acquired this company and today he preaches Advanced Analytics and Artificial Intelligence

[/vc_column][/vc_row][vc_row el_id=”botsandcogs”][vc_column width=”1/2″][vc_column_text]Are you ready for Artificial Intelligence? – Bots and Cognitive Services[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]It’s 2018 and AI is definitely here to stay! Learn all about Microsoft’s BotFramework and the various Cognitive Services that support it! In this short session, we will learn about the concepts behind the Botframework, from what’s inside and how one could build and deploy bots. We’ll also cover some of the ‘brains’ behind a bot, such as LUIS, a service which powers how phrases are quickly matched to an intent.  Concepts such as utterances, entities, intents and training LUIS are covered in this session.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Julian Lee

Julian Lee

Julian is not your traditional Microsoft employee. He does not know SQL, .NET or Windows. He started his career in Cancer Research and specialized in Genomics. Half of his time was spent in tools such as R, Bioconductor, Perl and a Sun Machine to do High Performance Computing work. 5 years ago, a Palo Alto based company (Revolution Analytics) started its operations in Asia and he joined them as their early ‘revolutionaries’ preaching R and Data Science. In 2015, Microsoft acquired this company and today he preaches Advanced Analytics and Artificial Intelligence

[/vc_column][/vc_row][vc_row disable_element=”yes” el_id=”whatdevops”][vc_column width=”1/2″][vc_column_text]What is DevOps and why do I care?[/vc_column_text][vc_column_text]Track: Database Development
Length: 75 minutes
Level: 100 – Intermediate[/vc_column_text][vc_column_text]If you like an interactive and lively sessions them this is the place for you.
We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional.
We’ll take a peak at what it means for the technology professional as well as what it means for the business professional.
We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up.
We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption.
We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these.
Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates knowledge.
At the very least, you’ll make some new friends.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Martin Catherall

Martin Catherall

Martin is a Consultant with SQL Down Under in Melbourne, Australia 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 for The Data Platform and is a Regional Mentor for the Professional Association of SQL Server (PASS) in the Asia Pacific area as well as the former leader of the Christchurch SQL Server User Group

[/vc_column][/vc_row][vc_row el_id=”privandprof”][vc_column width=”1/2″][vc_column_text]Data Privacy and the Data Professional[/vc_column_text][vc_column_text]Track: Database Development
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]It’s almost a daily occurrence to hear about some sort of data breach.
But what are the consequences of a data breach – for both the victims and companies involved – and what does that mean for you as a data professional.
As governments start to legislate more in an effort to protect the privacy of its citizens the entire concept of data storage become more complex.
Exactly what is legislation like the General Data Protection Regulation (GDPR) and how will it affect around the world.
We’re seen Microsoft give us tools over the years – like Transparent Data Encryption and Dynamic Data masking – to help with this sort of thing – but is there a better answer?
Come along to this session and hear how you and your team can lessen your chances of being the ones responsible for the next data breach.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Martin Catherall

Martin Catherall

Martin is a Consultant with SQL Down Under in Melbourne, Australia 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 for The Data Platform and is a Regional Mentor for the Professional Association of SQL Server (PASS) in the Asia Pacific area as well as the former leader of the Christchurch SQL Server User Group

[/vc_column][/vc_row][vc_row el_id=”correctlyaa”][vc_column width=”1/2″][vc_column_text]Correctly Architecting Availability Group Solutions[/vc_column_text][vc_column_text]Track: Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]With the release of SQL Server 2017, Microsoft has further enhanced the capabilities of Availability Groups. Clearly Microsoft is investing more in Availability Groups compared to Failover Clustering. However, this does not mean that you should automatically architect Availability Groups over Failover Cluster Instances.
In this session we will have a look at how to correctly architect and deploy Availability Groups. We will cover areas including: new features in SQL Server 2017 (and 2016), Availability Group internals, potential performance overhead of Availability Groups, licensing considerations and where to deploy Failover Clustering instead. We will look at the pros and cons of deploying Availability Groups over Failover Clustering.
If you are considering implementing Availability Groups in your new SQL Server high availability deployment this practical session should prove to be invaluable.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Victor Isakov

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.

[/vc_column][/vc_row][vc_row el_id=”azureiot”][vc_column width=”1/2″][vc_column_text]Azure IoT – Opportunities are Endless[/vc_column_text][vc_column_text]Track: Azure
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]How Microsoft is trying to simplify deliver of the IoT, examples of how it’s been used for business transformation and how Microsoft is investing to create new value with the Intelligent Edge + Intelligent Cloud.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Sam Denton-Giles

Sam Denton-Giles

Sam Denton-Giles is the Internet of Things Business Group Lead for Microsoft Asia-Pacific. He is responsible all up for managing the health and growth of the IoT business in APAC, from developing and integrating the partner ecosystem through to marketing and direct sales. He works closely with Microsoft specialist sales teams and partner ISV and Solution Integrators to deliver high impact Internet of Things and Advanced Analytics projects to customers in the Asia-Pacific region.

[/vc_column][/vc_row][vc_row el_id=”microsoftiot”][vc_column width=”1/2″][vc_column_text]Microsoft IoT Central – Enterprise IOT as-a-Service[/vc_column_text][vc_column_text]Track: Azure
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]Microsoft IoT Central is a fully managed IoT SaaS (software-as-a-service) solution that makes it easy to connect, monitor and manage your IoT assets at scale, so you can create deep insights from your IoT data and take informed action.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Sam Denton-Giles

Sam Denton-Giles

Sam Denton-Giles is the Internet of Things Business Group Lead for Microsoft Asia-Pacific. He is responsible all up for managing the health and growth of the IoT business in APAC, from developing and integrating the partner ecosystem through to marketing and direct sales. He works closely with Microsoft specialist sales teams and partner ISV and Solution Integrators to deliver high impact Internet of Things and Advanced Analytics projects to customers in the Asia-Pacific region.

[/vc_column][/vc_row][vc_row el_id=”sparkr”][vc_column width=”1/2″][vc_column_text]Scalable Data Science with SparkR on HDInsight[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 200 – Intermediate[/vc_column_text][vc_column_text]R, a powerful statistical programming language, is unfortunately single threaded and therefore, natively limited to a single node. What happens when data scientists need more resources that can fit in single server? Enter Apache Spark – a leading distributed in-memory analytics platform for data analysis, with interfaces in Scala, Python and of course, R. In this demo heavy session, we’ll take a look at using SparkR for scalable data analytics on an HDInsight cluster. First, we start with a technical and architectural overview of Apache Spark, SparkR and HDInsight. Then we’ll cover the basics of performing distributed data manipulation, cleansing, and machine learning using SparkR utilizing HDInsight, as well as how to parallelize existing R scripts and R packages using SparkR’s UDFs.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Lace Lofranco

Lace Lofranco

Lace is a Senior Software Development Engineer on the Commercial Software Engineering (CSE) Team at Microsoft. Her focus is on big data analytics, machine learning, data engineering, and scalable architecture. Prior to joining Microsoft, she worked as a Senior Consultant and has successfully delivered projects for various industries and companies across the globe, particularly in the US, South East Asia, Australia and New Zealand. She is also a co-founder of the Azure Nights Melbourne User Group.

[/vc_column][/vc_row][vc_row el_id=”adaptivequery”][vc_column width=”1/2″][vc_column_text]Adaptive Query Processing and Automatic Tuning[/vc_column_text][vc_column_text]Track: Database Administration
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Automatic Tuning and Adaptive Query Processing are perhaps the two key features of SQL Server 2017 and Azure SQL Database which would influence query optimizer’s plan choices. The following session will provide an overview of the features and explain how it can help to address performance issues like parameter sniffing, plan regressions, lack of indexes or too many indexes without any manual intervention and change of code.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Nagaraj Venkatesan

Nagaraj Venkatesan

Nagaraj Venkatesan is a Data Platform MVP from Singapore and the leader of Singapore SQL PASS Chapter. As a SQL Server enthusiast, Nagaraj is a regular speaker in Asia Pacific region at Data Platform events like SQL Saturdays, SQL Server Geeks Summit, User group meetups etc. Nagaraj shares his technical expertise at strictlysql.blogspot.com. Nagaraj also runs a YouTube channel called "DataChannel", which contains technical interviews with top Microsoft Data Platform experts in the world.

[/vc_column][/vc_row][vc_row el_id=”ssisdf”][vc_column width=”1/2″][vc_column_text]SSIS in Azure Data Factory v2 – a game changer?[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]SQL Server Integration Services in Azure Data Factory v2 is a solution for ETL/ELT workflows. Using SSIS in ADFv2, we will show you how to move all/parts of your on-premises ETL workloads and just “lift & shift” many existing SSIS packages to Azure, lowering your operational costs and gaining scalability + high availability. We will guide you end-to-end from provisioning Azure-SSIS Integration Runtime (IR) as the managed, dedicated, scaled up/out compute resource for SSIS to scheduling parallel package executions on it. But is it useful, is it fast, is it easy and powerful to use ? And most of all is ADF a replacement for SSIS or is it complementing it for hybrid ETL scenarios?

These are some of the questions that might arise, when reading about this new PaaS and that we will answer together in this demo packed session where will we go through orchestration, consumption and administration of data through the ADF pipeline.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Regis Baccaro

Regis Baccaro

Régis is a Senior Consultant working with databases and BI since 1999. He specializes in mentoring, performance tuning and scalable architecture of datawarehouses and bi-solutions. His background and work experience mixes technology and business, providing him a unique edge to contribute to datawarehouse and database projects, and effectively interacting with technical and business decision makers. Régis is a frequent speakers at SQL Server conferences around the globe and is a board member of the Danish SQL Server User Group and the founder of the SQL Saturday Denmark community event. He is also Recipient of an MVP award for Data platform for four years in a row.

[/vc_column][/vc_row][vc_row el_id=”kerberos”][vc_column width=”1/2″][vc_column_text]Kerberos for BI[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]Have you ever seen this message “Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON”

Have you ever witnessed Kerberos mentioned in a conversation – or in a forum – and seen developers shiver, sysadmins crawl back under their rock and project managers fear for the consumed hours ?

Have you ever wondered why it seems so complicated ?

If you answered yes to any of these question then this demo-packed session is for you.

Because Kerberos is something that anyone who must deploy SQL Server wishes they didn’t have to worry about. It truly affects all aspects of SQL Server including the engine, Reporting Services, Analysis Services, SharePoint and PowerPivot. Furthermore we will have a close look at how to diagnose problems and troubleshoot the three-headed beast when it breaks loose.

This session is based on many hours spent sweating in setting up Kerberos in BI and SharePoint environments and explaining support people how to troubleshoot and fix Kerberos issues when they arise.[/vc_column_text][/vc_column][vc_column width=”1/2″]

Regis Baccaro

Regis Baccaro

Régis is a Senior Consultant working with databases and BI since 1999. He specializes in mentoring, performance tuning and scalable architecture of datawarehouses and bi-solutions. His background and work experience mixes technology and business, providing him a unique edge to contribute to datawarehouse and database projects, and effectively interacting with technical and business decision makers. Régis is a frequent speakers at SQL Server conferences around the globe and is a board member of the Danish SQL Server User Group and the founder of the SQL Saturday Denmark community event. He is also Recipient of an MVP award for Data platform for four years in a row.

[/vc_column][/vc_row][vc_row el_id=”DSVM”][vc_column width=”1/2″][vc_column_text]Deep Learning with TensorFlow and the Data Science Virtual Machine[/vc_column_text][vc_column_text]Track: Business Intelligence
Length: 75 minutes
Level: 300 – Advanced[/vc_column_text][vc_column_text]The Data Science Virtual Machine is designed and configured for working with a broad range of usage scenarios and can be utilised as a one-stop-shop for a data scientists’ Big Data analytic workloads. You are able to scale your environment up or down as your project needs change, use your preferred language to program data science tasks and install other tools and customise the system for your exact needs.
First, we start with a technical and architectural overview of the Data Science Virtual Machine and TensorFlow. Then, we will demonstrate how to provision the services using a business case scenario and build out an end-to-end solution for Big Data Deep Learning workloads.[/vc_column_text][/vc_column][vc_column width=”1/2″]
Chimene Bonhomme

Chimene Bonhomme

Chimène Bonhomme is a Technical Solution Specialist in Data and Artificial Intelligence on the Enterprise team at Microsoft. Her focus is on the Cortana Intelligence Suite, big data analytics and machine learning. Prior to joining Microsoft, she worked as a Data Specialist Consultant and has successfully delivered projects for various industries and companies in the US, Australia and New Zealand. She is also a speaker in the NZ Business Intelligence - Power BI User Group.

[/vc_column][/vc_row]