sqlsathistory

Nr: 803

Back to Main list

SQLSaturday #803 - Durban 2018

Start Time (24h) Speaker Track Title
09:50:00 Sean Cremer Application Database Development SQL Server Temporal Tables
09:50:00 Jeanne Combrinck Application Database Development Master Data Services From Start To Finish
09:50:00 Luis de Sousa Analytics and Visualization Machine Learning with R in Power BI
11:00:00 Steve Simon Information Delivery All you wanted to know about CTE's but were afraid to ask
11:00:00 Andrew Collier Analytics and Visualization Wading into Stream Analytics
11:00:00 Gail Shaw Application Database Development An introduction to SQLDatawarehouse
11:00:00 Niels Berglund Analytics and Visualization SQL Server Extensibility Framework
13:00:00 Steve Simon BI Information Delivery SQL Server Reporting Services 2017 on Steroids!!
13:00:00 Jodi Craig Application Database Development Deadlocks: What they are and how to resolve them
13:00:00 Michael Johnson BI Information Delivery Power BI data preparation with Dataflows
14:10:00 Arohan Naidoo BI Platform Architecture, Development Administration Zero to Pi to 10 on Cloud,Intro to Windows 10 IoT Core on a Raspberry Pi and BI using Azure IoT Hub
14:10:00 Gail Shaw Application Database Development Graphs in SQL Server and Cosmos DB
14:10:00 Niels Berglund Analytics and Visualization The Ins and Outs of sp_execute_external_script
15:30:00 James McGillivray BI Information Delivery Power BI Report Design for the Aesthetically Challenged
15:30:00 Rory Bolle Application Database Development Does everyone hate replication?
15:30:00 Warren Rocchi Professional Development Top tips on cracking a new database (and improving your new emplo

SessionID: 83411

SQL Server Temporal Tables

Back to calendar

Event Date: 15-09-2018 - Session time: 09:50: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: 83415

Master Data Services From Start To Finish

Back to calendar

Event Date: 15-09-2018 - Session time: 09:50: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: 85091

Machine Learning with R in Power BI

Back to calendar

Event Date: 15-09-2018 - Session time: 09:50: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:

SessionID: 83427

All you wanted to know about CTE's but were afraid to ask

Back to calendar

Event Date: 15-09-2018 - Session time: 11:00:00 - Track: Information Delivery

Speaker: Steve Simon

Title: All you wanted to know about CTE's but were afraid to ask

Abstract:

In today's complex business environment, it is imperative that we provide the decision maker with information in a timely manner. One of the most powerful, efficient and effective ways of achieving our goal is by "working smarter" with our SQL Code. In this presentation we shall be looking and working with cool ways and means of getting the information out of the door, utilizing Common Table Expressions or CTE's to render the necessary data. This is your chance to experience first hand the power of these fantastic structures!! Carpe Diem!!!

SessionID: 83734

Wading into Stream Analytics

Back to calendar

Event Date: 15-09-2018 - Session time: 11: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:

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

SessionID: 85093

An introduction to SQLDatawarehouse

Back to calendar

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

Speaker: Gail Shaw

Title: An introduction to 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: 85098

SQL Server Extensibility Framework

Back to calendar

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

Speaker: Niels Berglund

Title: SQL Server Extensibility Framework

Abstract:

You may ask yourself what SQL Server Extensibility Framework (SSEF) is. Well, you may know it under another name: SQL Server Machine Learning Services (ML services). The thing is that since Python was added to the languages of SQL Server ML Services, you no longer are limited to purely data science "stuff" in SQL Server ML Services, you can do a lot of other things as well. So in this session, we will "use and abuse" SSEF and through lots of code and demos see what awesome things we can do!

SessionID: 83426

SQL Server Reporting Services 2017 on Steroids!!

Back to calendar

Event Date: 15-09-2018 - Session time: 13: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: 85099

Deadlocks: What they are and how to resolve them

Back to calendar

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

Speaker: Jodi Craig

Title: Deadlocks: What they are and how to resolve them

Abstract:

Deadlocks are a swear word in DB world. They always tend to happen at the worst possible time, are extremely difficult to recreate and the deadlock graph looks like some sort of abstract art.

So when your DBA tells you that you need to fix a deadlock: what is it and how should you go about resolving it?

SessionID: 85332

Power BI data preparation with Dataflows

Back to calendar

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

Speaker: Michael Johnson

Title: Power BI data preparation with Dataflows

Abstract:

Data preparation is often the most labour-intensive component of an analytics project and getting this right is vital if the results are to be accurate. While the growth of self-service BI has empowered users to answer important questions, ensuring well-managed data is available to all employees remains one of businesses biggest challenges. Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse. You will learn -How Dataflows can be used to create rich, vetted datasets -How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce -How to manage Dataflows using advanced data preparation tools such as Databricks

SessionID: 84324

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: 15-09-2018 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

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 the basics to rapidly getting started with 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 getting the development environment setup, getting Windows 10 IoT core running on a Raspberry Pi , connecting IoT device to Azure and 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: 85094

Graphs in SQL Server and Cosmos DB

Back to calendar

Event Date: 15-09-2018 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Gail Shaw

Title: Graphs in SQL Server and Cosmos DB

Abstract:

One of the new features in SQL Server 2017 was Graph tables. These represent a different way of storing data to what we’re use to in the relational model.

In this session, I’ll take you through the design process for graph tables, and then implement and query some graphs in both SQL Server 2017 and Cosmos DB using its graph model.

SessionID: 85097

The Ins and Outs of sp_execute_external_script

Back to calendar

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

Speaker: Niels Berglund

Title: The Ins and Outs of sp_execute_external_script

Abstract:

sp_execute_external_script (SPEES) is the "entry point" into SQL Server Machine Learning Services. In this session, we look at the various parameters it takes and what they are used for. The session is code and demo-heavy!

SessionID: 83423

Power BI Report Design for the Aesthetically Challenged

Back to calendar

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

Speaker: James McGillivray

Title: Power BI Report Design for the Aesthetically Challenged

Abstract:

So you're a BI developer, and you've worked hard to get a good knowledge of DAX. Your power BI model is working well, but you're not sure how to present it in a stylish, attractive and appealing way?

Many of us are not blessed with amazing artistic ability, and we find design work be a real challenge. Don't despair, there are some logical patterns and tips we can follow to make big differences in our reports without needing to unleash the artist within.

In this session we'll learn about layout, colour theory, design principles and how to choose the best visualisation for the message you wish to convey.

We'll also take a glance at enhancing our reports by the using bookmarks, tooltips and drillthrough features in Power BI.

SessionID: 84372

Does everyone hate replication?

Back to calendar

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

Speaker: Rory Bolle

Title: Does everyone hate replication?

Abstract:

Transactional replication has been around for a dogs age and most people have grown to hate the old girl. Not everyone though. Those of us that have applied ourselves to the technology have grown to love it.

This session will walk you through the basics of what replication is, why and when you should use it Next we will walk through some of the extra little toys that replication allows: --)Tweaking the target table --)Using custom stored procedures rather than standard ones --)Procedure replication rather than table replication

SessionID: 85120

Top tips on cracking a new database (and improving your new emplo

Back to calendar

Event Date: 15-09-2018 - Session time: 15:30:00 - Track: Professional Development

Speaker: Warren Rocchi

Title: Top tips on cracking a new database (and improving your new emplo

Abstract:

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

This site is open source. Improve this page.