SQLSaturday #803 - Durban 2018
Event Date: 09/15/2018 00:00:00
Event Location:
- Gateway Hotel
- Cnr Centenary Blvd Twilight Dr, Umhlanga Ridge, Umhlanga, KwaZulu Natal, South Africa
- La Lucia, KwaZulu-Natal, South Africa
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
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.
Speaker(s):
- Andrew Collier
Track and Room: Analytics and Visualization - Room 2
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.
Speaker(s):
- Steve Simon
Track and Room: BI Information Delivery - Room 1
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.
Speaker(s):
- James McGillivray
Track and Room: BI Information Delivery - Room 2
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
Speaker(s):
- Michael Johnson
Track and Room: BI Information Delivery - Room 2
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.
Speaker(s):
- Sean Cremer
Track and Room: Application Database Development - Room 3
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.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Room 3
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!!!
Speaker(s):
- Steve Simon
Track and Room: Information Delivery - Room 3
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
Speaker(s):
- Rory Bolle
Track and Room: Application Database Development - Room 3
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
Speaker(s):
- Warren Rocchi
Track and Room: Professional Development - Room 1
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
Speaker(s):
- Luis de Sousa
Track and Room: Analytics and Visualization - Room 2
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.
Speaker(s):
- Gail Shaw
Track and Room: Application Database Development - Room 1
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.
Speaker(s):
- Jeanne Combrinck
Track and Room: Application Database Development - Room 1
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!
Speaker(s):
- Niels Berglund
Track and Room: Analytics and Visualization - Room 2
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?
Speaker(s):
- Jodi Craig
Track and Room: Application Database Development - Room 3
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!
Speaker(s):
- Niels Berglund
Track and Room: Analytics and Visualization - Room 1
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
Speaker(s):
- Arohan Naidoo
Track and Room: BI Platform Architecture, Development Administration - Room 1
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
James McGillivray
Twitter: - JamesMcG_MSBI
LinkedIn: James McGillivray
Contact: https://jimbabwe.co.za/blog-posts/
James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. James is a director at Cobalt Analytics.
Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at numerous SQLSaturdays, PASS Summit, Power BI World Tour and SQL Bits.
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Sean Cremer
Twitter: - https://twitter.com/seanCremer
LinkedIn: Sean Cremer
Contact: https://seancremer.github.io/
Sean Cremer is a Senior Developer at Derivco. He has worked with SQL Server for nearly two decades on Large OLTP and Data Warehousing Systems and has a wealth of accumulated Database Design and Implementation knowledge.
Michael Johnson
Twitter: - MikeJohnsonZA
LinkedIn: Michael Johnson
Contact: http://michaeladrianjohnson.com/
Michael Johnson is a Microsoft data platform MVP and leader of the Johannesburg SQL User Group and Business Analytics Virtual Group. He works as an Independent Business Intelligence Consultant and regularly presents at local user groups, SQLSaturdays and PASS Virtual Chapters.
Arohan Naidoo
Arohan is a Business Intelligence developer working at Entelect primarily on the Microsoft BI stack who has an interest in using Big Data and IoT to find insights into ways to improve daily life as well as focused research on using technology to enhance learning.
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as “dreaming” up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Gail Shaw
Twitter: - @SQLInTheWild
Contact: http://sqlinthewild.co.za
Gail Shaw is a Database Specialist focusing on database performance tuning and database recovery, with a particular interest in topics such as indexing strategies, execution plans, and writing T-SQL code that performs well and scales gracefully. Gail holds a Microsoft Certified Master certification for SQL Server 2008 and is a Data Platform MVP. She’s a frequent poster on the SQLServerCentral forums, a Pluralsight author, writes articles for both SQLServerCentral.com and Simple-Talk.com, and has spoken at SQLSaturdays, SQL Bits and at the PASS Community Summit. Gail has been responsible for extending the lifespan of many an application, by performance-tuning their databases and providing technical guidance on all things SQL Server related.
Rory Bolle
Rory studied Information technology, ran a small computer shop then found Derivco as a Tester. Moved as soon as possible to Data Development and it has stuck.
Rory really loves wood work, general garage tinkering and has a second child on the way which his wife has told him he is excited about.
Rory’s Derivco career has centered around delivering data from 40+ busy source databases to +-120 consumer databases. The main focus in this space is deduplication and compression of data while finding the correct balance between RBAR and batching. If moving data is your thing, Rory can help.
Jodi Craig
I am passionate about striving for Technical Excellence and designing the right solution for the business need. I have been in the IT industry for 20+ years and spent majority of that time in a technical / management role. I particularly enjoy working with data anything related to SQL Databases.
Jeanne Combrinck
Twitter: - TheSQLGirl
LinkedIn: Jeanne Combrinck
Contact: http://thesqlgirl.com
Senior BI Developer at Britehouse. In her spare time she can be found spending time with her animals, doing SQL puzzles and writing on her blog http://thesqlgirl.com/.
Luis de Sousa
Twitter: - @luis_de_sousa
LinkedIn: Luis de Sousa
Contact: http://www.luisdesousa.co.za
Consult to large financial institutions in South Africa providing Business Intelligence and Analysis insight.
Steve Simon
Twitter: - SQLServerBoffin
LinkedIn: Steve Simon
Contact: http://www.sqlservercentral.com/blogs/simon_says/
Steve Simon is a Database Solutions Architect with Business Knowledge Services Inc. He has been involved with database design and analysis for over 35 years. Steve has presented papers at numerous PASS Summits and PASS SQL Rallies. He is also regular presenter on the SQLSaturday circuit and he is a contributor on SQLShack.com
Niels Berglund
Twitter: - nielsberglund
LinkedIn: Niels Berglund
Contact: https://nielsberglund.com
Niels works as Software Architect at Derivco, where he develops software as well as “dreaming” up new and innovative ways to use existing and new technology. Before joining Derivco, Niels worked as researcher/instructor at Developmentor where he was responsible for the database curriculum. He was a co-author of the first SQL Server 2005 book for developers: quot; A First Look at SQL 2005 for Developersquot;. He has presented at all leading technical conferences; Tech-ED, SQL PASS, DevWeek, Ignite the Tour, etc., and is also a Microsoft Data Platform MVP.
Andrew Collier
Twitter: - DataWookie
LinkedIn: Andrew Collier
Contact: https://datawookie.netlify.com/blog/
Itinerant Data Scientist; Geek; Runner.
Warren Rocchi
Twitter: - @wazdarocsta
LinkedIn: Warren Rocchi
Contact: http://www.ebsphere.com
Commonly described as the boy next door (although next door to whom has never been quite defined), Warren fell in love with SQL when he was accidentally thrust into it after going to see a girl at a tech company. He liked it so he put a ring on it. That was the girl, and as for SQL the affair continues. Warren consults as a SQL dev for EBSphere (Pty) Ltd and lectures on all aspects of SQL in his spare time. Amongst other things he dabbles in MySQL and is passionate about IT Security and recycling.
Sponsors
The following is a list of sponsors that helped fund the event: