sqlsathistory

Nr: 712

SQLSaturday #712 - South Island NZ 2018

Start Time (24h)	Speaker	Track	Title
10:00:00	Dave Dustin	Strategy and Architecture	Back to Basics – An overview of the internals of SQL Server
10:00:00	Gogula Aryalingam	BI Platform Architecture, Development Administration	Azure Data Lake Analytics: Leveraging the Modern Data Warehouse
10:00:00	Vanessa Larsen	Other	Deciphering the Black Box - Why productivity projects crash and burn
10:00:00	Leila Etaati	Analytics and Visualization	Create Custom Visual using JSON and R
11:15:00	Phillip Seamark	BI Platform Architecture, Development Administration	Advanced DAX for the SQL Professional
11:15:00	Ginger Grant	Advanced Analysis Techniques	Implementing Python in SQL Server 2017
11:15:00	Sudeep Ghatak	Other	Cloning the human brain - Cognitive Services
11:15:00	Amit R S Bansal	Enterprise Database Administration Deployment	Troubleshooting SQL Server Memory Issues
13:15:00	Craig Bryden	BI Information Delivery	SSRS and Power BI Report Server - What's New
13:15:00	Warwick Rudd	Application Database Development	SQLOpsStudio Vs SSMS - There can be only one
13:15:00	Reza Rad	Analytics and Visualization	Take Power BI Visualization to the Next Level
14:30:00	Patrick Flynn	Enterprise Database Administration Deployment	DBATools! The reason to finally start learning and using Powershell
14:30:00	Anupama Natarajan	Cloud Application Development Deployment	Modern Data Warehouse using Lambda Architecture and Azure
14:30:00	Simon Peck	BI Platform Architecture, Development Administration	Orchestration and data movement with Azure Data Factory v2
15:45:00	Manohar Punna	Advanced Analysis Techniques	Real-Time Analytics with Power BI
15:45:00	Martin Catherall	Strategy and Architecture	Data Privacy and the Data Professional.
15:45:00	Indira Bandari	BI Information Delivery	Google Forms meet Power BI via Reporting Services (SSRS)

SessionID: 71626

Back to Basics – An overview of the internals of SQL Server

Back to calendar

Event Date: 26-05-2018 - Session time: 10:00:00 - Track: Strategy and Architecture

Speaker: Dave Dustin

Title: Back to Basics – An overview of the internals of SQL Server

Abstract:

What actually happens when you execute a query.

This session drills down into how SQL Server and other relational database systems work behind the scenes. We’ll look at the interpreter, optimizer, estimator, storage, memory, locking, blocking, indexes, statistics and everything else that makes it all work.

SessionID: 72429

Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

Back to calendar

Event Date: 26-05-2018 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Gogula Aryalingam

Title: Azure Data Lake Analytics: Leveraging the Modern Data Warehouse

Abstract:

What you feared has come upon you: You’ve been happily building business intelligence solutions the traditional way for years; Finally, the big data curse has caught up with you. Your organization wants to exploit their big data along with their day-to-day transactional data. You are now tasked with storing all this in one place and working your analytics magic on it. You start wondering how and where you would store this data, what kind of hardware you would need and and how you would learn everything from storing to processing to analysis in a short time – after all big data is a different type of beast from transactional data.

Fear not, all you need to do is look to the heavens; with Azure Data Lake and Azure Data Lake Analytics, you could get started quite fast. After an introduction to Azure Data Lake, we will dive into how you could perform simple yet power analytics using methods that are familiar with Azure Data Lake Analytics.

SessionID: 77446

Deciphering the Black Box - Why productivity projects crash and burn

Back to calendar

Event Date: 26-05-2018 - Session time: 10:00:00 - Track: Other

Speaker: Vanessa Larsen

Title: Deciphering the Black Box - Why productivity projects crash and burn

Abstract:

Like a building a bridge that collapses within days of its grand opening (if it even gets finished at all), sometimes our digital projects don't go the way we expect. Productivity initiatives are particularly fickle as we try to change the way that people work. So how do we make sure we can successfully become a digital workplace without it all coming crashing down around our ears?

In this session, we will share our stories from our time in the field experiencing the twists and turns that productivity projects take; how to have success in your internal project; and if you choose to bring in external parties, how to make the most of them.

SessionID: 78712

Create Custom Visual using JSON and R

Back to calendar

Event Date: 26-05-2018 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Leila Etaati

Title: Create Custom Visual using JSON and R

Abstract:

Power BI visualization is a holistic visualization tool. You can draw most of the popular charts with it. However, there is always some needs for specific charts that may not be available in Power BI standard visualizations of the marketplace. There is a possibility to extend the visualization capabilities using R language. There are two ways to use R to extend the visualization possibilities. The approach was introduced in 2015 as “R” custom visual that you can draw chart by writing R scripts. The editor for writing R was not that was good and also the end-user able to see the R code behind the chart. The second approach for using R to have more chart in Power BI has been introduced in 2017 that is about creating Custom visual file (pbiviz file) using R and JASON language. In this seminar, I am going to show how you can create any custom visual by writing R codes. You able to create a custom visual that has a specific icon, name, and parameters.

SessionID: 70334

Advanced DAX for the SQL Professional

Back to calendar

Event Date: 26-05-2018 - Session time: 11:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Phillip Seamark

Title: Advanced DAX for the SQL Professional

Abstract:

We will create data from thin air and show how you can shape your data model using DAX.

SessionID: 78623

Implementing Python in SQL Server 2017

Back to calendar

Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Implementing Python in SQL Server 2017

Abstract:

Advanced data analytics does not live only in the realm of data scientists. The necessary tools now exist in SQL Server 2017 using the language which is number one on the list of most popular programming languages today, Python. This session will provide and introduction to Python, cover how to integrate the language into SQL Server, demonstrate how to use Python in stored procedures and review how you can determine the resources that Python is using within SQL Server.

SessionID: 78720

Cloning the human brain - Cognitive Services

Back to calendar

Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Other

Speaker: Sudeep Ghatak

Title: Cloning the human brain - Cognitive Services

Abstract:

Microsoft Cognitive Services enables developers to augment the next generation of applications with the ability to see, hear, speak, understand, and interpret needs using natural methods of communication. Hear from Sudeep and Amit on how Azure cognitive services is transforming the way we approach to problems.

SessionID: 80111

Troubleshooting SQL Server Memory Issues

Back to calendar

Event Date: 26-05-2018 - Session time: 11:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amit R S Bansal

Title: Troubleshooting SQL Server Memory Issues

Abstract:

Welcome to the dungeon. Yes, SQL Server memory concepts are like entering a dungeon where you are guaranteed to get lost. It’s dark and complex out there and not many have come back alive. This session will help you find your way out of the dungeon. In this deep-dive session you will understand SQL Server memory architecture, how the database engine consumes memory and how to track memory usage. Complex concepts will be made simple and you will see some light beyond the darkness. Finally, you will learn how to troubleshoot common memory issues.

SessionID: 75787

SSRS and Power BI Report Server - What's New

Back to calendar

Event Date: 26-05-2018 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Craig Bryden

Title: SSRS and Power BI Report Server - What's New

Abstract:

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.

SessionID: 78176

SQLOpsStudio Vs SSMS - There can be only one

Back to calendar

Event Date: 26-05-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Warwick Rudd

Title: SQLOpsStudio Vs SSMS - There can be only one

Abstract:

SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS?

In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.

SessionID: 78534

Take Power BI Visualization to the Next Level

Back to calendar

Event Date: 26-05-2018 - Session time: 13:15:00 - Track: Analytics and Visualization

Speaker: Reza Rad

Title: Take Power BI Visualization to the Next Level

Abstract:

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 affect tremendously on decision making process, bad visualization leads to wrong decisions. In this session, you will learn how to choose the right chart of visual with examples of Line chart, bar/column charts, and some other main charts in Power BI. You will also learn some tips and tricks to control interactivity of visuals in Power BI. You will learn about specific features in Power BI that helps empowering your visualizations. Session is full of demos, and through that you will learn tips and tricks for choosing best colors and best visuals for your solution.

SessionID: 71107

DBATools! The reason to finally start learning and using Powershell

Back to calendar

Event Date: 26-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Patrick Flynn

Title: DBATools! The reason to finally start learning and using Powershell

Abstract:

Powershell has been part of Windows for > 10 years and has been part of SQL Server since 2008.

In spite of this the adoption among Database Professionals for use in investigating and managing their environments has been low.

With the release of the open source DBA Tools module from DBATools.IO, with its 300+ commands, the time has arrived for Database Professionals to embrace PowerShell and upgrade their skills to support the modern Hybrid environment.

In this session we will look how to download, install and begin using the power within both this module and Powershell.

No prior experience with Powershell required!

SessionID: 77366

Modern Data Warehouse using Lambda Architecture and Azure

Back to calendar

Event Date: 26-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Anupama Natarajan

Title: Modern Data Warehouse using Lambda Architecture and Azure

Abstract:

Organisations capture huge volumes of data and they need actionable information to act on them proactively in real-time to stay competitive. This requires a different thinking from the conventional Data Warehouse Architecture to more Cloud based Data Processing Architecture where high volume batch and real-time processing can be achieved using optimal cost.

In this session you will learn about

Overview of Lambda Architecture
How Azure Services implement Lambda Architecture
Advantages of leveraging Azure for Lambda Architecture
Business Scenarios to consider Lambda Architecture
End to End Demo

SessionID: 80494

Orchestration and data movement with Azure Data Factory v2

Back to calendar

Event Date: 26-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Peck

Title: Orchestration and data movement with Azure Data Factory v2

Abstract:

As more and more businesses are looking to leverage cloud services to move and store their data we’ll take a look at how we can achieve that with ADF v2 and other Azure storage services.

For the SSIS developer, we’ll translate some ADF terminology to help get you started as well as demonstrate some real-life examples from our customer engagements. And of course, being automation experts with Biml, we’ll demonstrate how we can automate the creation of ADF v2 assets.

SessionID: 70391

Real-Time Analytics with Power BI

Back to calendar

Event Date: 26-05-2018 - Session time: 15:45:00 - Track: Advanced Analysis Techniques

Speaker: Manohar Punna

Title: Real-Time Analytics with Power BI

Abstract:

In this session

I will dive deep into real-time analytics with Power BI.
How to build streaming tiles in Power BI Dashboards.
Demo using Power BI REST APIs.
Demo using Azure Event Hub and Azure Stream Analytics.

SessionID: 77101

Data Privacy and the Data Professional.

Back to calendar

Event Date: 26-05-2018 - Session time: 15:45:00 - Track: Strategy and Architecture

Speaker: Martin Catherall

Title: Data Privacy and the Data Professional.

Abstract:

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.

SessionID: 80613

Google Forms meet Power BI via Reporting Services (SSRS)

Back to calendar

Event Date: 26-05-2018 - Session time: 15:45:00 - Track: BI Information Delivery

Speaker: Indira Bandari

Title: Google Forms meet Power BI via Reporting Services (SSRS)

Abstract:

Are you interested in getting to know what your customers are thinking about your services? Empower your business with this end to end solution of creating feedback survey, sending and receving the responses and then finally analysing the same.

In this session I will show you how to • Initiate customer feedback surveys using Google Forms. • Send the survey emails to the database contacts through data driven subscriptions of Reporting Services (SSRS) • And finally analyse the customer feedback using Power BI

This site is open source. Improve this page.