sqlsathistory

Nr: 785

Back to Main list

SQLSaturday #785 - Johannesburg 2018

Start Time (24h)	Speaker	Track	Title
10:00:00	Steve Simon	BI Information Delivery	SQL Server Reporting Services 2017 on Steroids!!
10:00:00	Jody Roberts	Cloud Application Development Deployment	Azure Managed Instance
10:00:00	Vanessa Raath	Professional Development	How to become the most sought after SQL Server professionals in SA
10:00:00	Andrew Collier	Analytics and Visualization	Wading into Stream Analytics
10:00:00	Kathryn Varrall	Cloud Application Development Deployment	Azure Database Migrations: The secret sauce to successful database migrations
11:10:00	Jeanne Combrinck	Application Database Development	Master Data Services From Start To Finish
11:10:00	Alex Yates	Application Database Development	DevOps 101 for Data People
11:10:00	Sean Cremer	Application Database Development	SQL Server Temporal Tables
11:10:00	James McGillivray	BI Information Delivery	Power BI Report Design for the aesthetically challenged
11:10:00	Ridewaan Hanslo	Application Database Development	Re-engineering legacy SQL Server Radius Accounting processor archiving solution
11:10:00	Warren Rocchi	Professional Development	Top tips on cracking a new database (and impressing your new employer)
13:00:00	Uwe Ricken	Application Database Development	Daily indexing problems and its - possible - solution
13:00:00	Ryan Jamieson	Advanced Analysis Techniques	Data Science in Power BI
13:00:00	Arohan Naidoo	Cloud Application Development Deployment	Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub
13:00:00	Minette Steynberg	Analytics and Visualization	Deploying Power BI for the Enterprise
13:00:00	Sven Vosse	BI Information Delivery	Tips Tricks To Bridge The Gap Between IT and Your BI Report Users
14:10:00	Tinus Visagie	BI Platform Architecture, Development Administration	Design considerations and patterns for creating a supportable Data Warehouse
14:10:00	Mercia Malan	Analytics and Visualization	Taking the data to Isengard
14:10:00	Niels Berglund	Advanced Analysis Techniques	Overview SQL Server Machine Learning Services
14:10:00	Alistair Pugin	Strategy and Architecture	Demystifying Azure Information Protection
15:20:00	Sandesh Nagaraj	BI Platform Architecture, Development Administration	BI and DW Schema Design and Evolution
15:20:00	Donovan White	Analytics and Visualization	GPU Accelerated Deep Learning with SQL Server 2017
15:20:00	Sifiso Ndlovu	BI Information Delivery	Generate Heatmap Dashboards: SSRS vs Power BI
15:20:00	Gail Shaw	Application Database Development	An introduction to Azure SQLDatawarehouse
15:20:00	Luis de Sousa	Analytics and Visualization	Machine Learning with R in Power BI

SessionID: 82126

SQL Server Reporting Services 2017 on Steroids!!

Back to calendar

Event Date: 01-09-2018 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Steve Simon

Title: SQL Server Reporting Services 2017 on Steroids!!

Abstract:

Reporting requests that are required ‘yesterday or sooner’, oft times necessitate working more efficiently and effectively. We have all been through this at one time or another.

In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.

SessionID: 82151

Azure Managed Instance

Back to calendar

Event Date: 01-09-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Jody Roberts

Title: Azure Managed Instance

Abstract:

In this session we will take a look at what all the fuss is about as well as

Architecture of AMI(Azure managed Instance) Cost of AMI vs on-prem Different options to migrate to AMI Benefits of AMI Differences Between AMI and SQL Server on=prem

SessionID: 82349

How to become the most sought after SQL Server professionals in SA

Back to calendar

Event Date: 01-09-2018 - Session time: 10:00:00 - Track: Professional Development

Speaker: Vanessa Raath

Title: How to become the most sought after SQL Server professionals in SA

Abstract:

Are you underpaid? Would you like to know what a market related salary is for your skill set? What are the most in demand IT Developer profiles in the market today? Is your CV going to stand out from the guy sitting next to you? Come along to my presentation and we will have a look at what a market related salary for you is; are you keeping your skills relevant for today’s needs and are you representing yourself well enough to stand out.

SessionID: 82903

Wading into Stream Analytics

Back to calendar

Event Date: 01-09-2018 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Andrew Collier

Title: Wading into Stream Analytics

Abstract:

Large volumes of data originate at high velocity from various sources including IoT devices and sensors, web sites and social media feeds. A common approach is to simply store these data for offline processing.

Processing that in many instances never happens...

Wouldn't it be more efficient and effective to process the data stream as it arrives?

Azure Stream Analytics is an event-processing engine which enables processing of streaming data in real time. It can handle up to 1 Gb of data per second, which should suffice for most applications.

In this tutorial I'll take you through the processing of setting up a job on Azure Stream Analytics. I'll look specifically at the following:

• connecting to a data source
• extracting information
• identifying patterns and relationships
• using machine learning
• triggering actions
• reporting tools and
• offline processing.

To illustrate these concepts we'll build a real time sentiment analysis system for streaming data from Twitter.

SessionID: 84196

Azure Database Migrations: The secret sauce to successful database migrations

Back to calendar

Event Date: 01-09-2018 - Session time: 10:00:00 - Track: Cloud Application Development Deployment

Speaker: Kathryn Varrall

Title: Azure Database Migrations: The secret sauce to successful database migrations

Abstract:

In this session you will learn about the various migration paths and tools available to migrate your databases to Azure.

SessionID: 82147

Master Data Services From Start To Finish

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Jeanne Combrinck

Title: Master Data Services From Start To Finish

Abstract:

Master Data Services can look complicated. In this session I will take you through how to install MDS to having a complete solution that will work for you. This session will include installing MDS, setting up a model with entities and attributes, integrating with Excel and setting up security.

SessionID: 82275

DevOps 101 for Data People

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Alex Yates

Title: DevOps 101 for Data People

Abstract:

In 2009 John Allspaw and Paul Hammond delivered the session "10 deploys per day - Dev ops cooperation at Flickr." In forty six minutes they changed the way millions of people would think about the software delivery process for years to come. It didn't have a name yet, but DevOps was born. DevOps folk preached about the cloud, automation, rapid delivery and any database technology that wasn't relational.

In 2013 Kenny Gorman declared "The DBA is Dead".

For the record, I don't believe that, but a lot of people do. What is certain is that the world of IT is changing and traditional roles are changing with it. We all need to adapt.

In this interactive talk I'll explain what DevOps is, where it came from, and its implications for SQL Server. I'll demo example solutions to some of the foundational technical challenges (source control and test/deployment automation) and will leave plenty of time at the end to answer your questions.

SessionID: 82957

SQL Server Temporal Tables

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Sean Cremer

Title: SQL Server Temporal Tables

Abstract:

Change Tracking over the years has been handled in many different ways with People often building their own bespoke auditing systems. This session will introduce Temporal Table's pros and cons allowing someone to make a much more informed decision as to whether or not this could add value to their systems.

SessionID: 83417

Power BI Report Design for the aesthetically challenged

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: BI Information Delivery

Speaker: James McGillivray

Title: Power BI Report Design for the aesthetically challenged

Abstract:

Do you ever worry that your reports look they were born in the 90s, or designed by a grade 1? Do you feel overwhelmed when tasked with creating attractive reports which tell the customer a story?

Thankfully, a few simple design concepts can have big impacts on your reports. There are easy-to-learn techniques and patterns to create a pleasing look and feel to our reports, and some well defined principles to decide which visual is most appropriate in your situation.

Join me in this session to learn:

• How to choose the right visual to complement the data message.
• Best practices for visual formatting to tell a complete story.
• Colour theory - designing a colour palette, and ensuring accessibility.
• Layout techniques for clean and simple reports.
• Real estate management, or how to fit everything on a report without it looking cluttered and losing effectiveness.

SessionID: 84287

Re-engineering legacy SQL Server Radius Accounting processor archiving solution

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Ridewaan Hanslo

Title: Re-engineering legacy SQL Server Radius Accounting processor archiving solution

Abstract:

In an outdated "resource hogged" solution the data archiving strategy of using stored procedures for DML with no caching, validation, exception handling and working automation was preventing thousands of the organisations client internet usage data from being correctly reported, due to lost records causing data integrity issues. This was a huge concern for the organisation as it affected the service ratings and client retention. In this presentation we relive the empirical process by going through the solution demonstrating the SSIS Incremental Data Loads method, discussing the creation and purpose of read and write tables, implementing indexes whilst keeping fill-factor, rebuilds and reorganization in mind, as well as provisioning staging tables for troubleshooting and verification purposes. Lastly we end off with the mirrored architecture's scheduled SQL agent jobs automation and notifications.

SessionID: 84327

Top tips on cracking a new database (and impressing your new employer)

Back to calendar

Event Date: 01-09-2018 - Session time: 11:10:00 - Track: Professional Development

Speaker: Warren Rocchi

Title: Top tips on cracking a new database (and impressing your new employer)

Abstract:

A quickstart guide for SQL developers in the dark to start making sense of their new environment

SessionID: 82119

Daily indexing problems and its - possible - solution

Back to calendar

Event Date: 01-09-2018 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Uwe Ricken

Title: Daily indexing problems and its - possible - solution

Abstract:

Have you ever been in the situation that an application performed well the last day and - suddenly - you run into problems? Although you have Index Maintenance jobs and statistics up to date you will monitor a big degrade of performance! This session will demonstrate in a over 80 percent demo based presentation the following scenarios which happend this way in real life!

• Why performance degradation in spite of maintenance jobs?
• just one more database in the result set and the query runs really bad - why?
• usage of literals is completely different from the usage of variables - why?
• identical data types but the query runs in part perfect and in part bad...
• your execution plan shows an INDEX SEEK - but the table will be scanned!
• you get a query from the business which performs really bad but when you test it it runs pretty cool - why?

SessionID: 82707

Data Science in Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Ryan Jamieson

Title: Data Science in Power BI

Abstract:

Microsoft has released amazing Machine Learning, Advanced Analytics and AI capabilities. as a Power BI user, how can we use these capabilities in our analytics and dashboards. This will cover in the box capabilities as well as enhancing Power BI with other Microsoft ML capabilities.

SessionID: 84309

Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub

Back to calendar

Event Date: 01-09-2018 - Session time: 13:00:00 - Track: Cloud Application Development Deployment

Speaker: Arohan Naidoo

Title: Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub

Abstract:

This session will focusing on providing a SQL/BI developer with a walkthrough developing apps for Windows 10 IoT core running on a Raspberry Pi and using this to collect data and send data to Azure IoT hub. Some of the aspects that will be looked at is development environment , Windows 10 IoT core running on a Raspberry Pi , Azure IoT the challenges faced, from getting started to getting an app running that sends data to IoT hub and visualizing this data in Power BI.

SessionID: 84362

Deploying Power BI for the Enterprise

Back to calendar

Event Date: 01-09-2018 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Minette Steynberg

Title: Deploying Power BI for the Enterprise

Abstract:

Implementing Power BI for the enterprise is not as easy as it may look. Most enterprises seem to follow a somewhat ad-hoc approach.

In this session I will look at what is required to plan a successful Power BI Premium implementation for the Enterprise.

The following topics may be included:

• Versions Overview
• Decision Points
• Data Sources
• Data Storage Options
• Data Refresh
• Dataset development vs Report authoring
• Security, Compliance and Auditing

SessionID: 84924

Tips Tricks To Bridge The Gap Between IT and Your BI Report Users

Back to calendar

Event Date: 01-09-2018 - Session time: 13:00:00 - Track: BI Information Delivery

Speaker: Sven Vosse

Title: Tips Tricks To Bridge The Gap Between IT and Your BI Report Users

Abstract:

IT / SQL-orientated BI users can significantly increase the success of BI projects by understanding the report user' needs, fears, pain points and so on. Learn practical, quick-win tips to help you hit the BI sweet-spot.

This topic will be a combination of theory (BI in general) and practical (using Power BI).

Learn how to address the needs of your end-users (user-friendly semantic model, appealing colour / report themes; interactive and intuitive report design; etc.), how to make reports accessible to the end-users (explore pros and cons of various deployment methods), whilst maintaining security and governance best-practice.

SessionID: 83230

Design considerations and patterns for creating a supportable Data Warehouse

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tinus Visagie

Title: Design considerations and patterns for creating a supportable Data Warehouse

Abstract:

So you've built a flashy new Data Warehouse and deployed it to production.

Great now what?

Nobody wants to be involved with a project that is constantly failing and difficult to support. This session will take a look at some design considerations and tips to ensure that your mart runs with minimal intervention and is easy to support.

The tools discussed and used in the examples will be SSIS and SQL server but many of the points discussed are valid for all tools.

SessionID: 84965

Taking the data to Isengard

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Analytics and Visualization

Speaker: Mercia Malan

Title: Taking the data to Isengard

Abstract:

Analysis of Big Data is a fast growing field with more and more technologies popping up to enable us to analyse this data in a fast and efficient way. With the available choices of technology ever increasing, the question remains - which way do we go?

In this session we'll explore the world of middle earth with the help of Apache Spark, Azure HDInsight and PowerBI. Apache spark is a distributed data processing engine which is deployed as a cluster, with master and worker nodes.

We'll look at setting up a spark cluster in Azure HDInsight as well as visualising the results in PowerBI.

SessionID: 84967

Overview SQL Server Machine Learning Services

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Advanced Analysis Techniques

Speaker: Niels Berglund

Title: Overview SQL Server Machine Learning Services

Abstract:

SQL Server Machine Learning Services (ML Services) was introduced in SQL Server 2016. At that time SQL Server ML Services only supported the R language. When SQL Server 2017 was released Python was added to the mix. In this session, we get an overview of what SQL Server ML services can do and what it can be used for. The session is code heavy.

SessionID: 85078

Demystifying Azure Information Protection

Back to calendar

Event Date: 01-09-2018 - Session time: 14:10:00 - Track: Strategy and Architecture

Speaker: Alistair Pugin

Title: Demystifying Azure Information Protection

Abstract:

Lets face it. Excel is still the largest used BI tool in the world. From traditional end user all the way up to organisational BI, data is still sucked into Excel and shared across the business. Now we know that at a data level, data is encrypted at REST and in transit but what happens once the data is surfaced in traditional applications like Excel? How do we ensure that the output (The excel file) is secured, protected and retained? Enter Azure Information Protection.

In this session we unpack: · What is Azure IP · How to find content that needs protection · How to use Azure IP to protect your content · How to build out you Information protection strategy

In the mobile first, work from anywhere world we live it, managing access control is only half the journey to ensuring that your content is protected from misuse and inadvertent dissemination.

SessionID: 82173

BI and DW Schema Design and Evolution

Back to calendar

Event Date: 01-09-2018 - Session time: 15:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sandesh Nagaraj

Title: BI and DW Schema Design and Evolution

Abstract:

Discussion around Data Warehouse Schema Design and evolution.The flexibility of ROLAP and In-Memory data models to support all Schema design categorizations and optimizes the performance of the data model.

Different types Schema Design: In terms of tables accessed, Joins, data modification, data loading/Maintenance, data redundancy, design and size.

• Normalized • Moderately de-normalized • Completely de-normalized • Star Schema • Data vault • NoSQL

And lastly discuss around the common schema design roadblocks that people face like Hierarchy, SCD etc…

SessionID: 83361

GPU Accelerated Deep Learning with SQL Server 2017

Back to calendar

Event Date: 01-09-2018 - Session time: 15:20:00 - Track: Analytics and Visualization

Speaker: Donovan White

Title: GPU Accelerated Deep Learning with SQL Server 2017

Abstract:

Learn how to leverage Python and SQL Server 2017 In-Database Analytics with GPU acceleration to use NeuralNet algorithms for Deep Learning.

SessionID: 84874

Generate Heatmap Dashboards: SSRS vs Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 15:20:00 - Track: BI Information Delivery

Speaker: Sifiso Ndlovu

Title: Generate Heatmap Dashboards: SSRS vs Power BI

Abstract:

Within the Microsoft reporting ecosystem, Power BI and Excel easily support the implementation of heatmaps yet the same cannot be said of SQL Server Reporting Services (SSRS). In this session, we take a look at the Top 3 options for implementing heatmaps in SSRS, namely, using the SWITCH Expression, using Custom VB.NET Code, as well as using External Assembly File.

SessionID: 84929

An introduction to Azure SQLDatawarehouse

Back to calendar

Event Date: 01-09-2018 - Session time: 15:20:00 - Track: Application Database Development

Speaker: Gail Shaw

Title: An introduction to Azure SQLDatawarehouse

Abstract:

The Azure SQL Datawarehouse is intended for large-scale data processing in the cloud, but it’s not just a really big managed SQL Server instance.

In this session, I’ll take you through the architecture of Azure SQL Datawarehouse, how it differs from a regular SQL Server and what those differences mean for database design, query design and usage patterns.

SessionID: 84968

Machine Learning with R in Power BI

Back to calendar

Event Date: 01-09-2018 - Session time: 15:20:00 - Track: Analytics and Visualization

Speaker: Luis de Sousa

Title: Machine Learning with R in Power BI

Abstract:

In this talk we'll discuss how to do Machine Learning with R inside Power BI with a brief explanation on different algorithms.

We'll cover:

• How to do machine learning inside power query using R
• How to write R scripts to create functions inside Power Query for data transformation
• A brief description of some algorithms with some R sample code

This site is open source. Improve this page.